Kryptos Technologies limited
1 week ago
Oracle PL SQL Developer
Sign up to save this job, get alerts, and apply with an optimized CV.
Company information
- Company
- Kryptos Technologies limited
- Location
- Leeds Germany
- Posted
- 1 week ago
Job description
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
Find Jobs in United Kingdom on Arbeitnow
Required skills
- quality assurance
- sql
- etl
- data modeling
- database development
- troubleshooting
- automation
- linux
- data integrity
- scripting
- data integration
- performance tuning
- oracle pl/sql
- unix
- pl/sql
- production support
- unix shell scripting
- triggers
- indexing
- functions
- relational database design
- shell scripts
- packages
- stored procedures
- views
- system administrators
- batch jobs
- system analysts
- explain plan
- tkprof
- wrapper programs
- oracle hints
- sql*loader
- external tables
- table partitioning
- scalable performance
Interested in this position?
Create your free account and tailor your CV to match this job.