Senior Database Analyst / Infrastructure Engineer

Consort Group; Porto Salvo; Híbrido; EUR 37 000 - 48 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health insurance

Hybrid work model

Resumo da oferta

Consort Group is hiring a Senior Database Analyst / Infrastructure Engineer to design, administer, optimize, and support enterprise database platforms. You will ensure data integrity, availability, security and performance while collaborating with development, operations, and security teams.

The role covers both DB design and run responsibilities; you will work on ETL, monitoring, and incident management in a hybrid Lisbon/Porto setting with a 50% remote schedule.

Qualificações

• At least 6 years in Database Administration / Infrastructure roles.
• Experience with enterprise DB platforms and data integrity, security and performance.

Responsabilidades

• Design, administer and optimize database platforms.
• Develop, optimize and maintain complex SQL queries, procedures, functions and triggers.
• Collaborate with dev, ops and security teams to support critical applications.
• Contribute to ETL design, development, and monitoring.
• Implement backup, recovery, and DR strategies.
• Support DevOps/CI/CD for DB deployments and releases.
• Monitor performance and troubleshoot incidents.

Conhecimentos

Database administration

Analytical thinking

Team collaboration

Problem solving

Ferramentas

Microsoft SQL Server

PostgreSQL

Power BI

Dynatrace

ELK

Zabbix

Descrição da oferta de emprego

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

• An initial phone call with our recruitment team
• An HR interview and a job interview with a business engineer
• A test or technical interview with one of our experts
• A final meeting with your future manager or project manager
• 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.