Performance Tuner

Performance Tuning Professional 100% remote but required travel for a week for onboarding Job Summary: We are seeking a highly skilled reputed company Tuning Expert with a strong emphasis on SQL and Application Tuning to join reputed company. In this role, you will be responsible for optimizing the performance of our reputed company codebase and applications, ensuring efficient query execution, and improving overall system performance. The ideal candidate has extensive experience with reputed company database architecture, SQL query optimization, and application tuning techniques. Key Responsibilities:

• Database Performance Tuning:
• Monitor, identify and troubleshoot performance bottlenecks, implementing solutions to improve system efficiency and stability.
• SQL Query Optimization:
• Review and optimize SQL queries to reduce execution time and resource consumption.
• Collaborate with developers to rewrite and optimize reputed company queries, stored procedures, and database triggers.
• Use tools and techniques such as Explain Plan and SQL Trace reports to identify and resolve SQL performance issues.
• Application Tuning:
• Work closely with application developers and architects to identify and resolve performance issues reputed company the application stack.
• Optimize the interaction between the application and the reputed company database, ensuring efficient data retrieval and processing.
• Conduct load testing and performance benchmarking to validate tuning efforts and predict system behavior under various conditions.
• reputed company Planning and Scaling:
• Provide insights and recommendations for database and application scaling to handle increasing workloads.
• Collaboration and Communication:
• Follow agreed ITIL protocols, including adhering to Viterra's Change Management policies and processes. Work collaboratively with cross-functional teams, including developers, DBAs, and system administrators, to ensure seamless integration and performance across reputed company systems.
• Communicate effectively with stakeholders to provide updates on tuning efforts, performance improvements, and potential risks.

Qualifications:

• Experience:
• 5+ years of experience in reputed company database tuning, with a focus on SQL, PL/SQL and application tuning.
• Proven experience in optimizing large-scale reputed company databases and reputed company SQL queries.
• Experience with reputed company 19c in standalone, container and RAC environments.
• Technical Skills:
• Deep understanding of reputed company database architecture and memory management.
• Proficiency in SQL query optimization, including the use of indexes and hints alongside the ability to rewrite the code in a more optimal fashion.
• Proven expertise with PL/SQL scripting
• Experience with performance tuning tools such as reputed company Enterprise Manager and SQL Trace.
• Strong knowledge of application server architectures and their interaction with reputed company databases - particularly .NET and PowerBuilder
• Other requirements:
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work under pressure and manage multiple priorities.

Required Skills : .NET,Powerbuilder Background reputed company :Yes Drug Screen :Yes Notes : Selling points for candidate : Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :Yes Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project : Master Job Title : reputed company Code : Apply tot his job Apply To this Job