Senior Oracle PL/SQL Developer

The Senior Oracle PL/SQL Developer will create Oracle procedures, functions, triggers, packages, and materialized views using advanced features of Oracle 11g and 12. The role involves ETL processing, data cleansing, data transformations, and loading huge data sets from multiple vendors. The developer will also work on performance tuning for existing SQL and PL/SQL objects, build optimized objects, and create complex Unix shell scripts to automate batch job processing.

What You Will Do

The Senior Oracle PL/SQL Developer will perform logical and physical design of databases, data modeling, and design specifications to analyze dependencies and perform risk analysis. The role also involves developing and maintaining technical specifications, data mappings, program logic, and flowcharts for change requests. The developer will write complex queries to identify potential issues and remediate them, automate flat file loading to Oracle using SQL Loader, and create control files for that activity.

Why It Might Be a Fit

The ideal candidate will have strong Oracle performance tuning skills, experience with GitHub Copilot or other Dev Assist tools, and the ability to understand the flow from UI to DB. The role offers a chance to work on complex projects, develop skills in data modeling and design, and contribute to the company's mission to help organizations design, develop, and optimize their data infrastructure and systems.

Requirements

• Create Oracle procedures, functions, triggers, packages, and materialized views using advanced features of Oracle 11g and 12
• ETL processing with Python, Oracle, and Unix
• Data cleansing, data transformations, and loading huge data sets from multiple vendors
• Performance tuning for existing SQL and PL/SQL objects
• Logical and physical design of databases, data modeling, and design specifications
• Developing and maintaining technical specifications, data mappings, program logic, and flowcharts
• Writing complex queries to identify potential issues and remediate them
• Automating flat file loading to Oracle using SQL Loader
• Experience with GitHub Copilot or other Dev Assist tools
• Strong Oracle performance tuning skills

Benefits

• Flexible work
• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan
• Paid time off and paid holidays
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child/elder care and tutoring
• Mentoring, coaching, and learning programs
• Employee Resource Groups
• Disaster Relief