
Thiago M
PostgreSQL DBA, Performance Tuning and Python Automation
Habilidades

Conheça meus serviços

Portfólio
Experiência profissional
Database Administrator (PostgreSQL)
Governo do Estado do Ceará • Período integral
Jan 2022 - Present • 4 yrs 10 mos
PostgreSQL DBA responsible for production databases at a state government agency in Ceará, Brazil. Also appointed as the information security focal point for database administration in the state's information security program. - Performance tuning, indexing and query optimization - Backup strategy with pg_basebackup, WAL archiving and Point-in-Time Recovery (PITR) - Troubleshooting authentication (pg_hba.conf), roles and permissions - Managing multiple PostgreSQL versions (9.6 to 18) on Linux and Windows - Automation and scripting with Python