Database Platform Engineer

Job Description:

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.

• 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. Implement or improve 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.
• 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, 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.
• 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.

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.

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