Oracle PL/SQL Developer (Job Code:176955)
Job description:
Duties:
Responsible for designing robust data models to capture and analyze trading positions and liquidity metrics for the Barclays Trading Wind-down (TWD) project; leading the development of CCR and WCR models and implement data validation rules for Risk-Based Loss (RBL) impact analysis; developing and deploying Generative AI platforms (Project Rhodium) using Python (Asyncio/Threading) and AWS Bedrock; developing and optimizing AWS Lambda functions for event-driven microservices and utilizing AWS Glue for large-scale data transformation and ETL orchestration; managing cloud infrastructure deployments utilizing Provisioned Product Services to ensure standardized service integration; architecting and implementing GraphQL layers and REST APIs to support flexible data querying; authoring complex Oracle PL/SQL packages utilizing Bulk Binding and Collections; utilize and apply knowledge of Oracle 12c/11g, PL/SQL, UNIX Shell Scripting, SSIS, SSAS, Performance Tuning and Optimization, ETL Pipeline Development, Root Cause Analysis (RCA), Python, REST API Integration, AWS, Jira, and GraphQL to complete necessary tasks; conducting deep-dive performance tuning and Root Cause Analysis (RCA); utilizing Tableau to automate the generation of PRA reports; and managing end-to-end delivery using TeamCity, GitLab, and Jira for agile sprint planning.
Location: Marlboro, NJ and various unanticipated locations throughout the U.S;
Salary: $115,835 per year;
Minimum Qualifications:
- Education: Bachelor’s Degree in Data Science, Computer Science, Electronic Engineering, Communication Engineering, or in a related field of study (will accept equivalent foreign degree);
- Experience: Two (2) years in the position above, as a SQL PL/SQL Developer, as a Systems Engineer, or in a related occupation;
- Other Requirements: Experience must include two (2) years’ use of all the following: Oracle 12c/11g, PL/SQL, UNIX Shell Scripting, SSIS, SSAS, Performance Tuning and Optimization, ETL Pipeline Development, Root Cause Analysis (RCA), Python, REST API Integration, AWS, Jira, and GraphQL.
- Will also accept any suitable combination of education, training, and/or experience.