L.A. Care Health Plan

Database Administrator III, SQL Server

L.A. Care Health Plan

full-time

Posted on:

Location Type: Office

Location: Los AngelesCaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $105,267 - $173,689 per year

Tech Stack

About the role

  • Oversee all aspects of SQL Server database system design, implementation, troubleshooting, and administration
  • Develop, install, maintain and monitor company databases in a high performance/high availability environment
  • Provide general database design, implementation and administration
  • Manage the Data Synchronization of multiple databases between data centers
  • Maintain database backup/recovery procedures and disaster recovery database environment
  • Implement and support database software upgrade and patch management procedures
  • Identify performance issues, deadlocks/contentions and resolve them
  • Generate traces, execution plans and SQL Profiling
  • Create and manage database constraints and indexes
  • Support Development Team and Business users with database operations

Requirements

  • At least 5 years of extensive and broad based experience in the design, administration and support of SQL Server databases
  • In depth experience in SQL Server 2008 R2/2012
  • Extensive experience writing T-SQL and stored procedures
  • Query tuning on high transaction databases
  • Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Experience in SQL Server clustering and HA technologies including Always On, mirroring, log shipping and transactional replication
Benefits
  • Paid Time Off (PTO)
  • Tuition Reimbursement
  • Retirement Plans
  • Medical, Dental and Vision
  • Wellness Program
  • Volunteer Time Off (VTO)
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL ServerT-SQLstored proceduresquery tuningSQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)database designdatabase administrationdatabase backup/recovery