Database Platform Engineer

BraunAbility•Carmel, IN

5d•Hybrid

About The Position

This role is responsible for owning database performance, health, and reliability within the current ERP environment. The engineer will remediate and right-size existing SQL Server instances, including log file configuration, maintenance plans, and tech-debt databases. A key aspect of the role involves designing and supporting the transition of on-prem databases to Azure (e.g., Azure SQL / Managed Instance) as an interim step toward full SaaS adoption, and supporting the broader transition from on-prem Epicor to Epicor Kinetic SaaS, including data access, integrations, and reporting impacts. The role will evolve to encompass ownership of enterprise data platforms and integrations (Azure, Snowflake, analytics, and data flows between systems), ensuring data accuracy, availability, and consistency across operational and analytical systems. The engineer will partner with IT and business teams to improve data flows, reduce risk, and retire legacy technical debt over time.

Requirements

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.

Nice To Haves

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

Responsibilities

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 of 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, 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.
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.