Arquiteto de Banco de Dados PostgreSQL
Tasks
- Administer PostgreSQL clusters
- Analyze PostgreSQL and Patroni logs
- Analyze query execution plans
- Apply OS and database stack patching
- Conduct RCA and incident reports
- Configure storage RAID and ext4 noatime
- Maintain HA infrastructure
- Manage replication and failover
- Monitor cluster health
- Optimize memory HugePages and swappiness
- Perform safe switchover with patronictl
- Resolve synchronous replication failures
- Troubleshoot outages and performance
- Tune Linux kernel parameters
- Tune PostgreSQL performance parameters
Perks/Benefits
- N/A
Skills/Tech-stack
Capacity Planning | Debian | Etcd | Execution Plans | Ext4 | HugePage | HugePages | HugePages memory | Keepalived | Kernel tuning | Linux | Linux Kernel | Linux Kernel Tuning | Patroni | PostgreSQL | Query Execution | Query execution plans | RAID | RAID Storage | RAID topology | RAID10 | Shared_buffers | Split Brain | Synchronous replication | System down | Systemd | TLS | Timeline mismatch | Turbo settings | WAL | Work_mem
Related jobs
-
Amazon RDS | Ansible | Azure SQL | Azure SQL Database | Big DataDental insurance | Extended maternity leave | Fitness membership | Health insurance | Language programSenior-level Full TimeEKT-0023-Campinas Sede, Brazil5d ago
-
Mid Level Analyst - Tableau Platform Admin (Tempo Determinado De 6 Meses - Afirmativa Para Mulheres) (34263) BRL 21K-24KCheckmk | ITIL | Jira | Linux | New RelicFlexible working hours | Home office | Life insurance | Meal vouchers | Medical and dental insuranceEntry-level Full TimeCampinas, SP, Brazil13d ago
-
Database Administrator BRL 234K-295KAmazon Aurora | Amazon RDS | Database Indexing | Database performance | Database performance tuningApple equipment | Birthday off | Discounts | English program | Extended maternity leaveSenior-level Full TimeVitória, Espírito Santo18d ago
-
AWS | Apache Flink | Apache Hadoop | Apache Hive | Apache ImpalaCareer development access | Employee resource groups | Flexible work from home | Generous paid time off | Paid volunteer timeMid-level Full TimeBrazil-Remote R19d ago
-
Automation | Database Administration | Database Backup | Database Migration | Database RestoreInternational environment | Paid sick leave | Paid vacation | Remote workMid-level Full TimeBrazil27d ago
-
Solutions Architect, Model Builder - LATAM BRL 304K-370KAPI Integration | Agents SDK | Benchmarking | C++ | CI/CDSenior-level Full TimeBrazil, Sao Paulo28d ago
-
Senior Data Engineer (SQL DBA) BRL 234K-368KAccess Control | Auditing | Backup and Recovery | Data Governance | Database AdministrationSenior-level Full TimeRio de Janeiro, RJ, Brazil R1mo ago