PostgreSQL DBA

This is a remote position.

Job Title: PostgreSQL DBA (Database Administrator)

Location: Remote

We are seeking a skilled and experienced PostgreSQL DBA to manage maintain and optimize our PostgreSQL database infrastructure. The ideal candidate will ensure high availability security and performance of our data systems and support development teams with SQL best practices and performance tuning.

Key Responsibilities:

• Install configure and upgrade PostgreSQL database systems
  

• Perform regular database maintenance tasks: backup recovery indexing vacuuming and updates
  

• Monitor system performance identify bottlenecks and tune queries
  

• Set up and maintain replication clustering and high availability (HA) environments
  

• Manage user roles access controls and database security
  

• Automate routine tasks using scripts or tools (Bash Python Ansible etc.)
  

• Troubleshoot issues related to performance downtime or failures
  

• Assist development teams with query optimization and schema design
  

• Implement and monitor backup and disaster recovery solutions
  

• Maintain documentation for processes configurations and policies
  

Required Skills:

• Strong hands-on experience with PostgreSQL (v10)
  

• In-depth knowledge of SQL and PL/pgSQL scripting
  

• Familiarity with pgAdmin psql CLI and PostgreSQL extensions (e.g. PostGIS pgstatstatements)
  

• Experience in database replication logical/physical backups and failover strategies
  

• Proficiency in Linux/Unix environments
  

• Basic understanding of networking firewall rules and cloud services (AWS Azure GCP)
  

• Knowledge of monitoring tools like Nagios Prometheus or pgMonitor
  

Good to Have:

• Experience with other RDBMS like MySQL Oracle or MS SQL
  

• Familiarity with NoSQL databases (MongoDB Redis)
  

• Knowledge of DevOps tools (Docker Kubernetes CI/CD pipelines)
  

• Experience working in Agile/Scrum environments
  

• PostgreSQL certification or relevant coursework