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.