Database Platform Engineer

## Database Platform Engineer Apply locations:
Winamac, IN:
Carmel, INtime type:
Full time posted on:
Posted 5 Days Agojob requisition :
R-102773
*
* 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.
** 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, 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.
** 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, Mule Soft)
* 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…