Lead Oracle Programmer Analyst

Becoming a McLane teammate is to become part of an honest, stable, and reliable company with 125 years of success. We are looking for teammates with perseverance who will take the extra step for our customers, our community, and our company. In return, we will pay you well and offer you the opportunity to go as far in your career as you want to go.

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.

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:

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

ESSENTIAL JOB FUNCTIONS:

• 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 QUALIFICATIONS & REQUIREMENTS:

• Have a bachelor's degree.
• QL 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

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.