Sr. Oracle Developer

Job Description

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

Additional Information

Perks/Benefits:

• Competitive salary
• Generous holiday plus Bank Holidays
• Life Assurance
• Company Pension Scheme
• Company Sick Pay Scheme
• Continuous Professional Development and Training Opportunities
• Business Casual dress code, dress down Fridays
• Free onsite parking
• Free Hot drinks
• Snack and Drink Vending machines on site
• Gym Membership Corporate Discount
• Service Awards
• BUPA Medical
• BUPA Travel
• Company Bonus

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