Description

Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, trouble shooting of PostgreSQL.

Expertise in Disaster Recovery plans by configuring Streaming Replication, Logical Replication, and utilizing backup and restore tools like pg Backrest or Barman.

Implementing High Availability in PostgreSQL using tools like Patroni, repmgr, or Pacemaker with Streaming Replication.

Expertise knowledge in database encryption methods for PostgreSQL.

Expertise in database Back Up, Restore, Recovery, updating statistics (`VACUUM ANALYZE`), Rebuilding and Reorganizing indexes (`REINDEX`, `CLUSTER`), Replication (Streaming and Logical), Foreign Data Wrappers, and routine maintenance tasks.

Monitoring Instances, Configuring and Enabling alerts using tools like Prometheus, Grafana, Datadog, or other PostgreSQL monitoring solutions.

Experience in query optimization and performance tuning. Experience in using `EXPLAIN ANALYZE`, `pg_stat_statements`, and system monitoring tools.

Experience in Python, Bash, or other scripting languages to automate day-to-day activities and troubleshoot/enhance existing scripts.





Monitoring/Troubleshooting Streaming Replication and Logical Replication setups.

Respond to and troubleshoot database-related problems reported by customers.

Automate routine database administration tasks.

Preparing Knowledge articles and sharing with the team on day-to-day activities.

PostgreSQL DBA

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 581495
- Project Location 1 : MAH | PUNE
- Project Location 2 : TELANGANA | HYDERABAD
- Project Location 3 : (No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : Kothakapu Bharath Reddy
- Relevant Experience : 6+ Years
- Mandatory skills : PostgreSQL DBA
- Desired skills : Refer JD
- Domain (Industry) : PostgreSQL DBA
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 8+ years
- BGC Details : NA
- BGC Vendor : FADV
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : Rotational (based on project requirement)
- Shift Timings : Others

📌 581495_PostgreSQL DBA (India)
🏢 Trigent Software
📍 India