PLSQL - Performance Tuning Jobs in Mumbai - Mphasis

PLSQL - Performance Tuning

Mphasis

3+ Years

Not disclosed

Expired

Posted: 30 Jun 20

Job Description

Job Description

Role: Software Engineer – L4

Location: Mumbai

Who are we looking for?

A Sr.Developer to manage a critical project for one of our biggest client in banking domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications. Experience in automation is added advantage

Technical Skills

Minimum 4 years Experience in Performance Tuning & Query Optimization on Large scale database environment and mission critical OLTP / batch processing systems.

Strong database development experience using Oracle 11g/12c.
Performed SQL / PL-SQL Tuning, database contention monitored using SQL Trace, Explain Plan, AWR, ADDM etc.
Should have good knowledge in understanding Execution plan.
Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries, Set Operators, co-related sub queries, with clause and merge statements.
Good exposure on advanced topics Like Indexes, SQL Loader, Tuning and Tracing of Procedures, Ref cursor, Collections, for all bulk collect and Execute immediate.

Process Skills

Capable of analyzing requirements

Develop and peer review of LLD (Initiate/ participate in peer reviews)

Participate in discussion with business stake holders

Create test cases as per the different testing methodologies

Coach members of project groups to ensure effective knowledge management activity.

Qualification

Somebody who has 4-6 years of work experience in software development.

BE in computer science or MCA