I/S - Salary - DBA, ERP Tech Support

Employer
Standard Motor Products, Inc
Location
Lewisville, Texas
Posted
Nov 15, 2023
Closes
Dec 01, 2023
Ref
2679123731
Discipline
Other
Position Type
Technician
Specialty
Other
Hours
Full Time
Organization Type
Corporate
Established in 1919 and traded on the NYSE, Standard Motor Products, Inc., (SMP) is a leading independent manufacturer, distributor, and marketer of replacement parts for motor vehicles in the automotive aftermarket industry, with a complementary focus on heavy duty, industrial equipment and original equipment markets.

We are organized into two operating segments. Each segment focuses on providing our customers with full-line coverage of its products, and a full suite of complementary services that are tailored to our customers' business needs and driving end-user demand for our products. Our Engine Management Segment manufactures and distributes a full line of critical components for the ignition, electrical, emissions, fuel and safety-related systems of motor vehicles. Our Temperature Control Segment manufactures and distributes a full line of critical components for the temperature control (air conditioning and heating) systems, engine cooling systems, power window accessories and windshield washer systems of motor vehicles.

We sell our products primarily to automotive aftermarket retailers, program distribution groups, warehouse distributors, original equipment manufacturers and original equipment service part operations in the United States, Canada, Europe, Asia, Mexico and other Latin American countries.

We employ approximately 4,300 people in North America, Europe and Asia.

GENERAL DESCRIPTION OF RESPONSIBILITIES

  • Help establish, maintain and enforce departmental software design and coding standards.
  • Enforce design standards and review of technical specs before any development starts.
  • Enforce standards through peer reviews of code before going to turnover/BA testing.
  • Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries.
  • Proposes and implements enhancements that will improve the performance and reliability of the system.
  • Help train new programmers on procedures and coding standards (CL, RPG, RGPLE, Free, SQL, etc.).
  • Help in iSeries considerations/decisions as far as environments, refreshes, etc.
  • Owner of turnover, make sure it is up to date, purged out, etc.
  • Help Monitor TrackIt for incoming orders, support of help desk requests and help assign work to programmers.
  • Once specs are done by the BA group help assign the projects to programmers.
  • Help keep up with the projects, notes, TrackIt and report to management on timely basis.
  • Help with prioritizing tasks/projects so resources are used in an efficient manner.
  • Research new technologies and make recommendations to management and train programmers on the new technology.
  • Ability to establish and maintain positive relationships with non-IT personnel at all levels in the business
  • Strong organizational skills with the ability to work on multiple projects against strict deadlines
  • Thorough knowledge of the software development lifecycle.
  • Ability to work independently and as part of a team


  • WORK EXPERIENCE REQUIREMENTS

  • Minimum of 10 years of a combination of RPG-ILE, RPG Free Form, CL, CLLE or Embedded SQL experience
  • Available to provide assistance during and after-hours to support business and operations. Provides support to on-call programmers needing assistance.
  • High level troubleshooting abilities, coupled with analytical and debugging skills necessary to analyze issues related to RPGLE and CLLE, ability to modify programs, write fix programs to correct data, if necessary.
  • Experience with database performance tuning, database security, and database management.
  • Able to write software code; excellent knowledge of appropriate programming language(s)
  • Proficient with structured query language (SQL) through query writing and/or ad hoc reporting
  • Able to meet aggressive deadlines.
  • Strong knowledge of manufacturing and distributions systems.
  • Strong knowledge of applicable Change Management System.
  • Excellent communication and interaction skills.
  • Ability to use Office products (Excel, Word, Power Point, Access, Project, Visio)
  • Some travel required


  • EDUCATION REQUIREMENTS

  • Bachelor's degree required



  • Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.