SQL Developer

Ampstek; Lisboa; Presencial; EUR 60 000 - 90 000; Tempo integral

Resumo da oferta

Ampstek in Lisbon, Portugal is seeking a senior SQL Server specialist to design, develop, and optimize database solutions. You will build ETL processes, implement robust security, backups, and recovery, and provide L2/L3 production support while collaborating across development teams to ensure reliable deployments.

The ideal candidate has 7+ years with MS SQL Server, deep T-SQL and SSIS experience, and a strong background in performance tuning and data modeling.

Qualificações

• 7+ years of hands-on experience with Microsoft SQL Server.
• Strong expertise in T-SQL, SSMS, SSIS, SQL Server Agent Jobs, Stored Procedures, Views, Functions, Triggers, and Dynamic SQL.
• Experience in database design, data modeling, indexing strategies, normalization/denormalization, and ETL development.
• Strong knowledge of query optimization, performance tuning, transaction management, and production support.

Responsabilidades

• Design, develop, and optimize SQL Server database solutions.
• Develop Stored Procedures, Functions, Views, Triggers, Dynamic SQL, and SQL scripts.
• Build and support ETL processes for data migration and integration.
• Perform query optimization, execution plan analysis, and database performance tuning.
• Provide L2/L3 production support, troubleshoot database issues, and perform root cause analysis.
• Support database deployments, upgrades, and release activities.
• Collaborate with development teams and ensure database security, backup, and recovery best practices.

Conhecimentos

Microsoft SQL Server

T-SQL

SSMS

Query optimization

Production support

Ferramentas

SSIS

SQL Server Agent Jobs

ServiceNow

Jira

Descrição da oferta de emprego

• Design, develop, and optimize SQL Server database solutions.
• Develop Stored Procedures, Functions, Views, Triggers, Dynamic SQL, and SQL scripts.
• Build and support ETL processes for data migration and integration.
• Perform query optimization, execution plan analysis, and database performance tuning.
• Provide L2/L3 production support, troubleshoot database issues, and perform root cause analysis.
• Support database deployments, upgrades, and release activities.
• Collaborate with development teams and ensure database security, backup, and recovery best practices

Required Skills:

• 7+ years of hands-on experience with Microsoft SQL Server.
• Strong expertise in T-SQL, SSMS, SSIS, SQL Server Agent Jobs, Stored Procedures, Views, Functions, Triggers, and Dynamic SQL.
• Experience in database design, data modeling, indexing strategies, normalization/denormalization, and ETL development.
• Strong knowledge of query optimization, performance tuning, transaction management, and production support.
• Experience with ServiceNow, Jira, or similar ticketing tools.

Preferred:

• Basic knowledge of Supply Chain, Omnichannel Retail, or E-commerce domains.