Job Description
Ingram Content Group (ICG) is hiring a Senior Oracle Application Developer for our Lightning Source IT Team. Lightning Source, part of Ingram Content Group, is a well-established print-on-demand (POD) and distribution service primarily for books. It helps publishers, both large and small, to print books only when there is demand, thus avoiding the costs and risks associated with maintaining large inventories. This model makes it easier for authors and publishers to handle smaller print runs, maintain control over their costs, and keep older or less popular titles available without warehousing
This individual performs design, development and support of large-scale mission critical software systems. This position will allow hybrid home/office environment but candidates must be in the Nashville, TN area.
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
- 5+ years’ experience designing and developing in the Oracle E-Business Suite
We have a preference for:
- A deep understanding of Oracle database architecture, Oracle SQL, PL/SQL programming, and performance tuning. Experience with Oracle database versions 19c, 12c, 11i are all acceptable.
- Several years of hands-on experience working with Oracle E-business with a focus on financial applications.
- Creating efficient, maintainable, and optimized PL/SQL stored code.
- Analyze and improve query performance, database indexing, and use
- Experience in writing Java Applications
- Hands on working with Bottomline Transform electronic document suite
- Oracle's performance monitoring tools.
- Strong documentation skills
- Team player that listens and contributes ideas
- Attention to detail
The Sr Oracle Developers key responsibilities are:
- Works with Development staff in all application interface design, installation, maintenance and troubleshooting.
- Coordinates the installation, configuration and monitoring of both systems and business-level monitoring that provides 24*7*365 feedback on systems health.
- Designs and develops custom software/production technology to meet LSI’s business requirements.
- Designs and implements solutions to solve business requirements using third-party hardware and software solutions.
- Documents solutions and train LSI personnel on implemented solutions.
- Designs, develops, and maintains Oracle database stored code and objects, including schema design, table structures, indexes, and data modeling.
- Optimizes database performance by fine-tuning queries, identifying and resolving bottlenecks, and implementing indexing strategies.
- Develops complex PL/SQL procedures, functions, triggers, and packages to implement business logic and data manipulation.
- Creates and maintains database scripts, including stored procedures, views, and materialized views.
- Performs unit testing and debugging of PL/SQL code to ensure functionality, accuracy, and adherence to business requirements.
- Proficiently handles creating and parsing XML and JSON structures and their interfaces within Oracle database applications.
- Troubleshoots and resolves database issues, including performance problems, data corruption, and connectivity errors.
- Interfaces with communication gateways to link and share relevant metadata between LSI’s enterprise IT applications.
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
- 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
- Casual Dress Code & Flexible Schedules (per team)
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.
Ingram Content Group LLC is an affirmative action/equal opportunity employer. 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.
- EEO/AA Employer/Vet/Disabled
- We participate in EVerify.
- EEO Poster in English
- EEO Poster in Spanish
Top Skills
What We Do
The world is reading. Ingram helps connect our world with the books they want—print and digital—when they need them, in the simplest ways. To better serve an increasingly connected global community of readers we are transforming the book industry for the better: through smart leadership, cutting-edge technology, and revolutionary innovations in the manufacture and distribution of books.
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, VitalSource Technologies LLC, Ingram Library Services LLC, and Tennessee Book Company LLC.