· Location - Ahmedabad
· Shift – 10:00 AM to 7:30 PM
· Working Days - Monday to Friday
Roles & Responsibilities:
· Analyze existing stored procedures, functions, triggers and views
· Reverse engineer undocumented business rules
· Create reusable database components
· Investigate production issues
· Debug complex SQL logic
· Analyze deadlocks and blocking
· Identify data inconsistencies
· Perform root cause analysis
· Performance Optimization
· Query tuning
· Index optimization
· Execution plan analysis
· Performance monitoring
· Follow coding standards
· Perform code reviews
· Document business rules
· Write unit test scripts
· Support release deployments
Required Skills:
· Expert level in writing complex Stored Procedures, Functions, Views, Triggers, CTE, Dynamic SQL, Temp Tables, Table Variables, SQL Agent Jobs.
· Must know about Execution Plans, Indexing, Query Optimization, Deadlock Analysis, Blocking, Statistics, Isolation Levels
· must have Strong analytical thinking, Excellent logical reasoning, Ability to understand complex legacy systems, Curiosity to investigate hidden business logic, Ability to ask the right questions, Comfortable working with minimal documentation, Patient problem solver, Ability to explain technical concepts clearly Strong communication and collaboration abilities.
· Ability to work independently and handle multiple tasks simultaneously.
· Value added - US Healthcare domain experience
Pay: ₹300,000.00 - ₹800,000.00 per year
Benefits:
- Paid sick time
- Paid time off
- Provident Fund
Work Location: In person
