Senior Database Analyst / Infrastructure Engineer

Consort; Porto; Hybrid; EUR 37,000 - 48,000; Full time

Benefits offered by this job

Health insurance

TR card

CSE

Job summary

Consort Group is hiring a Senior Database Analyst / Infrastructure Engineer to design, administer, optimize, and support enterprise database platforms in a nearshore Porto/Lisbon setting. You will work with development, operations, and security teams to improve data flows, automation, and reliability of critical applications.

Candidates should have at least 6 years in database administration/infrastructure support, deep SQL skills, and hands-on experience with SQL Server, PostgreSQL, ETL, and

Qualifications

• Extensive experience with enterprise database platforms and data security.

Responsibilities

• Design, administer, optimize, and support enterprise databases with a focus on integrity, availability, and performance.

Skills

Microsoft SQL Server administration

PostgreSQL administration

Advanced SQL development

ETL development

Database performance tuning

Backup and disaster recovery

Root cause analysis

DevOps and CI/CD

ITIL concepts

Power BI

Tools

Dynatrace

ELK

Zabbix

Power BI

Job description

Every moment counts. Especially those you live to the fullest. Welcome to Consort Group.

For over 30 years, Consort Group has been helping companies leverage their data and infrastructure. It is backed by two leaders, Consortis and Consortia, and places people and social responsibility at the heart of its values.

This is your future team

Established in 2021, Consort Portugal supports the strategic offshoring choices of our clients, particularly in Europe, and brings our expertise in infrastructure services to the Portuguese market. With a team of around 45 employees, our Service Center based in Porto is developing a dynamic nearshore business, offering the French and European markets an environment of excellence and high potential.

Senior Database Analyst / Infrastructure Engineer

This is your mission

Are you passionate about database administration, performance optimization, and business-critical systems? Then this position is for you.

As a Senior Database Analyst / Infrastructure Engineer, you will be responsible for designing, administering, optimizing, and supporting enterprise database platforms while ensuring data integrity, availability, security, and performance. You will work closely with development, operations, and security teams to support critical business applications and continuously improve database services.

Build side:

• Design and implement robust database solutions aligned with business and technical requirements.

• Develop, optimize, and maintain complex SQL queries, stored procedures, functions, and database triggers.

• Collaborate with development teams to improve business process performance and data flows.

• Contribute to ETL design, development, optimization, and monitoring initiatives.

• Evaluate and implement innovative solutions to automate, simplify, and optimize database operations.

• Support DevOps and CI/CD initiatives related to database deployments and releases.

• Participate in database architecture improvements and modernization projects.

Run side:

• Administer and maintain Microsoft SQL Server and PostgreSQL environments.

• Monitor database performance, availability, and capacity to ensure optimal service levels.

• Implement and maintain backup and recovery strategies in accordance with operational requirements.

• Troubleshoot database incidents and perform root cause analysis for recurring issues.

• Participate actively in major incident management and post-mortem reviews.

• Provide technical support to development teams and application support teams.

• Ensure compliance with operational procedures, security standards, and governance requirements.

• Leverage monitoring and observability tools to proactively identify and resolve performance issues.

This is your background

You have at least 6 years of experience in Database Administration, Database Engineering, Infrastructure Support, or a similar role within enterprise environments.

You enjoy managing critical database systems, solving complex performance challenges, and working closely with technical teams to deliver reliable and scalable solutions. You thrive in environments where operational excellence and continuous improvement are key drivers of success.

This is your expertise:

• Microsoft SQL Server administration and optimization.

• PostgreSQL administration and performance tuning.

• Advanced SQL development (queries, stored procedures, functions, triggers).

• ETL development, monitoring, and optimization.

• Database performance tuning, partitioning, and indexing strategies.

• Backup, recovery, and disaster recovery processes.

• Root cause analysis and incident investigation.

• Master Data Services (MDS).

• Monitoring and observability tools such as Dynatrace, ELK, and Zabbix.

• DevOps and CI/CD practices.

• ITIL concepts and service management processes.

• Performance reporting and visualization tools such as Power BI.

This is how you work as part of a team:

• Excellent written and verbal communication skills.

• Strong collaboration and teamwork mindset.

• Analytical thinking and problem-solving expertise.

• High attention to detail and operational rigor.

• Creativity and innovation in improving processes and solutions.

• Adaptability and continuous learning attitude.

• Ability to manage multiple priorities in demanding environments.

• Strong sense of ownership and accountability.

Language Skills :

• Portuguese: Fluent

• English: C1

• Spanish: Nice to have.

This is our commitment

At Consort Group, you are an expert who we support so that every assignment becomes a step that counts.

• Attentive and human onboarding

• A truly hands-on management style

• Continuous training opportunities

• Concrete commitments: inclusion, equality, solidarity

• A comprehensive HR package: health insurance, TR card, CSE

• A culture of feedback and meaningful projects

The recruitment process:

1. An initial phone call with our recruitment team

2. An HR interview and a job interview with a business engineer

3. A test or technical interview with one of our experts

4. A final meeting with your future manager or project manager

5. And if we're a good fit, we'll get started together

Good to know

Location: Lisbon or Porto

Contract: Permanent contract

Remote work: Hybrid (50%)

Salary: From 37 K€ to 48 K€ (depending on experience) gross annual salary

Job category: Database Administration / Infrastructure Engineering / Production Support

What you will do here, you won't do anywhere else.

This moment is yours.