This is a remote position.
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.
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
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, pg_stat_statements)
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
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