Senior SQL Developer

Job Summary

The Senior Database Application Associate is responsible for analysing, debugging, and optimizing complex SQL queries used in reporting environment. This role involves hands-on troubleshooting, SQL performance tuning, improving query runtime and collaboration with cross-functional teams to ensure the stability, scalability, and reliability of mission-critical business applications. The ideal candidate brings strong technical expertise, problem-solving skills, and experience managing production systems in a fast-paced environment.

Key Responsibilities

Database Development & Optimization

• Develop, debug, and maintain SQL queries, stored procedures, triggers, packages, and functions.
• Perform database performance tuning—index optimization, query rewriting to reduce execution time, and resource utilization improvements.
• Support schema design, data modelling, and database architecture improvements.
• Diagnose and resolve complex application and database-related issues.
• Analyse large and complex SQL queries used in reports by identifying performance issues in joins, filters, CTEs, functions, indexes, and data model design.
• Ensure optimized SQL returns the same data as the original queries.

• Maintain accurate technical documentation, runbooks, and knowledge articles.

Cross-functional Collaboration

• Work closely with application developers, system engineers, QA teams, and business stakeholders.
• Provide technical guidance and mentorship to junior team members.
• Work with team members to validate logic and resolve data or performance issues.
• Support unit testing, QA testing, and user acceptance testing.
• Share technical recommendations for improving query performance and structure with the team.

• Ensure compliance with data governance, security, and backup policies.

Required Qualifications

• Strong expertise in SQL (SQL Server— customize as needed).
• Expertise in joins, subqueries, CTEs, window functions, aggregations.
• Strong experience in analysing execution plans and tuning queries.
• Understanding of indexing, partitioning, statistics, and database performance.
• Experience troubleshooting and tuning large, complex queries and database operations.
• Strong analytical, communication, and documentation skills.
• Good communication skills and ability to articulate technical details clearly.

Good to Have

• Knowledge/Experience with Cognos, Power BI, Tableau, or other reporting tools.
• Understanding of BI concepts, metadata layers, and reporting models.