Oracle PL/SQL Developer

Develop, test, and maintain PL/SQL stored procedures, functions, triggers, packages, and views.

Optimize SQL queries and PL/SQL code for better performance and efficiency.

Design and implement database structures, tables, indexes, constraints, and relationships.

Work closely with application developers to integrate backend logic with front-end applications.

Perform data migration, transformation, and loading (ETL) processes.

Troubleshoot and resolve database issues, including query tuning and performance bottlenecks.

Ensure data integrity and security by implementing proper access controls and backup strategies.

Participate in code reviews, documentation, and system design discussions.

Collaborate with business users to understand requirements and deliver database solutions.

Implement job scheduling, automation, and batch processing as needed.

A total of 6 years of experience as an Oracle PL/SQL Developer.

Extensive experience in Oracle development SQL, PL/SQL, and Unix shell script.

Proficient in developing and maintaining database-intensive applications. Sound knowledge of Design patterns, database design, normalization, and tuning.

Sound knowledge of ETL processing in Oracle server and data-warehousing concepts.

Knowledge of CICD tools like JIRA, TeamCity, Gitlab, and SonarQube. Excellent verbal and written communication skills.

N/A

SQL (PL/SQL - Oracle)

BCM Industry

13/02/2025

Req. VR-111776