Description :

Role Overview :

As a Database Consultant I (PostgreSQL), you will take ownership of PostgreSQL database environments, offering expert-level support to our clients.

This role involves proactive monitoring, performance tuning, troubleshooting, high availability setup, and guiding junior team members.

You will play a key role in customer-facing technical delivery, solution design, and implementation.

Key Responsibilities :

- Manage PostgreSQL production environments for performance, stability, and scalability.

- Handle complex troubleshooting, performance analysis, and query optimisation.

- Implement backup strategies, recovery solutions, replication, and failover techniques.

- Set up and manage high availability architectures (Streaming Replication, Patroni, etc.

- Work with DevOps/cloud teams for deployment and automation.

- Support upgrades, patching, and migration projects across environments.

- Use monitoring tools to proactively detect and resolve issues.

- Mentor junior engineers and guide troubleshooting efforts.

- Interact with clients to understand requirements and deliver solutions.

Requirements :

- 35 years of hands-on experience in PostgreSQL database administration.

- Strong Linux OS knowledge and scripting skills (Bash/Python).

- Proficiency in SQL tuning, performance diagnostics, and explain plans.

- Experience with tools like pgBackRest, Barman for backup and recovery.

- Familiarity with high availability, failover, replication, and clustering.

- Good understanding of AWS RDS, Aurora PostgreSQL, and GCP Cloud SQL.

- Experience with monitoring tools like pg_stat_statements, PMM, Nagios, or custom dashboards.

- Knowledge of automation/configuration tools like Ansible or Terraform is a plus.

- Strong communication and problem-solving skills.

Preferred Qualifications :

- Bachelors or Masters degree in Computer Science, Engineering, or equivalent.

- PostgreSQL certification (EDB/Cloud certifications preferred).

- Past experience in a consulting, customer support, or managed services role.

- Exposure to multi-cloud environments and database-as-a-service platforms.

- Prior experience with database migrations or modernisation projects