Principal SQL Database Administrator

L.A. Care Health Plan•Los Angeles, CA

About The Position

The Principal SQL Server Database Administrator is a seasoned technologist responsible for the design and support of Microsoft SQL Technology Platform including SQL Server Databases, Applications and Reporting environments. This is a hands on position that leads the development of standards and SOPs, and the design and implementation of new applications and disaster recovery solutions for a diverse group of databases. This role provides technical leadership and guidance to varying audiences regarding database architectures and successful implementation methodologies. This is a highly interactive position and involve communication with I.T. analysts and application sponsors across the organization.

Requirements

At least 7 years of extensive and broad based experience in the design, administration and support of SQL Server databases with in depth experience in SQL Server 2008 R2/2012 in a production environment.
Experience in resource planning / management and source control.
Experience in working with applications that are mission critical and require 24/7 uptime.
Experience in consolidating and virtualizing the environments.
Experience in building and maintaining DEV, QA, UAT, PROD and Disaster Recovery environments.
Experience in troubleshooting issues and quickly resolve them in an efficient manner that minimizes downtime.
Able to prioritize work and complete deliverables to timelines with minimal supervision by senior staff.
Excellent verbal and written communication skills.
Excellent training skills to be able to present, train, and convey technical information simply and understandably to department staff and administrators.
Ability to periodically work under stressful and chaotic circumstances.
Must have a service-oriented attitude with excellent problem solving and analytical skills.
Ability to work independently, self-motivated, and highly focused are required.
Ability to thrive in a changing environment. Ability to manage multiple projects with multiple priorities.
A strong understanding of the software development lifecycle and software development methodologies (requirements gathering, analysis and design, development tools, version control, testing and QA, and deployment).
Thorough knowledge of all types SQL Server replication, clustering, partitioning and mirroring.

Nice To Haves

Master's Degree in Computer Science or Related Field

Responsibilities

Serve as the primary database administrator and subject matter expert for all the systems based on Microsoft SQL Technology including Databases, Applications and Reporting environments.
Define standards to manage multiple relational database management system (RDBMS) on various operating systems.
Provide input on and design new implementations in collaboration with vendors, infrastructure and application support teams in on-premise, cloud and hybrid environments where appropriate.
Work with Project Managers on work prioritization and assign tasks to the team members and make sure to complete them successfully.
Assist I.T. Management in day-to-day operations including timesheet management, ticket resolution and work allocation.
Oversee all aspects of SQL Server database system design, implementation, troubleshooting, and administration.
Lead and mentor the team members to provide tier 2 and 3 support for all corporate SQL Server database systems and services to meet or exceed service level agreements.
Develop, install, maintain and monitor company databases in a high performance/ high availability environment while supporting enterprise projects.
Provide general database design, implementation and administration to assure highest reliability and availability of I.T. services.
Maintain database backup/ recovery procedures and disaster recovery database environment.
Develop and support procedures for database security.
Conduct database capacity planning, record archival, and storage monitoring regularly.
Implement and support database software upgrade and patch management procedures.
Document database specifications, licensing, configuration and infrastructure.
Develop processes, procedures and guidelines for troubleshooting database events and performing tasks.
Evaluate and seek solutions to production issues as well as new projects.
Work closely with application developers and project managers in solving production issues.
Perform other duties as assigned.