Technical Analyst

Overview

Develop and maintain PL/SQL solutions for ERP and mobile apps, ensuring system uptime.

Key Responsibilities

• version control
• app development
• sql reporting
• code deployment
• pl/sql development
• production support

Tasks

-As part of code development, overlooking and maintaining control versions like GitHub. -Design user-friendly and efficient applications utilizing internal or external resources for data entry, reporting, and system integration. -Create basic reports from SQL/Oracle database using appropriate tools. -Generate and compile reports based on findings, complete with probable cause and potential solutions to systems issues -Develop, test, and deploy code into the appropriate environment. -Create custom PL/SQL solutions within our ERP and mobile apps system. -Provide technical knowledge and expertise to help Business Systems Analysts translate business needs into technical designs. -Analyzes and creates software requirements and estimates for execution to determine the feasibility of design within time and cost constraints based on customer needs. -Prepare technical documentation for code and design changes and debug, monitor, and troubleshoot end-user applications. Develop and implement procedures and documentation for software system testing, data validation, and training. -Identify and resolve complex production issues. Monitor system processes to guarantee high uptime. -Confer with third-party software solutions to ensure that the most effective and efficient method of integration is chosen. -Provide system administration functions for ERP and Mobile applications -Partner with an extended team of business analysts to lead end users through training and testing by documenting user guides, training materials, business processes, and test plans, and then performing the required in-person material reviews.

Requirements

• oracle pl/sql
• restful apis
• github
• erp systems
• toad
• problem solving

What You Bring

-3+ years of technical analyst/developer or related experience -Office deskwork, requiring sitting, walking, using phone & computer -7+years or equivalent combination of education and experience -Experience utilizing SOAP, XML and JSON -Strong analytical and creative problem-solving skills -Excellent debugging and troubleshooting skills -May lift up to 30 lbs. occasionally -3+ years’ experience with source control systems such as GitHub -3+ years RESTful APIs, RESTful APIs integrations and event-driven architectures experiences -Can tolerate variable and sometimes challenging conditions during visits or inspections of company equipment in a railroad environment. -3+ years Oracle PL/SQL development experience -1+ year in a manufacturing environment -10% or more travel including international -Experience with ERP systems -Experience with TOAD, Oracle SQL Developer or SQL Navigator or similar tool -Excellent verbal and written communication skills to convey complex technical solutions clearly to a group

People Also Searched For

About Loram Maintenance Of Way, Inc.

-Revolutionized track maintenance by automating ballast cleaning. -Expanded into rail grinding, inspection, geotechnical services, friction management, and OEM equipment manufacturing over decades. -Operates advanced computer-guided grinders for rail grinding and inspection worldwide. -Projects include deep ballast cleaning, rail profile restoration, material handling, and structural monitoring. -Introduced Railvac trench-cleaning cars and data-driven digital inspection platforms in the 2000s. -Absorbed Rail Vehicle Engineering in 2016, creating Loram UK for heavy overhaul and rolling-stock services. -Grinding trains feature built-in firefighting systems and on-site crew accommodations.

Sector Specialisms