On-Site SQL Server DBA: ETL, T-SQL & Data Quality

Zventus; Ensenada; Presencial; MXN 240 000 - 420 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Weekly payment

Education sponsorship

Time off beyond law

Seniority gifts

Wholesale membership sponsorship

Telehealth and Wellness events

Birthday bonus

Sponsored lunch events

Resumo da oferta

Zventus seeks a SQL Server ETL Developer to design and maintain databases for scalable data integration at our Ensenada, Baja California center. You will build tables, views, procedures and ETL pipelines to support accurate data movement.

Candidates should have a Bachelor's in CS or equivalent, strong T-SQL, SQL Server, and scripting skills (PowerShell). This on-site role requires a collaborative mindset and ability to optimize performance in a fast-paced environment.

Qualificações

• Bachelor's degree in Computer Science, or IT related field, or 3+ years equivalent work experience.
• Solid T-SQL coding to develop complex views, stored procedures and functions.
• Experience with Microsoft SQL Server, SQL Server Agent, and stored procedure development.
• Experience developing ETL processes and troubleshooting ETL issues.
• Ability to write PowerShell scripts.
• Knowledge of data transformations and data modeling.
• Experience with data formats, linked servers, APIs and web services.
• Strong verbal and written communication skills.

Responsabilidades

• Create database tables, structures, views, functions, stored procedures, schemas and dictionaries to facilitate the ETL of data within Microsoft SQL Server.
• Responsible for developing and maintaining Microsoft SQL Server databases whilst also ensuring their performance and stability.
• Create and implement changes to databases based on the requirements of the end user.
• Ensure data quality and integrity.
• Works on problems of complex scope where analysis of situations or data requires a review of a variety of factors.

Conhecimentos

T-SQL

SQL Server

ETL development

Data modeling

PowerShell

Query performance tuning

Data quality assurance

Shell scripting

Formação académica

Bachelor's degree in Computer Science / IT

Ferramentas

Microsoft SQL Server

SQL Server Agent

Linked servers

ETL tooling

Descrição da oferta de emprego

Zventus seeks a SQL Server ETL Developer to design and maintain databases for scalable data integration at our Ensenada, Baja California center. You will build tables, views, procedures and ETL pipelines to support accurate data movement.

Candidates should have a Bachelor's in CS or equivalent, strong T-SQL, SQL Server, and scripting skills (PowerShell). This on-site role requires a collaborative mindset and ability to optimize performance in a fast-paced environment.