We are looking for an experienced Oracle PL/SQL Developer with strong hands-on expertise in SQL/PLSQL development, database performance tuning, and production support. The candidate will develop database components, optimize complex queries, troubleshoot production issues, and work closely with application teams.
Key Responsibilities
- Develop and maintain complex PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Views, and Jobs.
- Write and optimize complex SQL using joins, subqueries, CTEs, analytical functions, MERGE, and set operators.
- 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.
- 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.
Mandatory Skills
- Minimum 2 years of hands-on Oracle PL/SQL development.
- 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.
Pay: ₹300,000.00 - ₹800,000.00 per year
Benefits:
- Cell phone reimbursement
- Flexible schedule
- Health insurance
- Leave encashment
- Paid sick time
- Provident Fund
Ability to commute/relocate:
- Bengaluru, Karnataka (Bengaluru, Bengaluru Urban District): Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- What is your notice period?
- What is your current CTC?
- What is your expected CTC?
Experience:
- PL/SQL: 2 years (Required)
Work Location: In person
