Oracle Developer

We are looking for an experienced Oracle Developer responsible for designing, developing, testing, and maintaining Oracle database applications. The candidate should have strong expertise in Oracle SQL, PL/SQL, stored procedures, functions, packages, triggers, and performance tuning.

Key Responsibilities

• Develop, maintain, and optimize Oracle database applications.
• Write complex SQL queries and PL/SQL programs.
• Develop and maintain stored procedures, functions, packages, triggers, and views.
• Design and modify database tables, schemas, indexes, and constraints.
• Analyze and optimize SQL queries and database performance.
• Perform database troubleshooting and resolve application/database issues.
• Develop data migration and data transformation scripts.
• Work with development teams to integrate Oracle databases with applications.
• Perform unit testing, debugging, and code optimization.
• Participate in database design and application development projects.
• Prepare technical documentation for database objects and processes.
• Monitor database performance and identify potential bottlenecks.
• Ensure data integrity, security, and availability.
• Support production deployments and resolve critical database issues.
• Collaborate with business analysts, developers, DBAs, and other technical teams.

Required Technical Skills

• Strong knowledge of Oracle Database.
• Excellent knowledge of SQL and PL/SQL.
• Hands-on experience with:
• Stored Procedures
• Functions
• Packages
• Triggers
• Cursors
• Views
• Indexes
• Constraints
• Joins and subqueries
• Experience in SQL query optimization and performance tuning.
• Knowledge of database normalization and relational database concepts.
• Experience with data migration and ETL processes.
• Knowledge of Oracle tools such as SQL Developer.
• Understanding of database security, backup, and recovery concepts.
• Knowledge of Unix/Linux scripting is an advantage.
• Experience with Oracle Forms/Reports or Oracle APEX is an advantage.
• Knowledge of cloud databases such as Oracle Cloud / OCI is a plus.

Preferred Certifications

• Oracle Database SQL Certified Associate
• Oracle Database PL/SQL Developer Certified Professional
• Oracle Database Administration certification
• Oracle Cloud Infrastructure (OCI) certification

Educational Qualification

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

Key Skills

Oracle | SQL | PL/SQL | Stored Procedures | Functions | Packages | Triggers | Query Optimization | Performance Tuning | Database Design | Data Migration | Oracle SQL Developer | Unix/Linux

Soft Skills

• Strong analytical and problem-solving skills.
• Good communication and interpersonal skills.
• Ability to work independently and within a team.
• Good debugging and troubleshooting abilities.
• Ability to manage multiple tasks and meet project deadlines.

Certification Requirement

Oracle SQL/PL-SQL certification is preferred. Relevant Oracle certification will be an added advantage.

Pay: ₹30,000.00 - ₹40,000.00 per month

Benefits:

• Flexible schedule
• Paid time off

Work Location: In person