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
#J-18808-Ljbffr
Oracle Pl/Sql Developer (With Unix Shell Scripting) in Ledston employer: American IT Systems
Palantir is an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration among high-complexity teams. With a focus on employee growth, we provide opportunities for professional development in cutting-edge technologies like Kubernetes and Terraform, all while contributing to meaningful projects that support UK Government programs in defense. Our London location not only offers a vibrant city life but also a unique chance to work on secure and scalable infrastructure that makes a real impact.
