Senior Database Performance Analyst

 

 

Title: Senior Database Performance Analyst (2 positions)

Location: San Jose, CA

Contract: 6+ months (renewed quarterly)

 

The client is searching for a Senior Database Performance Analyst that fits the description below.

 

- Candidates must be within a commutable distance to (or willing to relocate to) San Jose, CA.

 

DESCRIPTION:

- Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

- Communicate solution to the application developers and verify that it is implemented correctly.

- Provide on-call support for any urgent performance issues in production environment.

- Periodically Monitor Production databases from performance perspective.

- Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.

- Work with the DBA and application teams to explain critical production performance issues.

- Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.

- Keep abreast of new, performance related Oracle features and evangelize their use across IT teams.

- Develop SQL Performance Coding standards and conduct training for Developers.

- Document technical details of issues resolved and assist the team with building and maintaining technical repositories.

 

REQUIRED SKILLS:

- 6+ years as an Oracle Application (PL/SQL) Developer and/or DBA. Ideal candidate will have the right blend of these two skills.

- 2+ 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.

- Thorough knowledge of Oracle Cost Based Optimizer and clear understanding of Oracle architecture.

- Sound knowledge of business application development and support.

- Knowledge of Oracle Apps and Web Apps architecture is a big plus.

- A Team player to work with cross-functional teams with varying skill-sets and in different time-zones.

- Excellent verbal and written communication skills.

 

Thanks & Regards,

 

Ashish Gupta.

Tel: -( 832) 232-3522

11777 Katy Freeway, Suite# 434S, Houston, TX 77079

E-mail: ashish.gupta@priserve.com 

Gmail : ashish.priserve@gmail.com