Database Engineer- Manufacturing

Company: Agri-Mark/Cabot Creamery
Location: Waitsfield
Posted on: May 4, 2024

Job Description:

DescriptionHow would we describe a career with Agri-Mark/McCadam/Cabot Creamery? More than 100 years of: Farmers, Family, Mission, Purpose, Sustainability, Respect, Integrity, Work Ethic, Teamwork, Pride in Award Winning Products, and Agriculture.Cabot Creamery achieved B Corp certification in 2012 and became the world's first dairy co-op to do so. This certification demonstrates our commitment to transforming the global economy to benefit all people, communities, and the planet.As a Database Engineer at Agri-Mark, you will be responsible for the performance, integrity, and security of SQL Servers and their databases. This position plays a role in the design, implementation and support of the organization's enterprise class, mission-critical systems on an evolving hybrid-cloud network, including on-prem and cloud-based infrastructure. The role will provide technical assistance to IS team members and third parties with a high degree of professionalism, working independently and in concert with Infrastructure Engineers, Business Analysts, and Developers to complete assigned tasks on time and within budget.A Database Engineer at Agri-Mark should be able to function effectively within the following core competencies while helping to support productive relationships with consultants, vendors, and other partners. They will work independently and in teams, seeking understanding from associated subject matter experts (SMEs) where necessary.This hybrid role can be based out of MA or VT.What you'll be doing:--Working collaboratively with business owners and other parties to set standards of requested implementation projects, including logs, clustering, mirroring, and capacity planningInstall and configure, and/or migrate to new SQL serversAssisting with performance issues from applications to determine how configuration changes, index/query modifications, and additional hardware can improve performanceConfigure SQL server monitoring to alert the appropriate partiesDeploy database scripts provided by third-party vendorsEnsure all SQL servers are backed up to ensure Agri-Mark's Recovery Point Objectives (RPO)Verify all SQL backups are tested regularly to meet Agri-Mark's Recovery Time Objectives (RTO)Troubleshoot database outages as the occurUsing third-party tools to diagnose performance and reliability issuesDeploy and support physical and virtual database infrastructure required to maintain the organization's mission-critical systems and line-of-business applications using a hybrid of Microsoft Azure-based and VMware-based on-premises virtual environmentsProvide direct technical support and guidance to key decision-makers in the fulfillment of well-informed planning, capacity, budgetary and capital decisions by the IS departmentBuild and maintain strong partner relationships with all 3rd parties. Work seamlessly with vendors, consultants, and subject matter experts (SMEs)Work with security team to design and integrate best-practice security solutionsAssume a supporting role in the design and implementation of robust business continuity and disaster recovery (DR) plans, including storage and data-flow designMonitor day to day network performance; diagnose network problems and resolve issues, often under time constraintsPromote, create, and maintain comprehensive documentation as it relates to database configuration, topology, process, standards and change managementRemain current on emerging technologies via industry conferences, professional groups, trade publications, training, independent research, and other avenuesPromote and maintain a positive attitude, a strong work ethic and a commitment to the success of all projects and teams within the IS departmentPerform other tasks and special assignments as requested by the Infrastructure Manager or Director of ISThis role requires:----Experience in a manufacturing environmentAbility to conduct troubleshooting and research into production products as requiredCan effectively utilize various hardware & network diagnostic toolsExperience in the support of software solutions, systemsStrong written and verbal communication skillsStrong interpersonal skillsKeen attention to detailBeing a good team player and ability to work with various departments throughout the companyBachelor's degree in a technical field or relevant combination of education, training, and experience. Some formal training desirable, especially on Microsoft technologiesProfessional certification(s) are desirable (e. Microsoft Azure certification, ICCT)Minimum 4-6 years of progressive responsibility for deploying and supporting state of the art database environments at a technical levelExperience deploying enterprise class on both physical and virtual server workloads running Windows and VMware ESXi operating systemsExperience deploying and configuring Microsoft Azure-based VMs and storage resources using Azure Management Portal.Demonstrated experience designing and implementing high performance, scalable solutions to fulfill business continuity and disaster recovery (DR) requirements of the organizationWorking knowledge of Windows server operating systems and best practices, including Microsoft Active Directory, NTFS security and group policy.Experience deploying and leveraging enterprise Network Management Systems, scripting/automation tools, and other utilities to maximize effectivenessExperience tuning T-SQL queries to improve performancePowerShell experience to build new and maintain existing database administration toolsCapable of independently prioritizing tasks from help desk ticketing system and other sourcesSitting for extended periods of timeTravel to support various plants, warehouses, offices, and distribution centerDexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and to handle other computer components--Off-hours work may be necessary.

Keywords: Agri-Mark/Cabot Creamery, New England , Database Engineer- Manufacturing, Engineering , Waitsfield, Northeast