Job Description

Salary Range: $139,215.00 (Min.) - $184,460.00 (Mid.) - $229,704.00 (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

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.

Duties

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.

Duties Continued

Education Required

Bachelor's Degree in Computer Science or Related FieldIn lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Master's Degree in Computer Science or Related Field

Experience

Required:

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.

Skills

Required:

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.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Light

Additional Information

Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

L.A. Care offers a wide range of benefits including

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)