Senior Database Administrator

A reasonable salary expectation is between $103,708.80 and $132,225.60, based upon experience and internal equity.

This position is on a hybrid work schedule. (Mon & Fri - remote, Tues - Thurs onsite in Rancho Cucamonga, CA)

Position Summary/Position

The Senior Database Administrator (Senior DBA) is responsible for the design, performance, integrity and security of production databases in a highly available 24/7 data systems environment. The role will be involved in the planning and development of new databases, as well as troubleshooting any issues on behalf of the users.

Major Functions (Duties and Responsibilities)

1. Create, configure, monitor, and maintain databases in a large, highly available, distributed, enterprise production database systems.
2. Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
3. Maintain database performance; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
4. Demonstrate extensive knowledge of all aspects of Microsoft SQL Server and MongoDB including administration, replication, backup/restore procedures, and related components such as Reporting Services, Analysis Services, and Integration Services.
5. Work outside of normal business hours as required for completing projects, working on deployments, and resolving system outages.
6. Work with DBAs to determine where the databases will reside in multi-tier distributed/shared applications, comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability.
7. Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases. Read and implement entity-relationship diagrams.
8. Develop alerts, reports, and automated processes for failed jobs.
9. Design and develop complex database design from high level business requirements. Must be able to provide database design options, alternatives and recommendations based on experience and best practices for database design.
10. Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations.
11. Establish standards for documentation and ensure that all designs are documented.
12. Establish standards for permissions and privileges to databases.
13. Develops, manages, and tests back-up and recovery plans; handles seamless failover and recovery.
14. Work with Systems team on planning server hardware, storage, and OS configuration upgrades.
15. Monitor MS SQL performance through Solarwinds, reporting and remediating any issues within the published SLAs.
16. Perform SQL server migrations - adhering to best practices.
17. Participate in on-call rotation for 24/7 database support.
18. Train, mentor, and guide.

Experience Qualifications

Seven (7) years of experience performing database architecture, management, modification and support with five (5) years working with Microsoft SQL Server. Experience in supporting large, highly available, distributed, enterprise production database systems. Experience and knowledge in the design and implementation of new DBMS systems, programming, analysis and design, systems development or systems administration, MSSQL low-level database, query development and Stored Procedure tuning and optimization, tuning data structures, indexing and queries, managing production databases with replication, hot stand-by, clustering, and table partitioning and working in a team-oriented, collaborative environment. Experience working in a 24/7/365 environment and taking a lead role in architecting, designing, and building complex database systems.

Preferred Experience

Experience with both Windows and Linux operating systems is preferred. Experience in programming, analysis and design, systems development, or systems administration preferably in a healthcare setting.

Education Qualifications

Bachelor’s degree in a quantitative field from an accredited institution required.

In lieu of the required degree, a minimum of four (4) years of additional relevant work experience is required for this position. This experience is in addition to the minimum years listed in the Experience Requirements above.

Knowledge Requirement

Detailed knowledge of database technical architectures, ETL, data structures, and reporting tools and environments. Significant practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions. Knowledge of MS SQL standard database maintenance, monitoring/alerting and best practices. Expert knowledge of PLSQL, triggers, and stored procedure development and optimization in SQL Server. Strong understanding of database structures, theories, principles, and practices. Extensive background in database systems along with a strong knowledge of SQL.

Skills Requirement

Fluency with at least one scripting or programming language. Skilled in advising developers on query best practices, tuning, data consistency and availability.

Abilities Requirement

Demonstrated leadership capabilities. Strong analysis and critical thinking skills with the ability to multi-task while maintaining careful attention-to-detail. Ability to handle multiple projects, data input, strong problem-solving capability, excellent interpersonal/ communication skills. Independent self-starter who is driven to success, takes great pride in accomplishments and works with a sense of urgency to meet deadlines and address competing priorities. This position requires willingness to be on call and attend to technical issues outside of normal business hours.

Commitment to Team Culture

The IEHP Team environment requires a Team Member to participate in the IEHP Team Culture. A Team Member demonstrates support of the Culture by developing professional and effective working relationships that include elements of respect and cooperation with Team Members, Members and associates outside of our organization.

Inland Empire Health Plan (IEHP) is the largest not-for-profit Medi-Cal and Medicare health plan in the Inland Empire. We are also one of the largest employers in the region, designated as “Great Place to Work.” With a provider network of more than 5,000 and a team of more than 3,000 employees, IEHP provides quality, accessible healthcare services to more than 1.5 million members. And our Mission, Vision, and Values help guide us in the development of innovative programs and the creation of an award-winning workplace. As the healthcare landscape is transformed, we’re ready to make a difference today and in the years to come. Join our Team and make a difference with us! IEHP offers a competitive salary and stellar benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and state pension plan.

Job Type: Full-time

Pay: $103,708.80 - $132,225.60 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Retirement plan
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Ability to commute/relocate:

• Rancho Cucamonga, CA 91730: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Database administration: 7 years (Required)
• SQL: 5 years (Required)
• MongoDB: 1 year (Required)

Work Location: Hybrid remote in Rancho Cucamonga, CA 91730