Senior Database Administrator – Job Description
Own advanced database administration and technical escalation across SQL Server, PostgreSQL and MySQL workloads in scope, including performance, resilience, security and controlled recovery.
· Own complex database incidents involving blocking, deadlocks, stored procedure/function failures, query regressions and database availability.
· Administer and troubleshoot SQL Server, PostgreSQL and MySQL, including SQL Server on FSx/EC2 and RDS PostgreSQL/MySQL.
· Investigate deadlock graphs, blocking chains, wait conditions, execution plans, slow queries, indexes and resource bottlenecks; implement approved remediation.
· Lead database capacity and performance analysis across CPU, memory, I/O, storage growth, connections, query workload and scaling.
· Own backup/recovery assurance, point-in-time recovery where supported, full restore tests and recovery evidence.
· Lead replication configuration and advanced troubleshooting, including replication failures and lag; coordinate network-path validation.
· Assess HA/DR readiness and plan/execute approved failover/failback tests for SQL Server FSx clusters and RDS PaaS.
· Review and approve database deployment scripts, schema/stored procedure changes and production database changes with peer review, implementation and rollback plans.
· Perform database setup/configuration, operations and maintenance; maintain standards for indexing, partitioning, configuration and resource management.
· Provide database security input, privileged access review, stale-access removal and patch planning.
· Support complex SQL logic, business rules, code review and optimization; application feature development excluded unless separately agreed.
· Contribute to data modelling, partitioning and multi-tenant design under approved project/change.
· Lead migration/conversion planning and data validation only when explicitly in approved scope.
· Maintain DBA runbooks, known-error records and procedures; coach Junior DBAs.
· Strong hands-on Microsoft SQL Server administration; practical PostgreSQL/MySQL and managed RDS knowledge.
· Advanced SQL, stored procedure/function troubleshooting, execution plans, indexing and query optimization.
· Database internals, storage, memory, locking, transactions and concurrency.
· Backup/recovery, point-in-time restore, CHECKSUM, restore testing and recovery planning.
· Replication, clustering, HA/DR failover/failback.
· Database security, patch/change management, RCA and technical communication.
· SQL, PowerShell or Python scripting for routine DBA checks.
· Database availability/performance against agreed SLAs.
· P1/P2 database incidents technically owned and resolved/escalated on time.
· Backup success, restore-test completion and recovery evidence.
· Replication health and lag exceptions managed.
· Reduction in recurring blocking/deadlock/query issues.
· Approved database changes with validation and rollback evidence.
· One Senior DBA is the advanced technical owner; this does not independently establish 18×7 dedicated DBA coverage.
· Define out-of-hours rota/on-call, escalation backup and leave coverage.
· Migrations, major redesign, application SQL development and large platform upgrades require explicit scope.