Sr. Oracle Developer

at  Ingram Content Group

Job Description
Ingram Content Group (ICG) is hiring a Senior Oracle Developer for our Lightning Source IT Team based in LaVergne, TN. This position will allow Work from Home but candidates must be in the Nashville, TN 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

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