PostgreSQL Database Administrator

Req number:

R7882

Employment type:

Full time

Worksite flexibility:

Hybrid

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are looking for a motivated PostgreSQL Database Administrator ready to take us to the next level! If you have experience in overseeing database development activities, optimizing performance, and ensuring database health while collaborating with the development team and are looking for your next career move, apply now.

Job Description

We are looking for an experienced PostgreSQL Database Administrator with strong expertise in PostgreSQL and MS SQL Server to join our development team. This position will be full-time and hybrid in Bengaluru.

What You’ll Do

• Perform routine database maintenance including indexing, vacuuming (PostgreSQL), and statistics updates to ensure optimal performance

• Monitor and manage database health, proactively identifying and resolving bottlenecks and idle/long-running queries

• Design and implement data purging strategies to manage storage and maintain performance at scale

• Set up, schedule, and monitor database jobs and automated maintenance tasks

• Collaborate closely with the development team to support database changes and enhancements aligned with application requirements

• Review and optimize existing stored procedures, indexes, and table structures for performance and correctness

• Write, test, and maintain complex stored procedures, views, and functions across PostgreSQL and MS SQL Server

• Define and enforce database development standards across the team, including schema design, indexing strategy, key constraints, and naming conventions

• Contribute to the design and validation of any feature that touches the data layer, ensuring data-layer decisions are sound from the outset

What You'll Need

Required:

• 8+ years of experience in PostgreSQL and MS SQL Server

• Proven experience in database maintenance, performance optimization, and troubleshooting

• Strong ability to write, test, and optimize stored procedures and queries

• Knowledge of data purging strategies and automated maintenance tasks

Preferred:

• Experience collaborating with development teams on application-side database enhancements

• Familiarity with database standards, governance, and schema design

Physical Demands

• Ability to safely and successfully perform the essential job functions

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.