Database Administrator at Rochester Precision Optics LLC

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!

Job Summary:

The Database Administrator will be responsible for maintaining, upgrading, and improving several key database-driven applications, including, but not limited to, the Epicor Kinetic ERP system and FileMaker Databases, by performing upgrades, data migrations, and the creation of informational and Visual Factory dashboards. The ideal candidate should have a proven track record of working well with others and be familiar with various tools for data manipulation, to include (but not limited to) PowerShell, Microsoft Excel, Power BI, as well as familiarity with C# and SQL coding at least a basic knowledge level.

Summary of Essential Job Duties:

• Creates, modifies, and maintains databases and database-related applications utilizing the companys primary manufacturing software solutions including, but not limited to, FileMaker and Epicor Kinetic
• Build, deploy, and troubleshoot informational dashboards and reports in the ERP system
• Establish and continue the development of in-house information systems to manage the daily flow of manufacturing data
• Work closely with peers on implementation, testing, and configuring of new databases and front-end software in the companys 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 the company's existing Visual Factory displays and Power BI dashboards to meet current production demands, support the development and implementation of new solutions
• Ensure that visual factory displays are showing concise, accurate, updated and relevant data to meet the production needs of their respective areas
• Work with peers and other relevant stakeholders and consultants on the new implementation of and migration to the Epicor Kinetic ERP system, and future such implementations and migrations.
• Collaborate with key stakeholders and consultants to develop effective ERP system processes, dashboards and reports
• Submit and work support cases with outside support services as required
• Manage effective security access groups & user management within such systems as FileMaker and Epicor
• Maintain professional and technical knowledge by attending webinars, workshops, conferences and other training relevant to database systems, Visual Factory and other production needs
• Work within the confines of NIST 800-171, CMMC 2.0 Level 3, DFARS contractual requirements, and related security obligations and policies when implementing business processes, solutions, and software

Additional Qualifications:

• 1+ years experience with industry-standard programming concepts, including a basic familiarity with C#
• 1+ years experience managing SQL databases
• Knowledge of ERP systems preferred
• Experience with Microsoft Power BI preferred
• Advanced Microsoft Excel skills preferred
• Experience with Manufacturing and lean manufacturing methods preferred
• FileMaker Pro knowledge preferred but not required
• On-call support as required, to be limited to systems under the Database Administrators purview, every other week rotation
• Self-motivated, positive attitude, high energy, hands-on individual who can multi-task effectively

Requirements and Competencies:

Language Skills:

Ability to read, analyze and interpret SQL, C#, 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 and consultants on analyzing business needs to formulate solutions.

Mathematical Skills:

• Ability to apply advanced mathematical concepts.

Educational Requirements:

• BA/BS Degree in related field or equivalent combination of experience and education.

Additional Requirements:

• Pursuant to ITAR, EAR, and other export compliance laws and regulations, applicants for this position must be U.S. Persons as defined by U.S. law, i.e., 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.

Work Requirements:

Environment & Physical Demands:

• Professional office environment with routine use of standard office equipment such as computers, phones, copiers, filing cabinets and related equipment; noise level typical of a standard office environment
• Prolonged sitting, computer use, as well as standing, filing, bending, reaching and lifting and carrying up to 15 pounds
• Occasional exposure to manufacturing plant floor requiring the use of personal protective equipment (ear plugs, safety glasses, etc.)
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Compensation & Benefits:

RPO offers highly competitive, total compensation packages linked directly to employees professional experience. RPOs benefits include: Tuition Reimbursement Program, Health Insurance, Dental Insurance, Disability Insurance, Life Insurance, 9 paid holidays, generous paid vacation and sick time and a 401(k) plan after a 60-day waiting period. Additionally, we work a 4/10 work week that provides for every Friday as a non-work day.

Disclaimer:

This job description reflects managements 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.

Compensation details: 60000-85000 Yearly Salary

PI362d139e2dbe-26289-35993374