Database Analyst

QUANTEAM - Portugal (RAINBOW PARTNERS Group); Porto; Hybrid; EUR 25,000 - 61,000; Full time

Benefits offered by this job

Health Insurance

Extra holiday: Christmas Eve or New To

Access to Quanteam Academy

Elevate Program

Ongoing technical support via a Senior

Job summary

Quanteam, founding entity of RAINBOW PARTNERS, is hiring a DataBase Analyst for a hybrid role based in Lisbon or Porto. You will design, implement and optimize database systems, ensuring high availability and performance while supporting ETL, reporting and automation initiatives.

You will work with SSIS/SSRS/SSAS, SQL, C#, .NET and PowerShell, using Power BI and MDS, Dynatrace and ELK/Zabbix to monitor and improve critical processes. A permanent CTI contract and health benefits are offered.

Qualifications

• 6+ years of professional experience in Database Analysis or DBA role.
• Strong experience with the Microsoft BI stack: SSIS/SSRS/SSAS and Tabular Models.
• Advanced ETL development, optimization and monitoring, including SQL procedures and functions.

Responsibilities

• Design, implement, maintain and optimize database systems ensuring data integrity and performance.
• Monitor and support critical business processes and database availability.
• Develop and optimize SQL queries, stored procedures, and ETL processes for reporting.
• Administer and maintain databases with high availability and recovery planning.
• Provide support to Dev and Ops teams for database incidents and performance issues.
• Perform root cause analyses and participate in post-mortems for major incidents.
• Monitor performance using Dynatrace, Power BI, ELK and Zabbix.
• Collaborate with Dev, Ops and Security to improve business processes.
• Identify and implement automation to reduce costs and improve performance.
• Contribute to continuous improvement of database environments.

Skills

Communication

Collaboration

Problem solving

Attention to detail

Process improvement

Tools

SSIS

SSRS

SSAS

Tabular Models

SQL

C#

NET

PowerShell

Power BI

MDS

Dynatrace

ELK

Zabbix

DevOps

CI/CD

Job description

Quanteam, founding entity of RAINBOW PARTNERS, is a consulting firm specialized in Banking and Financial Services. With more than 1200 consultants across 10 countries, we combine business and IT expertise to support leading institutions in transformation projects.

Our core areas

Operations & Finance

We are looking for a DataBase Analyst

Main Tasks

• Design, implement, maintain and optimize database systems, ensuring data integrity, performance, availability and reliability.
• Monitor and support critical business processes, ensuring database systems operate efficiently.
• Develop, maintain and optimize SQL queries, stored procedures, functions and database triggers for data manipulation, ETL processes and reporting.
• Administer and maintain databases, ensuring high availability and business continuity.
• Implement and manage database backup and recovery solutions, ensuring compliance with established backup strategies.
• Provide technical support to development and operations teams, troubleshooting database-related incidents and performance issues.
• Perform root cause analysis and actively participate in post-mortems for major and recurring database incidents.
• Monitor database performance and availability using tools such as Dynatrace, Power BI, ELK and Zabbix.
• Collaborate with Development, Operations and Security teams to improve business processes and support business-critical applications.
• Identify and implement innovative solutions to automate processes, optimize database performance and reduce operational costs.
• Contribute to continuous improvement initiatives and the optimization of database environments.

Main Skills & Requirements

• Minimum 6 years of professional experience in Database Analysis, Database Administration or a similar role.
• Strong experience with the Microsoft Business Intelligence stack: SSIS, SSRS and SSAS, preferably with Tabular Models.
• Advanced knowledge of ETL development, optimization and monitoring, including SQL stored procedures and functions.
• Strong SQL expertise, including query performance tuning, database partitioning and indexing.
• Experience with C#, .NET and PowerShell.
• Strong experience with Power BI.
• Experience with Microsoft Master Data Services (MDS).
• Strong root cause analysis and troubleshooting capabilities.
• Expert knowledge of ITIL processes and practices.
• Practical experience with DevOps and CI/CD processes.
• Experience with monitoring tools such as Dynatrace, ELK and Zabbix.

Soft Skills

• Excellent oral and written communication skills.
• Strong collaboration and teamwork capabilities.
• Creativity and innovation.
• Ability to develop, adapt and improve processes.
• Strong problem-solving and analytical thinking skills.
• High attention to detail and rigor.

Languages

• Portuguese: Mastery.
• Spanish: Basic knowledge.
• This role offers a gross annual salary between 24.500€ to 60.500€, defined according to the candidate’s experience and competencies.
• Permanent contract (CTI).
• Health Insurance.
• Extra holiday: Christmas Eve or New Year’s Eve.
• Access to Quanteam Academy for continuous learning and certifications.
• Elevate Program to support professional development and career growth.
• Ongoing follow-up and technical support provided by a Consultant Expert.

Hybrid position based in Lisbon or Porto