Oracle Pl/Sql Developer

Job Title: Oracle PL/SQL Developer

Location: Ashburn, VA/ Basking Ridge, NJ / Silver Spring, MD or Irving, TX (Hybrid)

Duration: Long Term
Client: Telecommunication
Description:

Need senior solid candidate, Strong PLSQL coding exp in production environment

Able to Analyze AWR report and do performance tuning by PLSQL Query

Experienced SQL & PL/SQL developers (let's start small max 3) with 12+ years relevant hands-on experience including complex query performance analysis and tuning.

Experience using AWR, ADDM, ASH for application / database tuning is also required.

Experience using Toad and/or SQL Developer for tuning / coding. Candidates should be detail oriented and have good written and oral communication skills.

They should have worked (hands on) Oracle 19c and previous Oracle versions for the above requirements
Quickly understand and come up to speed with existing application.
Understand new requirements and translate them into functional specifications.
Analyze and design solutions for the new requirements.
Implement and test the changes in various stages and environments and all the way into production.
Develop adequate documentation of the design and changes, socialize/review changes with peers.
Provide the daily and weekly status updates of the tasks and projects assigned.
Troubleshoot and fix any production and non-production issues.
Provides expert advice where needed and mentor other developers.
Ideally, the candidate will also have:
Teamwork & collaboration skills to work across organizations and lead cross-functional teams.
Communication & stakeholder management skills.
Problem solving skills to develop quick yet sound solutions to resolve complex issues.
EDUCATION/CERTIFICATIONS:
4 years of Bachelor's degree in Computer Science or equivalent degree

Expectation Need from Candidate :-

• Understand Business Requirement.
• Candidate need to know where code need to change.
• He also need to tell where schema need to change .
• Database Inspection , find bad code and rewrite and put it into system. Check if new code working fine.
• On call and off-hour work
• Proactive Monitoring and quick Mitigation
• Candidate able to provide quick solution on the spot for all performance issue.

Main Topics Relate to Performance Tuning – day to day work with them

• How to find out slow query in DB.
• methodologies you use when query is slow.
• Autonomous Transaction
• PLSQL Profiler.
• Reset Cash- what is it
• Hash Partitioning
• Local Prefix and Local Non Prefix
• ADDM reports must, AWR and ASH report
• how to check execution Plan in Database Report
• Candidate able to find out where code is wrong , they will show 2 different code . 1 is big confusing code, candidate need to figure out what is happing in code. 2nd one is small code, where candidate need to find out what wrong in code and how optimize the code.
• Candidate need to find from ADDM report where tuning required