PostgreSQL-DB Administration

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.

About the Client

Our client is a global digital solutions and technology consulting company headquartered in Mumbai, India. The company generates annual revenue of over $4.29 billion (₹35,517 crore), reflecting a 4.4% year-over-year growth in USD terms. It has a workforce of around 86,000 professionals operating in more than 40 countries and serves a global client base of over 700 organizations. Our client operates across several major industry sectors, including Banking, Financial Services & Insurance (BFSI), Technology, Media & Telecommunications (TMT), Healthcare & Life Sciences, and Manufacturing & Consumer. In the past year, the company achieved a net profit of $553.4 million (₹4,584.6 crore), marking a 1.4% increase from the previous year. It also recorded a strong order inflow of $5.6 billion, up 15.7% year-over-year, highlighting growing demand across its service lines. Key focus areas include Digital Transformation, Enterprise AI, Data & Analytics, and Product Engineering—reflecting its strategic commitment to driving innovation and value for clients across industries.

Job Title : PostgreSQL-DB Administration

Job Locations : Pan India

Experience : 5+ Years

Job description:

Detailed 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 issues

Skills

Mandatory Skills : Windows Server,Azure Database Service,AWS Database Service,PostgreSQL-DB Administration,RedHat Linux Administrator

Good to Have Skills : Azure Database Service, AWS Database Service