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 company's 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 company'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 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 Administrator's 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 employee's professional experience. RPO's 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 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.