Senior PostgreSQL Administrator – Enterprise Database Architecture

Vertex Analytics

Freelance · Remote · Flexible hours

About the role

Vertex Analytics is accelerating its release cadence through a focused CI/CD and platform automation sprint. We need a seasoned PostgreSQL Administrator to design, implement, and fine‑tune automated database pipelines that integrate seamlessly with our deployment workflow.

Key responsibilities

• Architect and deploy PostgreSQL clusters using IaC tools (Terraform, Ansible)
• Build CI/CD jobs that provision, migrate, and validate databases on each release
• Implement automated backup, restore, and point‑in‑time recovery processes
• Monitor performance metrics and tune queries for sprint‑time efficiency
• Collaborate with DevOps engineers to embed database steps into GitLab/CircleCI pipelines

Must-have skills

• 5+ years managing PostgreSQL in production environments
• Proficiency with CI/CD platforms and scripting (Bash, Python)
• Experience automating schema changes and data migrations
• Strong understanding of replication, sharding, and high‑availability setups

Nice to have

• Hands‑on with MongoDB or MySQL for cross‑database workflows
• Familiarity with container orchestration (Kubernetes)
• Knowledge of monitoring tools like Prometheus or Grafana