Urgent opening for PostgresSQL DBA/Location-Pune/Salary-Upto 18lpa/Need 5+yrs of DBA/Shell scripting/EDB products/WFO

  • Pune
  • Jobman By Shunya Tattva

Hi Folks,


We have opening for the below with one of the leading IT firm


Designation-POSTGRES L3

Location- Pune

Salary- 18lpa

Rotational Shifts

Need IT Graduate with 5.5 to 6+ years of strong experience as PostgreSQL DBA

Hands-on experience on Shell scripting

Must have: Experience on EDB products and Certifications.


Key Responsibilities:


1. Provide advance support for Application DB hosted Azure (EDB PostgreSQL and Postgres community edition

2. EDB Postgres Advanced Server (Implementation, Configuration, HA, Streaming Replication, EFM, & REPMGR for Postgres Databases)

3. Design, maintain and ensure high availability solutions including replication, clustering etc

4. Design, Implement Disaster Recovery strategies.

5. On-demand support for system failure, DR/HA Drill, festival support

6. Review periodic log files for PostgreSQL on proactive basis to find out potential risks and performance issues

7. DB Patch management (minor and major upgrade)

8. Postgres Performance monitoring and optimization (parameter configuration and recommendation)

9. Provide inputs on tuning OS parameters as applicable to the DB server, provide advice on tuning the DB instance

parameters, provide recommendation for indexes, provide query tuning guidelines

10. Based on the specific requests, help project teams to optimize PostgreSQL configurations

11. Restoration of EDB Postgres Database using pg_restore and PITR as per requirement of users and application

12. Linux (RHEL & OEL 6,7 and 8) and Windows server 2012,2016 and 2019

13. Logical backup using PG_Dump and PG_Dumpall and restoration using PG_Restore

14. Database Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH

15.Experience in managing and maintaining mission-critical 24 by 7 production databases along with installation and configuration of the database, implementing high-availability solutions, setup monitoring tools, setup database security,

optimizing resources, etc.


Interested candidates kindly share your updated resume on WhatsApp or email on the below number.



Regards

Neha Arora

Team Leader-Recruitment

7208069100

Shunyatattva Management Consultant