Lead Database Administrator at Datacor

About Us: Datacor is the leading provider of software solutions, including ERP, CRM, Asset Tracking, Simulation and Formulation, to the process manufacturing space. We are on a mission to better equip the industry with software solutions and move it forward by building thoughtful, intuitive products that solve our customers’ most difficult problems. We are passionate about serving our customers and helping them use data as a competitive advantage. Our customers make products that extend and sustain lives by sanitizing, fertilizing, beautifying, cleaning, and recycling the world we live in. We at Datacor help our customers make those products you use every day more safely, cost effectively and more efficiently through our technology platforms and applications. About the Role The Database Administrator partners with product teams, developers, and the Principal Architect to manage, maintain, and optimize the organization's database environments. This role is responsible for ensuring the reliability, performance, and security of all databases while driving modernization efforts including migration from legacy platforms such as Microsoft Access to modern database solutions. Key Responsibilities Database Management & Maintenance • Responsible for designing, building, and maintaining scalable data lake architectures to support analytics, reporting, and data-driven decision-making across the organization. This includes managing data ingestion pipelines, enforcing data quality and governance standards. • Manage, monitor, and maintain all databases across the organization including Microsoft Access, SQL Server, MySQL, PostgreSQL, and other platforms • Maintain a comprehensive inventory of all databases, including ownership, usage, and technology stack • Perform routine database administration tasks including backups, restores, copying, archiving, and schema updates • Ensure database availability, integrity, and reliability across all environments Performance Optimization • Monitor and tune database performance to ensure optimal response times and resource utilization • Analyze and optimize queries, with a focus on improving performance in VB-based applications • Proactively identify and resolve database bottlenecks and performance issues • Implement indexing strategies, query optimization, and execution plan analysis Modernization & Migration • Lead and support the migration of Microsoft Access databases to SQL Server, MySQL, PostgreSQL, and other modern platforms • Collaborate with the Principal Architect and product teams to define migration strategies and timelines • Document legacy database structures and developing migration plans that minimize disruption to operations • Evaluate and recommend modern database technologies and architectures as appropriate Developer Collaboration & Best Practices • Partner with development teams to establish and enforce database query best practices • Provide hands-on guidance and code review for database interactions within applications • Create and maintain documentation, standards, and reference guides for database development • Serve as a technical resource for developers on schema design, stored procedures, and data modeling Monitoring & Alerting • Implement and manage database monitoring and alerting solutions to proactively detect and respond to issues • Define and track key database health metrics including performance, storage, and availability • Respond to and resolve database incidents, performing root cause analysis and implementing preventive measures • Maintain audit logs and ensure compliance with data governance and security policies Security & Compliance • Manage database access controls, user permissions, and role-based security • Ensure sensitive data is protected in accordance with organizational and regulatory requirements • Perform regular security assessments and vulnerability reviews of database environments • Responsible for designing, building, and maintaining scalable data lake architectures to support analytics, reporting, and data-driven decision-making across the organization. This includes managing data ingestion pipelines, enforcing data quality and governance standards. Required Qualifications • 3+ years of experience in database administration or a related role • Strong proficiency in Microsoft SQL Server and Microsoft Access • Experience with database migration projects, particularly Access to SQL Server • Proficiency in T-SQL, query optimization, and execution plan analysis • Experience with .Net application database interactions • Familiarity with database monitoring and alerting tools • Knowledge of backup, recovery, and archiving strategies • Strong understanding of database security, access control, and compliance practices • Excellent communication and collaboration skills with both technical and non-technical stakeholders Please submit your resume in English. EOE Statement: Datacor is an Equal Opportunity Employer and does not discriminate on the basis or race, color, religion, sex, national origin, age, disability, veteran status, or any other protected characteristic. Use of AI During Interviews: At Datacor, we value thoughtful problem-solving and authentic perspectives. To ensure a fair and consistent evaluation process, we ask that candidates do not use generative AI tools or outside assistance during live interviews unless explicitly stated otherwise. We're interested in hearing your experience, your approach, and how you think through challenges.