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.

Lead Database Administrator

TLDR

This job is no longer available