Database Platform Engineer

Position Purpose and Operational Expectations 

• Own database performance, health, and reliability in the current ERP environment. 

• Remediate and right‑size existing SQL Server instances, including log file configuration, maintenance plans, and tech‑debt databases (e.g., legacy DBs such as “DB1”). 

• Design and support the transition of on‑prem databases to Azure (e.g., Azure SQL / Managed Instance) as an interim step toward full SaaS adoption. 

• Support the broader transition from on‑prem Epicor to Epicor Kinetic SaaS, including data access, integrations, and reporting impacts. 

• Evolve into ownership of enterprise data platforms and integrations (Azure, Snowflake, analytics, and data flows between systems). 

• Ensure data accuracy, availability, and consistency across operational and analytical systems. 

• Partner with IT and business teams to improve data flows, reduce risk, and retire legacy technical debt over time. 

Core Responsibilities 

On‑Prem Database Health & Optimization 

• Optimize SQL Server performance including query tuning, indexing, execution plans, and deadlock resolution. 

• Stabilize large databases (e.g., multi‑terabyte), including:  

• Correct log file configuration and growth. 

• Appropriate recovery models, backup/restore strategies, and space management. 

• Implementation or improvement of index and statistics maintenance and DBCC checks. 

• Identify and remediate technical debt in the database of estate (e.g., legacy databases like DB1), including cleanup of unused objects, obsolete data, and inconsistent configurations. 

Cloud / Azure & Migration 

• Assist in designing migration paths from on‑prem SQL Server to Azure (Azure SQL Database, Azure SQL Managed Instance, or other appropriate services). 

• Support planning and execution of database migrations, including sizing, performance planning, and cutover strategies in coordination with Infrastructure and Application teams. 

• Contribute to standards and best practices for SQL workloads in Azure (configuration of baselines, monitoring, security, and cost optimization). 

Data Platform & Integrations 

• Support and troubleshoot data pipelines into Snowflake and Power BI, recognizing Snowflake as the replicated analytics layer rather than the initial system of record. 

• Investigate and resolve integration data issues across APIs and middleware platforms (e.g., Boomi, MuleSoft). 

• Assist in designing scalable and resilient data flows across ERP, CRM, CPQ, manufacturing, and other business systems. 

• Ensure data accuracy, reliability, and consistency across transactional and analytical platforms. 

Operations, Troubleshooting & Documentation 

• Perform root cause analysis for data and performance issues, implementing durable fixes rather than workarounds. 

• Maintain system and data documentation, including database configurations, maintenance plans, integrations, and dependencies. 

• Collaborate with ERP, development, infrastructure, and business teams to support system performance, data access, and reporting needs. 

Scope of Responsibility 

• Owns database performance, health, and data reliability across key enterprise systems. 

• Bridges ERP systems, on‑prem databases, Azure data services, and integration layers. 

• Supports the transition from a database‑centric model to a cloud/data‑platform architecture in alignment with enterprise IT strategy. 

Technology Environment 

• Microsoft SQL Server (on‑prem, large databases) 

• Epicor ERP (on‑prem and SaaS / Kinetic) 

• Microsoft Azure (e.g., Azure SQL, Azure SQL Managed Instance, related services) 

• Snowflake (analytics / replicated data layer) 

• Power BI and analytics tools 

• Integration platforms (Boomi, MuleSoft) 

• Multi‑site manufacturing systems and related data flows 

Plant / Site Expectations 

• Support systems critical to manufacturing operations 

• Understand impact of data issues on production and planning 

• Ensure reliability of shared systems and reporting pipelines 

Required Skills and Qualifications 

• 5+ years experience in database engineering, DBA roles, or closely related positions. 

• Strong SQL skills including performance tuning, query optimization, indexing, and troubleshooting. 

• Experience with SQL Server in enterprise environments, including large or complex databases. 

• Demonstrated experience diagnosing and fixing database health issues (log growth, backups, maintenance, space, etc.). 

• Strong troubleshooting and analytical skills with focus on root cause and prevention. 

• Ability to communicate clearly with both technical and business stakeholders. 

Preferred Qualifications 

• Epicor ERP experience (on‑prem and/or Kinetic). 

• Experience with ETL/ELT and data pipelines feeding analytics platforms. 

• Experience with Azure data platforms (e.g., Azure SQL Database, Azure SQL Managed Instance) and/or Snowflake. 

• Experience in a manufacturing data environment (ERP, MRP, shop‑floor/OT integrations). 

• Relevant certifications (e.g., Microsoft, Azure, SQL Server, Epicor, or data platform certifications). 

Key Performance Indicators 

• Database performance and response time 

• Reduction in production data issues 

• Data pipeline reliability 

• Data accuracy across systems 

• Support of ERP transformation initiatives 

Physical Requirements 

• Office or hybrid work environment 

• Extended computer use 

• Occasional after-hours support