Sr. Postgresql Dba

Jobgether; Portugal; Remote; EUR 70,000 - 110,000; Full time

Benefits offered by this job

Remoto 100%

Exposição a Fortune 500

Trabalho com PostgreSQL em ambientes m

AWS e ESRI em contexto corporativo

Desenvolvimento profissional contínuo

Job summary

A posição Sr. PostgreSQL DBA para a Jobgether, baseada em Portugal, oferece a oportunidade de apoiar ambientes empresariais críticos.

Será responsável por manter plataformas de bases de dados seguras, estáveis e de alto desempenho, em Linux e Windows, com foco em disponibilidade, integridade de dados e resiliência operacional. Contribuirá com automação para melhoria de processos, monitorização de performance, backup e recuperação, segurança e suporte de produção.

Qualifications

• 5+ anos como DBA PostgreSQL.
• Experiência instalando, configurando, atualizando e solucionando PostgreSQL.
• Experiência em ambientes Linux e Windows.
• Fortes habilidades em PL/pgSQL.
• Gestão de objetos de banco como triggers, indexes e schemas.
• Conhecimentos em monitorização de performance, HA, backup e DR.
• Controlo de segurança, acessos e integridade de dados.
• Capacidade de automatizar a administração de bases de dados.
• Boa comunicação e colaboração em equipas distribuídas.

Responsibilities

• Criar, configurar, manter e otimizar objetos PostgreSQL (triggers, indexes, schemas).
• Desenvolver soluções de automação para administração e loading de dados.
• Instalar e manter PostgreSQL em Linux e Windows.
• Monitorizar performance, identificar bottlenecks e resolver proativamente.
• Suportar HA e garantir disponibilidade para aplicações críticas.
• Gerir utilizadores, papéis, permissões e segurança.
• Realizar backups, recovery e procedimentos de DR.
• Desenvolver e manter PL/pgSQL com loops e lógica condicional.
• Fornecer orientação a equipas de desenvolvimento sobre melhores práticas.
• Contribuir para iniciativas em cloud (AWS) e ESRI Enterprise Geodatabase quando aplicável.

Skills

PostgreSQL

Linux

Windows

PL/pgSQL

Automation

Performance monitoring

Security

Troubleshooting

Communication

Independent work

Tools

AWS

ESRI Enterprise Geodatabase

Automation scripts

Job description

Sr. PostgreSQL DBA

Empresa : Jobgether

Tipo de Emprego : Periodo Integral

Descrição do Emprego - Sr. PostgreSQL DBA

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Sr. PostgreSQL DBA based in Portugal.

This role offers an opportunity for an experienced PostgreSQL database professional to support critical enterprise technology environments. You will be responsible for maintaining reliable, secure, and high-performing database platforms across Linux and Windows environments. Your expertise will help ensure database availability, performance, data integrity, and operational resilience. You will design and maintain database objects while developing automation that improves data-loading and administrative processes. The role also involves performance monitoring, troubleshooting, backup and recovery, security management, and production support. You will collaborate with development and technology teams to provide database best practices and resolve complex data issues efficiently. Experience with AWS and ESRI environments is an advantage for professionals looking to contribute to sophisticated, enterprise-scale systems.

Accountabilities

• Create, configure, maintain, and optimize PostgreSQL database objects, including triggers, indexes, schemas, and relational structures.
• Develop automation solutions to streamline database administration and data-loading processes while improving operational efficiency.
• Install, configure, upgrade, and maintain PostgreSQL databases across both Linux and Windows environments.
• Monitor database performance, identify bottlenecks and potential issues proactively, and implement solutions to maintain reliable and efficient operations.
• Support high availability initiatives and ensure database environments remain resilient and accessible to business-critical applications.
• Manage database users, roles, permissions, and security controls while maintaining strong data integrity and following established best practices.
• Schedule and perform routine database maintenance, backups, recovery activities, and disaster recovery procedures to protect critical data.
• Develop and maintain PL/pgSQL stored procedures and functions using loops, conditional logic, variables, and related programming constructs.
• Troubleshoot and resolve production database and data-related issues promptly, helping minimize operational disruption.
• Provide database architecture and best-practice guidance to development and technology teams and support effective implementation of database solutions.
• Contribute to database initiatives within cloud environments, including AWS, and support specialized platforms such as ESRI Enterprise Geodatabase when applicable.

Requirements

• 5+ years of professional experience working as a PostgreSQL Database Administrator.
• Strong hands-on experience installing, configuring, upgrading, maintaining, and troubleshooting PostgreSQL databases.
• Proven experience supporting database environments running on both Linux and Windows operating systems.
• Strong PL/pgSQL experience, particularly with loops, conditional statements, variables, stored procedures, and functions.
• Experience managing database objects such as triggers, indexes, schemas, and relational structures.
• Solid understanding of database performance monitoring, optimization, high availability, backup, recovery, and disaster recovery practices.
• Experience with database security, including user access, permissions, roles, and data integrity controls.
• Strong troubleshooting and problem-solving skills, with the ability to diagnose and resolve production issues efficiently.
• Ability to develop automation that improves database administration and data-management workflows.
• Strong communication and collaboration skills, with the ability to provide practical technical guidance to development and engineering teams.
• Experience working independently in a fully distributed environment while collaborating effectively with cross-functional technology teams.
• Preferred: Experience working with AWS environments.
• Preferred: Experience with ESRI environments, particularly ESRI Enterprise Geodatabase.

Benefits

• Work Arrangement: 100% remote position.
• Enterprise Exposure: Opportunity to support technology environments for a major Fortune 500 organization.
• Technical Scope: Work with PostgreSQL across Linux and Windows environments and contribute to database performance, security, automation, and resilience.
• Cloud Exposure: Opportunity to work with AWS environments.
• Specialized Technology: Potential exposure to ESRI Enterprise Geodatabase and related enterprise data platforms.
• Professional Impact: Provide database expertise and best-practice guidance on business-critical technology systems.
• Career Development: Strengthen expertise in PostgreSQL administration, automation, high availability, disaster recovery, and enterprise database operations.