Database Platform Engineer

• 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

Do you have experience in Technical troubleshooting support?, * 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