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 & recent 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.

📌 Lead System Engineer (Bengaluru)
🏢 NR Consulting
📍 Bengaluru