SQL Query tuning expert

Job Description

About Oracle Customer Success Services(CSS): As a key member of Oracle Customer Success Services, you will join an international network of experts dedicated to driving customer success through innovation and expertise. Our One Oracle approach ensures you will be part of a team delivering comprehensive, end-to-end services and solutions that accelerate the entire customer journey. Work alongside certified and experienced professionals, gaining exposure to cutting-edge technologies and methodologies, and enhancing your skills and credentials. Engage with a diverse range of customers, managing the full lifecycle of delivery and services, and ensuring each project has a tangible impact. Benefit from robust team support in a collaborative environment that prioritizes teamwork and mutual success. Join us in Oracle Customer Success Services and elevate your career with a company that values innovation, expertise, and customer-centric solutions Career Level - IC4 Mandatory Skills: Should have 8+ years of experience in Oracle SQL query tuning expertise. Strong expertise in writing and understanding of Oracle SQL/PLSQL Functional knowledge of Oracle Fusion Middleware products, Weblogic & Database products. Interpreting explain plans and able to read AWRs and ASH for identifying SQL query bottle necks. Ability to interpret explain plans for access path, predicate filtering and high knowledge of joins and orders in table access. Advanced knowledge of SQLHC, parallel query knowledge. Should have rich experience in factored / scalar sub-queries and ability to utilise them in sql queries. Strong decision making, convincing skills to bring down the complex discussions to closure supported by right arguments and facts. Understanding of database initialization parameters, logs and traces. Experience working on complex software development/integration projects Experience in scripting tool like Unix shell, Python, Perl Optional hands on troubleshooting Oracle OTBI & BIP report issues and performance related techniques on components like Data models/sets, LOV, parameters , bursting, FF, scheduling. Good to Have Skills: Understanding of AI and Machine learning will be an added advantage. Oracle SQL performance diagnostic tools like SQLHC Experience in using monitoring tools like OEM. Building synthetic test cases. Responsibilities: Optimize Oracle SQL: Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues) . Early Adopter of Innovation: Explore and adopt new technologies like Oracle 23ai, Autonomous DB, Auto indexing, AI related tools. Analysis and Optimize Oracle BIP Reports: Should be able to help customer to identify performance issues with Oracle BIP reports functionality and sql queries involved with them. Optional knowledge of various components of BIP reports like Data models, Parameters, LOVs, Flex Fields, Bursting. Should be able to advise customers to use right sql queries as per Oracle best practices and which aids in completing the report optimally. OTBI and BIP reports: Knowledge of troubleshooting OTBI reports for advising customers to use performance enhancing configuration parameters.