Website:
mycareernet.co
Job details:
Key Skills: Oracle, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Views, Scheduler Jobs, Performance Tuning, SQL, Technical Leadership
Roles & Responsibilities:
- Analyze Oracle applications and understand business logic.
- Review database objects such as procedures, packages, functions, triggers, tables, and views.
- Analyze scheduler jobs and application dependencies.
- Perform impact analysis and provide solutions for application changes.
- Support production issues, troubleshooting, and root cause analysis.
- Improve database performance and optimize SQL queries.
- Prepare application and database mapping documents.
- Create architecture, data flow, and support documentation.
- Mentor developers and provide technical guidance.
- Conduct code and design reviews.
- Lead knowledge transfer and documentation activities.
- Work with technical and business stakeholders.
Experience Required:
- 10 - 15+ years of experience in Oracle PL/SQL development.
- 3 - 5+ years of experience as a Technical Lead or Architect.
- Strong experience with Oracle 11g, 12c, or 19c.
- Hands-on experience with PL/SQL procedures, packages, functions, triggers, and views.
- Experience with Oracle Scheduler jobs.
- Strong experience in production support and troubleshooting.
- Good knowledge of performance tuning and query optimization.
- Experience with SQL Developer, TOAD, or DBeaver.
- Strong leadership, mentoring, and stakeholder management skills.
Education:
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Click on Apply to know more.