PostgreSQL DBA

This is a remote position.

Job Title: PostgreSQL DBA (Database Administrator) Location: Remote Experience: 10y+ Job Type: Freelance Job Summary: 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, 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 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