Oracle PL SQL Developer

Job Description: Oracle PL/SQL Developer (with Unix Shell Scripting)

Job Summary

We are seeking a highly skilled Oracle PL/SQL Developer with a strong background in Unix Shell Scripting . In this role, you will be responsible for developing database objects, optimizing query performance, and writing automated Unix scripts to handle batch processing and data integration tasks. The ideal candidate thrives in a backend environment, possesses excellent troubleshooting skills.

Key Responsibilities

• Database Development: Design and develop highly efficient Oracle database code including stored procedures, functions, packages, triggers, and views to support complex business logic.

• Automation & Scripting: Create, maintain, and debug complex Unix/Linux shell scripts (Wrapper Programs) to automate routine PL/SQL Programs, and scheduled batch jobs.

• Performance Tuning: Monitor and optimize code performance by tuning complex SQL statements and PL/SQL blocks using tools like EXPLAIN PLAN, TKPROF, Oracle Hints, and indexing strategies.

·         ETL & Data Integration: Design and manage Extract, Transform, Load (ETL) data pipelines using SQL*Loader, external tables, or native PL/SQL to migrate data from legacy systems and external sources.

·         Data Modeling & Architecture: Participate in relational database design, table partitioning, and data modeling to ensure data integrity and scalable performance.

·         Production Support & Troubleshooting: Diagnose and resolve, failing batch jobs, and performance bottlenecks in a timely manner.

·         Collaboration: Partner with System Analysts, Quality Assurance teams, and System Administrators to migrate code across environments and support testing team