Ingram Content Group (ICG) is hiring an Oracle Developer. The Oracle Developer performs maintenance of Oracle based, internally developed applications for Print on Demand business, including development of back-end applications, system enhancements, and interfaces with other systems. This position will require 3 days in the office, candidates must be in or willing to relocate to the Nashville, TN region.Want to help explore and build new ways to deliver content to the world? At Ingram, our Technology team is blazing a trail by providing content distribution services to thousands of publishers with key initiatives around business intelligence, machine learning, continuous integration and omnichannel. We support diverse people and technology that highlights innovation through SaaS platforms, metadata, cloud, and containerization. Our teams are agile, and emphasize authenticity, creativity, and transparency upon a fact-based foundation. The world is reading, and it is our goal to connect as many people as possible to the content they want in the simplest ways. If you are an IT professional who strives to deliver results through collaborative partnerships, understanding what drives business, and enjoys working in a connected culture, we can’t wait to meet you! The ideal candidate will have the following minimum qualifications:Bachelor’s degree in IT, computer science or related field or directly related year-for-year experience 2+ years’ experience with Oracle including SQL, pl/sql We have a preference for:Experienced with programming (stored procedures, packages etc.) in Oracle Enterprise Edition, fluent in Oracle PL/SQL Strong working knowledge of SQL. Hands-on experience with UTLFILE for file I/O operations Strong knowledge of XML file structures (schema design, parsing, generation) Linux & shell scripting Experience with Oracle Scheduler (DBMSSCHEDULER) for job automation and monitoring Hands-on experience with UTLFILE for file I/O operations Strong knowledge of XML file structures (schema design, parsing, generation) Solid understanding of Oracle transaction management, locking, and concurrency control Experience managing large table data lifecycle, including purging and archiving strategies Java/JSP experience a plus Experience with Claude Code a plusThe Oracle Developer’s key responsibilities are:Participates in analysis, development, support and testing for custom stored procedures, functions, and packages in Oracle PL/SQL to support backend application logic Builds and maintains complex Oracle packages, including package specifications and bodies, following modular and reusable design principles. Writes and optimize SQL queries, including use of Oracle analytic/window functions for reporting and data analysis needs Regularly monitors and tunes SQL and PL/SQL code for performance, including execution plan analysis  Manages lifecycle of large database tables, including scheduled purging/archiving of historical or obsolete data Generates flat files, XML, and JSON outputs from the database using UTLFILE and native Oracle XML/JSON packages. Writes and maintains Unix/Linux shell scripts to support job automation, file processing, and system integration tasks  Integrates PL/SQL processes with OS-level scripts for end-to-end automation Designs solutions that safely handle concurrent access to shared data, avoiding locking conflicts and deadlocks  Interacts with Oracle support to research and resolve issues Provides technical support to the Application Services groupHiring Salary Range: $110,981 - $141,123. This range represents the anticipated low and high end of the salary for this position. It will be determined by factors including but not limited to:  the applicant’s education, experience, knowledge, skills, and abilities, geographic location, as well as internal equity and alignment with market data.
