Oracle Developer

Ingram Content Group•La Vergne, TN

21h•$110,981 - $141,123•Hybrid

About The Position

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!

Requirements

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

Nice To Haves

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 UTL_FILE for file I/O operations
Strong knowledge of XML file structures (schema design, parsing, generation)
Linux & shell scripting
Experience with Oracle Scheduler (DBMS_SCHEDULER) for job automation and monitoring
Hands-on experience with UTL_FILE 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 plus

Responsibilities

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 UTL_FILE 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 group

Benefits

A highly competitive compensation package with generous benefits beginning first day of employment for Medical/Prescription Drug plans, HSA, Vision, Dental and Health Care FSA.
15 vacation days & 12 sick days accrued annually and 3 personal days
401K match, Life and AD&D, Employee Assistance programs, Group Legal, & more
Wellness program with access to onsite gym and basketball court for associates
Encouraged continued education with our tuition reimbursement program
Financial and in-kind opportunities to engage with non-profits in your community
Company match program for United Way donations
Volunteer opportunities and in-kind drives for non-profits throughout the year
Take breaks or brainstorm in our game room with ping pong & foosball
Casual Dress Code & Flexible Schedules (per team)