Data Migration Engineer (SQL Server / TSQL)

45 minutes ago
Full-time
Senior
Software Development
Cresteo

Cresteo

Cresteo is a technology partner based in Chicago, founded in 2021. The company specializes in AI-driven solutions and digital transformation services tailored for enterprises and scale-ups. Cresteo focuses on delivering measurable business outcomes through technical expertise and collaborative efforts. The company offers a wide range of services, including AI strategy consulting, custom AI development, computer vision, natural language processing, process automation, software engineering, data science, experience design, cloud engineering, quality assurance, mobile services, and application management. Cresteo employs a full-cycle delivery model that supports clients from ideation to execution, ensuring ongoing performance monitoring and iterative improvement. Cresteo's operational approach is centered on agility, precision, and partnership-driven collaboration. This structure allows for rapid response and effective communication, ultimately leading to impactful results for clients. The company aims to accelerate time-to-market, reduce operational overhead, and generate significant new revenue for its clients.

information technology & services
51-200
Founded 2022

Description

  • Own data migrations end to end, from legacy source schemas to production-ready target data.
  • Develop and maintain SQL Server migration and ETL processes.
  • Reverse-engineer and document undocumented legacy databases.
  • Design incremental, idempotent, re-runnable migration pipelines.
  • Tune query performance using execution plans and indexing strategies.
  • Handle transactions and concurrency to support safe data movement.
  • Build reconciliation and validation scripts to compare source and target data.
  • Test migration performance under production-scale volume.
  • Automate migrations using SQL Server Agent or other orchestrators.
  • Collaborate with cross-functional teams and document issues clearly.

Requirements

  • Deep hands-on T-SQL experience, including complex queries, stored procedures, and functions.
  • Proven data migration or ETL experience, especially with legacy or poorly documented schemas.
  • Ability to reverse-engineer and document undocumented legacy databases.
  • Experience with query performance tuning, execution plans, and indexing strategy.
  • Experience designing incremental, idempotent, re-runnable migration processes.
  • Knowledge of transaction handling and concurrency control, including locking and isolation levels.
  • Experience with data validation and reconciliation scripts, including counts and checksums.
  • Experience with performance testing under real production volume.
  • Familiarity with SQL Server special data types such as temporal tables and JSON.
  • Familiarity with SQL Server Agent or other job schedulers/orchestrators.
  • Clear written and verbal communication skills.
  • Advanced English level.

Benefits

  • 100% remote work.
  • USD salaries above market average.
  • Profit sharing policy.
  • Unlimited PTO after the first year (20 PTOs in the first year).
  • Equipment provided for your setup.
  • Great work/life balance.
  • Honest, simple, and transparent culture.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Engineer IV (6249)

Dan.com - a GoDaddy brand Internet Software & Services

itD is hiring a Data Engineer IV to build and optimize AWS-based data infrastructure and pipelines that support AI infrastructure and inference initiatives in a remote role.

AWS
30 minutes ago

Senior Data Engineer (GCP)

Xebia 1K-5K Internet Software & Services

Xebia is hiring a data engineer to support a BigQuery migration by building and maintaining scalable data pipelines for production reporting, analytics, and business intelligence solutions.

Apache Airflow CI/CD Databricks dbt Git Python Snowflake SQL
30 minutes ago

Staff Data Engineer (Coupang Pay)

Coupang 1K-5K Internet Software & Services

쿠팡페이 핀테크 데이터 플랫폼 팀의 Staff Data Engineer로서 실시간 결제·주문 데이터를 기반으로 데이터 파이프라인과 분석 인프라를 구축·고도화하는 역할입니다.

Apache Spark AWS ClickHouse Flink Hive Java Presto Python Scala SQL Tableau
45 minutes ago

Data Engineer (Azure & Snowflake) - Remote

Mindex 251-1K Internet Software & Services

Mindex is seeking a Data Engineer to build and maintain cloud-based data solutions that support analytics, reporting, automation, and internal AI initiatives.

Azure dbt JSON Machine Learning Python Salesforce Snowflake SQL XML
1 hour, 15 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers