Mgr, Database

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.

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

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