Job Description :
We are looking for Technical Lead - Oracle Performance tuning based in Irvine, CA (Remote until covid-19) - Fulltime/Permanent position. If interested please share your resume at

Role: Technical Lead - Oracle Performance tuning
Location: Irvine, CA (Remote until Covid-19)
Fulltime/Permanent position

Oracle Performance tuning Developer and DB lead. The position’s primary responsibility will be to work with the application team that supports applications like Charles River Financial Suite and other financial applications that run on Oracle database and help resolve performance issues in the SQL and database. This position needs extensive experience in both code level performance tuning (SQL/PLSQL) and database level performance tuning. The selected candidate will be responsible for working with the development team and performing code changes to the SQLs for better performance, monitor index usage, monitor performance of the database, recommend tuning and optimization options.

Required Qualifications:
Bachelor’s Degree or foreign equivalent, will consider work experience in lieu of a degree
4+ years of Relevant Information Technology experience
Exposure to multiple versions of Oracle database like 11g, 12c, 19c etc
The role is specifically for performance improvement of a large Application, hence extensive Performance tuning knowledge around hints and optimizers, evaluating explain plans, indexes, different types of index scans, analyzing execution paths and recommending tuning options is a must.
Hands on experience in working on AWR Reports, ASH Reports, monitoring SQL IDs, SQL Profiles, SQL Tuning advisor, Plan management, parsing issues etc. is a must.
Good hands on knowledge on Oracle PLSQL and coding constructs.
Exposure to software configuration management, code check in process, code deployment process is a must.

Preferred Qualifications:
Knowledge of Unix/Linux scripting and Perl, Python is preferred.
Exposure of working in agile mode, CI/CD is preferred.
Exposure to cloud/ database containerization is preferred.
Experience of working with Financial services clients is preferred
Ability to communicate complex technology solutions to diverse teams namely, technical, business and management teams
Experience and desire to work in a Global delivery environment

Similar Jobs you may be interested in ..