R
Oracle PL/SQL Developer
Salary undisclosed
Checking job availability...
Original
Simplified
Oracle 12c or above, they are on 19c, Unix, autosys or a job scheduling tool, big data warehousing, heavy PL SQL programming (packages, procedures, functions) because they do not have a set ETL.
Responsibilities:
- Oracle Exadata: Utilize experience with versions 12c or above to manage and optimize databases. (Currently in 19c)
- PL/SQL: Handle outdated ETL processes with a strong emphasis on packages, procedures, functions, triggers, and indexing. Provide troubleshooting support as the team transitions to other ETL tools.
- Dynamic SQL: Develop and maintain dynamic SQL queries.
- Parallel Processing: Design and automate processes using Autosys. Experience with scheduling software such as Control M, Autosys, and IBM tools is required.
- SQL Explain Plan: Analyze and optimize SQL queries using Explain Plan.
- Data Preparation: Prepare data to simplify reporting processes, ensuring minimal need for complex data processing.
- Requirements Gathering: Collaborate with small business lending teams, especially in digital analytics (AB Initio), to gather and understand requirements.
- Transformation Projects: Support the transformation of small business processes using tools like nCino, ensuring data integration into the analytics space.
- Dashboard Integration: Feed data into dashboards for real-time analysis and reporting.
- Regulatory Reporting: Manage regulatory reporting processes, ensuring all reports are accurately generated and submitted.
- Automation Recreation: Recreate and optimize processes for automation.
- Performance Tuning: Apply fundamental knowledge of performance tuning to ensure efficient data processing and system operations.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job