01
TRFI-26-06121
Oracle PL/SQL Developer (Unix Shell Scripting, Batch/ETL)
Looking for a senior Oracle PL/SQL Developer (7–10 years) with strong Unix/Linux shell scripting to build and support backend database solutions. The role focuses on developing Oracle database objects (procedures, packages, triggers, views), automating batch processing via shell wrapper scripts, tuning SQL/PLSQL performance (EXPLAIN PLAN, TKPROF, hints, indexing), and building ETL/data integration flows using SQL*Loader/external tables/PLSQL. Candidate should be strong in troubleshooting production batch failures and collaborating with analysts, QA, and sysadmins for environment migrations and testing support.
Position summary
- Location
- United Kingdom of Great Britain and Northern Ireland (the)
- Workplace
- On-site
- Employment
- Full Time
- Experience
- Minimum 7 years and Maximum 10 years
Role overview
Why This Role Matters.
Looking for a senior Oracle PL/SQL Developer (7–10 years) with strong Unix/Linux shell scripting to build and support backend database solutions. The role focuses on developing Oracle database objects (procedures, packages, triggers, views), automating batch processing via shell wrapper scripts, tuning SQL/PLSQL performance (EXPLAIN PLAN, TKPROF, hints, indexing), and building ETL/data integration flows using SQL*Loader/external tables/PLSQL. Candidate should be strong in troubleshooting production batch failures and collaborating with analysts, QA, and sysadmins for environment migrations and testing support.
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
02
Automation & Scripting: Create, maintain, and debug complex Unix/Linux shell scripts (Wrapper Programs) to automate routine PL/SQL Programs, and scheduled batch jobs.
03
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.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
Oracle
Required
02
PL/SQL
Required
03
SQL
Required
04
Stored Procedures
Required
05
Functions
Required
06
Packages
Required
07
Triggers
Required
08
Views
Required
09
Unix
Required
10
Linux
Required
11
Shell Scripting
Required
12
Bash
Required
13
Batch Jobs
Required
14
Wrapper Scripts
Required
15
ETL
Required
16
Data Integration
Required
17
SQL*Loader
Required
18
External Tables
Required
19
EXPLAIN PLAN
Required
20
TKPROF
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Oracle PL/SQL development (procedures, functions, packages, triggers, views)
Advanced SQL and complex query writing
Unix/Linux shell scripting (automation, wrapper scripts, batch jobs, scheduling support)
SQL/PLSQL performance tuning (EXPLAIN PLAN, TKPROF, Oracle hints)
Indexing strategies and query optimization
ETL/data integration using SQL*Loader and/or external tables and/or native PL/SQL
Production support and troubleshooting of batch failures/performance issues
Relational database design fundamentals and data integrity concepts
Preferred
Nice to Have
Table partitioning
Data modeling (logical/physical)
Legacy system data migration experience
Collaboration with QA/System Analysts/System Administrators for code migration across environments
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Oracle PL/SQL Developer (Unix Shell Scripting, Batch/ETL)
One page, about two minutes. We only ask for what we actually need to have a first conversation.