Your Technology Partner for Measurable Business Impact → Beyond solutions • Above expectations
Data Migration Engineer, SQL Server, TSQL
Location
Latin America
Posted
11 days ago
Salary
0
Seniority
Senior
Job Description
Data Migration Engineer, SQL Server, TSQL
Cresteo
• 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.
Job 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
Related Guides
Related Job Pages
More Backend Engineer Jobs
Senior .NET Developer
TransUnionTransUnion is a global information and insights company that makes trust possible by ensuring that each consumer is reliably and safely represented in the marketplace. We do this by having an accurate and comprehensive picture of each person. This picture is grounded in our legacy as a credit reporting agency which enables us to tap into both credit and public record data; our data fusion methodology that helps us link, match and tap into the awesome combined power of that data; and our knowledgeable and passionate team, who stewards the information with expertise, and in accordance with local legislation around the world. Because of our work, organizations can better understand consumers in order to make more informed decisions, and earn their trust through great, personalized experiences, and the proactive extension of the right opportunities, tools and offers. In turn, consumers can be confident that their data identities will result in the opportunities they deserve. We make trust possible, so businesses and consumers can transact with confidence and achieve great things. We call this Information for Good®—it’s our purpose, and what drives us every day.
• Lead development efforts for key DHI Information Technology software applications and frameworks • Serve as a technical leader for the DHI Information Technology Online Scrum Team • Design, develop, test, troubleshoot, maintain, and support secure enterprise applications • Partner with stakeholders and senior leaders to define technical direction • Maintain and enhance end-to-end continuous integration and continuous delivery (CI/CD) pipelines • Research, evaluate, and recommend technologies
• Liderar a implementação de funcionalidades críticas em sistemas backend utilizando Java e Kotlin, propondo soluções técnicas inovadoras e alinhadas ao negócio. • Analisar e decidir sobre algoritmos e estruturas de dados, avaliando trade-offs de desempenho, memória e escalabilidade. • Conduzir revisões de código, refatoração de issues e processos avançados de versionamento (ex: rebase interativo e cherry-pick). Projetar e implementar pipelines CI/CD robustos, integrando múltiplos serviços e garantindo deploys seguros. • Participar ativamente do design de APIs críticas, definindo padrões de autenticação, versionamento e tratamento de erros. • Colaborar na definição de práticas de segurança em aplicações e APIs do backend, disseminando guidelines para a equipe. • Identificar e resolver gargalos arquiteturais críticos, promovendo manutenibilidade e resiliência em sistemas distribuídos.
Senior Backend Software Engineer
GrailedGrailed is one of the largest online marketplaces to buy & sell authentic luxury, streetwear, vintage, sneakers & more.
• Work closely with product managers, designers, and other engineers to build features and improvements • Extend our API and back-end systems • Interface directly with our PostgreSQL cluster • Add to and improve our testing environment • Solve challenges in architecture, security, anti-fraud, performance, scalability, personalization, optimization, payments and more • Be a helpful and supportive presence on the team, contributing to code reviews and other team processes • Keep up with the latest development trends in server-side technologies • Mentor and sponsor other engineers in your areas of expertise • Coordinate and communicate seamlessly across other technical and product teams • Be part of an on-call rotation • Use LLMs, when appropriate, to improve the product and development workflows
• Build integrations with healthcare and financial systems • Automate end-to-end data ingestion and delivery pipelines, with a strong focus on observability and data quality • Build GenAI features and chat to solve real problems and build user confidence, backed by rigorous evaluation loops and guardrails • Design high-throughput, low-latency systems where performance is a mission-critical requirement • Be the glue between our PhD-level Data Scientists and Front-end Engineers, taking raw outputs and building the APIs that drive a full, impactful product



