t
thiago_tmf

Thiago M

@thiago_tmf

PostgreSQL DBA, Performance Tuning and Python Automation

Brazil
Portuguese, English
About me
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. ... Read more

Skills

t
thiago_tmf
Thiago M
Offline • 
Average response time: 1 hour

See my services

Database Administration (DBA)
I will be your postgresql dba for tuning, backup and replication

Portfolio

Work experience

Governo_do Estado do Ceará

Database Administrator (PostgreSQL)

Governo do Estado do Ceará • Full-time

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