Database Administrator - PostgreSQL

About Company :

Our Client is a global leader in next-generation digital services and consulting.

We enable clients in more than 50 countries to navigate their digital transformation.

With over three decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey.

We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change.

We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight.

Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

Job Title : PostgreSQL-DB Locations : Pan : 5+ Years

Job description JD :

• PostgreSQL Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing.
• Three 3 years of experience with PostgreSQL version 9 up till latest version hosted on Azure Postgre SQL platforms.
• Three 3 years of experience migrating MS SQL Serer databases to PostgreSQL deploying databases in containers.
• Install monitor and maintain PostgreSQL implement monitoring and ing implement backup and recovery processes provide system and SQL performance tuning.
• Two 2 years of experience as a PostgreSQL database administrator deploying PostgreSQL databases on Cloud platforms such as Azure Cloud Environment.
• Programming languages such as UNIX shell scripting PLpgSQL Python or Perl experience.
• Two 2 years of experience with PostgreSQL native tools like pgAdmin pgAudit pgBadger pgPool pSQL.
• Estimate PostgreSQL database capacities develop methods for monitoring database capacity and usage.
• Must have experience in PostgreSQL database architecture logical and physical design automation documentation installs shell scripting PL SQL programming catalog navigation query tuning system tuning resource contention analysis backup and recovery standby replication etc.
• Must have strong understanding of command line and server administration.
• Participate in application development projects and be responsible for the database architecture design and deployment.
• Participate in the creation of development staging and production database instances and the migration from one environment to another.
• Responsible for regular backups and recovery of databases.
• Responsible for regular maintenance on databases eg Vacuum Reindexing Archiving.
• Responsible for proactive remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance.
• Ability to proactively identify troubleshoot and resolve live database systems Skills : Windows Server, Azure Database Service, AWS Database Service, PostgreSQL-DB Administration, RedHat Linux to Have Skills : Azure Database Service, AWS Database Service.

(ref : hirist.tech)