Req number:
R7882Employment type:
Full timeWorksite flexibility:
HybridWho we areCAI 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.
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
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 [email protected] or (888) 824 – 8111.
Skills 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
- Perform routine database maintenance including indexing, vacuuming, and statistics updates
- Experience collaborating with development teams on application-side database enhancements
- Familiarity with database standards, governance, and schema design
CAI (cai.io). Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CAI (cai.io). and has not been reviewed or approved by CAI (cai.io)..
-
Retirement Support — Retirement contributions and an ownership component are highlighted as standout perks and positioned as a key strength of the package. This is framed as a notable differentiator within the overall offering.
-
Wellbeing & Lifestyle Benefits — A wellness program that can reduce medical premiums, an Employee Assistance Program, and active employee resource groups are emphasized. A work-from-anywhere philosophy and flexible scheduling are also presented as quality-of-life benefits when client needs allow.
-
Affordable Benefits — The primary medical setup is described as a high-deductible option with low premiums and an HSA contribution, which some view as cost-effective. Wellness participation is stated to further lower monthly premiums.
CAI (cai.io). Insights
What We Do
CAI is a global services firm with over 8,700 associates worldwide and a yearly revenue of $1 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’s 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
