hace 8 días

Senior T SQL Database Engineer

ImprovingRemote

Oferta publicada originalmente vía Get on Board

Aplicar

Descripción del puesto

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.

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.

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..