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.
