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
-
Administrador de Dados - Engenharia e modelagem BRL 21K-23KCA Gen | DB2 | DCL | DDL | DMLDental plan | Gympass | Health insurance | Life insurance | Meal or food voucherEntry-level Full TimeRemoto, Brasil R8h ago
-
CA Gen | DB2 | DCL | DDL | DMLDental insurance | Gym membership support | Health insurance | Life insurance | Meal or food allowanceMid-level Full TimeBrazil16h ago
-
Senior Database Administrator (DBA) - Software BRL 234K-316KAWS Aurora | AWS DMS | AWS Data | AWS Data Migration | AWS Data Migration ServicePaid time off | Remote work | Work with autonomy | Work with top American companiesSenior-level Full TimeSão Paulo R1d ago
-
BI | Big Data | CA Gen | DB2 | DCLDental insurance | Gym membership | Health insurance | Life insurance | Meal allowanceEntry-level Full TimeRemoto, Brasil R4d ago
-
Líder Técnico Dados (Híbrido/SP)- 133217 BRL 54K-72KAWS | Apache Spark | Azure | Big Data | Cloud ArchitectureAgile team collaboration | Hybrid work | Mentoring supportSenior-level Full TimeAlphaville - Barueri, BR, 06.454-000 R14d ago
-
DevOps Architect BRL 240K-275KAmazon Linux | Ansible | Azure | Bash | CI/CDExchange program | Health insurance | Life insurance | OPD | Paid time offSenior-level Full TimeBrazil - Remote R18d ago
-
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, Brazil26d 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 Santo1mo ago
-
Solutions Architect, Model Builder - LATAM BRL 304K-370KAPI Integration | Agents SDK | Benchmarking | C++ | CI/CDSenior-level Full TimeBrazil, Sao Paulo1mo ago