Req number:
R8138Employment 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 an experienced Senior Database Engineer ready to take us to the next level! If you have strong expertise in Microsoft SQL Server, database performance tuning, query optimization, execution plan analysis, stored procedure development, and production troubleshooting, and are looking for your next career move, apply now.Job Description
We are looking for a Senior Database Engineer to support database development, performance optimization, troubleshooting, governance, and reliability initiatives while partnering closely with Development, Product, Infrastructure, and DBA teams to deliver scalable, high-performing data solutions. This position will be Full-time, Hybrid - Bengaluru.
What You'll DoDesign, develop, test, and maintain complex stored procedures, functions, views, triggers, and other database objects
Write efficient, maintainable SQL and optimize existing queries for performance, scalability, and accuracy
Analyze query execution plans and optimize joins, indexing strategies, statistics, aggregations, and data-access patterns
Monitor database performance metrics including CPU, memory, I/O, blocking, locking, deadlocks, waits, throughput, and storage utilization
Establish database performance baselines and implement performance improvement initiatives
Identify performance bottlenecks and implement corrective actions through query tuning, indexing, schema optimization, and configuration improvements
Review and recommend database configuration changes based on workload characteristics and operational requirements
Optimize table structures, partitioning strategies, indexing approaches, statistics maintenance, and data-purging mechanisms
Serve as the Database SME for Microsoft SQL Server and provide guidance on database design, scalability, performance, reliability, and best practices
Define and enforce database development standards, including schema design, naming conventions, indexing strategies, constraints, and release-readiness criteria
Act as the primary technical reviewer for database-related code, schema changes, and deployment activities
Develop and maintain performance-tuning guidelines, troubleshooting playbooks, operational runbooks, and recovery procedures
Partner with DBA and monitoring teams to implement alerts, automated health checks, diagnostic logging, and proactive monitoring solutions
Configure and monitor database jobs and maintenance activities such as indexing, statistics updates, consistency checks, and data purging
Conduct periodic database health assessments and recommend improvements to performance, capacity, resilience, and operational readiness
Lead technical troubleshooting efforts during critical database incidents and participate in incident war rooms
Troubleshoot slow-running queries, blocking, deadlocks, failed jobs, transaction issues, resource contention, and connection-related problems
Perform root cause analysis and implement long-term corrective and preventive solutions
Work closely with DBA teams to support backup, restore, replication, high availability, disaster recovery, failover, and recovery validation activities
Collaborate with developers, architects, product teams, support teams, and infrastructure teams to improve database reliability and performance
Bachelor's Degree in Computer Science, Information Science, Engineering, or a related discipline
8+ years of hands-on experience in Database Engineering, Database Development, Performance Tuning, or Database Administration with strong expertise in Microsoft SQL Server
Expert-level SQL skills with extensive experience writing and optimizing complex stored procedures, functions, views, triggers, and queries
Strong understanding of relational database concepts including transactions, indexing, statistics, locking, blocking, concurrency management, and execution plans
Hands-on experience with query optimization, workload analysis, performance tuning, and database troubleshooting
Experience monitoring and analyzing database performance metrics including CPU, memory, storage I/O, waits, and connection management
Experience implementing database monitoring, alerting, health checks, automated maintenance, and preventive controls
Strong experience handling production support incidents, performing root cause analysis, and resolving critical database issues
Knowledge of backup and recovery processes, replication, high availability, and disaster recovery concepts
Experience reviewing database code and collaborating with software development teams on database best practices
Strong analytical, troubleshooting, communication, and problem-solving skills
Experience with cloud database platforms such as Azure SQL, AWS RDS, or Google Cloud SQL
Experience with NoSQL databases such as MongoDB or Redis
Exposure to graph databases and vector databases such as Neo4j, AllegroGraph, Pinecone, or pgvector
Familiarity with database observability, monitoring, and workload analysis tools
Experience leveraging automation or AI-powered tools for query analysis, anomaly detection, documentation, and root cause investigation
Microsoft SQL Server, Azure Database, or related database certifications
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 [email protected] or (888) 824 – 8111.
Skills Required
- Bachelor's degree in computer science, Information Science, Engineering, or related field
- 10+ years hands-on Database Administration experience with Microsoft SQL Server and PostgreSQL
- Strong understanding of relational database concepts (indexing, query planning, transactions, locking, concurrency)
- Proven experience writing and optimizing complex stored procedures, functions, views, triggers, and queries
- Hands-on experience with database performance tuning, execution plan analysis, and query optimization
- Experience performing database maintenance activities (vacuuming, index rebuilds, statistics management, data purging)
- Experience configuring, scheduling, and monitoring database jobs, alerts, and automated maintenance processes
- Strong knowledge of backup, recovery, disaster recovery, and high availability concepts
- Experience collaborating with software development teams and supporting application database requirements
- Excellent analytical, troubleshooting, and problem-solving skills
- Experience with NoSQL databases such as MongoDB, Cassandra, or Redis
- Experience with graph/vector databases or knowledge graph platforms (Neo4j, Pinecone, pgvector, AllegroGraph)
- Experience working with RDF/SPARQL-based data platforms
- Familiarity with AI/LLM-powered tools for database optimization, anomaly detection, documentation, and RCA
- Experience with cloud database platforms such as AWS RDS, Azure SQL Database, or Google Cloud SQL
- Relevant database certifications (e.g., Azure Database Administrator Associate, PostgreSQL certifications)
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
