Oracle Developer

Ingram Content Group

La Vergne (TN)

Hybrid

USD 111,000 - 141,000

Full time

6 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Benefits offered by this job

Competitive salary

Medical/Prescription Drug plans

Vision

Dental

HSA

12 vacation days

12 sick days

Personal days

401K match

Life and AD&D

Employee Assistance programs

Tuition reimbursement

Volunteer opportunities

Onsite gym

Job summary

Ingram Content Group in the Nashville area is seeking an Oracle Developer to maintain and extend Oracle-based applications for Print on Demand. The role focuses on backend logic, complex packages, and data automation across a modern SaaS-like environment.

The candidate will collaborate with IT and business teams to optimize data flows and interfaces. The ideal candidate has 2+ years of Oracle experience with SQL/PL-SQL and a Bachelor’s degree in IT or related field.

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.

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 optimizes 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.
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.

Skills

Oracle PL/SQL

SQL

Stored procedures

Oracle EE

XML parsing

Shell scripting

UTL_FILE

Oracle Scheduler

Java/JSP

Claude Code

Education

Bachelor's degree in IT or related field

Job description

Job Description

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

The 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 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

Hiring 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.

Additional Information

Perks/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)

The world is reading, and Ingram Content Group ("Ingram") connects people with content in all forms. Providing comprehensive services for publishers, retailers, libraries and educators, Ingram makes these services seamless and accessible through technology, innovation and creativity. With an expansive global network of offices and facilities, Ingram's services include digital and physical book distribution, print-on-demand, and digital learning. Ingram Content Group is a part of Ingram Industries Inc. and includes Ingram Book Group LLC, Ingram Publisher Services LLC, Lightning Source LLC, Ingram Library Services LLC, Tennessee Book Company LLC, Ingram Content Group UK Ltd. and Ingram Content Group Australia Pty Ltd.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, work related mental or physical disability, veteran status, sexual orientation, gender identity, or genetic information.