Sr. Postgresql Dba

Jobgether; México; Remote; MXN 800.000 - 1.400.000; Vollzeit

Benefits dieser Stelle

Remote 100%

Fortaleza tecnológica

Entorno Fortune 500

Oportunidad de desarrollo

Zusammenfassung

Jobgether busca un/a Senior DBA de PostgreSQL para liderar la administración de bases de datos en entornos Linux y Windows. El rol contempla desarrollo, optimización, automatización y recuperación ante desastres, con foco en disponibilidad y rendimiento para aplicaciones críticas.

La posición es 100% remota desde México, con interacción directa con equipos de desarrollo y tecnología y exposición a AWS y ESRI Enterprise Geodatabase.

Qualifikationen

• 5+ años de experiencia como PostgreSQL DBA.
• Experiencia sólida instalando, configurando y manteniendo PostgreSQL.
• Experiencia en Linux y Windows, con PL/pgSQL avanzado.
• Capacidad de automatizar tareas y mejorar procesos.

Aufgaben

• Crear, configurar y optimizar objetos de PostgreSQL (triggers, índices, esquemas).
• Desarrollar soluciones de automatización para administración de bases de datos.
• Mantener bases de datos PostgreSQL en Linux y Windows.
• Monitorear rendimiento y resolver cuellos de botella proactivamente.
• Gestionar alta disponibilidad, copias de seguridad y recuperación ante desastres.
• Gestionar usuarios, roles y permisos de seguridad.
• Desarrollar PL/pgSQL con procedimientos y funciones.
• Colaborar con equipos para aplicar buenas prácticas de base de datos.

Kenntnisse

PostgreSQL

PL/pgSQL

Automation

Performance tuning

Linux/Windows

Tools

AWS

ESRI Geodatabase

Backup & DR tooling

Jobbeschreibung

Sr. PostgreSQL DBA

Empresa : Jobgether Tipo de empleo : Tiempo completo Remote / Work from Home

Descripción del trabajo - 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 Mexico.

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.