Posted 12 June, 2026
Lead System Engineer - PostgreSQL
NR Consulting - India
Bangalore/Chennai, IN
Full Time
Reference: 26-04776-2220-1
Title: Lead System Engineer - PostgreSQL
Location: Bangalore/Chennai
Exp: 8 – 10 Years
Job Description:
Key Responsibilities
• Own 24* 7 database support; handling Incidents, Requests, Problems & Changes.
• Handle on-call database support during week-ends & out of business hours.
• Own & deliver various client & infra projects.
• Plan & deliver various projects around database patching, upgrades & migrations.
• Management of various tools/scripts being used for databases.
• Managing Primary DBA roles for multiple applications.
• Contribution towards automation of recurrent tasks.
• Ticket reduction through problem management.
• Manage disaster recovery tests & exercises.
• Identify & deliver various POCs (Proof of concepts) for latest RDBMS features, open source & new technologies.
• Work closely with application teams to provide solutions across various requirements & problems.
• Proactively identify the problems and provide solutions to avoid incidents & application outages.
• Work with other infra teams to optimize databases performance and reduce incidents probability.
Mandatory Skills and Experience:
• Hands-on experience with database standards and end user applications.
• Experience on PG version – PG 12, PG 13, PG 14 & PG 15
• Excellent knowledge of PG RDBMS (all versions) architecture & design.
• Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
• Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
• Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer,
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values)
• Scripting knowledge using Ansibel and SHELL
• Proficient in troubleshooting & solving complex performance problems.
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools
• Experience in handling Disaster Recovery tests & exercises.
• Certifications and experience of managing RDS for PostgreSQL on AWS
• Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).
• Working experience in banking domain (preferred).
• Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
• Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
• Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.
• Demonstrable crisis management skills in a large, globally distributed environment.
• Experience working with or in an automated operations environment
• Experience managing operations on core & cloud-based infra environments – 'AaS platform' experience ideal.
Preferred Education, Skills and Experience:
• Certifications and experience of managing RDS for PostgreSQL on AWS
• Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
• Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
• Experience in Ansible, Shell / Perl / Python Scripting
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools
Location: Bangalore/Chennai
Exp: 8 – 10 Years
Job Description:
Key Responsibilities
• Own 24* 7 database support; handling Incidents, Requests, Problems & Changes.
• Handle on-call database support during week-ends & out of business hours.
• Own & deliver various client & infra projects.
• Plan & deliver various projects around database patching, upgrades & migrations.
• Management of various tools/scripts being used for databases.
• Managing Primary DBA roles for multiple applications.
• Contribution towards automation of recurrent tasks.
• Ticket reduction through problem management.
• Manage disaster recovery tests & exercises.
• Identify & deliver various POCs (Proof of concepts) for latest RDBMS features, open source & new technologies.
• Work closely with application teams to provide solutions across various requirements & problems.
• Proactively identify the problems and provide solutions to avoid incidents & application outages.
• Work with other infra teams to optimize databases performance and reduce incidents probability.
Mandatory Skills and Experience:
• Hands-on experience with database standards and end user applications.
• Experience on PG version – PG 12, PG 13, PG 14 & PG 15
• Excellent knowledge of PG RDBMS (all versions) architecture & design.
• Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
• Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
• Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer,
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values)
• Scripting knowledge using Ansibel and SHELL
• Proficient in troubleshooting & solving complex performance problems.
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools
• Experience in handling Disaster Recovery tests & exercises.
• Certifications and experience of managing RDS for PostgreSQL on AWS
• Experience in working on a large-scale environment (at least 1000 + databases with bigger sizes).
• Working experience in banking domain (preferred).
• Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
• Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
• Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long-term solutions as appropriate.
• Demonstrable crisis management skills in a large, globally distributed environment.
• Experience working with or in an automated operations environment
• Experience managing operations on core & cloud-based infra environments – 'AaS platform' experience ideal.
Preferred Education, Skills and Experience:
• Certifications and experience of managing RDS for PostgreSQL on AWS
• Hands-on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
• Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery
• Experience in Ansible, Shell / Perl / Python Scripting
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools
