Sr Postgres DBA

PRGX; Ciudad de México; Presencial; MXN 600,000 - 800,000; Jornada completa

Descripción de la vacante

A leading data analytics firm in Mexico City seeks a Senior PostgreSQL DBA to manage and optimize database environments. This role requires expertise in PostgreSQL, effective communication, and experience with automation. Ideal candidates will have over 6 years’ experience in database administration, ensuring data integrity and high availability while collaborating with various teams. Offer includes a competitive salary.

Formación

• 6+ years of experience as a DBA with a focus on PostgreSQL.
• Deep understanding of PostgreSQL architecture.
• Experience with ISO compliance and data security.

Responsabilidades

• Install, configure, monitor, and troubleshoot PostgreSQL databases.
• Analyze and optimize database performance.
• Design and maintain high availability solutions.

Conocimientos

PostgreSQL expertise

SQL proficiency

Automation scripting (Bash, Python)

Database performance optimization

Communication skills

Herramientas

Database monitoring tools

MSSQL

MongoDB

Descripción del empleo

About PRGX Global, Inc Job Description

Job Title

Sr Postgres DBA

Employment Type

Full-time

Work Authorization Requirements

Authorized to work in Mexico without sponsorship

Language Requirements

Fluent English

About PRGX

PRGX is the global leader in source-to-pay data analytics and software, and tech-enabled profit recovery services. We provide software and services to maximize revenue recovery and drive margin improvement for our clients. For more information about PRGX, visit www.prgx.com.

Job Duties & Responsibilities

• Install, configure, monitor, maintain, and troubleshoot PostgreSQL databases across various environments (development, testing, production). This includes managing replication (streaming, logical), backups, and recovery procedures.

• Analyze and optimize database performance, including query optimization, indexing strategies, and server configuration tuning to ensure high throughput and low latency.

• Design, implement, and maintain high availability (HA) and disaster recovery (DR) solutions to ensure continuous database operation and data integrity.

• Implement and enforce database security policies, manage user permissions, and ensure compliance with relevant data security standards.

• Work closely with development, DevOps, and other engineering teams to design, implement, and optimize database solutions for applications. Provide support and guidance on database-related issues.

• Develop and utilize scripts (e.g., Bash, Python) to automate routine database tasks, improve efficiency, and streamline operations.

• Implement and manage database monitoring tools to proactively identify and resolve performance or availability issues.

• Create and maintain comprehensive documentation for database environments, standards, and procedures.

• Plan for future storage requirements and database growth, and design scalable database architectures.

Knowledge & Qualifications

• Extensive experience as a DBA, with a 6+ years focus on PostgreSQL.

• Deep understanding of PostgreSQL architecture, features, and best practices.

• Proficiency in SQL and experience with complex query optimization.

• Experience with database monitoring tools and performance analysis.

• Knowledge of high availability and disaster recovery techniques.

• Scripting skills (e.g., Bash, Python, Ansible, AWX) for automation.

• Strong analytical and problem-solving abilities.

• Excellent communication and collaboration skills.

• Experience with MSSQL is required.

• Experience with MongoDB or other document databases is beneficial.

Our Commitment to Equal Opportunity

PRGX is an equal opportunity employer. We comply with all applicable local, national, and international laws regarding non-discrimination and equal employment. We do not discriminate based on any legally protected characteristic and are committed to fostering an inclusive, respectful, and equitable workplace. Reasonable accommodations are available for qualified individuals in accordance with local laws and best practices.

Physical Requirements

Ability to sit or stand for extended periods of time, manual dexterity for typing, writing, or using office equipment, visual acuity for reading screens and documents, ability to lift or carry light items such as laptops, and speech and hearing ability for calls, virtual meetings, and in-person communication

Data Privacy

Your personal data will be handled in accordance with applicable data protection laws. We only collect information necessary for recruitment and will not share your data without your consent.

Skills & Requirements Qualifications

PRGX provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, age, sex, national origin, disability status, genetic information, Protected Veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.