Description

You will modernize legacy systems by migrating databases and supporting large MS Access application suites. You will translate complex legacy logic into scalable SQL Server solutions.

Responsibilities

• Migrate and optimize databases, focusing on schema, tables, views, and stored procedures.
• Build and maintain ETL pipelines using Alteryx, Azure Data Factory, and SQL.
• Reverse engineer legacy codebases (~100k lines) and modernize system architecture.
• Perform performance tuning, indexing, and database optimization.
• Collaborate with business teams to translate legacy business rules into technical requirements.

Required Skills

• 5+ years of experience as a SQL Developer or similar role.
• Strong proficiency in MS Access and VBA for legacy system support.
• Expertise in SQL Server, including schema design, stored procedures, and business rule implementation.
• Hands-on experience building ETL pipelines.
• Experience with Alteryx and Azure Data Factory.
• Proven ability to reverse engineer and refactor large legacy codebases.
• Strong skills in performance tuning, indexing, and database optimization.

Preferred Skills

• Exposure to ERP integration, specifically Infor.
• Knowledge of data security best practices.

Key Skills

Education

Any Gradute