Database Administrator

Title: Database Administrator

Department: Contracts & Legal Affairs

Reports to: IT Manager

SEE YOUR CAREER THROUGH A NEW LENS WITH RPO! RPO is a global leader in precision optics, optical components, and optical assemblies. We specialize in a full spectrum of products & services including — Design and Engineering, Systems Integration, Lens Assembly, Visible and Infrared Components, Glass and Plastic Molded Aspheres, and Thin Film Coating. As one of the fastest growing companies in Rochester, RPO offers exciting career paths and work on market-leading programs.

See below one of many career opportunities to join to RPO team!

The Database Administrator as a member of the Information Technology Team, will be responsible for the creation and maintenance of information systems and processes used for collecting and presenting manufacturing data to include the ERP and Visual Factory solutions that RPO utilizes (Epicor and File Maker). The ideal candidate should have a proven track record of working well with others and the use of the VBA and SQL programming language and knowledge or experience in the concept of a “Visual Factory”, as well as maintain and develop applications within the File Maker platform.

• Creates, modifies, and maintains databases and database-related applications utilizing RPO’s primary manufacturing software solutions to include, but not limited to, File Maker and the ERP System (Epicor)
• Establish and continue the development of in-house information systems to manage the daily flow of manufacturing data
• Work with other IT team members on implementation, testing, and configuring of new databases and front-end software in RPO’s established information systems
• Maintain existing SQL server databases and execute queries, updates, backups/restores as needed or required utilizing SQL Management Studio and other tools
• Maintain and periodically refresh test and pilot databases in the ERP System
• Work with RPO’s existing Visual Factory displays and Power
  
  BI dashboards to meet current production demands while new solutions are developed
• Ensure that visual factory displays are showing concise, accurate and relevant data to meet the production needs of their respective areas
• Work with IT and other relevant stakeholders on the new implementation of and migration to the Epicor Kinetic ERP system
• Collaborate with key stakeholders to develop effective ERP system processes, dashboards and reports within the Epicor system
• Maintain professional and technical knowledge by attending webinars, workshops and conferences and other training relevant to database systems, Visual Factory and other production needs
• Work under the confines of NIST 800-171, CMMC 2.0 Level 3 and DFARS contractual requirements when implementing business processes, solutions, and software

• 3 years’ experience with Visual Basic (VBA) and industry-standard programming concepts
• Strong SQL database knowledge required
• Expert-level Microsoft Excel skills preferred
• File Maker Pro knowledge and experience required.
• On-call support as required to be limited to systems under the Database Administrator’s purview
• Experience with Epicor administration required.
• Self-motivated, positive attitude, high energy, hands-on individual who can multi-task well
• Basic manufacturing knowledge required. Experience with Lean Manufacturing desired
• Ability to read, analyze and interpret VBA and other computer code. Ability to communicate effectively with various levels of the business through both verbal and written communication and work with key stakeholders on analyzing business needs to formulate solutions.
• Ability to apply advanced mathematical concepts.
• BA/BS Degree in related field or equivalent experience and H.S diploma.

• Results-Oriented:
  Motivated, hard-working and ready to level-up;
• Curious:
  You never stop learning and have an insatiable desire to gain new skills and knowledge;
• Process Oriented:
  Well organized, demonstrating attention to detail;
• Analytical:
  Possess a “If there’s a problem, I’ll find a solution” attitude;
• Accountable:
  Demanding the highest quality from yourself and team members;
• Detail-Oriented:
  Have excellent time management…