DATABASE ANALYST/DEVELOPER (MICROSOFT) (HYBRID)

iTRTech Group; Lisboa; Hybrid; EUR 28,000 - 31,000; Full time

Job summary

iTRTech Group seeks a Senior Database Analyst/Developer (Microsoft) to design, develop, maintain, and optimize database systems and BI solutions in a hybrid Lisbon role.

The successful candidate will focus on data integrity, performance tuning, ETL processes, and Microsoft BI tools (SSIS/SSRS/SSAS, Power BI) to support critical business applications. English proficiency of B2 required.

Qualifications

• Solid experience with Microsoft SQL Server and database development.
• Strong knowledge of the Microsoft BI stack: SSIS, SSRS, and SSAS, preferably Tabular Models.
• Hands-on experience with ETL development, optimization, and monitoring.
• Strong SQL skills, including stored procedures, functions, and triggers.
• Experience with SQL performance tuning, partitioning, and indexing.
• Knowledge of database administration, maintenance, and backup strategies.
• Experience with C#, PowerShell, and .NET.
• Practical experience with Power BI.
• Strong troubleshooting and root cause analysis skills.
• English B2 or higher.

Responsibilities

• Design, implement, maintain, and optimize database systems.
• Develop and optimize SQL queries, stored procedures, functions, and database triggers.
• Monitor and support critical business processes, ensuring database performance and availability.
• Develop, optimize, and monitor ETL processes and Microsoft BI solutions.
• Implement and maintain database backup systems to ensure data integrity.
• Ensure database backups comply with business requirements and established backup strategies.
• Investigate database incidents, perform root cause analysis, and resolve performance issues.
• Collaborate with Development, Operations, and Security teams to improve database solutions and business processes.

Skills

SQL

ETL development

Performance tuning

Root cause analysis

Troubleshooting

English B2

Tools

MS SQL Server

SSIS

SSRS

SSAS

Tabular Models

C#

PowerShell

.NET

Power BI

Job description

DATABASE ANALYST/DEVELOPER (MICROSOFT) (HYBRID LISBON)

Location: Lisbon, Portugal

Only candidates already based in Portugal will be considered

Work Model: Hybrid

Language Requirements: English B2 minimum

Seniority: Senior (5+ years in database development and Microsoft BI technologies)

Rate Between €2500 - 2800 RV or unipessoal (gross value)

About The Opportunity

We are looking for an experienced Database Analyst / Developer (Microsoft) to design, develop, maintain, and optimize database systems and business processes.

The professional will focus on data integrity, database performance, ETL processes, and Microsoft Business Intelligence solutions, supporting business-critical applications.

Responsibilities

• Design, implement, maintain, and optimize database systems.
• Develop and optimize SQL queries, stored procedures, functions, and database triggers.
• Monitor and support critical business processes, ensuring database performance and availability.
• Develop, optimize, and monitor ETL processes and Microsoft BI solutions.
• Implement and maintain database backup systems to ensure data integrity.
• Ensure database backups comply with business requirements and established backup strategies.
• Investigate database incidents, perform root cause analysis, and resolve performance issues.
• Collaborate with Development, Operations, and Security teams to improve database solutions and business processes.

Requirements

• Solid experience with Microsoft SQL Server and database development.
• Strong knowledge of the Microsoft BI stack: SSIS, SSRS, and SSAS, preferably Tabular Models.
• Hands-on experience with ETL development, optimization, and monitoring.
• Strong SQL skills, including stored procedures, functions, and triggers.
• Experience with SQL performance tuning, partitioning, and indexing.
• Knowledge of database administration, maintenance, and backup strategies.
• Experience with C#, PowerShell, and .NET.
• Practical experience with Power BI.
• Strong troubleshooting and root cause analysis skills.
• English B2 or higher.

Ideal Candidate Profile

An experienced Database Analyst / Developer with strong expertise in Microsoft SQL Server, Business Intelligence, and ETL processes. A professional capable of developing efficient database solutions, optimizing SQL performance, ensuring data integrity, and collaborating with technical teams to support critical business applications.

5 Questions for Candidates

• How many years of experience do you have with Microsoft SQL Server and database development?
• Do you have hands-on experience with SSIS, SSRS, and SSAS, particularly Tabular Models?
• Have you developed and optimized ETL processes, stored procedures, and complex SQL queries?
• Do you have practical experience with C#, PowerShell, .NET, and Power BI?
• Are you available for hybrid work in Lisbon, with an expected rate between €2500 and €2800 under an RV or Unipessoal contract?

Keywords

Database Analyst, Database Developer, Microsoft SQL Server, SQL, T-SQL, Microsoft BI, SSIS, SSRS, SSAS, Tabular Models, ETL, Stored Procedures, SQL Performance Tuning, Indexing, Partitioning, C#, PowerShell, .NET, Power BI, Database Backup, Lisbon, Hybrid