Job Description

Duration:18-month contract

Hours: Full-time, 40 hours per week.

Interview process: Screening call (30 min) and Technical Interview (1 hour)

Location: This role is open only to candidates based in the US, Canada, and Latin America. Applications from outside these regions will not be considered.

Project Overview:

Our legacy system, covers all aspects of wine production from "dirt to bottle" including land management, vineyard planning, grape harvesting, testing, and bottling processes.

We are undergoing a significant modernization project for our 25-year-old in-house developed software, transitioning from a classic RPG-based system to a more modern architecture incorporating SQL and potentially Python.

Role Summary:

We are seeking an experienced SQL Developer to join our software team, focusing on rewriting and optimizing SQL stored procedures as part of our system's modernization. The successful candidate will work closely with our application architects and newly onboarded junior developers to transform our legacy codebase into a streamlined, efficient system.

Key Responsibilities:

• Design, develop, and implement robust SQL stored procedures, optimizing performance and ensuring scalability. Familiarity with IBM RPG is advantageous but not essential.
• Analyze existing free form RPG code and other legacy systems to understand and document business processes and rules.
• Collaborate with team members to understand system functionalities and integration points.
• Maintain high standards of code quality and adhere to best practices including the use of templates, processes, and standards provided by the company.
• Participate in daily stand-ups, code reviews, and other collaborative meetings as required to ensure alignment and project progress.
  
  

Required Skills and Qualifications:

• Proven expertise in SQL development, with a strong portfolio of writing high-performance stored procedures.
• Ability to analyze and interpret complex code in legacy systems and translate business logic into efficient code.
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork skills, capable of working effectively in a collaborative environment.
• Familiarity with IBM RPG is advantageous but not essential.
  
  

Desired Skills:

• Experience with Python or willingness to learn may be beneficial as the project evolves.
• Understanding of web-based systems and previous experience in modernizing legacy software platforms will be considered a plus.