Oracle PL/SQL Developer 1875

Job Title – Oracle PL/SQL Developer (with Unix Shell Scripting)

Experience – 7-11 years

Job Description –

• 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

#J-18808-Ljbffr…