Share this Job

Senior Database Administrator

Date: Aug 12, 2019

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 3087 

 

 

Position Summary/ Purpose

The Senior Database Administrator (DBA) is responsible for the 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 Duties/ Responsibilities

  • Create, configure, monitor and maintain databases in a large, highly available, distributed, enterprise production database systems.
  • Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
  • Maintain database performance; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
  • Demonstrate extensive knowledge of all aspects Microsoft SQL Server including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services and Integration Services.
  • Work outside of normal business hours as required for completing projects, working on deployments and resolving system outages
  • Work with DBA’s to determine where the databases will reside in multi-tier distributed/shared applications, comparing hardware/infrastructure alternatives in conjunction with cost, use, growth, supportability
  • Define database authorization rules, perform security audit, and perform platform assessment regarding proper support for the selected databases. Read and implement entity-relationship diagrams
  • Develop alerts, reports and automated processes for failed jobs
  • 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.
  • Understand SAN based storage and related technologies, specifically as applicable and useful to MS SQL Server installations.
  • Establish standards for documentation and ensure that all designs are documented
  • Establish standards for permissions and privileges to databases.
  • Develops, manages and tests back-up and recovery plans; handles seamless failover and recovery
  • Work with Systems team on planning server hardware, storage and OS configuration upgrades.
  • Monitor MS SQL performance through Solarwinds, reporting and remediating any issues within the published SLAs.
  • Ability to perform SQL server migrations - adhering to best practices
  • Participate in on-call rotation for 24/7 database support
  • Train, mentor and guide
  • Ensure the privacy and security of PHI (Protected Health Information) as outlined in IEHP's policies and procedures relating to HIPAA compliance.
  • Other duties as required to ensure Inland Empire Health Plan operations are successful.

 

Experience Requirement

 

6 - 10 years experience required

 

Education   Requirement

 

Associate's degree, or vocational or technical school degree required.  Bachelor's degree preferred.

 

Specialized Knowledge/

Skills

 

  • Seven (7) years’ experience performing database architecture, management, modification and support; Five (5) years with MSSQL Server. 
  • Experience in supporting large, highly available, distributed, enterprise production database systems
  • Detailed knowledge of database technical architectures, ETL, data structures, and reporting tools and environments. 
  • Fluency with at least one scripting or programming language
  • Experience in programming, analysis and design, systems development, or systems administration preferably in a healthcare setting.
  • Experience with MSSQL low-level database, query development and Stored Procedure tuning and optimization.
  • Experience in tuning data structures, indexing and queries.
  • Knowledge of MS SQL standard database maintenance, monitoring/alerting and best practices
  • Experience working in a team-oriented, collaborative environment.
  • Distributed version control system experience
  • Experience with Linux operating systems is preferred.

 

Abilities

 

  • Strong understanding of database structures, theories, principles, and practices
  • Fluency with at least one scripting or programming language
  • Demonstrated leadership capabilities. 
  • Skilled in advising developers on query best practices, tuning, data consistency and availability
  • Strong experience and knowledge in the design and implementation of new DBMS systems.
  • Extensive background in database systems along with a strong knowledge of SQL.
  • Had taken a lead role in architecting, designing, and building complex database systems.  

 

 

Starting Salary: $87,734.00  - $111,820.00  

Pay rate will commensurate with experience

 

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. With a provider network of more than 6,000 and a team of more than 2,000 employees, IEHP provides quality, accessible healthcare services to more than 1.2 million members. And our mission and core 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 a benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and retirement plan.

 


Nearest Major Market: Riverside
Nearest Secondary Market: Los Angeles

Find similar jobs: