Senior Database Engineer (SQL Server / PostgreSQL)

Consort Group; Porto; On-site; EUR 37,000 - 48,000; Full time

Job summary

Consort Group Portugal is seeking 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.

You will work with MS SQL Server and PostgreSQL, develop complex SQL, ETL, and monitoring solutions, and contribute to DevOps and CI/CD initiatives.

Qualifications

• At least 6 years of experience in Database Administration or Infra.
• Expert in SQL Server and PostgreSQL with performance optimization.
• Experience with ETL design, monitoring and optimization.
• Strong collaboration with Dev, Ops and Security teams.

Responsibilities

• Design, administer, and optimize enterprise database platforms.
• Develop and maintain complex SQL queries and procedures.
• Collaborate with development teams to improve data flows.
• Contribute to ETL design and monitoring.
• Implement backup and disaster recovery strategies.
• Support DevOps and CI/CD for database deployments.
• Monitor performance and capacity, ensure data integrity.
• Participate in incident management and root cause analysis.
• Ensure security and governance compliance.

Skills

MS SQL Server

PostgreSQL

SQL development

ETL development

Performance tuning

Backup & DR

Root cause analysis

Monitoring tools

DevOps/CI-CD

ITIL

Power BI

Dynatrace

ELK

Zabbix

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.

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.
• 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
• 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
• Concrete commitments: inclusion, equality, solidarity
• 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

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.