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.

• 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 estate (e.g., legacy databases like DB1), including cleanup of unused objects, obsolete data, and inconsistent configurations.

• 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).

• 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, Mule Soft).
• 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.

• 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.

• Own database performance, health, and data reliability across key enterprise systems.
• Bridge ERP systems, on‑prem databases, Azure data services, and integration layers.
• Support the transition from a database‑centric model to a cloud/data‑platform architecture in alignment with enterprise IT strategy.

• 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, Mule Soft)
• Multi‑site manufacturing systems and related data flows

• Support systems critical to manufacturing operations
• Understand impact of data issues on production and planning
• Ensure reliability of shared systems and reporting pipelines

• 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…