We are looking for an experienced Oracle APEX & PL/SQL Developer with strong hands-on expertise in Oracle APEX, SQL/PLSQL development, database performance tuning, and production support. The candidate will be responsible for developing database components and web applications, optimising complex queries, troubleshooting production issues, and working closely with application teams.
Key Responsibilities
- Develop and maintain complex PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Views, and Jobs.
- Develop and maintain web applications using Oracle APEX, PL/SQL, HTML, CSS, JavaScript, and other web technologies.
- Write and optimize complex SQL using joins, subqueries, CTEs, analytical functions, MERGE, and set operators.
- Design and implement user interfaces, reports, dashboards, charts, and other components using APEX features and plugins.
- Perform SQL/PLSQL performance tuning using execution plans and SQL optimization techniques.
- Optimize high-volume data processing using BULK COLLECT, FOR ALL, Collections, and Dynamic SQL.
- Design and maintain tables, indexes, constraints, sequences, and database objects.
- Troubleshoot and resolve issues related to APEX applications, database performance, security, and integration.
- Analyze and resolve production issues, data issues, and performance bottlenecks.
- Perform root-cause analysis and develop permanent fixes for recurring issues.
- Create and execute database deployment and rollback scripts.
- Collaborate with developers, testers, and stakeholders throughout the software development lifecycle.
- Document and maintain code standards, best practices, and technical specifications.
- Integrate APEX applications with external systems using REST APIs and SOAP Web Services.
- Use version control tools such as Git or SVN.
- Work with testing tools such as Selenium or J Meter.
Mandatory Skills
- Minimum 2 years of hands-on Oracle PL/SQL development.
- Minimum 4+ years of experience in developing web applications using Oracle APEX.
- Strong SQL and PL/SQL programming skills.
- Strong experience with Packages, Procedures, Functions, Triggers, Cursors, Collections, BULK COLLECT, FOR ALL, and Dynamic SQL.
- Strong knowledge of execution plans, indexing, query optimization, and SQL performance tuning.
- Good understanding of transactions, locking, concurrency, constraints, and data integrity.
- Experience handling large-volume data and performance-sensitive applications.
- Production support and troubleshooting experience.
- Good knowledge of Oracle 19c/21c or equivalent enterprise Oracle environments.
- Proficient in Oracle Database 11g/12c/19c, PL/SQL, SQL*Plus, SQL Developer, and SQL Loader.
- Familiar with APEX features such as Interactive Grids, Dynamic Actions, Restful Services, Application Items, Processes, Branches, etc.
- Experience using APEX plugins such as APEX Office Print, APEX Nitro, APEX Charts, etc.
- Knowledge of web development technologies such as HTML5, CSS3, JavaScript, jQuery, Bootstrap, etc.
- Experience integrating APEX applications with external systems using REST APIs and SOAP Web Services.
- Experience using version control tools such as Git or SVN.
- Experience using testing tools such as Selenium or J Meter.
- Excellent communication and problem-solving skills.
Job Type: Full-time
Pay: ₹500,000.00 - ₹1,200,000.00 per year
Benefits:
- Cell phone reimbursement
- Health insurance
- Life insurance
- Provident Fund
Ability to commute/relocate:
- Bangalore City, Bengaluru, Karnataka: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- What is your notice Period?
- Are you ready to travel Abroad ?
- What is your Current CTC?
- What is your Expected CTC?
Experience:
- total work: 3 years (Required)
Work Location: In person
