Senior SQL Developer/Architect

We are looking for a Senior SQL Developer / SQL Architect with 18+ years of experience in Microsoft SQL Server and at least 10 years of hands-on SQL development experience. The ideal candidate should have strong expertise in designing, developing, and optimizing SQL databases, stored procedures, and queries while ensuring high performance and scalability.

Key Responsibilities :

- Design and develop database tables, views, indexes, functions, and stored procedures.

- Write, optimize, and maintain complex SQL queries and stored procedures.

- Perform query tuning, SQL profiling, and database performance optimization.

- Create and manage database schemas, triggers, and other database objects.

- Analyze, troubleshoot, and resolve database and data-related issues.

- Collaborate with application developers to deliver end-to-end database solutions.

- Support business stakeholders with data analysis and reporting requirements.

- Prepare mapping documents and maintain database documentation.

- Conduct code reviews, technical design reviews, and promote best practices.

- Participate in architecture discussions and recommend database improvements.

- Implement database enhancements, upgrades, and system modifications.

- Integrate third-party APIs with database solutions where required.

Required Skills :

- Microsoft SQL Server (18+ years)

- SQL Development (10+ years)

- Complex SQL Queries & Stored Procedures

- Database Design (Tables, Views, Indexes, Triggers)

- Query Optimization & Performance Tuning

- SQL Profiling

- Database Schema Design

- Data Analysis & Troubleshooting

- API Integration

- Stakeholder Management

Preferred :

- Experience in the US Healthcare Payer domain.

(ref:hirist.tech)