PostgreSQL

About the Company

They balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what's now to what's next by unlocking the value of their data and applications to solve their digital challenges, achieving outcomes that benefit both business and society.

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

Location : Pune

Experience : 6 yrs

About the Role

PostgreSQL Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing.

Responsibilities

• 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 Server databases to PostgreSQL deploying databases in containers.
• Install, monitor and maintain PostgreSQL, implement monitoring and 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 (e.g., 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.

Qualifications

Mandatory Skills:

• Windows Server
• Azure Database Service
• AWS Database Service
• PostgreSQL-DB Administration
• RedHat Linux Administrator

Preferred Skills

• Azure Database Service
• AWS Database Service