Database Administrator

Job Description

Position Summary:

We are seeking an experienced Database Administrator with a deep understanding of PostgreSQL internals and proven experience managing high-availability, large-scale transactional databases in production environments. This role will support mission-critical applications across multiple business units with zero tolerance for downtime and a strong emphasis on performance tuning and security compliance.

Key Responsibilities:

• Architect, implement, and maintain PostgreSQL clusters with streaming replication, hot standby, and point-in-time recovery.
• Tune queries and indexes for high-volume OLTP workloads involving 10K+ concurrent users and 1TB+ datasets.
• Manage HA/DR strategies using tools like Patroni, pgBackRest, and pgbouncer.
• Conduct regular performance benchmarking and provide optimization reports to engineering and analytics teams.
• Implement role-based access control (RBAC) and maintain compliance with SOC 2 and HIPAA data standards.
• Automate backup, maintenance, and failover routines via Ansible or Terraform.
• Monitor and resolve replication lag, deadlocks, and long-running queries using Prometheus, Grafana, and pg_stat_statements.
• Collaborate with developers to review schema changes and design efficient data models.
• Maintain strong audit trails and support forensic analysis when required.

Required Qualifications:

• 5+ years of hands-on experience as a PostgreSQL DBA in production environments (not just RDS or cloud-managed).
• Proven expertise in PostgreSQL 13+ including streaming replication, logical replication, and WAL archiving.
• Advanced understanding of database internals (e.g., vacuuming, autovacuum thresholds, query planner behavior).
• Experience with Linux-based environments (Debian/Ubuntu/CentOS) and command-line tooling.
• Demonstrated ability to write complex SQL queries and PL/pgSQL procedures.
• Familiarity with Infrastructure as Code (IaC) for database provisioning (Ansible, Terraform).
• Hands-on experience with observability tools: pg_stat_monitor, pgBadger, Prometheus exporters.

Are you interested in this position?

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

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