Senior Oracle PL​/SQL Developer

Overview

Job Description:

Job Title:

Senior Oracle PL/SQL Developer | Contract Duration: 9 Months |

Location:

Chicago, IL (Fully Onsite)

We invite you to join the GIS team as an Oracle DB Developer. We are a tight-knit, supportive community passionate about delivering the best experience for our customers while remaining sensitive to their unique needs.

• Assist in the design, development, and implementation of various complex applications.
• Follow team best practices, including proper source code control and delivery of unit test cases.
• Contribute across the application stack and collaborate with various teams to build or debug applications.

• Oracle Development (PL/SQL)
• Informatica experience
• Analysis and performance tuning of queries and scripts

• Conducts logical and physical database design
• Designs key indexing schemes and partitioning
• Constructs and implements operational data store
• Analyzes and optimizes query performance
• Ensures 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 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 data at scale
• 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 is a plus; able to understand the business driven by data and how it fits into the application platform

• 5 to 10 years of Oracle Applications related development experience using PL/SQL
• 2 to 3 years of Informatica development experience
• Development and troubleshooting skills using SQL, PL/SQL and Shell scripts

EEO Employer. Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with applicable law.

If you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email redacted] or .