Consultor de banco de dados

TMC; Lisboa; Presencial; EUR 55 000 - 90 000; Tempo integral

Resumo da oferta

TMC is seeking a Senior Database Administrator to support Oracle and SQL Server environments across on-prem and cloud platforms. The role involves ensuring high availability, DR, performance, and security, with hands-on work on RAC, Data Guard, RMAN, and Always-On AG implementations.

Requirements include strong SQL/PL-SQL, T-SQL scripting, PowerShell automation, and collaboration with Infra, App, and DevOps teams. Portugal-based candidates preferred.

Qualificações

• Ideal candidate will manage Oracle and SQL Server environments across on-prem and cloud.

Responsabilidades

• Manage and maintain Oracle and SQL Server database environments.
• Ensure high availability, disaster recovery, performance, and security.
• Administer Oracle RAC, Data Guard, RMAN, Always-On Availability Groups, and FCI.
• Perform database monitoring, troubleshooting, query tuning, and execution plan analysis.
• Develop and maintain SQL, PL/SQL, T-SQL, and PowerShell scripts.
• Support Azure database services and automation initiatives.
• Collaborate with infrastructure, application, and DevOps teams.

Conhecimentos

SQL Server

Oracle

T-SQL scripting

PowerShell automation

Always-On Availability Groups

Execution plan analysis

Performance tuning

Storage account management

Ferramentas

SQL Server

Oracle

OEM

Azure

Descrição da oferta de emprego

Senior Database Administrator (Oracle OR SQL Server) | TMC

About TMC

TMC is an international high-tech consultancy company that brings expertise in Engineering, Technology, and Digital to leading organizations worldwide. Through our unique Employeneurship model, we combine the security of permanent employment with the opportunities of entrepreneurship, empowering our consultants to drive their careers while working on innovative and impactful projects.

About the Role

We're looking for a Senior Database Administrator (Oracle OR SQL Server) to join an international project and support critical database environments across on-premises and cloud platforms.

What You'll Do

• Manage and maintain Oracle and SQL Server database environments.
• Ensure high availability, disaster recovery, performance, and security.
• Administer Oracle RAC, Data Guard, RMAN, Always-On Availability Groups, and FCI.
• Perform database monitoring, troubleshooting, query tuning, and execution plan analysis.
• Develop and maintain SQL, PL/SQL, T-SQL, and PowerShell scripts.
• Support Azure database services and automation initiatives.
• Collaborate with infrastructure, application, and DevOps teams.

What You'll Do

• Manage, monitor, and optimize enterprise database environments.
• Ensure high availability, disaster recovery, security, and performance.
• Perform database troubleshooting, tuning, upgrades, and automation.
• Collaborate with Infrastructure, Application, and DevOps teams.
• Support cloud database services and continuous improvement initiatives.

What We're Looking For

SQL Server

• SQL Server installation and configuration
• Always-On Availability Groups (mandatory)
• T-SQL scripting (mandatory)
• PowerShell automation (mandatory)
• Execution plan analysis and performance tuning
• Storage account management

Oracle

• Oracle RAC
• Data Guard
• RMAN
• Oracle Enterprise Manager (OEM)
• SQL and PL/SQL scripting (mandatory)
• Query tuning and performance optimization
• Transparent Data Encryption (TDE)
• Auditing and compliance controls

Nice to Have

Microsoft SQL Server Certifications

Oracle Certified Professional (OCP)

CI/CD and deployment automation experience

To be considered for this opportunity, candidates must be based in Portugal and hold either a valid Portuguese Residence Permit/Card or an EU Passport. Applications that do not meet these criteria cannot be considered.