Postgresql DBA-L2/L3

4 weeks ago

pune, India Techberry Infotech Pvt Ltd Full time

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




  • PostgreSQL DBA

    3 weeks ago

    Pune, India Virtusa Full time

    PostgreSQL DBA - CREQ185384 Description strong working experience with PostgreSQL activities like supporting implementations, Upgrades, ongoing maintenance and implementing Golden GateInstalling, configuring, troubleshooting and maintaining of databases on Test and Production( with Local Resilience )Database Architecture & design, RTO (recovery time...

  • PostgreSQL DBA

    4 weeks ago

    Pune, India Virtusa Full time

    PostgreSQL DBA - CREQ185384 Description strong working experience with PostgreSQL activities like supporting implementations, Upgrades, ongoing maintenance and implementing Golden Gate Installing, configuring, troubleshooting and maintaining of databases on Test and Production( with Local Resilience ) Database Architecture & design, RTO (recovery time...

  • PostgreSQL DBA

    4 weeks ago

    pune, India Virtusa Full time

    PostgreSQL DBA - CREQ185384 Description strong working experience with PostgreSQL activities like supporting implementations, Upgrades, ongoing maintenance and implementing Golden GateInstalling, configuring, troubleshooting and maintaining of databases on Test and Production( with Local Resilience )Database Architecture & design, RTO (recovery time...

  • L2/L3 Test Automation/Python Test Engineer

    3 weeks ago

    Pune, India Inspirisys Solutions Limited Full time

    L2/L3 Test Automation/Python Test Engineer | Chennai, Bangalore, Cochin, Trivandrum, Hyderabad, Pune, Mumbai, Gurgaon, KolkataFunction - Product Engineering and Development - Non BankingRequirements / Responsibilities:Should have 4+ years of experience in L2/L3 protocol testingMust have experience in automation using Python

  • Python and L2& L3 Tester

    2 days ago

    Pune, Maharashtra, India Global Talent Strategist Full time

    **Vacancy for Python and L2 and L3 tester** - Collaborate with cross-functional teams to understand networking requirements and develop comprehensive test plans for L2/L3 protocols - Design, develop, and maintain automated test scripts using Python to validate networking functionalities and protocol compliance - Execute tests, analyze results, and generate...

  • L2/L3 Test Automation/Python Test Engineer

    4 weeks ago

    Pune, India Inspirisys Solutions Limited Full time

    L2/L3 Test Automation/Python Test Engineer | Chennai, Bangalore, Cochin, Trivandrum, Hyderabad, Pune, Mumbai, Gurgaon, Kolkata Function - Product Engineering and Development - Non Banking Requirements / Responsibilities: Should have 4+ years of experience in L2/L3 protocol testing  Must have experience in automation using Python

  • L2/L3 Test Automation/Python Test Engineer

    4 weeks ago

    pune, India Inspirisys Solutions Limited Full time

    L2/L3 Test Automation/Python Test Engineer | Chennai, Bangalore, Cochin, Trivandrum, Hyderabad, Pune, Mumbai, Gurgaon, Kolkata Function - Product Engineering and Development - Non Banking Requirements / Responsibilities: Should have 4+ years of experience in L2/L3 protocol testing  Must have experience in automation using Python

  • Percona/PostgreSQL/Cassandra DBA

    3 weeks ago

    Pune, India Paradise Placement Consultancy Full time

    Job Description:Location-: Kharadi, Pune.Hybrid Work ModePrimary skill:Oracle ADBA+ PostgreSql /CassandraOracle /AuroraDBExperience: 5 to 10yrsAn experienced Application DBA professional with experience ranging from 7-10 yrs in database administration on Oracle + Aurora (PostgreSQL)/ Cassandra.He has to be an individual contributor and willing to support...

  • Percona/PostgreSQL/Cassandra DBA

    4 weeks ago

    pune, India Paradise Placement Consultancy Full time

    Job Description:   Location-: Kharadi, Pune.   Hybrid Work Mode Primary skill:  Oracle ADBA+ PostgreSql /CassandraOracle /AuroraDB Experience : 5 to 10yrs An experienced Application DBA professional with experience ranging from 7-10 yrs in database administration on Oracle + Aurora (PostgreSQL)/ Cassandra. He has to be an...

  • PostgreSQL DBA

    4 weeks ago

    pune, India Clover Infotech Private Limited Full time

    1. Depth knowledge of the EDB PostgreSQL DB architecture. 2. Experience on community-supported tools like Pgbadger, Slony, PGadmin, Pgpool, Pgbouncer. 3. Cluster and upgrading/migrating various PostgreSQL database version.

  • PostgreSQL Dba

    4 days ago

    Pune, India AppyStack Private Limited Full time

    Having Experience in Installation and maintenance, Data extraction and transformation, Data Recovery, Authentication, Troubleshooting. Advantage to have expertise on AWS managed services Must Have **3+ years** hands-on experience in PostgreSQL. **Salary**: ₹275,252.30 - ₹716,550.97 per year Schedule: - Day shift Ability to commute/relocate: -...

  • Database Administrator

    4 weeks ago

    Pune, India Change leaders Full time

    Role : PostgreSQL DBAExperience : 5 - 8yearsLocations : Hyderabad, Bangalore, Pune, VijaywadaPrimary Skills : Postgresql DBA, Performance tunning, Migration, Upgradation , Backup and recoveryDesired Skills & Responsibilities :- Minimum 5 years of experience in database administration or database architecture- Implementing Postgresql database clusters with...

  • Database Administrator

    3 weeks ago

    Bangalore/Hyderabad/Pune/Vijayawada, IN Change leaders Full time

    Role : PostgreSQL DBAExperience : 5 - 8yearsLocations : Hyderabad, Bangalore, Pune, VijaywadaPrimary Skills : Postgresql DBA, Performance tunning, Migration, Upgradation , Backup and recoveryDesired Skills & Responsibilities :- Minimum 5 years of experience in database administration or database architecture- Implementing Postgresql database clusters with...

  • Database Administrator

    4 weeks ago

    Bangalore,Hyderabad,Pune,Vijayawada, India Change leaders Full time

    Role : PostgreSQL DBAExperience : 5 - 8yearsLocations : Hyderabad, Bangalore, Pune, VijaywadaPrimary Skills : Postgresql DBA, Performance tunning, Migration, Upgradation , Backup and recoveryDesired Skills & Responsibilities :- Minimum 5 years of experience in database administration or database architecture- Implementing Postgresql database clusters with...

  • PostgreSQL Support Engineer

    2 weeks ago

    Pune, India EDB Full time

    A Little About UsInnovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the world’s fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the full power of Postgres, whether on premises or in...

  • PostgreSQL Dba

    6 days ago

    Pune, India TeamPlus Staffing Solution Pvt Ltd Full time

    In depth knowledge of the PostgreSQL architecture Experienced in installing, configuring and upgrading EnterpriseDB/Postgres databases and clusters. Experience in configuring and supporting Enterprise Manager. Setting up users tools for administration. Experience in deploying EnterpriseDB in Linux on Power environment and good understanding of operating...

  • Hiring SQL Dba- Postgres

    7 days ago

    Pune, India Crafsol Technology Solutions Pvt Ltd Full time

    _**DBA**_ - Associate needed with 6 to 10 years of experience as a SQL Server DBA_ - Roles & Responsibilities include:_ - _Experience in SQL Server Database Administration/Development using MS SQL Server Management Studio 2019, 2017, 2016, 2014, 2012, 2008 R2_ - _Enrolling users and maintaining system security and controlling and monitoring user access to...

  • PostgreSQL Support Engineer

    2 weeks ago

    pune, India EDB Full time

    A Little About Us Innovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the world’s fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the full power of Postgres, whether on premises or...

  • PostgreSQL Support Engineer

    2 weeks ago

    Pune, India EDB Full time

    A Little About UsInnovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the world’s fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the full power of Postgres, whether on premises or in...

  • DBA Administrator

    5 days ago

    Pune, India Infogain Full time

    DBA Administrator (Lead) with skills Oracle DBA, SQL Server DBA, Azure SQL DBA for location Pune, IndiaPosted on: May 08, Share on Linkedin Share on Twitter Share on FacebookROLES & RESPONSIBILITIESJOB DESCRIPTION: Mid-level PostgreSQL / MySQL Database AdministratorCLASSIFICATION:ExemptJOB SUMMARYAs a member of the Data Operations Team, the mid-level...