Senior Database Analyst

PrimeIT; Lisboa; Hybrid; EUR 13,000 - 22,000; Full time

Benefits offered by this job

Meal Allowance

Flexible Benefits

Job summary

PrimeIT in Lisbon offers aSenior Database Analyst role in a hybrid Lisbon setting. You will design, administer and optimize database systems, focusing on data integrity, performance, and high availability.

You will develop advanced SQL, manage SQL Server and PostgreSQL environments, and support ETL workflows and reporting. Strong analytical skills, ITIL familiarity and teamwork are required for success.

Qualifications

• 10+ years of experience in database analysis, design and administration.
• Strong expertise with MS SQL Server and PostgreSQL.
• Proficient in SQL development, stored procedures, functions and triggers.
• Experience with ETL, data warehousing and reporting.
• Knowledge of backup strategies, partitioning and indexing.
• Familiarity with DevOps and CI/CD practices.
• Excellent analytical and problem-solving abilities.
• Strong written and verbal communication and teamwork.

Responsibilities

• Design, administer and optimize database systems for integrity and availability.
• Develop and optimize SQL queries, stored procedures, functions and triggers.
• Manage SQL Server and PostgreSQL environments, including backups, partitioning and indexing.
• Provide technical support to development and production teams; perform root-cause analysis.
• Monitor performance, review post-incident analyses and optimize costs.
• Collaborate with development, operations and security teams on core applications.

Skills

Microsoft SQL Server

PostgreSQL

SQL Development

ETL Processes

Query Optimization

Partitioning

Indexing

Backup Strategies

Performance Tuning

DevOps CI/CD

ITIL

Dynatrace

ELK

Power BI

Data Integrity

Analytical Thinking

Communication

Teamwork

Problem Solving

Attention to Detail

Tools

Dynatrace

ELK

Zabbix

Power BI

CI/CD tooling

Job description

Did you know that the average reading time for a job advertisement is only 30 seconds? Let's use them well:

20 years of experience.

25 offices and 3 Talent Hubs.

10 internal programmes designed with you in mind.

We are looking for an Senior Database Analyst!

Location: Lisbon | Hybrid

Level of Experience: Senior (10+ years)

Salary Package & Benefits: €1,200 to €2,000 (salary base) + Meal Allowance + Flexible Benefits

Main Tasks

• Design, administer and optimize database systems to ensure data integrity, performance and high availability.
• Develop and optimize SQL queries, stored procedures, functions and triggers to support data processing, ETL workflows and reporting.
• Manage complex Microsoft SQL Server and PostgreSQL environments, including backup strategies, partitioning and indexing.
• Provide technical support to development and application production support teams, troubleshooting database incidents and conducting root cause analysis.
• Monitor database performance, participate in post-incident reviews and implement solutions to automate processes and optimize costs.
• Collaborate with development, operations and security teams to improve business-critical applications and processes.

Technical skills

• Strong experience with Microsoft SQL Server and PostgreSQL.
• Advanced SQL development, including stored procedures, functions, triggers and ETL processes.
• Database performance tuning, partitioning, indexing and query optimization.
• Experience with Master Data Services.
• Database administration, backup strategies and data integrity management.
• Monitoring and visualization tools such as Dynatrace, ELK, Zabbix and Power BI.
• Knowledge of DevOps and CI/CD practices.
• Understanding of ITIL processes and root cause analysis.
• Excellent analytical thinking and problem-solving skills.
• Strong written and verbal communication.
• Teamwork and collaboration across technical teams.
• Creativity and an innovative approach to process improvement.
• Attention to detail and a strong sense of responsibility.

Languages

• Portuguese (fluent).
• English (professional proficiency).
• Spanish (basic knowledge is a plus).