Database Management Specialist/Services Coordination

DataSmart; Porto; Presencial; EUR 50 000 - 80 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid work model

On-call rotation

Resumo da oferta

DataSmart, a Portuguese technology services company, is seeking a Database Management Specialist/Services Coordination for a hybrid role in Porto. The ideal candidate will manage the full lifecycle of PostgreSQL and MongoDB databases, while supporting Oracle and SQL Server environments both on-premises and in the cloud.

You will design and test backup, recovery, HA and DR solutions, monitor capacity, and ensure security at both system and application levels.

Qualificações

• Minimum 5+ years in Database Administration or Services Coordination.
• Degree in CS/IS or related field.
• Hands-on PostgreSQL and MongoDB in on-premises and cloud.
• Experience with Oracle and/or SQL Server administration.
• Certs in PostgreSQL/MongoDB/Oracle/SQL Server preferred.

Responsabilidades

• Manage full lifecycle of database platforms and components.
• Administer PostgreSQL and MongoDB both on-prem and cloud.
• Support Oracle and SQL Server databases on-prem and cloud.
• Design and test backup, recovery, HA, DR solutions.
• Monitor capacity and plan future resources.
• Ensure database security at system and application levels.
• Analyze and optimize SQL queries with tools.
• Collaborate with devs to optimize schemas, tables, indexes.
• Handle deployments, schema changes, and CI/CD releases.
• Troubleshoot incidents and perform root-cause analysis.
• Improve monitoring, automation, and error prevention.
• Participate in database-related projects and 24/7 on-call rotation.

Conhecimentos

Analytical thinking

Troubleshooting

Team collaboration

Portuguese & English proficiency

Formação académica

Bachelor's degree in Computer Science or Information Systems

Ferramentas

PostgreSQL

MongoDB

Oracle Database

Microsoft SQL Server

CI/CD pipelines

SQL performance tuning

Database security

Backup/Recovery

Descrição da oferta de emprego

Tel.: [phone] - Lisboa
Tel.: [phone] - Braga
Fax: [phone]
(Chamada para a rede fixa nacional) (Call to the national fixed network)

Database Management Specialist/Services Coordination

# Think Data Be Smart #

About Us:DataSmartis a Portuguese company, positioning itself as a consulting company of excellence, with over 20 years of existence. We are specialized in Technologies and Information Systems services, for the Portuguese and International markets. We pride ourselves on fostering a culture of involvement, experience, and excellence.

Join our team as a Database Management Specialist/Services Coordination(Hybrid – Porto)!

What You’ll Do:

• Manage the full lifecycle of database platforms and related components.
• Administer and maintain PostgreSQL and MongoDB environments (on-premises and cloud).
• Support and maintain Oracle and Microsoft SQL Server databases (on-premises and cloud).
• Design, implement, and test backup, recovery, high availability (HA), and disaster recovery (DR) solutions, ensuring RTO/RPO objectives are met.
• Monitor database capacity, including storage, CPU, memory, and disk usage, and plan future resource requirements.
• Manage database security at both the system and application levels, including user access, authentication, roles, and permissions.
• Analyze and optimize SQL queries using performance analysis tools (e.g., Explain Plan, AWR, profilers).
• Collaborate with development teams to design and optimize database schemas, tables, indexes, and views.
• Manage database deployments, schema changes, and releases through CI/CD pipelines.
• Troubleshoot database incidents, perform root cause analysis, and resolve operational issues.
• Improve database monitoring, automation, and error-prevention processes.
• Recommend and implement operational improvements aligned with database best practices.
• Participate in database-related projects and infrastructure initiatives.
• Take part in a 24/7 on-call rotation to support production environments.

Qualifications:

• 5+ years of experience in Database Administration or Database Services Coordination.
• Degree in Computer Science, Information Systems, or a related field.
• Strong hands-on experience with PostgreSQL and MongoDB in both on-premises and cloud environments.
• Experience with Oracle Database and/or Microsoft SQL Server administration.
• Knowledge of database lifecycle management, maintenance, and upgrades.
• Experience with backup, recovery, high availability (HA), and disaster recovery (DR) solutions.
• Understanding of capacity planning, performance tuning, and resource optimization.
• Experience implementing database security, including user management, roles, privileges, and authentication.
• Strong SQL performance tuning and query optimization skills.
• Experience with database schema management, deployments, and CI/CD processes.
• Strong troubleshooting, incident resolution, and root cause analysis skills.
• Experience with database monitoring and automation tools.
• Relevant certifications in PostgreSQL, MongoDB, Oracle, or Microsoft SQL Server (preferred).
• Native Portuguese and English (minimum B1).
• Availability to work in a hybrid model (at least two days per week in Maia).
• Availability to participate in a 24/7 on-call rotation.
• Commitment to continuous learning and keeping up to date with database technologies.

AtDataSmart, you will have the opportunity to integrate into a solid company and participate in projects of high recognition, nationally and internationally, with an appealing technological environment and career progression.

Excellence in the way to the future!

#JoinOurTeam #DataSmart #ThinkDataBeSmart #postreSQL #MongoDB

Do you accept the challenge?
We are waiting for you!