Postgres SQL

Position: Specialist Systems Engineer-Postgres SQL

Exp: 4-8 Years

Location: Bangalore/Chennai

Work Mode: WHO & Permanent

**NP: Only Immediate**

Interview Process:

- Round of interviews of Client -3-4 rounds
- Mode of interviews -Virtual, can call F2F for final discussion.

**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.
- 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 with other infra teams to optimize databases performance and reduce incidents probability.

**Profile**

Mandatory Skills and Experience:

- 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

**Job Types**: Full-time, Permanent

Pay: ₹1,000,000.00 - ₹1,200,000.00 per year

**Benefits**:

- Health insurance
- Provident Fund

Schedule:

- Day shift
- Rotational shift

Supplemental Pay:

- Performance bonus

Application Question(s):

- Note:

- Freshers are NOT allowed.

**Experience**:

- PostgreSQL: 5 years (preferred)

Work Location: In person