PostgreSQL Admin

Job Description:

IT 5-9 years experience as a DBA of PostgreSQL in a 24/7 production environment including backup recovery, replication, high availability, designing and managing schema, monitoring diagnosing and optimizing database performance

Ability to detect and troubleshoot database-related CPU, memory, IO, disk space, and other resource contention issues

Expertise in writing SQL queries, analysing query performance using query plans and tuning query performance

Expertise in Database Administration on PostgreSQL platforms operating within on premise & AWS installations.

Expertise in Troubleshooting and resolving database problems in a high transaction OLTP environment.

Database Performance Tuning and Optimization (PTO), using native monitoring and 3rd party tools.