Lead Oracle Programmer Analyst

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

Job summary

An established industry player is seeking a Lead Oracle Programmer Analyst to join their innovative team. This hybrid role requires expertise in Oracle PL/SQL, where you will design, develop, and support complex data processes while collaborating with junior developers. With a strong emphasis on performance tuning and detailed specifications, you will play a crucial role in ensuring project success. The company offers competitive benefits from day one, including medical, dental, and vision insurance, along with a 401(k) plan. If you are driven by excellence and ready to make an impact, this position is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401(k) with Company Match

Paid Holidays

Vacation Time

Sick Leave Accrual

College Tuition Reimbursement

Qualifications

• 8+ years in software development with strong Oracle PL/SQL experience.
• Proficient in creating detailed specifications and managing project tasks.

Responsibilities

• Design, develop, and support PL/SQL and ETL processes for data management.
• Create test plans and documentation while ensuring compliance with requirements.

Skills

Oracle PL/SQL

SQL

Performance Tuning

Communication Skills

Testing Skills

Education

Bachelor's Degree

Tools

Oracle

ETL Processes

McLane Development Tools

Job description

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

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.