Address
Form of work
Ingram Content Group (ICG) is hiring a Senior Oracle Programmer/Analyst for our Lightning Source IT Team. This position will allow hybrid but candidates must be in the Nashville, TN or Chambersburg, PA region.
This individual performs design, development and support of large-scale mission critical software systems.
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 the financial applications.
- Creating efficient, maintainable, and optimized PL/SQL stored code.
- Analyze and improve query performance, database indexing, and use 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.
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 Assistant programs, Group Legal, & more
- Avid reader? Numerous opportunities to engage with books and authors
- Discounted offers to self-publish with IngramSpark!
- 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
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.
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
