Sr, Oracle PL/SQL Developer (Onsite Job)

Cigniti - Chicago, IL

Full-time - Senior

Chicago, IL

Professional, Scientific, and Technical Services

About the position

The Sr. Oracle PL/SQL Developer position is a long-term onsite role located in Chicago, IL. The primary focus of this role is to design, develop, and optimize complex SQL queries and PL/SQL procedures to support various database applications. The successful candidate will be responsible for developing and maintaining Unix shell scripts to automate routine processes, ensuring efficiency and reliability in database operations. Additionally, the developer will manage job scheduling using Control-M or similar tools, which is crucial for maintaining the workflow of database jobs. Collaboration is key in this role, as the developer will work closely with cross-functional teams to facilitate database integration and data migration projects. This requires a strong understanding of database systems and the ability to troubleshoot and resolve any database-related issues that may arise. Performance tuning and query optimization are also critical components of the job, ensuring that the database systems operate at peak efficiency. The position also involves implementing and maintaining database security policies and procedures, which are essential for protecting sensitive data. Documentation of processes and maintaining a knowledge base for developed systems is another important aspect of the role, contributing to the overall efficiency and effectiveness of the team.

Responsibilities

• Design, develop, and optimize complex SQL queries and PL/SQL procedures.
• Develop and maintain Unix shell scripts to automate routine processes.
• Manage scheduling of jobs using Control-M or similar tools.
• Collaborate with cross-functional teams for database integration and data migration projects.
• Provide performance tuning and query optimization to ensure high-efficiency database systems.
• Troubleshoot and resolve database-related issues.
• Implement and maintain database security policies and procedures.
• Document processes and maintain knowledge base for developed systems.

Requirements

• Total 10+ years of experience in Oracle SQL and PL/SQL development.
• Proficiency in writing complex queries and stored procedures.
• Experience in Unix shell scripting.
• Familiarity with job scheduling tools like Control-M (or similar).
• Strong analytical and problem-solving skills with a focus on performance tuning.
• Understanding of database security and optimization techniques.
• Ability to work independently and within a team environment.
• Excellent verbal and written communication skills.
• Experience in cloud technologies.
• Knowledge of Agile development methodologies.