Senior Enterprise Database Administrator

The Senior Enterprise Database Administrator (Senior DBA) is responsible for the performance, integrity, security, and availability of Berry Dunn's database platform, which supports operational, financial, healthcare, and analytical applications across on-premises SQL Server and Microsoft Azure environments. This is Berry Dunn's first dedicated database role and serves as the firm's senior technical authority for database operations.

The Senior Enterprise Database Administrator (Senior DBA) is responsible for the performance, integrity, security, and availability of Berry Dunn's database platform, which supports operational, financial, healthcare, and analytical applications across on-premises SQL Server and Microsoft Azure environments. This is Berry Dunn's first dedicated database role and serves as the firm's senior technical authority for database operations.

The Senior DBA takes full ownership of database backups and recovery, migrations, patching and lifecycle management, security and permissions, provisioning, performance tuning, and capacity planning. Beyond traditional administration, this role is expected to modernize how the firm operates its data layer: automating database operations, applying source control and Dev Ops practices to database code, contributing to data engineering and pipeline standards, and helping prepare the data platform for analytics, Power Platform, and AI workloads.

The role partners closely with the Engineering, Systems, Applications, Analytics, and Data Governance teams across Berry Dunn's consulting practices to ensure our databases are reliable, secure, performant, and well-documented. As the senior subject‑matter expert, the Senior DBA is also expected to mentor and cross‑train others, build runbooks that enable Service Desk and Systems staff, and reduce the firm's reliance on any single individual for database operations.

The ideal candidate is data‑driven, proactive, highly organized, and analytical, with the ability to troubleshoot complex issues, influence technical standards, and communicate effectively with both technical and non‑technical audiences.

This role requires minimal travel, less than 10% per year.

• Own backup, restore, and disaster recovery strategies across on‑premises and cloud databases.
• Maintain database maintenance plans, including indexing, integrity checks, statistics updates, and transaction log management.
• Monitor database health, availability, and jobs; proactively identify and resolve issues before they impact users.
• Design, implement, and maintain high availability and resiliency solutions such as SQL Server Always On Availability Groups, failover clustering, and log shipping.
• Ensure all databases remain on supported, patched, and secure versions of SQL Server and Azure database services.

• Lead proactive query tuning, index optimization, and performance troubleshooting across operational and analytics workloads.
• Optimize disk, I/O, and storage for large (4 TB+) analytics databases, including SSISDB health and performance management.
• Monitor system performance and storage utilization; forecast and plan for future database growth, capacity, and cloud cost efficiency.
• Support the healthcare analytics SAS environment with performance and reliability improvements.

• Plan and execute database migrations, including on‑premises to Azure, lateral server moves, version upgrades, and vendor transitions (e.g., EOL server consolidations).
• Manage SQL Server patching, upgrades, and end‑of‑life planning across the estate.
• Provision and configure new database instances and databases to firm…