Oracle PL/SQL Developer (with Unix Shell Scripting)

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

Location - Leeds, UK

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