Senior T SQL Database Engineer

Improving South America; Colombia; Remote; COP 120,000,000 - 180,000,000; Full time

Benefits offered by this job

Contrato a largo plazo

100% Remoto

Vacaciones y PTOs

Bonos anuales

2 revisiones salariales al año

Clases de inglés

Equipamiento Apple

Plataforma de cursos en linea

Budget para compra de libros

Budget para compra de materiales de (1

Job summary

Improving South America busca un arquitecto de bases de datos Senior para reversar y documentar lógica de negocio en SQL Server, refactorizar código T-SQL y garantizar rendimiento a través de pruebas automatizadas.

Trabajarás estrechamente con ingenieros C#/.NET y DBAs para asegurar límites entre la aplicación y la base de datos, manteniendo la trazabilidad y la confiabilidad.

Se valora experiencia en Azure SQL y migración de sistemas legados; puesto 100% remoto desde Colombia.

Qualifications

• Advanced T-SQL: strong experience with stored procedures, UDFs, views, triggers, and SQL Server Agent jobs.
• Query optimization: execution-plan analysis, indexing, and tuning, with hands-on capability to address concurrency/locking/deadlock challenges.
• App-to-database troubleshooting: working familiarity with C#/.NET sufficient to troubleshoot how application behavior interacts with database logic.
• Experience: minimum 8 years relevant experience, matching a Senior/architect-level standard.

Responsibilities

• We reverse-engineer and document existing T-SQL stored procedures, functions, triggers, views, and SQL Server Agent jobs to capture undocumented business logic.
• We build automated and characterization tests around critical SQL Server-resident business logic to preserve required behavior during change.
• We safely refactor complex or fragile T-SQL while ensuring business behavior remains correct and unchanged from a functional perspective.
• We troubleshoot production issues involving SQL logic, data processing, performance, and concurrency.
• We analyze execution plans and use SQL Server diagnostics to resolve performance problems.
• We partner with C#/.NET engineers on app-to-database boundaries and collaborate with DBAs on the engineering/administration split.

Skills

Advanced T-SQL

Query optimization

App-to-database troubleshooting

8+ years experience

Collaboration & mindset

Tools

SQL Server

Azure SQL

C#/.NET

Job description

We are Improving, an IT services firm focused on AI, Data, and Applications. We modernize legacy systems, build cloud-native platforms, and deliver future-ready solutions through collaborative, long-term partnerships. In this role, we work within teams responsible for mission-critical, SQL Server-resident business logic. We reverse-engineer and document existing T-SQL artifacts, protect behavior through automated tests, refactor safely, and drive performance and reliability improvements. You will partner closely with C#/.NET engineers and our DBAs to ensure correct app-to-database boundaries and an engineering/administration split that scales.

Responsibilities

We reverse-engineer and document existing T-SQL stored procedures, functions, triggers, views, and SQL Server Agent jobs to capture undocumented business logic.

We build automated and characterization tests around critical SQL Server-resident business logic to preserve required behavior during change.

We safely refactor complex or fragile T-SQL while ensuring business behavior remains correct and unchanged from a functional perspective.

We troubleshoot production issues involving SQL logic, data processing, performance, and concurrency.

We analyze execution plans and use SQL Server diagnostics to resolve performance problems.

We partner with C#/.NET engineers on app-to-database boundaries and collaborate with DBAs on the engineering/administration split.

Requirements

Advanced T-SQL: strong experience with stored procedures, UDFs, views, triggers, and SQL Server Agent jobs.

Query optimization: execution-plan analysis, indexing, and tuning, with hands-on capability to address concurrency/locking/deadlock challenges.

App-to-database troubleshooting: working familiarity with C#/.NET sufficient to troubleshoot how application behavior interacts with database logic.

Experience: minimum 8 years relevant experience, matching a Senior/architect-level standard.

Collaboration & mindset: we value careful analysis, attention to detail, and a disciplined approach to change management. We work in partnership with engineers and DBAs- so we expect clear communication, ownership of outcomes, and the ability to translate complex database behavior into well-documented logic and reliable tests.

Nice To Have

Experience modernizing legacy SQL Server applications.

Background with high-volume transactional systems - financial, billing, payroll, or logistics.

Accounting or financial background.

Experience with Azure SQL / cloud-hosted SQL Server workloads.

Benefits

• Contrato a largo plazo.
• 100% Remoto.
• Vacaciones y PTOs
• Posibilidad de recibir 2 bonos al año.
• 2 revisiones salariales al año.
• Clases de inglés.
• Equipamiento Apple.
• Plataforma de cursos en linea
• Budget para compra de libros.
• Budget para compra de materiales de trabajo
• mucho mas..