PostgreSQL DBA

We are looking for a PostgreSQL DBA who wants to learn and transform his career.
Requirements:
Strong hands-on experience as a PostgreSQL DBA
Practical experience with AWS RDS for PostgreSQL and EC2-hosted PostgreSQL
In-depth knowledge of PostgreSQL architecture (WAL, MVCC, vacuum, autovacuum)
Experience with backup, recovery, and PITR
Strong skills in performance tuning and query optimization
Good understanding of replication, HA, and DR architectures
Working knowledge of AWS services: RDS, EC2, CloudWatch, IAM, S3
Proficiency in SQL and PostgreSQL utilities
Experience with Linux/Unix systems
Familiarity with parameter groups, maintenance windows, and storage management
Exposure to security and compliance best practices
Ability to support large, mission-critical production environments
Good communication, documentation, and troubleshooting skills
Key Responsibilities:
nstall, configure, and administer PostgreSQL databases on AWS RDS and EC2
Manage day-to-day PostgreSQL operations across Dev, Test, UAT, and Production
Monitor database health, availability, and performance using CloudWatch, Performance Insights, and native PostgreSQL tools
Perform backup and recovery using RDS automated backups, snapshots, pg_dump, pg_basebackup, and WAL archiving
Design and maintain High Availability and Disaster Recovery solutions using RDS Multi-AZ, Read Replicas, and EC2-based standby setups
Perform database performance tuning, including query optimization, indexing, vacuuming, and configuration tuning
Troubleshoot database issues such as slow queries, locks, deadlocks, replication lag, and connection problems
Manage PostgreSQL replication (RDS read replicas, logical replication, streaming replication on EC2)
Handle database upgrades, patching, and migrations (major and minor versions)
Manage database security, including users, roles, privileges, SSL, parameter groups, and IAM-based access (where applicable)
Implement and maintain monitoring, alerting, and capacity planning
Support database scaling activities (vertical and horizontal scaling on AWS)
Coordinate with application, DevOps, and infrastructure teams during releases and incidents
Automate routine DBA tasks using shell scripting / Python
Troubleshoot and resolve production incidents; perform root cause analysis
Maintain DBA documentation, SOPs, and runbooks
Participate in 24x7 on-call and production support

What do we offer?
Health insurance
Dental Plan
Life insurance
Meal/Food Voucher
Childcare assistance
Total Pass
Free 0800 that provides psychological assistance (24 hrs/day), legal, social and financial assistance to associates
Partnership with SESC
Reimbursement of Certifications
Learning Portal – Online courses and live training
International experience opportunity
Discount Partnership with Universities and Language Schools
Bring Your Buddy – By referring people you become eligible to receive a bonus for each hire
Recognition for performance
Xcelerate – Free Mentoring Career Platform

• Local de trabalho: Barueri, SP
• Regime de contratação de tipo: Efetivo – CLT
• Jornada: Período Integral
• Área e especialização profissional: Informática, TI, Telecomunicações - Informática
• Nível hierárquico: Analista

VALORIZADO

Tempo de experiência: Entre 5 e 10 anos