Job Description
Job details PostgreSQL-DBA-L2 & L3 Experience-2 to 5 yrs Work from Office Location-Pune(Work from Office only) Key Responsibilities L2 =================== Experience in monitoring, 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. Hands-on experience on Shell scripting. SQL query tuning hands-on experience. Responsible for understanding operational requirements including hardware, architecting, configuring, integrating, and maintaining mission-critical Production PostgreSQL databases. Responsible for all backup, recovery, PITR replicating Experience on community-supported tools like Pgbadger, Slony, PGadmin, Pgpool, Pgbouncer, barman, Clusters and upgrading/migrating various PostgreSQL database version. Database administration and tuning databases Develop database automation. scripts and maintenance. Provide technical guidance for integration, testing, design, development, planning of new production systems/databases Contribute to improving and creating DBA policies, procedures and standards. Key Responsibilities: L3 =================== Provide advance support for Application DB hosted Azure (EDB PostgreSQL and Postgres community edition) EDB Postgres Advanced Server (Implementation, Configuration, HA,Streaming Replication, EFM, & REPMGR for Postgres Databases) Design, maintain and ensure high availability solutions including replication, clustering etc. Design, Implement Disaster Recovery strategies. On-demand support for system failure, DR/HA Drill, festival support. Review periodic log files for PostgreSQL on proactive basis to find out potential risks and performance issues. DB Patch management (minor and major upgrade). Postgres Performance monitoring and optimization (parameter configuration and recommendation). 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 Based on the specific requests, help project teams to optimize PostgreSQL configurations Restoration of EDB Postgres Database using pg_restore and PITR as per requirement of usres and application Linux (RHEL & OEL 6,7 and 8) and Windows server 2012,2016 and 2019. Logical backup using PG_Dump and PG_Dumpall and restoration using PG_Restore. Database Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH. Interested candidates can share their updated resume on mail id
hidden_email Candidates should be available to join on or before 1st APRIL 2024 If you have any references then kindly share as it would be helpful
Employement Category:
Employement Type: Full time
Industry: IT Services & Consulting
Role Category: DBA / Datawarehousing
Functional Area: Not Applicable
Role/Responsibilies: Postgresql DBA(L2 & L3)
Keyskills:
PostgreSQL
Shell scripting
PGadmin
Database administration
Database tuning
Azure
Disaster Recovery
Linux
Windows server
Database Maintenance
Performance Benchmarking
DBA
SQL query tuning
Pgbadger
Slony
Pgpool
Pgbouncer
barman
Clusters
Database automation
EDB PostgreSQL
Postgres community edition
Postgres Performance monitoring
Logical backup