Oracle PL/SQL Developer

'

: - ( - )

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.

Requirements

• 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.
• 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.