Hybrid Mid-level DBA Analyst, PostgreSQL

at INFOX Tecnologia da Informação

• Job title: Mid-level DBA Analyst, PostgreSQL
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Grafana, Postgres, Prometheus, SQL
• Location requirements: Hybrid, Sao Paulo, Brazil

About the role

• DBA Analyst managing PostgreSQL databases at INFOXER, responsible for database performance, security, and integrity. Working closely with development and infrastructure teams to implement best practices.

Responsibilities

• PostgreSQL Database Administration: installation and configuration.
• High Availability: create and hot-standby replica.
• Capacity Management: monitor disk space usage.
• Documentation: create and maintain detailed technical documentation.
• Upgrades and Migrations: plan and execute PostgreSQL upgrades.
• SQL Development and Queries: write and optimize complex SQL queries.
• Database Modeling and Design: design database schemas.
• Performance Tuning and Troubleshooting: identify and resolve performance issues.
• Backup and Data Recovery: design and execute backup strategies.
• Database Security: implement and maintain access security policies.

Requirements

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or a related field;
• 3 to 5 years of experience in database administration, with at least 2 years focused on PostgreSQL;
• Hands-on experience in production high-availability environments and disaster recovery;
• Proven track record implementing backup and data recovery strategies;
• Experience in PostgreSQL performance optimization and tuning;
• Experience developing complex SQL queries and PL/pgSQL scripts;
• Experience with PostgreSQL version migrations and upgrades;
• Experience with monitoring and observability tools such as Prometheus, Grafana, Zabbix, and the ELK Stack;
• Application of IT service management best practices, including frameworks like ITIL.

Benefits

• Meal or Food Voucher to support balanced meals.
• Group Bradesco Health Plan to support the well-being of you and your family.
• Dental Plan to keep your smile healthy.
• Group Life Insurance.
• Transportation Voucher for on-site office commutes.
• Corporate partnership with SESC.