L.A. Care Health Plan

SQL Server Database Administrator III

L.A. Care Health Plan

full-time

Posted on:

Location Type: Office

Location: Los Angeles • California • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

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

Job Level

Mid-LevelSenior

Tech Stack

SQLSSIS

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 while supporting enterprise projects.
  • Provide general database design, implementation and administration to assure highest reliability and availability of I.T. services.
  • Manage the Data Synchronization of multiple databases between data centers using transaction replication.
  • 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 including the development of complex SQL, tuning of DML and the creation of stored procedures.
  • Perform proactive housekeeping/archiving and shrinking of databases and logs.
  • Develop and support procedures for database security.
  • Develop processes, procedures and guidelines for troubleshooting database events and performing tasks.
  • Provide tier 2 and 3 support for all corporate SQL Server database systems and services to meet or exceed service level agreements.

Requirements

  • Bachelor's Degree in Computer Science or Related Field
  • 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 and query tuning on high transaction databases
  • Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
  • Experience in SQL Server clustering and HA technologies including Always On, mirroring, log shipping and transactional replication
  • Experience in administering SharePoint and IIS Platforms is preferred.
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
SQL ServerT-SQLstored proceduresquery tuningSQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)database designdatabase administrationdisaster recovery
Soft skills
troubleshootingproblem solvingcommunicationcollaborationsupport
Certifications
Bachelor's Degree in Computer Science