Data Management Engineer OnPrem ETL Sr

Softtek · Aguascalientes City, Aguascalientes, Mexico

IT Services and IT Consulting · 10,001+ employees

Yesterday

Senior (5-10 yrs) Full-time Mexico

About the role

The role involves maintaining business-critical applications and supporting production database environments to ensure stability and availability. Responsibilities include troubleshooting incidents, optimizing database performance, and collaborating with development teams on system improvements.

What they look for

SQL SQL Server Azure SQL T-SQL Query optimization Index tuning Database performance analysis Stored procedures Database functions Data modeling ETL Data integration L3 support Troubleshooting Problem-solving Production support

Requirements

Candidates must possess advanced SQL and T-SQL development skills, along with experience in database administration and performance tuning. Strong analytical, communication, and problem-solving abilities are required to provide effective L3 support in production environments.

Full description

Requirements

Required – Technical Skills

· Proficient SQL expertise (mandatory)

· Experience with SQL Server administration

· Experience with Azure SQL administration

· Advanced SQL and T-SQL development skills

· Experience in query optimization

· Experience in index tuning

· Experience performing database performance analysis

· Experience developing stored procedures

· Experience developing database functions

· Experience creating and maintaining views

· Experience in data modeling

· Knowledge of ETL processes

· Experience with data integration solutions

· Experience providing L3 support

· Strong troubleshooting and problem-solving skills

· Experience supporting production environments

Required – Soft Skills

· Analytical thinking

· Problem-solving mindset

· Attention to detail

· Effective communication skills

· Collaboration and teamwork

· Customer-oriented approach

· Accountability and ownership

· Continuous improvement mindset

Responsibilities (Activities to perform)

· Maintain business-critical applications

· Support production database environments

· Implement minor application enhancements

· Develop solutions based on business requirements

· Ensure application stability and availability

· Monitor compliance with KPIs and service objectives

· Troubleshoot incidents and application issues

· Resolve database performance problems

· Analyze and resolve locks and deadlocks

· Optimize queries and database performance

· Collaborate with development teams on improvements

· Support database and application optimization initiatives

· Document incidents, changes, and solutions

· Maintain traceability and operational transparency

· Provide ongoing production support

· Contribute to continuous improvement initiatives

· Ensure reliability and availability of database systems

Required Languages

· English: Advanced

Additional Information

· Location

· Bogotá and surrounding areas (Hybrid)

· Mexico (Hybrid)

· Rest of Colombia (Remote)