Engineering Operations Support Specialist

Senior Database Engineer (SQL Server)
Chennai India

Summary/Objective

Reveleer is a healthcare data and analytics company that uses Artificial Intelligence to give health plans across all business lines greater control over their Quality Improvement Risk Adjustment and Member Management programs. With one transformative solution the Reveleer platform enables plans to independently execute and manage every aspect of enrolment provider outreach and data retrieval coding abstraction reporting and submissions. Leveraging proprietary technology robust data sets and subject matter expertise Reveleer provides complete record retrieval and review services so health plans can confidently plan and execute risk quality and member management programs to deliver more value and improved outcomes.

Job Summary:

We are seeking a highly skilled Senior Database Engineer (SQL Server) to design implement optimize and manage our SQL Server database infrastructure. The ideal candidate will have deep expertise in database architecture performance tuning automation and high availability solutions. This role requires collaboration with development QA and IT teams to ensure the database environment is secure scalable and aligned with business goals.

Key Responsibilities:

• Database Design & Architecture

• Design develop and maintain complex SQL Server databases.

• Define and implement database models schemas and indexing strategies.

• Design database structures and schemas based on business requirements.

• Performance Tuning & Optimization

• Analyse and optimize SQL queries stored procedures and indexing strategies.

• Monitor database performance using tools like SQL Profiler Extended Events and DMVs.

• Implement partitioning caching and plan optimization to improve efficiency.

• Database Deployment and Integration

• Build and deploy database systems for new applications.

• Ensuring seamless integration with frontend and backend systems.

• Collaborate with developers to implement APIs for database access.

• Database Maintenance and Monitoring

• Monitoring database systems for performance uptime and availability.

• Addressing incidents and alerts related to database health.

• Performing routine maintenance tasks like backups and recovery testing.

• Collaboration & Support

• Work closely with application developers to optimize database interactions.

• Provide production support troubleshoot database issues and participate in oncall rotations.

• Document database processes architecture and troubleshooting guides.

• Database Administration & Maintenance

• Install configure and upgrade SQL Server instances in onpremises and cloud environments.

• Manage database security user access controls and compliance policies (RBAC encryption auditing).

• Develop and enforce database backup recovery and retention policies.

Qualifications & Skills:

Required:

• Bachelors degree in computer science Information Technology or a related field.

• 7 years of experience as a Database Engineer/Administrator (SQL Server).

• Expertise in SQL Server 2016/2019/2022 TSQL and query optimization.

• Strong knowledge of indexing partitioning and performance tuning techniques.

• Experience with PowerShell TSQL scripting or automation tools.

• Familiarity with CI/CD pipelines for database deployments (e.g. Redgate).

• Strong analytical and problemsolving skills.

• Handson experience with highavailability (HA) and disaster recovery (DR) solutions.

• Excellent communication and documentation abilities.

Preferred:

• Experience with cloudbased SQL Server solutions (AWS RDS).

• Familiarity with NoSQL databases (MongoDB Redis) is a plus.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities duties or responsibilities that are required of the employee for this job. Duties responsibilities and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame.

EEO Statement

Reveleer provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression or any other characteristics protected by federal state or local laws.