Postgresql DBA-L2/L3

19

Applications

Pune
Full-Time
Mid-Level: 4 to 6 years
Posted on Feb 16 2024

About the Job

Skills

postgresql dba
L2
REPLICATION
BACKUP
Vacuum
SHARDING

Location-Pune


POSTGRES L2 POSITION

Tech Profile·       

3.4 to 4+ years of strong experience as PostgreSQL DBA·    


   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·     

  Good to have: Experience on EDB products and Certifications.


Key Responsibilities:·    

   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





.  POSTGRES L3 POSITION


 Tech Profile·       

5.5 to 6+ years of strong experience as PostgreSQL DBA·    

   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.·    

   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 usres 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


Candidates available to join on immediate basis or on or before 1st April 2024 can apply




About the company

We have a very practical vision i.e. “Optimize IT operations cost”. This can be at Capex or Opex level. We are not here to show that we are masters in a technology product but we want to be with you in your journey of adapting new technology in very practical manner which can reduce the TCO. You can leverage our experience of handling multiple clients in same industry and get best out of ...Show More

Company Size

51-200 Employees

Headquarter

Mumbai

Other open jobs from Techberry Infotech Pvt Ltd