Senior Database Analyst

Descompagnons Trabalho Temporário Lda; Lisboa; Híbrido; EUR 40 000 - 60 000; Tempo integral

Resumo da oferta

A leading staffing company in Lisbon is looking for a Senior Database Analyst to enhance their database systems and business processes. The candidate will ensure data integrity and performance while collaborating with various teams. Key responsibilities include designing databases, optimizing SQL queries, and managing complex environments. The role follows a hybrid model, requiring 2 days onsite, and requires strong analytical skills and a minimum English level of B2.

Qualificações

• Strong analytical and technical skills.
• Minimum English level of B2.
• Experience with Microsoft SQL Server and PostgreSQL.

Responsabilidades

• Design and implement database systems.
• Monitor and support business processes.
• Develop and optimize SQL queries and procedures.

Conhecimentos

SQL performance tuning

ETL process development

Root cause analysis

Monitoring tools (Dynatrace, ELK, Zabbix)

Collaboration and teamwork

Descrição da oferta de emprego

We are looking for a Senior Database Analyst to join our team and play a key role in designing, maintaining, and optimizing our database systems and business processes. The ideal candidate will ensure the highest levels of data integrity, performance, and availability, while collaborating closely with development, operations, and security teams to support critical applications.

This position requires strong analytical and technical skills, a minimum English level of B2, and the ability to work effectively in a collaborative environment.

The role follows a hybrid work model, with 2 days per week onsite in Lisbon or Porto.

Main Responsibilities

• Design and implement database systems within the Information Systems ecosystem.
• Monitor and support critical business processes.
• Develop and optimize SQL queries, stored procedures, and triggers for data manipulation and reporting.
• Collaborate closely with development teams to improve business process outcomes.
• Manage complex database environments in Microsoft SQL Server and PostgreSQL.
• Administer and maintain databases to ensure operational excellence and reliability.
• Implement and monitor backup systems, ensuring data integrity and compliance with defined recovery strategies.
• Provide technical support to development and APS teams.
• Troubleshoot and resolve database incidents affecting performance or accessibility.
• Actively participate in incident reviews to identify root causes and prevent recurrences.
• Conduct ongoing technology monitoring to ensure performance and availability through visualization tools (e.g., Dynatrace, Power BI).
• Assess and deploy innovative solutions to simplify, automate, and optimize database costs.

Technical Skills

• Strong experience in developing, optimizing, and monitoring ETL processes (SQL Procedures, Functions, etc.).
• Root cause analysis and troubleshooting skills.
• Experience with SQL performance tuning, partitioning, and indexing.
• Knowledge of Master Data Services.
• Familiarity with ITIL practices and DevOps (CI/CD) methodologies.
• Experience with monitoring tools such as Dynatrace, ELK, and Zabbix.

Soft Skills

• Excellent verbal and written communication skills (minimum English level: B2).
• Strong collaboration and teamwork abilities.
• Creativity and innovation mindset.
• Ability to develop and adapt processes effectively.
• Strong solving and analytical thinking skills.