Perform root cause analysis of database/SQL performance problems and recommend solutions for optimization
Develop and enhance procedures for proactively identifying expensive SQL's and other performance bottlenecks
Work with the DBA's and application teams to explain critical production performance issues
Interact with the cross functional teams such as Customer Support, Professional Services and Engineering to identify and resolve SQL performance issues (customer or Engineering initiated)
Interact directly with customers on SQL tuning and optimization on an as needed basis
Provide on call support for any urgent performance issues in the production environment
Develop SQL optimization and performance standards for customers and internal teams
Document Standard Operating Procedures for Production Support/Operations team as required
Attend weekly team meetings and participate team building activities
Requirements:
BS. In a technical area or 5-10 years equivalent experience
5 plus years Oracle Application (PL/SQL) Developer and/or DBA. Ideal candidate will have the right blend of these two skills
2 plus years as a DB Performance Analyst and/or SQL Tuner
Proven expertise in tuning Oracle 9i/10g for high transaction, multi-TB sized Databases
Proven expertise in optimization of Oracle SQL Queries
Strong skills in troubleshooting user specific SQL queries and recommending solutions
Sound knowledge of business application development and support
Experience in any standard scripting language such as c-shell, perl, python and ruby
Experience in high availability, 24x7 production environment
Must be a team player with an attribute to help as necessary
Self-motivated and able to adapt to a constant changing environment
