Senior Database Engineer SQL Server

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.