SQL Server DBA – ETL & Data Warehousing

La familia presenta; Ensenada; Híbrido; MXN 300.000 - 520.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Weekly pay

Time off beyond legal requirements

Grocery vouchers

Meal subsidy

Education sponsorship

Career growth opportunities

Telehealth services

Prescription glasses benefit

Birthday bonus

Descripción de la vacante

La familia presenta in Ensenada, Baja California seeks an experienced Database Administrator to manage SQL Server databases, optimize complex queries, and implement robust data models and ETL processes.

The role involves data integration from APIs, text files, and web services, plus designing mappings and supporting OLTP/OLAP systems. On-site position with structured weekly pay and local benefits.

Formación

• Bachelor's degree in Computer Science, or IT related field, or equivalent work experience.
• 3+ years of related experience.
• Experience working with Microsoft SQL Server (2012+ ).
• Solid T-SQL to develop complex views, stored procedures and functions.
• Experience importing data from text files, linked servers, APIs and web services.
• Experience creating mapping documents between source and target data structures.
• Excellent knowledge of data transformations including calling custom scripts and applying complex logic.
• Solid knowledge of database design to produce sound data models.
• Ability to understand and analyze system interdependencies, data structures, and data models.
• Experience with OLTP/OLAP, data warehousing, and data stores.

Conocimientos

SQL Server

T-SQL

Data modeling

ETL

Data integration

Data warehousing

OLTP/OLAP

APIs & web services

Educación

Bachelor's degree in Computer Science or IT related field

Herramientas

MS SQL Server

Descripción del empleo

La familia presenta in Ensenada, Baja California seeks an experienced Database Administrator to manage SQL Server databases, optimize complex queries, and implement robust data models and ETL processes.

The role involves data integration from APIs, text files, and web services, plus designing mappings and supporting OLTP/OLAP systems. On-site position with structured weekly pay and local benefits.