Top Skills - Must Haves

Development

oracle 19c

oracle

pl 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 Description

Required 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 scale

Additional 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 platform

Employee 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.