Lead Oracle Programmer Analyst

McLane Company, Inc; Temple (TX); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Join a leading supply chain services provider as a Lead Oracle Programmer Analyst. This hybrid role involves creating detailed specifications and developing PL/SQL modules to support robust data processes. With a focus on performance tuning and collaboration with junior developers, you’ll play a key role in enhancing the efficiency of our systems. Enjoy comprehensive benefits from day one, including medical, dental, and vision insurance, a 401(k) plan with company match, and generous paid time off. If you are ready to make a significant impact in a dynamic environment, this is the opportunity for you!

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401(k) with Match

Paid Holidays

Vacation Time

Sick Leave

Tuition Reimbursement

Pet Insurance

Employee Assistance Programs

Qualifications

• 8+ years in software development with extensive PL/SQL experience.
• Strong SQL skills and ability to write detailed specifications.
• Experience working with offshore developers.

Responsibilities

• Create specifications for Oracle PL/SQL modules and ETL processes.
• Manage project tasks and ensure deliverables match design specifications.
• Work closely with junior developers and offshore teams.

Skills

Oracle PL/SQL

SQL

Performance Tuning

Communication Skills

Testing Skills

Education

Bachelor's Degree

Tools

Oracle Exadata

McLane Development Tools

Job description

Description

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 Analyst 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.

Primary Location:United States-Texas-Temple

Work Locations:

IS970 HO MBIS

3407 S 31st Street

Temple76502

Job:Information Technology

Schedule:Full-time

Shift:1st - Day

Employee Status:Regular