The DBA is largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (database back-ups, maintenance, and monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems. Job Responsibilities: * Implement database cluster and database replication to enable DR * 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 and privileges) * Work as part of a team and provide 7x24 supports when required * Coordinate and manage data services nightly jobs with IT infrastructure, Finance, Servicing, and CLG * Install and administer SharePoint, enabling enterprise dashboards (a plus) * Work on projects as needed (help build reporting databases) * Support in trouble shooting, server performance issues and setting up new databases * Set-up and maintain documentation and standards The successful applicant will possess the following requirements (items are required unless noted otherwise): * 5+ years of experience in database development and administration in a Microsoft SQL Server environment * 1+ years of experience in using ETL tools such as SSIS, Pentaho, and DataStage * 2+ years in scripting languages such as Perl, Python, and PowerShell * Ability to perform DBA tasks including backups, setting up access policy, data migrations, ETL operations, troubleshooting, data partitioning, replication, clustering, 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
Simi Valley, CA
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."