PostgreSQL DBA

Job Description

Roles & Responsibilities:

Having experience of 7+ years as PostgreSQL DBA

Architect database replication, high availability concepts

Installation and upgrade of PostgreSQL on 10/12/14 version under Linux platforms

Good scripting skills to automate regular DBA admin tasks

Strong experience on backup utilities or tools like BARMAN & PostgreSQL dump/load, Cohesity and Telegraf/Helios

Applying minor version upgrade in standalone and standby servers

Should have good command over speaking and writing.

Strong experience on database and SQL queries tuning for PostgreSQL databases

He will be customer facing for all operational issues and activities

Strong experience on configure and troubleshoot physical standby database using repmgr

Good Grip over Tables fine tuning and troubleshooting

Implement backup and recovery of PostgreSQL databases for various scenarios

Administration over DB Objects including Tables , Clusters , Views , Procedures etc.

Good in Impact Analysis of DB Change / DB Design Change etc.

In-depth understanding of Advanced Architectures (repmgr)

Good understanding of core support processes and change management, maintain documentation standards

Must have experience in Database tuning

Responsible for installation, upgrades (Database), vendor support, database tuning, cloning

Able to work in 24 by 7 Support.

Requirements:

Candidate must possess at least a bachelors degree, Post Graduate Diploma, Professional Degree (MCA / BE / BSC or SC computer science)

Having previous banking BAU support will be added advantage

Having experience on additional database technologies MSSQL or DB2 or Oracle will be added advantage

At least 7 year(s) of working experience in the related field is required for this position.

Preferably Senior Executives specializing in IT/Computer Network / System/ Database Admin or equivalent.