About the role
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.