Lead Database Administrator

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 ... (truncated, view full listing at source)