Oracle/ PL-SQL developer
Location: NOIDA
Exp: 5-7 yrs
Inviting applications for the role of Development team Member
PFB- Updated JD
Candidate must be evaluated on below for this DB Profile :
- Good at Writing complex queries using JOIN , Analytical function , Recursive CTE etc .
- Good at Performance and Optimization.
- DB2
- Good at Index , Trigger , Partition ,Procedure ,function ,packages etc .
- Good at PLSQL / T-sql / PL Programing
- Should aware of different Locks and its mechanism .
- Should have experience of improving performance by re-writing queries ,procedure etc (should have good understanding of explain plan )
- Understanding of Database design –Data Modeling , Metadata etc.
- Writing Procedures, Functions, Packages and Database Trigger
- Oracle Forms Personalization and Oracle Alert
- SQL, PL/SQL
- Database Development
- Performance Tuning
