Senior Database Performance Analyst

Apply Now

Company: RICEFW Technologies, Inc.

Location: San Jose, CA 95123

Description:

Title: Senior Database Performance Analyst

Location: San Jose, CA

Experience Level Required: 6+ years

Mandatory Required Skills:

6+ years as an Oracle Application (PL/SQL) Developer and/or DBA, with a balanced skill set in both areas
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 the optimization of Oracle SQL Queries
Thorough knowledge of Oracle Cost Based Optimizer and a 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 with experience working in cross-functional teams with varying skill sets and across different time zones
Excellent verbal and written communication skills

Job Responsibilities:

Conduct root cause analysis of Database/SQL performance problems and recommend solutions for both Production and Release environments.

Communicate solutions to application developers and ensure correct implementation.

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

Periodically monitor production databases from a performance perspective.

Analyze performance reports and proactively identify expensive SQLs and other performance bottlenecks.

Collaborate with DBA and application teams to explain critical production performance issues.

Participate in software design reviews with developers to ensure scalable architecture for long-term performance goals.

Stay updated on new performance-related Oracle features and promote their use across IT teams.

Develop SQL Performance Coding standards and conduct training for developers.

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

Basic Qualification : null