Job: Postgres Database Administrator (DBA)
Location: Sheffield, UK (3 days weekly from office)
We at Coforge are looking for Postgres Database Administrator (DBA) in Sheffield, UK.
Job Summary:
As a PostgreSQL Database Administrator (DBA), you will play a vital role in managing PostgreSQL databases to ensure their optimal performance and
reliability. Expertise in PostgreSQL, particularly in GCP environments, will be considered a significant advantage. You will be responsible for managing
database schemas, optimizing configurations, and troubleshooting production incidents. Your expertise in relational databases (PostgreSQL) will directly
support business objectives and operational capabilities.
Responsibilities:
PostgreSQL Database Administration:
* Collaborate with teams to integrate PostgreSQL databases into the infrastructure and ensure their optimal performance.
* Perform PostgreSQL database backups, recovery, and restoration activities.
* Optimize PostgreSQL configurations and query performance for transactional workloads.
* Design and implement PostgreSQL data models and SQL scripts for transactional workloads.
* Manage PostgreSQL databases in GCP environments (preferred).
* Diagnose and troubleshoot PostgreSQL production incidents and resolve performance bottlenecks.
Requirements:
PostgreSQL:
* 5+ years of experience in PostgreSQL database administration.
* Expertise in installing, configuring, and monitoring PostgreSQL databases.
* Proficiency in PostgreSQL data modeling and SQL scripting.
* Strong experience in performance tuning PostgreSQL databases to optimize writes and reads.
* Hands-on experience with PostgreSQL in GCP environments (preferred).
* Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.
Preferred Skills:
* Experience with Datastax Enterprise Service (DSE).
* Familiarity with cloud environments like GCP.
* Strong troubleshooting and analytical skills