Oracle PL/SQL Developer

Top Skills -

Must Haves

Developmentoracle 19coraclepl sql

Top Skills' Details- This candidate needs to write PL/SQL code but more importantly need to be able to do production support within PL/SQL where they analyze, debug, and fix existing code that is already in production.
- 5 to 10 years of Oracle Applications related development experience using PL/SQL and doing their production support on these applications.
- Ability to code at a high level.
- 2 to 3 years of Informatica development experience to help with debugging. Job DescriptionRequired Skills:
- Oracle Development (PL/SQL)
- Informatica experience
- Production support (Only business hours Monday- Friday)
- Identity Access Management
- Soft skills very important. They will need great communication skills because this person will be working with the end users.
- Analysis and Performance tuning of queries and scripts
- Conducts logical and physical database design
- Designs key and indexing schemes and designs partitioning
- Constructs and implements operational data store
- Analyze and Optimize query performance
- Ensures that data models are consistent with the ecosystem
- Adheres to data management standards and advises on best practices
- Participates in building and testing business continuity disaster recovery procedures per requirements
- Has experience with relational database internals, including both query processing and query planning, or other data processing infrastructure
- Has knowledge of key data structures and algorithms
- Has knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases
- Has experience with dealing with data at scaleAdditional Skills & Qualifications- Has experience adhering to strict audit standards
- Has experience with relational database management systems (e.g. Oracle)
- Has experience in different programming/scripting languages (e.g. python) and ETL tools (e.g. Informatica)
- Experience with Data Analysis and Science will be a plus, the ideal candidate should be able to understand the business driven off the data and how it fits into the Application platformEmployee Value Proposition (EVP)Building a new application platform to support enterprise collaboration sites and functions.
This person will be joining a team of Identity Access Management professionals in a rare innovation team that no other top 50 Fortune company has. It is truly a one of a kind team/application. The app processes 1 million transactions each month. Flexible work environment- team centric and also allows individuals to be autonomous and they welcome people who want to take on a lead role (either individually or manage a small team).
95% of the FTE base started out as a contractor and converted to FTE and they are still growing.

Job Type: Full-time

Pay: $58.46 - $65.65 per hour

Benefits:

• 401(k)

Experience level:

• 9 years

Schedule:

• Monday to Friday

Experience:

• Oracle PL/QL: 7 years (Preferred)

Ability to Commute:

• North Chicago, IL 60064 (Required)

Work Location: Hybrid remote in North Chicago, IL 60064

Salary : $58 - $66