t
thiago_tmf

Thiago M

@thiago_tmf

PostgreSQL DBA, Performance Tuning and Python Automation

Brasil
Português, Inglês
Algumas informações são exibidas no idioma inglês.
Sobre mim
With approximately 3 years of experience in the IT field, I specialize in Python programming, focusing on database management and data analysis. I have a strong proficiency in working with various database management systems (DBMS) such as PostgreSQL and Oracle. My skills encompass developing robust database solutions, performing comprehensive data analysis, and leveraging Python to streamline and optimize processes. I'm dedicated to delivering high-quality, efficient solutions tailored to your specific needs. ... Saiba mais

Habilidades

t
thiago_tmf
Thiago M
offline • 
Tempo médio de resposta: 1 hora

Conheça meus serviços

Administração de Banco de Dados (DBA)
I will be your postgresql dba for tuning, backup and replication

Portfólio

Experiência profissional

Governo_do Estado do Ceará

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