Senior Database Administrator (SQL/PostgreSQL)
Overview
As a Senior Database Administrator for PostgreSQL and SQL Server, you will design, implement, and maintain highly available, secure databases supporting production and development environments. You will lead lifecycle management, backups, DR, performance tuning, and CI/CD automation for schema and data changes while mentoring junior DBAs. You’ll work with cross-functional teams to harden security and optimize operations at scale. This role offers meaningful impact through reliable data platforms that enable business resilience and innovation.
Compensation / BenefitsVacation/PTOMedicalDentalVision401kRemote
ResponsibilitiesDesign, implement and maintain PostgreSQL and SQL Server databases to meet availability, scalability and security requirementsManage backup and restore strategies, verify recoverability, and execute disaster recovery and failover proceduresPerform performance tuning and query optimization, including index strategy and resource monitoringImplement and operate high-availability and replication solutions (clustering, streaming replication, failover orchestration)Develop and maintain automation for provisioning, configuration, schema migrations and deployments using CI/CD tools and database migration frameworksCreate and maintain monitoring, alerting and capacity planning practices to proactively identify and remediate issuesCollaborate with application, infrastructure and security teams to support deployments, incident response, and security hardeningAuthor and maintain runbooks, documentation, and playbooks for operations, backup/recovery, and change managementDrive database change management and deployment processes (code reviews, rollback strategies, release coordination)Mentor and train junior DBAs and engineers on best practices, troubleshooting and operational procedures
Key requirements5+ years of professional database administration experience with PostgreSQL and SQLExpert-level SQL skills and deep understanding of database internals, indexing, query plans and performance optimizationProven experience with backup, restore and disaster recovery strategies and testing recoverabilityExperience implementing and operating CI/CD for database deployments and schema migrationsStrong experience with PostgreSQL features (roles, extensions, WAL, replication, partitioning, vacuuming/autovacuum tuning)Proficient with monitoring and observability tools (PgBouncer, Patroni, Prometheus, Grafana or equivalent)Scripting and automation skills (Python and/or PowerShell) for tooling and runbooksFamiliarity with cloud platforms and services (Azure preferred) and operating databases in cloud/hybrid environmentsExperience with high availability, failover, clustering, and replication technologiesNice to have: RedGate, Flyway, Octopus Deploy, Kubernetes and DockerStrong communication and collaborationMentoring and coachingDocumentation and runbook creationPostgreSQLSQL ServerBackup/DR strategies