Data Migration Engineer, SQL Server, TSQL

Job not on LinkedIn

🔥 3 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Cresteo

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2022

🤖 Artificial Intelligence

💼 Consulting

🏢 Enterprise

Artificial Intelligence • Consulting • Enterprise

Cresteo is a strategic technology partner that designs, builds, and operates enterprise AI solutions. They offer an AI Agentic Studio and the Cresteo Forge framework to integrate GenAI, agentic systems, LLMOps, computer vision, data & analytics, and cybersecurity into production on client infrastructure. Cresteo embeds with enterprise teams to deliver digital transformation, platform engineering, and measurable outcomes across industries such as fintech, legal, healthcare and e-learning, and emphasizes security (ISO/IEC 27001) and strong delivery metrics (reduced costs, faster time-to-market, high client retention).

📋 Description

• As a Data Migration Engineer at Cresteo, you'll be more than just a developer; you will be part of transforming the tech industry through our honest, transparent, and people-centric approach. • Your role will be diverse and dynamic. You'll be instrumental in developing and maintaining our software solutions, working with a varied technology stack, and ensuring that our products are functional, efficient, reliable, and scalable.

🎯 Requirements

• Deep, hands-on TSQL: complex queries, stored procedures, and functions (not ORM-generated SQL). • Proven data migration / ETL experience, especially against legacy or poorly documented source schemas. • Ability to reverse-engineer and document undocumented legacy databases. • Query performance tuning through execution plan analysis and indexing strategy. • Design of incremental, idempotent, re-runnable migration processes. • Transaction handling and concurrency control (locking, isolation levels). • Data validation and consistency: reconciliation scripts (source vs. target counts, checksums) and a sharp analyst eye for numbers that don't add up. • Performance testing under real production volume. • Special data types in SQL Server: temporal tables and JSON. • Familiarity with jobs/schedulers (SQL Server Agent) or other orchestrators to automate migrations. • Experience designing incremental pipelines at scale. • Clear and concise communication skills, both written and verbal, to support documentation, issue reporting, and cross-team collaboration. • Advanced English level

🏖️ Benefits

• 100% Remote • USD above-average salaries • Profit Sharing Policy • Unlimited PTOs after your first year (20 PTOs the first year) • Equipment for your setup • Great work/life balance • Honest, simple, and transparent culture • US-based clients and international teams