• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 11th Jan 2021

Role        : SQL server Developer DBA
Location    : Agoura Hills, CA
Type        : Contract

Independent visa holders

Job Responsibilities:
•    Implement high performance physical database environment for high availability and disaster recovery
•    Establish and maintain sound backup and recovery policies and procedures
•    Implement data partitioning and database tuning to enable data warehouse scale to 1 million loans (capacity planning)
•    Implement and maintain database security (create and maintain users and roles, assign privileges)
•    Coordinate and manage data services nightly jobs with IT infrastructure, Finance, Servicing, and CLG
•    Work on projects as needed (eg: design and configure high performance SQL Server farm)
•    Support in trouble shooting, server performance issues and setting up new databases
•    Setup and maintain documentation and standards
•    Perform other related duties as required and assigned
•    Demonstrate behaviors which are aligned with the organization’s desired culture and values

Skills & Abilities Required:
•    Ability to perform DBA tasks including backups, setting up access policy, data migrations, ETL operations, troubleshooting, data partitioning, replication, clustering, mirroring, and performance optimization
•    Experience with database optimization and performance tuning
•    Programming experience with emphasis on designing complex SQL queries and business components  
•    Experience in the physical and logical design of database architecture and exposure to building dimensional data models 
•    Exposed to SOX audit
•    Experience with Linux operating system is a big plus
•    Excellent written and verbal communication ability
•    Must be highly proficient in Excel and Word
•    Must be a team player with strong attention to detail and able to work independently
•    Proven track record at delivering timely and accurate information in a fast-paced environment 
•    Excellent critical thinking, problem solving, mathematical skills and sound judgment 
•    Financial Services and, if possible, mortgage industry experience preferred
•    Strong business acumen and ability to interface with executive management
 

Saravana P

saravananp@sightspectrum.com