Senior Database Analyst / Infrastructure Engineer

Consort Group; Lisboa; Hybrid; EUR 37,000 - 48,000; Full time

Benefits offered by this job

Health insurance

TR card

CSE

Job summary

Consort Group is seeking a Senior Database Analyst / Infrastructure Engineer to design, administer, and optimize enterprise databases. You will ensure data integrity, security, and performance while collaborating with development, operations, and security teams on critical business applications.

You will administer MS SQL Server and PostgreSQL, monitor performance, manage backups, and contribute to ETL and CI/CD initiatives.

Qualifications

• Minimum 6 years in Database Administration, Engineering, or infra support in enterprise environments.
• Experience with Microsoft SQL Server and PostgreSQL in production environments.
• Ability to design, optimize, and support enterprise database platforms and data flows.

Responsibilities

• Design and implement robust database solutions per technical requirements.
• Develop and maintain complex SQL queries, procedures, functions, and triggers.
• Monitor performance, availability, and capacity; handle backups and recovery.
• Support DevOps/CI/CD initiatives for database deployments.
• Participate in incident management and root cause analysis.
• Optimize ETL processes and data integration workflows.
• Ensure security, governance, and ITIL-aligned service management.
• Provide data visualization and reporting via Power BI.

Skills

SQL Server admin

PostgreSQL admin

Advanced SQL

ETL development

Performance tuning

Backup & DR

Root cause analysis

DevOps & CI/CD

ITIL concepts

Power BI reporting

Tools

Dynatrace

ELK

Zabbix

Power BI

Master Data Services (MDS)

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

• 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.