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

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

Database Operations, Reliability & Recovery

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

Performance Tuning & Capacity Planning

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

Migrations, Lifecycle & Cloud Modernization

• 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 standards.
• Evaluate and recommend modern data platform services (e.g., Azure SQL, Azure MySQL Flexible Server, Microsoft Fabric, Databricks) and support adoption where they meet firm needs.

Security, Compliance & Access Controls

• Administer database security, including logins, roles, and least-privilege permission models, with clear separation of duties.
• Manage vendor and application access controls and ensure auditable, well-governed changes.
• Support the firm's compliance, backup/retention, and risk-assessment requirements as they relate to data.
• Support data classification and sensitivity mapping efforts in coordination with the Security and Data Governance functions.

Data Engineering & Pipeline Support

• Develop and support ETL/ELT processes and pipeline orchestration using SSIS, Azure Data Factory, or equivalent tooling.
• Contribute to repeatable practices for data warehouse implementation, view/virtual data object logic, and reliable data delivery.
• Establish and maintain SQL code repository practices, including source control, branching, review, and deployment standards for database code.
• Partner with the Analytics team and outsourced database developers to ensure database…