Ingram Content Group is hiring a Remote Sr. Oracle Developer
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
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.
Qualifications
See more jobs at Ingram Content Group