SeniorDatabase Administrator – Job Description
Ownadvanced database administration and technical escalation across SQL Server,PostgreSQL and MySQL workloads in scope, including performance, resilience,security and controlled recovery.
Key responsibilities
- Own complex database incidents involving blocking, deadlocks,stored procedure/function failures, query regressions and databaseavailability.
- 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; implementapproved 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 wheresupported, 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/failbacktests for SQL Server FSx clusters and RDS PaaS.
- Review and approve database deployment scripts, schema/storedprocedure 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 resourcemanagement.
- Provide database security input, privileged access review,stale-access removal and patch planning.
- Support complex SQL logic, business rules, code review andoptimization; application feature development excluded unless separatelyagreed.
- Contribute to data modelling, partitioning and multi-tenant designunder approved project/change.
- Lead migration/conversion planning and data validation only whenexplicitly in approved scope.
- Maintain DBA runbooks, known-error records and procedures; coachJunior DBAs.
Required skills and experience
- Strong hands-on Microsoft SQL Server administration; practicalPostgreSQL/MySQL and managed RDS knowledge.
- Advanced SQL, stored procedure/function troubleshooting, executionplans, indexing and query optimization.
- Database internals, storage, memory, locking, transactions andconcurrency.
- Backup/recovery, point-in-time restore, CHECKSUM, restore testingand recovery planning.
- Replication, clustering, HA/DR failover/failback.
- Database security, patch/change management, RCA and technicalcommunication.
- SQL, PowerShell or Python scripting for routine DBA checks.
KPIs / expected outcomes
- Database availability/performance against agreed SLAs.
- P1/P2 database incidents technically owned and resolved/escalatedon 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.
Authority and boundaries
- One Senior DBA is the advanced technical owner; this does notindependently establish 18×7 dedicated DBA coverage.
- Define out-of-hours rota/on-call, escalation backup and leavecoverage.
- Migrations, major redesign, application SQL development and largeplatform upgrades require explicit scope.