
Database Administrator III, SQL Server
L.A. Care Health Plan
full-time
Posted on:
Location Type: Office
Location: Los Angeles • California • United States
Visit company websiteExplore more
Salary
💰 $105,267 - $173,689 per year
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