Senior Enterprise Database Administrator

Senior Enterprise Database AdministratorThe Senior Enterprise Database Administrator (Senior DBA) is responsible for the performance, integrity, security, and availability of BerryDunn's database platform, which supports operational, financial, healthcare, and analytical applications across on-premises SQL Server and Microsoft Azure environments. This is BerryDunn'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 DevOps 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 BerryDunn'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.You WillDatabase Operations, Reliability & RecoveryOwn 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 PlanningLead 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 ModernizationPlan 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 ControlsAdminister 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 SupportDevelop 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 designs are performant, secure, and supportable.Data Quality, Lineage & Governance SupportContribute to and help maintain data source inventories, relationship mapping, and data lineage documentation.Help define and monitor data quality measures and service level objectives for key databases and reporting workloads.Partner with Data Governance and the M365 Platform Owner on shared accountabilities for data platform standards, retention, and classification.AI & Power Platform Data EnablementSupport data platform readiness for AI and Power Platform workloads, including data source inventory for AI agents and supporting Dataverse data practices.Ensure data feeding AI, reporting, and low-code solutions is accurate, secure, appropriately classified, and performant.Application & Integration SupportSupport custom and vendor-managed application databases (approximately 30% custom applications and 60% vendor-managed).Manage data gateways and connectivity that bridge on-premises data to Azure, Tableau, and Tableau Bridge.Install and support related SQL Server components such as SSIS (integration services) and SSRS (reporting services).Collaborate with the Applications and Systems/Engineering teams to support development work and safely deploy database changes into production.Automation, Standards & DocumentationLeverage PowerShell (including the dbatools and sqlserver modules) to automate routine DBA tasks, standardize configurations, and reduce manual effort.Implement and maintain automated maintenance solutions with Ola Hallengren's SQL Server Maintenance Solution.Apply infrastructure-as-code and CI/CD practices (e.g., Bicep, Azure DevOps Pipelines, GitHub Actions) to database provisioning and deployments in partnership with Platform Engineering.Establish, document, and enforce database standards, runbooks, and operational procedures, and align them with enterprise architecture and platform standards.Maintain accurate documentation of database architecture, configurations, and processes, and keep production code in source control (Azure DevOps / GitHub).Leadership, Mentoring & Knowledge TransferServe as the firm's senior subject-matter expert and escalation point for database issues.Mentor and cross-train Systems, Service Desk, and Applications staff, including building runbooks that enable Tier 1 and Tier 2 support to handle routine database requests.Provide backup coverage and knowledge transfer so that database operations are no longer dependent on a single individual.Represent database considerations in project planning, change advisory, and architecture discussions.You HaveBachelor's degree in Computer Science, Information Technology, or a related field. (Equivalent experience or technical certifications may be considered.)Typically 5+ years of progressive experience as a SQL Server DBA or in a similar dedicated database administration role, including senior-level ownership of a production database estate.Strong hands-on experience with Microsoft SQL Server and Azure SQL Database; experience with Azure MySQL Flexible Server a plus.Demonstrated experience with backup, recovery, security, integrity, high availability (Always On/clustering), and performance tuning.Experience with database migrations, including on-premises to cloud (Azure) migrations.Experience supporting large-scale and/or analytics databases (multi-terabyte) is strongly preferred.Experience with PowerShell automation and the dbatools module.Experience with Ola Hallengren's maintenance solution and standardized maintenance frameworks.Hands-on experience with SSIS, SSRS, and data integration/reporting components; experience with Azure Data Factory or similar orchestration tooling preferred.Experience with source control and DevOps practices for database code (Git, Azure DevOps, GitHub); familiarity with CI/CD and infrastructure-as-code a plus.Certificates, License & Registrations (Preferred but not required)Microsoft Certified: