Database Administrator

Description

The Database Administrator is a specialist individual-contributor role at the Upper Mid (L3+) level, above Data Engineer II and alongside Data Engineer III, responsible for the availability, performance, security, and recoverability of Campbell Companies’ relational databases and the Microsoft Fabric capacity. This role administers the on-premises SQL Servers, the Azure SQL databases and the Microsoft Fabric capacity behind enterprise applications (ERP, CRM, WHM), reporting and the Data platform, owns backups and disaster recovery for the database tier, tunes performance, manages database and Fabric security and access, including user access and Microsoft Entra groups for Fabric, and plans upgrades and migrations. Reporting to the Director, Data, the Database Administrator works closely with the Data Engineering team on reliable source-system access for the Microsoft Fabric platform, with IT Infrastructure (Manager, Infrastructure & Cloud Ops) on servers, hosting, storage and the host operating system, and with the Manager, Enterprise Solutions & Experience and application owners on application databases. Within the Data team's plan, this role also carries the legacy data estate, security and governance, and the Fabric capacity. This position supports all Campbell Companies.

Duties and Responsibilities

Database Administration & Availability

• •Administer on-premises SQL Server instances, Azure SQL databases and the Microsoft Fabric capacity supporting enterprise applications (ERP, CRM, WHM), the reporting layer and the Data platform, including instance configuration, SQL Server Agent jobs, maintenance plans, and high-availability features.
• •Own database backups, restore testing on a schedule with evidence kept, and disaster recovery for the database tier; ensure RPO/RTO targets are defined, documented, and tested.
• •Monitor database health and availability; respond to alerts and resolve database incidents within SLA targets, including participation in the on-call rotation on the Data team's rotation, with IT Infrastructure engaged for host-level incidents.
• •Own capacity planning and storage management across on-premises and Azure-hosted database instances.
• •Own the on-premises data gateways: install, patch, rotate credentials, monitor, and retire them as data sources move to the cloud.
• •Partner with IT Infrastructure on the host operating system, storage and disks, and scheduled OS-level maintenance (including PowerShell maintenance scripts) on the servers that on-premises SQL Server runs on; own the database-level impact and escalate host-level issues to Infrastructure.

Performance Tuning

• •Monitor and tune database performance, including index analysis, query plan optimization, statistics maintenance, and resource governance.
• •Partner with application owners, the Enterprise Solutions Software Engineer, and vendors to resolve slow queries, blocking, and deadlocks.
• •Review new database objects, stored procedures, and schema changes for performance and standards before production deployment.
• •Monitor and optimize Microsoft Fabric capacity unit (CU) consumption: track capacity metrics, identify and tune expensive items, prevent throttling, and keep the AI and BI shares of capacity visible. Administer the Fabric capacity day to day under the Director, Data's plan: the baseline, the dev/prod split, optimization, and a cost view by consumer including AI

Security & Compliance

• •Manage database security, including logins, roles, least-privilege access, row-level security, Transparent Data Encryption (TDE), and auditing.
• •Apply database patches and cumulative updates in coordination with the Manager, Infrastructure & Cloud Ops and per security directives from the Manager, Infrastructure & Cloud Ops.
• •Support access reviews, audit evidence requests, and data protection requirements for regulated and sensitive data.
• •Administer Fabric workspace access and Microsoft Entra groups for Fabric so access follows role, with no personal grants; manage service principals and their secrets for data-platform identities. The Database Administrator creates, owns and manages the row-level security roles and the Microsoft Entra group mapping and membership, with no access granted to individual users; Data Engineers implement access only through those roles, and Business Intelligence uses them in its certified datasets.
• •Run the Microsoft Purview account, scans and access model that carry the data dictionary's term ids, history and lineage, with Business Intelligence writing the definitions and relationships; register and scan the databases this role administers.

Upgrades, Migrations & Standards

• •Plan and execute database migrations and version upgrades with minimal business disruption, and support migration of legacy databases to the target platform agreed in the Data roadmap (Azure SQL or Fabric).
• •Participate in database schema design reviews, working with software engineers and data engineers, and enforce standards for naming conventions, referential integrity, and normalization.
• •Coordinate ERP, CRM, and WHM database administration with the Manager, Infrastructure & Cloud Ops (servers and hosting platform) and the Manager, Enterprise Solutions & Experience (application owners).
• •Support decommissioning of legacy database servers as data sources are retired, in step with the Data team’s retirement plan.

Data Platform Partnership

• •Provide reliable, secure, and performant source-database access for Data Engineering pipelines that ingest ERP, CRM, and operational data into the Microsoft Fabric lakehouse, including change data capture where needed.
• •Partner with the Director, Data and Data Engineers on extraction patterns that protect production database performance.
• •Support Analytics Engineering with database-level troubleshooting for reporting sources.

Documentation & Continuous Improvement

• •Maintain runbooks, the legacy data estate register (every legacy database, integration and gateway, including DB2 and MIMIX, CData, SSIS, DBSSQL3 and the on-premises gateways, each with a named business owner, a retire-or-keep decision and planned conversions, as the input to the retirement plan), database inventories, configuration baselines, and recovery procedures.
• •Automate routine DBA tasks using T-SQL, PowerShell (including dbatools), and SQL Server Agent.
• •Stay current with SQL Server and Azure SQL roadmap developments and recommend improvements.
• •Work safely in all aspects of the role.
• •Performs all other duties as assigned.

Qualifications

Education

Bachelor’s degree in Computer Science, Information Systems, or a related field; equivalent experience considered.

Experience

• •Minimum of 4–7 years of database administration experience, including at least 3 years administering production SQL Server environments.
• •Demonstrated experience with backup/recovery, performance tuning, security, and version upgrades for business-critical databases.
• •Experience supporting ERP or other enterprise application databases preferred.
• •Experience with Azure SQL Database or Azure SQL Managed Instance preferred.
• •Experience administering Microsoft Fabric or Power BI Premium capacity preferred.

Technical Skills

• •Expert T-SQL, including complex queries, stored procedures, indexing strategies, and query plan analysis.
• •SQL Server administration: backup/restore, SQL Server Agent, DMVs, Always On availability groups or log shipping, TDE, and Database Mail.
• •Azure SQL Database and Managed Instance administration, including security, scaling, and monitoring.
• •PowerShell (including dbatools) for automation.
• •Familiarity with change data capture and data integration patterns used by Microsoft Fabric and Azure Data Factory.
• •Source control proficiency (Git / Azure DevOps) for schema change management.

Skills and Competencies

• •Strong analytical and root-cause problem-solving skills under production pressure.
• •Meticulous attention to detai