Sr. SQL Developer

Pune - India

Monthly Salary: Not Disclosed

Experience Required: 4-8years

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

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 tuningindex 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.

Required Skills:

SQLJOinsIndexqueries

Job SummaryThe 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 en...