Database Administrator

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!

Job Summary:

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 FileMaker)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 FileMaker platform

 You will:

• Creates, modifies, and maintains databases and database-related applications utilizing RPO’s primary manufacturing software solutions to include, but not limited to, FileMaker 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 PowerBI 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

You have:

• 3 years’ experience with Epicor ERP.
• 3 years’ experience with industry standard programming concepts such as, C# and SQL.
• Strong SQL database knowledge required
• Experience with VBA is a plus but not required.
• Expert-level Microsoft Excel skills preferred
• FileMaker Pro knowledge and experience required. 
• On-call support as required to be limited to systems under the Database Administrator’s purview
• 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. 

 You Are:

• 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 and organizational skills;
• A Team Player: Reliable, collaborative, flexible with a positive ‘get things done’ attitude;
• A U.S. Person: Compliant with ITAR, EAR and other laws and regulations as defined:   “U.S. citizens, lawful permanent residents ("Green Card" holders), persons granted refugee status or asylum status in the United States, or temporary residents granted amnesty.”

You Will Enjoy:

• Growth: The opportunity to learn and advance your career;
• Wealth: Competitive compensation package linked to your experience and performance, a 401(k) with company match;
• Wellness: Health, dental, vision & life insurance;
• Balance: 11 paid holidays, generous paid vacation and sick -time;
• Culture: an energetic, caring, fun, value-driven team.

Work Requirements & Physical Demands:

• While performing the duties of this job, the employee is regularly required to stand: use hands to fingers, handle or feel: and reach with hands and arms. The employee frequently is required to stand, walk, stoop, kneel, crouch: and talk and hear.
• The job may involve prolong periods of sitting/standing.
• Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus. May involve prolonged periods of magnified inspection (eye strain)
• Requires good hand-eye coordination, arm, hand and finger dexterity, including ability to grasp.
• The employee is frequently required to use the computer.
• May involve the use of oils and solvents.
• Subject to some soilage and irritation from cleaning solutions. (Lab Coats provided)
• Generally works in a clean environment and works to maintain the environment as such.
• Safety Glasses are required
• May require area specific safety training
• This position works in a manufacturing environment. The noise level in the work environment is usually loud. 
• The employee is regularly exposed to moving mechanical parts and fumes or airborne paper particles.
• May work at different workstations as production needs require, or shifts from one station to another, during the production process.

Disclaimer: 

This job description reflects management’s assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned. The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed. 

Rochester Precision Optics is committed to leveraging the talent of a diverse workforce to create great opportunities for our business and our people.

EOE/AA/Minority/Female/Disability/Veteran

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States, and to complete the required employment eligibility verification form upon hire.