Performance Tuner

Job#: 2043550

Job Description:

• 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 complex 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 within the application stack.
  • Optimize the interaction between the application and the Oracle database, ensuring efficient data retrieval and processing.
  • Conduct load testing and performance benchmarking to validate tuning efforts and predict system behavior under various conditions.
• Capacity 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 all systems.
  • Communicate effectively with stakeholders to provide updates on tuning efforts, performance improvements, and potential risks.

• Experience:
  • 5+ years of experience in Oracle database tuning, with a focus on SQL, PL/SQL and application tuning.
  • Proven experience in optimizing large-scale Oracle databases and complex SQL queries.
  • Experience with Oracle 19c in standalone, container and RAC environments.
• Technical Skills:
  • Deep understanding of Oracle 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 Oracle Enterprise Manager and SQL Trace.
  • Strong knowledge of application server architectures and their interaction with Oracle 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.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.