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 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

Employment Type : Full Time

Experience : years

Vacancy : 1