DBA Analyst, Mid-level (PostgreSQL)

Role Overview

• PostgreSQL Database Administration: Installation and Configuration: Perform installation, configuration, and upgrades of PostgreSQL servers across different environments (on-premises, cloud).
• High Availability: Create hot-standby replicas and perform replica promotion.
• Capacity Management: Monitor disk space and other resource usage, planning and implementing scalability strategies to ensure adequate database capacity.
• Documentation: Create and maintain detailed technical documentation of database configuration, architecture, and procedures.
• Upgrades and Migrations: Plan and execute PostgreSQL upgrades. Migrate data between different PostgreSQL versions.
• SQL Development and Queries: Write and optimize complex SQL queries. Create and maintain stored procedures, functions, and triggers. Knowledge of PL/pgSQL. Execute SQL scripts (DDL and DML).
• Database Modeling and Design: Design database schemas. Normalize and denormalize data. Implement indexes and foreign keys.
• Performance Tuning and Troubleshooting: Identify and resolve performance issues. Analyze and optimize slow queries. Investigate incidents (troubleshooting). Analyze performance, perform DBMS tuning, or recommend improvements to application maintenance teams. Monitor server resources and perform operating system tuning for PostgreSQL.
• Backup and Data Recovery: Develop and execute backup strategies. Plan disaster recovery. Experience with tools such as pg_dump and pg_basebackup. Monitor routine operations (backups, VACUUM, restore tests).
• Database Security: Implement and maintain database access security policies, managing users, roles, and permissions. Audit access and activity logs.
• Complementary Tools and Technologies: Familiarity with PostgreSQL log analysis tools such as pgBadger. Experience with monitoring tools like Zabbix or Grafana. Experience with Linux operating systems, particularly for PostgreSQL optimization. Scripting in Bash, Python, or other relevant languages to automate administrative tasks. Experience in high availability and disaster recovery (HA/DR) environments. Knowledge of clustering and replication technologies such as Barman, Pgpool, or PgBouncer.

Requirements

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

Tech Stack

• Grafana
• Linux
• Postgres
• Prometheus
• Python
• SQL

Benefits

• Meal or Food Allowance (Meal Ticket) to support balanced meals.
• Group Bradesco Health Plan to support your and your family's well-being.
• Dental Plan to keep you smiling.
• Group Life Insurance.
• Commuter Allowance for in-office attendance.
• Partnership with SESC (service/concession benefits).