Job
Description
As a Senior Database Application Associate, your role involves analysing, debugging, and optimizing complex SQL queries used in the reporting environment. You will be responsible for hands-on troubleshooting, SQL performance tuning, improving query runtime, and collaborating with cross-functional teams to ensure the stability, scalability, and reliability of mission-critical business applications. Your technical expertise, problem-solving skills, and experience managing production systems in a fast-paced environment will be crucial for success. Key Responsibilities: - 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 customized 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 the 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. As a Senior Database Application Associate, your role involves analysing, debugging, and optimizing complex SQL queries used in the reporting environment. You will be responsible for hands-on troubleshooting, SQL performance tuning, improving query runtime, and collaborating with cross-functional teams to ensure the stability, scalability, and reliability of mission-critical business applications. Your technical expertise, problem-solving skills, and experience managing production systems in a fast-paced environment will be crucial for success. Key Responsibilities: - 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 customized 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 the 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.
