t
thiago_tmf

Thiago M

@thiago_tmf

PostgreSQL DBA, Performance Tuning and Python Automation

Brasilien
Portugiesisch, Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
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. ... Mehr lesen

Kompetenzen

t
thiago_tmf
Thiago M
offline • 
Durchschnittliche Antwortzeit: 1 Stunde

Meine Dienstleistungen

Datenbankadministrator
I will be your postgresql dba for tuning, backup and replication

Portfolio

Arbeitserfahrung

Governo_do Estado do Ceará

Database Administrator (PostgreSQL)

Governo do Estado do Ceará • Vollzeit

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