Database Administrator

Job Description

We are seeking a detail-obsessed Database Administrator with a strong focus on PostgreSQL and experience managing complex, high-availability environments. This role is not about simply keeping the lights on — it’s about owning the data layer, solving non-obvious latency issues, designing for scale, and building fault-tolerant database infrastructure that serves millions of users in real time.

The ideal candidate thrives in production-critical environments, understands how databases interact with application layers, and isn’t afraid to say “this schema won’t scale” or rewrite a bad query. You’ll collaborate closely with backend engineers, SREs, and security analysts to ensure our databases are performant, secure, and recoverable.

Key Responsibilities:

• Manage, monitor, and tune multiple PostgreSQL clusters (12.x and above) in both production and staging environments.
• Design and implement robust backup, recovery, and disaster recovery strategies — you’ll be the one we trust to bring data back fast under pressure.
• Optimize slow-running queries and educate developers on writing performant SQL.
• Own and maintain database-level observability: query metrics, slow logs, locks, and replication lag.
• Design and enforce database security standards (role-based access, data encryption at rest and in transit, audit logging).
• Evaluate and execute schema migrations with zero downtime using tools like Sqitch, Liquibase, or Flyway.
• Collaborate with DevOps to ensure tight integration of DB systems with container orchestration (Kubernetes experience preferred).
• Develop custom tooling or automation scripts (Python, Bash, or Go) to improve operational efficiency.

Qualifications:

Required:

• 5+ years of experience administering PostgreSQL in a production environment.
• Proven success managing HA setups using Patroni, PgBouncer, or similar tooling.
• Deep understanding of query planning, indexing strategies, and vacuum behavior.
• Experience with logical and physical replication, including cross-region setups.
• Proficiency in scripting languages (e.g., Bash, Python) for automation.
• Comfortable with Infrastructure-as-Code (Terraform, Ansible, or Helm).
• Strong knowledge of Linux internals as they relate to database performance (IO, memory, kernel tuning).
• On-call rotation experience with confidence in handling real-time production incidents.

Nice to Have:

• Experience migrating from commercial RDBMS (e.g., Oracle, MS SQL) to PostgreSQL.
• Familiarity with hybrid cloud or multi-cloud architectures (AWS RDS/Aurora, GCP Cloud SQL).
• Exposure to time-series extensions like TimescaleDB or columnar storage engines.
• Contributions to open-source database projects or communities.

Are you interested in this position?

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

#GraphicDesignJobsOnline#WebDesignRemoteJobs #FreelanceGraphicDesigner #WorkFromHomeDesignJobs #OnlineWebDesignWork #RemoteDesignOpportunities #HireGraphicDesigners #DigitalDesignCareers#Dynamicbrandguru