Pharmerica
From Pharmerica's careers page
Status: listed on the employer's own careers page when we last checked (daily). Confirm on their site before applying.
Our Company
PharMerica
Overview
Responsible for ensuring database availability, performance, security, and integrity. Leads a team of database administrators, plans and implements database upgrades, backups, and recovery procedures. Collaborates with IT and development teams to support data requirements and troubleshoot database-related issues. Develops and enforces database policies and best practices to ensure compliance with organizational standards and regulatory requirements.
Medical, Dental, Vision insurance
Health Savings & Flexible Spending Accounts (up to $5,000 for childcare)
Tuition discounts & reimbursement
401(k)
Company Paid Time Off*
Shift Differential
DailyPay
Pet Insurance
Employee wellness and discount programs
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
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
Windows Server, storage, and virtualization fundamentals as they affect database performance
PowerShell scripting for administrative automation
Database security administration in a regulated or externally audited environment
Written communication sufficient to produce runbooks, incident reports, and architecture proposals for non-specialist readers
Availability for on-call rotation and after-hours maintenance windows
PharMerica, an affiliate of BrightSpring Health Services, delivers personalized pharmacy care through dedicated local teams, serving health care providers such as skilled nursing facilities, senior living communities, and hospitals. We also cater to individuals with behavioral needs, infusion therapy needs, seniors receiving in-home care, and patients with cancer. Operating long-term care, home infusion, and specialty pharmacies across the nation, we combine the personal touch of a neighborhood pharmacy with the resources of a national network. Our comprehensive solutions, backed by industry-leading technology and regulatory expertise, ensure accurate medication access, cost control, and compliance with best-in-class clinical standards. We are committed to enhancing resident health, reducing staff burdens, and supporting our clients' success. For more information, visit www.pharmerica.com. Follow us on Facebook, Twitter, and LinkedIn.
Scores your resume against this job the way resume scanners do: the job's hard and soft skills, searchability, recruiter tips and formatting.
Create a free account to see your score. Your resume stays in this browser until then, and we never store it.
Already a member? Sign in