- 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