PostgreSQL Database Administrator

About the role

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 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 Database Administrator with strong expertise in PostgreSQL and MS SQL Server to join our development team. This position will be full-time and Hybrid - Bangalore .

Responsibilities

• 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

Requirements

• 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
• 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.

Benefits

Additional Information

PostgreSQL Database Administrator Req number: R7882 Employment type: Full time Worksite flexibility: Hybrid

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at cai? Share your experience