Oracle PL/SQL Developer

Weekday; Bengaluru; On-site; INR 500,000 - 1,000,000; Full time

Job summary

Weekday in Bengaluru, Karnataka, India, is seeking an experienced Oracle PL/SQL Developer to design, develop, and maintain complex database solutions for critical business applications. You will collaborate with analysts, data architects, and developers to translate requirements into robust PL/SQL code and scalable database components.

You will tune SQL queries, create triggers, stored procedures, and participate in rigorous unit testing to deliver production-ready code on schedule.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 5+ years of professional experience in Oracle PL/SQL development.
• Strong command of Oracle SQL, including complex joins, subqueries, and analytic functions.
• Proficiency in writing and optimizing stored procedures, functions, packages, and triggers in PL/SQL.
• Experience with Oracle database performance tuning, indexing, and partitioning techniques.
• Familiarity with database versioning and migration tools such as Oracle Database Migration Assistant.
• Knowledge of data flow modeling, ETL processes, and integration patterns.
• Excellent problem‑solving, debugging, and performance troubleshooting skills.
• Ability to collaborate across cross‑functional teams and communicate technical concepts clearly.
• Self‑motivated, detail‑oriented, and committed to delivering high‑quality code on time.

Responsibilities

• Design, develop, and maintain PL/SQL modules for data processing and integration.
• Write efficient SQL queries and scripts for ETL.
• Perform code reviews, unit testing, and debugging to ensure code quality.
• Collaborate with DBAs to tune performance and manage resources.
• Document design decisions and technical specifications for database components.
• Implement data migration strategies and data quality management across environments.
• Monitor and troubleshoot production databases for performance and integrity.
• Participate in capacity planning and scalability assessments for large data environments.
• Mentor junior developers and share PL/SQL best practices.
• Stay updated on Oracle releases and new features to propose enhancements.

Skills

PL/SQL

Oracle SQL

Performance tuning

ETL processes

Education

Bachelor’s degree in CS/IT

Tools

Oracle Database

Migration tools

Job description

𝗧𝗵𝗶𝘀 𝗿𝗼𝗹𝗲 𝗶𝘀 𝗳𝗼𝗿 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗪𝗲𝗲𝗸𝗱𝗮𝘆'𝘀 𝗰𝗹𝗶𝗲𝗻𝘁𝘀

Salary range: 𝗥𝘀 𝟱𝟬𝟬𝟬𝟬𝟬 - 𝗥𝘀 𝟭𝟬𝟬𝟬𝟬𝟬𝟬 (𝗶𝗲 𝗜𝗡𝗥 𝟱-𝟭𝟬 𝗟𝗣𝗔)

Experience: 5+ yrs

Location: Bengaluru, Karnataka, India

As an Oracle PL/SQL Developer, you will design, develop, and maintain complex database solutions that power critical business applications for our clients. You will collaborate closely with business analysts, data architects, and application developers to translate functional requirements into robust PL/SQL code, ensuring optimal performance, security, and scalability. Your role will involve tuning SQL queries, creating triggers and stored procedures, and conducting rigorous unit testing to deliver high-quality, production-ready code on schedule. By staying current with Oracle best practices and industry trends, you will continuously improve database architecture and contribute to the overall success of our technology initiatives.

Key Responsibilities

• Design, develop, and optimize PL/SQL modules for data processing and integration.
• Write efficient, maintainable SQL queries and scripts for data extraction, transformation, and loading (ETL).
• Perform code reviews, unit testing, and debugging to ensure code quality and reliability.
• Collaborate with database administrators to tune performance and manage database resources.
• Document design decisions, technical specifications, and user manuals for database components.
• Implement data migration strategies and data quality management across multiple environments.
• Monitor and troubleshoot production database systems, addressing performance bottlenecks and data integrity issues.
• Participate in capacity planning and scalability assessments for large-scale data environments.
• Mentor junior developers and share knowledge on best practices in PL/SQL development.
• Stay updated on Oracle releases, new features, and emerging industry trends to recommend technology enhancements.

What Makes You a Great Fit

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 5+ years of professional experience in Oracle PL/SQL development.
• Strong command of Oracle SQL, including complex joins, subqueries, and analytical functions.
• Proficiency in writing and optimizing stored procedures, functions, packages, and triggers in PL/SQL.
• Experience with Oracle database performance tuning, indexing, and partitioning techniques.
• Familiarity with database versioning and migration tools such as Oracle Database Migration Assistant.
• Knowledge of data flow modeling, ETL processes, and integration patterns.
• Excellent problem‑solving, debugging, and performance troubleshooting skills.
• Ability to collaborate across cross‑functional teams and communicate technical concepts clearly.
• Self‑motivated, detail‑oriented, and committed to delivering high‑quality code on time.