Job Description
Job Description:
Skills:
Skills:
- Experienced on Oracle PL/SQL + Unix Shell development for Java swings based applications.
- Should have spent at least 85% of time coding on Candidate's/Candidate's past engagement.
- Oracle 12c/19c database understanding is a must.
- Hands on experience in monitoring/ Handling production job queues and L2/L3 support activities.
- Well versed in SQL (DML/DCL/TCL, etc.) and PLSQL independent development [advance level in packages/procedures etc.].
- Hands on experience on python would be beneficial.
- Advance concepts of 19c (Partitioning, Data Archiving, profiling etc).
- Can understand pre-written code and confident to change code for specific requirements.
- Create and manage database objects like, tables, views, stored procedures, user defined functions etc.
- Performance tuning is required for query optimization.
- Monitor and tune query performance.
- Analyze and resolve problems of medium to high complexity.
- Monitor and tune existing databases of medium complexity and moderate business exposure.
- Investigate, troubleshoot, and resolve Users issues.
- Oracle PL/SQL, Unix Shell scripting & Retail Forecasting business domain knowledge.