Database Administrator

Remote

May 8, 2025

Full Time

Application ends: August 8, 2025

Job Description

Job Summary

We are seeking a highly skilled Database Administrator (DBA) with hands-on expertise in managing mission-critical PostgreSQL and Microsoft SQL Server environments across production and staging systems. The ideal candidate will have demonstrated experience in query optimization, automated backup/recovery processes, and database security protocols, particularly in environments subject to SOC 2 or HIPAA compliance.

Key Responsibilities

Design, deploy, and maintain PostgreSQL and SQL Server databases in a high-availability, multi-region environment.
Implement and manage replication (e.g., streaming replication, Always On Availability Groups) and disaster recovery strategies.
Develop and maintain custom monitoring solutions for query performance, slow log analysis, and storage growth trends.
Collaborate with development teams to optimize stored procedures, indexes, and complex joins in high-throughput applications.
Enforce database access control policies and audit mechanisms aligned with internal compliance requirements.
Manage schema migrations using tools such as Liquibase or Flyway, with strict version control via Git workflows.
Lead root cause analysis (RCA) efforts for database-related incidents, documenting findings and remediation steps.
Evaluate and recommend improvements for current infrastructure (e.g., failover mechanisms, partitioning strategies).
Support DevOps teams in automating database provisioning and configuration via Terraform or Ansible.

Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or related field; Master’s degree preferred.
5+ years of hands-on DBA experience in a production environment, with direct responsibility for PostgreSQL and SQL Server.
Deep knowledge of SQL query tuning, execution plans, and database engine internals.
Proven expertise with database replication, HA/DR design, and automated failover strategies.
Proficient in scripting (e.g., Bash, PowerShell, or Python) for automation and scheduled tasks.
Experience with cloud-hosted databases (e.g., AWS RDS, Azure SQL) and hybrid cloud/on-prem configurations.
Familiarity with compliance frameworks such as SOC 2, HIPAA, or PCI-DSS, particularly in a data handling context.
Comfortable working with CI/CD pipelines that integrate database changes.

Preferred Qualifications

Experience with PostgreSQL logical replication and SQL Server Query Store analysis.
Familiarity with infrastructure-as-code principles and tooling.
Contributions to internal database documentation and disaster recovery playbooks.
Certifications such as Microsoft Certified: Azure Database Administrator Associate or EDB PostgreSQL Associate are a plus.

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!