It system administrator jobs in Rochester, New YorkCreate job alerts

Job Description Title Database Administrator Department Contracts & Legal Affairs/IT 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 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.

Position: IT Manager Location: Rochester NY, 14623 Employment Type: Full time Compensation: $106,000 – $136,500 Travel: Occasional travel between Rochester and Painted Post facilities is required Manages Others: Yes, two direct reports: Data Analyst, Salesforce System Administrator Education: 4-year degree in IT or related field is preferred; will consider candidates without a 4 year degree with at least 9 years of experience in a similar role. Experience: 5+ years of experience in IT service management or support, with a track record of dependable execution. 3+ years working with IT security tools or responding to security needs. About This Opportunity: Adaptec is looking for an IT Manager who loves rolling up their sleeves, creating structure where it’s needed, and improving processes that make life easier for a 200-person workforce. If you’re the type who gets satisfaction from tightening up systems, and delivering consistent, reliable support, this is absolutely your lane. This role is perfect for someone who thrives in a smaller company, values the ability to make an impact and follow-through, and wants the chance to grow into a future Director-level role. What You’ll Do: IT Operations & Daily Support • Manage incident and service requests with timely, predictable resolution., • Troubleshoot PCs, laptops, mobile devices, and printers with a customer-first mindset., • Support local users at both Rochester and Painted Post locations., • Coordinate onsite vendor support and ensure onsite expectations are consistent week-to-week., • Administer Microsoft 365, Entra ID, Exchange Online, and Teams., • Maintain user accounts, permissions, access controls, and updates., • Monitor and respond to cyber incidents in partnership with our external security team., • Improve cyber hygiene through training, reminders, and consistent follow-through., • Oversee the lifecycle of hardware, software, licensing, and subscriptions., • Maintain accurate, reliable inventory and device tracking, including wipe readiness for lost devices., • Deliver a clean, consistent setup experience for new employees., • Standardized device builds, access templates, and process checklists., • Streamline onboarding/offboarding workflows until they feel crisp, repeatable, and drama-free., • Bring order, clarity, and structure to the IT environment so employees feel supported and equipped., • Improve mobile device tracking, access consistency, and process documentation., • Build predictable onsite support expectations across both locations. What You Bring: Required • 5+ years of experience in IT service management or support, with a track record of dependable execution., • 3+ years working with IT security tools or responding to security needs., • Strong troubleshooting skills and steady, customer-focused communication., • Solid hands-on experience administering Microsoft 365, Entra ID, Exchange Online, and Teams., • Experience managing hardware, software, and subscription budgets., • Experience maintaining asset inventories and device lifecycles., • Ability to create structure, build simple processes, and improve consistency across the IT environment., • Bachelor’s degree in IT, Computer Science, or related field., • CompTIA or Microsoft certifications., • Experience with Intune or MDM tools., • Someone who values reliability, organization, follow-through, and helping people feel supported through stable systems. In compliance with pay transparency requirements, the wage range for this role is $106,000 – $136,500/yr. The rate range provided is a general guideline. When extending an offer, Adaptec Solutions considers factors including, but not limited to experience and geographic location. Adaptec Solutions also offers a variety of benefits including generous paid time off (PTO), 11 paid company holidays including your birthday, generous health plans, dental and vision insurance, HSA/FSA accounts, generous 401(k) match and immediate vesting, short-term/long term disability coverage and basic life/AD&D insurance and education assistance. Adaptec Solutions, LLC is an equal opportunity organization. We recruit, employ, train, compensate, and promote without regard to race, religion, color, national origin, age, gender, sexual orientation, gender identity, marital status, disability, protected veteran status, or any other basis protected by applicable federal, state or local law.