PharMerica

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.

 

Benefits and perks for You!    

• 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 

 

*Benefits may vary by employment status   

• 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.