Database Operations Lead

PharMerica

Phoenix (AZ)

On-site

USD 120,000 - 150,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision insurance
Health Savings & Flexible Spending (HS
Tuition discounts & reimbursement
401(k)
Company Paid Time Off
Shift Differential
DailyPay
Pet Insurance
Wellness programs

Job summary

PharMerica is seeking an experienced Database Administrator Lead to ensure availability, performance, security, and integrity of SQL Server environments. You will lead a team of DBAs, drive backups, DR testing, and high-availability architectures while aligning with security and regulatory requirements.

Collaborate with IT and development teams to optimize data solutions, implement schema migrations, and maintain runbooks, monitoring, and reporting pipelines.

Qualifications

  • 5+ years administering production Microsoft SQL Server environments, including two or more years leading or supervising technical staff preferred.
  • Bachelor's degree in Computer Science, Information Systems, or an equivalent combination of education and experience.
  • Working knowledge of SSIS and SSRS sufficient to review, troubleshoot, and set standards for work produced by a report writer / ETL developer.
  • SQL Server instance configuration, Always On availability groups, backup and restore, SQL Server Agent, and Database Mail.
  • Backup and recovery design with demonstrated disaster recovery testing.
  • T-SQL development and performance tuning, including execution plan and wait statistics analysis.

Responsibilities

  • Maintains uptime, performance, and capacity across production, staging, and development SQL Server environments.
  • Defines and enforces backup, retention, and disaster recovery strategy; test restores and failover on a scheduled basis against documented RTO and RPO targets.
  • Leads incident response for database outages and performance degradation; conduct root cause analysis and drive remediation to completion.
  • Builds and maintains monitoring, alerting, and runbooks for recurring operational issues.
  • Diagnoses and resolves query performance problems, including execution plan analysis, indexing strategy, statistics, locking and blocking, and connection pooling.
  • Designs and implements high-availability topologies: Always On availability groups, failover cluster instances, log shipping, and transactional replication.
  • Forecasts capacity across storage, memory, and CPU; advise on hardware refresh cycles and SQL Server edition and core licensing.
  • Reviews schema design and data model changes prior to production release.
  • Administers database access control, least-privilege role design, credential rotation, and audit logging.
  • Implements encryption at rest and in transit and manage key rotation in coordination with the security team.
  • Provides database control evidence for audits, including SOC 2 and, as applicable, HIPAA, PCI-DSS, or GDPR.
  • Establishes a repeatable schema migration and release process integrated with CI/CD.
  • Automates provisioning, patching, and routine maintenance.
  • Maintains documentation and reduce recurring manual operational work.
  • Oversees development and maintenance of SSIS packages and scheduled data integration jobs, including failure handling and reconciliation.
  • Oversees the operational reporting environment and set standards for report development, source data selection, and query efficiency.
  • Manages the intake and prioritization of reporting and data extract requests from business departments.
  • Ensures reporting and ETL workloads do not degrade transactional database performance.
  • Directs the daily work of direct reports, setting priorities, assigning tasks, and providing technical direction across database administration and reporting.
  • Reviews technical output and approve work before it reaches production.
  • Manages the on-call rotation and participate in escalation.
  • Sets team priorities, conduct performance reviews, and participate in hiring.
  • Manages vendor relationships, licensing, and support contracts.

Skills

SQL Server
Team leadership
Incident response
Performance tuning
PowerShell

Education

Bachelor's degree in CS/IS or related field

Tools

SSIS
SSRS

Job description

PharMerica is seeking an experienced Database Administrator Lead to ensure availability, performance, security, and integrity of SQL Server environments. You will lead a team of DBAs, drive backups, DR testing, and high-availability architectures while aligning with security and regulatory requirements.

Collaborate with IT and development teams to optimize data solutions, implement schema migrations, and maintain runbooks, monitoring, and reporting pipelines.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Server Database Lead & Reliability Manager
SQL Server Database Lead & Reliability Manager

PharMerica • Phoenix (AZ)

Hybrid
USD 110,000 - 150,000
Medical insurance
Dental insurance
Vision insurance
+9
Senior Enterprise DBA: Performance, Security & DR
Senior Enterprise DBA: Performance, Security & DR

Upturn • San Juan (PR)

On-site
USD 90,000 - 120,000
Senior Database Architect & Reliability Lead
Senior Database Architect & Reliability Lead

Regional Management Corp • Plano (TX)

On-site
USD 120,000 - 180,000
Remote Senior SQL Server Cloud DBA & Lead (AWS/HA)
Remote Senior SQL Server Cloud DBA & Lead (AWS/HA)

Peraton • United States

Remote
USD 104,000 - 166,000
Medical benefits
401(k) plan
Paid time off
Database Administrator: Secure, High-Availability Data Ops
Database Administrator: Secure, High-Availability Data Ops

Work corp • Las Vegas (NV)

On-site
USD 9,100 - 11,000
Senior Database Administrator (SQL Server & Azure Data Platform)
Senior Database Administrator (SQL Server & Azure Data Platform)

Madison-Davis • New Jersey

Hybrid
USD 120,000 - 180,000
Senior SQL Server DBA
Senior SQL Server DBA

Veriipro • New York (NY)

On-site
USD 110,000 - 170,000
Data Base Administrator (DBA)
Data Base Administrator (DBA)

Marwood Group • New York (NY)

On-site
USD 90,000 - 120,000
Senior SQL Server DBA - HA & Performance Lead
Senior SQL Server DBA - HA & Performance Lead

AmeriSave Mortgage • United States

Remote
USD 115,000 - 150,000
401(k)
Dental insurance
Disability insurance
+9
Database Administrator — Cloud/On-Prem Performance & Security
Database Administrator — Cloud/On-Prem Performance & Security

Associates Systems LLC • Indian Head (MD)

On-site
USD 90,000 - 130,000