Oracle Performance Tuner

About Wipro:

Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help clients realize their boldest ambitions and build future-ready, sustainable businesses. A company recognized globally for its comprehensive portfolio of services, strong commitment to sustainability and good corporate citizenship, we have over 250,000 dedicated employees serving clients across 66 countries. We deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world.

• A PROUD HISTORY OF OVER 75 YEARS
• FY22 REVENUE 10.4 BN USD
• WE'RE PRESENT IN 66 COUNTRIES
• OVER 1,400 ACTIVE GLOBAL CLIENTS

Oracle Performance Tuner SME (DBA)

San Jose, CA (Remote)

***This role will be hybrid onsite 4 days per week***

Senior Oracle SME (8+ years' experience), who will provide high quality technology solutions that address business needs by supporting application development team for SQL tuning, Guidance on best practices for SQL coding and perform reviews and documentation. This role will participate in software development and support efforts for large Data Warehouse and financial applications using Oracle 11g / 12c / 19c databases.

Oracle Performance Tuner SME Required Skills:

• Must have extensive experience working closely with the Application Development teams.
• Strong PL/SQL experience, targeting Oracle versions 11g, 12c, 19c.
• "SUPERIOR" level Performance Tuning & Troubleshooting skills.
• Strong understanding of Oracle Cost Based Optimizer
• Proven development of Statistics and Index strategies
• Proficiency in diagnosing performance issues across application tiers
• PL/SQL development experience of all types of SQL DML statements - functions, stored procs, triggers etc.
• Proactive Code Reviews and follow-ups to communicate best practices.
• Will be a part of the Oracle Team supporting a wide array of application development teams developing custom applications.
• Should have experience & ability to work with various teams to resolve performance issues.
• Understand and recommend industry best practices and standards.
• GoldenGate is HUGE PLUS but not a disqualifying skill.
• Experience with developing ETL solutions

Oracle Performance Tuner SME Preferred Skills:

Very Strong database development experience using Oracle 19c/12c/11g.

Expert: How to interpret and utilize the following

SQL Plan Management, Incremental Stats collection, Synopsis, histograms, SQL Access Advisor, Tuning Advisor, Segment Advisor, SQL Plan Baselines, SQL Profiles, Column Groups, Optimizer Statistics Advisor,

Expert in SQL & PL/SQL modules such as packages, procedures, functions, and other database objects.

Expert in Performance Tuning of application code at the database level.

Experience in Unix/Linux and Shell scripting.

Excellent oral/written communication.

Should have Undergraduate Degree or possess extensive experience in related field.

Soft skills such as "team player" "collaborative mentality" etc.

Excellent Communication and collaboration skills required.

Comfortable leading and presenting during discussions.

Huge Plus - Not mandatory - Any experience in PostgreSQL, Data Guard Replication Configuration & Troubleshooting and Working closely with Global Support DBA teams in addressing the data issues.

Data Stage added advantage.

Wipro is an Equal Employment Opportunity employer and makes all employment and employment-related decisions without regard to a person's race, sex, national origin, ancestry, disability, sexual orientation, or any other status protected by applicable law.

Oracle Apps DBA