Job Description

Basic Qualifications:

5 Plus years of experience on PostgreSQL in database administration, in an enterprise environment with multiple database servers

Database Health - Validations and Monitoring.

Database Migrations - Dedicated support for application migration waves

Automation capabilities - Validating and assisting in the enablement of automated capabilities for DBMS Configuration and Management

Provision, Build, Configure, Patch & Maintain PostgreSQL Clusters.

Vendor Engagement - Triage support to remediate identified issues during migrations

Job Responsibilities



Job Responsibilities:

Providing 24x7 support for production databases.

PostgreSQL database administration skills include Installation, Configuration, Security management, and Audit SQL server with PBM, Patch management, Performance tuning, Query optimization, Storage management.

Experience in Installation, Creation, Maintenance of Databases, Performance Tuning, Backup and Recovery, Providing and Configuring Disaster Recovery Solutions and Database Security.

Managing PostgreSQL 12, 13, 14, 15 & 16 instances.

Managing , Open Prem, AWS and Azure (PostgreSQL).

Experience in Streaming, Logical and Trigger Based Replication (repmgr, Patroni).

Installation and Configuration of Backup and Recovery (pgbackrest)

Formulated backup-recovery strategies for various Databases.

Installation and Configuration of repmgr 3.x, PgBouncer.

Implementation of database maintenance jobs to ensure optimal performance.

Qualifications

Range of Year Experience-Min Year

Range of Year Experience-Max Year