Cigniti - Chicago, IL
posted about 1 month ago
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.