Lead Oracle Programmer

McLane is one of the largest and most stable supply chain services leaders in the United States. We've been at the forefront of delivering retail and restaurant solutions for convenience stores, mass merchants, drug stores, and chain restaurants for over 125 years. Our vision is to be an agile, innovative, and unified supply chain partner that delivers a superior customer experience, improves the lives of our teammates and community, and produces best-in-class returns.

The Lead Oracle Programmer is a hybrid remote position which will require the candidate to report and work from the office four days a week. Therefore, interested candidates should be within a 50-minute radius from Temple, TX.

Position Overview:

Create detail specifications for Oracle PL/SQL Modules (Packages, Procedures, Functions, Triggers, etc.). Create test plans and detailed system documentation. Design, Develop, and Support PL/SQL, ETL processes for loading data from External as well as internal systems. Work with Junior level developers. Manage detailed project tasks. Help with gathering Requirements.

Benefits you can count on:

• Day 1 Benefits available: medical, dental, and vision insurance, FSA/HSA and company-paid life insurance.
• 401(k) with annual company match.
• Paid holidays, vacation time, sick leave accrual, college tuition reimbursement, and more.
• Additional benefits: pet insurance, maternity/paternity leave, employee assistance programs, discount programs, tuition reimbursement program, and more!

Essential Job Functions/Principal Accountabilities:

• 8+ Years working with Software Development.
• 5+ Years writing Detailed Specifications.
• 2+ Years working with Offshore Developers.
• 5+ years Developing Oracle PL/SQL Environment.
• Extensive Performance Tuning Experience of Oracle Applications.
• Strong understanding of the Oracle Architecture discipline, processes, concepts, and best practices.
• Has significant coding walk-thru experience. Has worked in an Exadata environment.
• Create high-level and detailed developer specifications.
• Develop and test solutions using the McLane development tools in the McLane environment.
• Provide the appropriate implementation documentation for installs and manage and execute the system-testing process and UAT process.
• Ensure that requirements and development deliverables match the design specifications.
• Ensure that test plans match the requirements; ensure that test results match the test plans.
• This position has additional duties. Special projects may be assigned at the position supervisor's discretion.

Minimum Skills & Qualifications:

• Have a bachelor's degree.
• SQL Skills
• Strong written and oral communication skills.
• Strong Testing skills.
• Can develop advanced PL/SQL modules.
• SQL Scripting for data validation, conversions, and manipulation.
• Can demonstrate skills in interpreting Oracle EXPLAIN generations

Working Conditions:

• Office environment

Candidates may be subject to a background check and drug screen, in accordance with applicable laws.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.