TIAGO JOSÉ ADAMI

• Company Overview: www.tallertechnologies.com
• Customer Venmo / PayPal Inc (San José - CA, USA)
• Designed and maintained PostgreSQL architecture (tables, partitions, indexes, MQTs, and more).
• Created and improved complex SQL queries of Data.Warehouses databases in PostgreSQL and GCP BigQuery.
• Monitored and improved database performance by tuning AWS RDS Aurora QPM plans for SQL queries.
• Collaborated on creation of Blue to Green database migration for Global Aurora PostgreSQL databases using logical replication for mission critical database environments with SLA of 99.9995% of availability.
• Improved database performance by optimizing SQL queries and implementing efficient indexing strategies.

• Company Overview: www.devgrid.co.uk
• Customer PAHO - Pan American Health Organization (UN/WHO - United Nations World Health Organization for Americas).
• Developed and implemented data pipelines to ingest, store and process Excel datasets using (WHO/PAHO xMart ETL tool) from 30 latin american countries + USA and Canada.
• Documented processes related to database design, configuration, and performance.
• Created ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Coordinated database development and determine project scope and limitations.
• Developed logical data models for applications: tables, views, and related database structures (Microsoft SQL Server).
• Created PowerBI dashboards for weekly epidemiological bulletins.
• Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.

• Company Overview: www.kyndryl.com
• Customer FedEx Corporation (Memphis - TN, USA).
• Managed authorizations and security settings for IBM Db2 pureScale databases.
• Automated security authorization validations using Python 3 scripts.
• Created database maintenance plans using Python 3 and shell scripts.
• Converted mainframe data encoded in EBCDIC to Linux UTF-8 CODEUNITS32 using SQL and bash scripts.
• Provided technical support for database applications and systems, including troubleshooting, and resolving performance issues
• Administrated IBM Db2 pureScale clusters - including IBM Spectrum Scale (GPFS) disk clusters on Red Hat Linux Enterprise.
• Provided technical support for application teams to migrate COBOL packages to Java packages within IBM Db2
• Migrated database objects using procedural languages from IBM DB2 on Z/OS (mainframe) and Microsoft SQL Server (T-SQL) to IBM Db2 on Linux (SQL/PL).

Company Overview: www.kyndryl.com

• Customer IBM Corporation (Armonk - NY, USA).
• This is a continuation of the previous experience working at IBM.
• The very same role and responsibilities. Separation is needed since Kyndryl was created by IBM and then hired Kyndryl to continue supporting the same systems/applications with the same teams.
• Please refer to the previous job experience at IBM.

• Company Overview: www.ibm.com
• Working for internal IBM financial accounts and Wall Street Systems.
• Supported 18+ IBM's financial accounts tied to Wall Street operations, most of them mission critical and subject to SOx and SEC audit.
• Administered over 80+ Linux servers and 200+ IBM Db2 databases on x86-64 and S/390 architectures.
• Designed and created a toolkit called DB2MGTK to migrate IBM Db2 databases between different and incompatible ENDIAN code sets, all built using SQL Procedural Language (SQL/PL), SQL language and Linux Bash shell scripts (full database rebuild).
• Managed server's Cobaltiron software for cloud backups
• Monitored databases and servers' using Dynatrace.
• Implemented security audit and health check for Unix, Linux and Db2 databases according to IBM policies.
• Automated OS and database routines using Linux Bash shell scripts, Java, Python 3, Perl and Ansible playbooks.
• Created a set of Ansible playbooks that reduced health check validations from 22 days of manual labor to less than 2 hours.
• Maintained a legacy IBM database maintenance toolkit written in Perl, contributing to the migration to Python 3.
• Optimized database complex queries (SQL optimization) and routines reducing IBM Cognos reporting time from hours to less than 15 minutes.
• Responded to IBM's internal and external audits, including Sarbanes-Oxley (SOx) and SEC audits.
• Collaborated to design and create database models for many software applications (physical and logical layout).
• Developed database objects using SQL and Procedural SQL (T-SQL, SQL/PL, PL/SQL): triggers, stored procedures, functions, MQT and views.

• Company Overview: www.powerdba.com.br
• Self-owned company to work on small contracts/freelance jobs.
• Many customers, national and international.
• Automated data loading processes from various sources including IoT software applications, flat files, Excel spreadsheets and other databases.
• Designed and built ETL and ELT data pipelines for national and global retail/wholesale companies for CRM/ERP/WMS systems, including Data Warehouse and BI operations.
• Created data pipelines using Google Pub/Sub, Pentaho, SAP BO, Python 2/3, Java, and Linux Bash shell scripts.
• Created reports and data processing pipelines using Google Cloud Big Query leveraging its power and reducing costs by using data partitioning and data fragmentation techniques.
• Created on-cloud backup procedures for database and related files in Google Cloud Buckets to ensure data recovery in case of hardware and software failure.
• Created and managed virtual machines on AWS EC2 and GCP Compute Engines.
• Created and administered PostgreSQL databases on-premises and AWS RDS and GCP Cloud SQL clouds.
• Designed and created reports using SQL language for Sybase Infomaker, Jasper Reports/iReports, and SAP BO.
• Designed and created dashboards in Microsoft PowerBI, Tableau, SAP BO, and Qlik Quick View.
• Developed software modules on Java Web Applications using Struts, JSF, Hibernate, Sybase PowerBuilder and Visual FoxPro for ERP, CRM and WMS software.

• Organization Overview: www.utfpr.edu.br
• Troubleshot technical issues with network devices, operating systems, and applications.
• Administrated PostgreSQL and MySQL Databases on-premises.
• Designed and developed a web application for time slot booking of shared resources using PostgreSQL, Java, JSF PrimeFaces, Hibernate, LDAP and Linux - as of now, this software still in use (2025).
• Created automation scripts in Python 3: backups, validation of backups, software install.
• Created ETL/ELT pipelines using XML, Excel, CSV, PostgreSQL and MySQL databases, integrating more than one campus information about student, teachers, projects and classes.
• As a network and infrastructure Sysadmin, maintained, deployed, and migrated ProxMox, VMWare and Xen virtualization host servers; Dell, IBM, and HP physical servers; storage and fiber channel devices; network router and switches; monitoring using Zabbix.

• Company Overview: www.horusinfo.com.br
• Wrote fast performance SQL queries and created dashboards and reports utilizing SAP Business Objects.
• Applied SQL queries to extract, analyze and visualize data from ERP databases.
• Designed customized data collection models for specific visualization tasks.
• Tuned SQL queries to benefit from regular row stored tables to columns stored tables using IBM Db2 BLU feature, reducing complex queries execution time from hours to less than 5 minutes - for some cases.
• Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
• Created ETL procedures using Linux Bash shell scripts and SQL Procedural language for IBM Db2 (SQL/PL) and Microsoft SQL Server (T-SQL).

• Company Overview: www.ciss.com.br
• Managed authentication, authorization and overall database security for IBM Db2 and PostgreSQL databases.
• Designed customized maintenance plans for remote IBM Db2 and PostgreSQL databases using Powershell, Bash and Java.
• Provided technical support for database applications and systems, including troubleshooting, and resolving issues.
• As a DBA administrated 500+ IBM Db2 and PostgreSQL servers, distributed among Windows and Linux for ERP/CRM software.
• Implemented efficient backup and disaster recovery processes with high availability (backup, storage snapshots, IBM Db2 HADR and PostgreSQL replication.).
• Installed and fine-tuned Linux and Windows operating systems on physical and virtualized servers using best practices (RAID, LVM, etc.)
• Created and maintained procedural SQL objects for IBM Db2 (SQL/PL) and PostgreSQL (PL/PgSQL).
• Improved SQL query performance for reports, functions, triggers, stored procedures, and views.

• Company Overview: www.celepar.pr.gov.br
• Designed and developed web applications using Java, Struts + Tiles, Sencha ExtJS, Java JSF, PostgreSQL PL/PgSQL, and Oracle PL/SQL.
• Created 200+ reports using SQL language and Jasper Reports/iReports on Oracle and PostgreSQL databases.
• Optimized SQL query performance for existing reports.
• Designed logical model for Oracle and PostgreSQL databases.
• Created database objects using SQL procedural languages PL/SQL and PL/pgSQL (triggers, functions, procedures, packages, views, and MQT).

• Company Overview: www.ciss.com.br
• Created database backup routines with incremental data storage to reduce storage space.
• Automated ETL processes from various sources including flat files, Excel spreadsheets and other databases using Pentaho and Shell Scripts.
• Maintained up-to-date documentation on all aspects of the deployed databases including architecture diagrams, table structure definitions, ETL processes and backup schedules.
• As a DBA administrated 500+ IBM Db2 and PostgreSQL servers, distributed among Windows and Linux for ERP/CRM software.
• Developed and maintained procedural SQL and SQL ANSI objects for IBM Db2 (SQL/PL) and PostgreSQL (PL/PgSQL): SQL queries for reports, functions, triggers, stored procedures, and views.
• Supported development teams to create efficient software routines enhancing performance and data integrity, creating and fixing many software objects (functions and routines) which used SQL.
• Improved database performance by optimizing queries and implementing efficient indexing strategies.

• Company Overview: www.sssistemas.com
• Collaborated with other developers to integrate 1 legacy ERP software and 1 CRM software through API in Java and Database Stored Procedures.
• Maintained databases by writing complex SQL queries and stored procedures.
• Designed and documented re-engineering of current company's ERP software written in Visual FoxPro to Java EE platform with PostgreSQL.
• Designed and developed an application for complete software life cycle control using Sybase PowerBuilder and PostgreSQL, integrating test cases, software artifacts, version control software and customer tickets in a complex environment where the tools available at time were too expensive and did not fit to the company's development process (MaSSter software). The software helped to reduce the compiling and deployment time of the main ERP project from 4+ hours to less than 30 minutes.

• Company Overview: www.politec.com.br
• Customer HSBC Bank Brazil S/A.
• Conducted user acceptance testing to evaluate system performance and adherence to requirements.
• Maintained and enhanced software for home-broker software using Sybase PowerBuilder, Java, SQL ANSI, Sybase T-SQL, and Oracle PL/SQL.
• Developed and implemented workflow templates, prioritizing efficiency and ease-of-use for end-users of HSBC Home Broker customer compliant software (BKS), reducing the time of document validation from ~1 hour to less than 20 minutes.
• Improved document storage changing it from database tables using BLOB columns to a local NAS secured and compressed storage (application code redirection and migration), reducing the size of the database from 1+ Terabyte to less than 200 GB - since files were not stored in the database anymore.

• Company Overview: https://ciandt.com/
• Customer XM Satellite Radio (now Cirrus XM).
• Developed SQL queries, stored procedures, functions, and views to support the development of business intelligence solutions.
• Performed troubleshooting activities related to Data Warehouse issues like connectivity problems or query optimization.
• Created and maintained ETL pipelines to integrated SIEBEL, SAP and PEOPLESOFT databases into a Data Warehouse for BI and reporting, using Linux/Unix shell scripts, Informatica Powercenter and Oracle PL/SQL.
• Improved SQL Query performance rewriting code using CTE and using efficient index strategies.

• Company Overview: www.sssistemas.com
• Collaborated with stakeholders to define project scope and objectives.
• Developed test plans and scripts to ensure functional requirements were met.
• Investigated issues reported by users to determine root cause of problems.
• Developed and maintained ERP software using Visual FoxPro and PostgreSQL database.
• Developed fast and optimized reports in SQL language for Crystal Reports (now SAP BO) and JasperReports.
• Designed database for ERP software (logical model) and also created database objects using SQL and PL/PgSQL languages: queries, functions, and views.
• Improved SQL query performance for many queries, reducing hardware requirements for the PostgreSQL database server for the ERP software.

• Company Overview: www.ciss.com.br
• Developed and maintained ERP software built in Sybase PowerBuilder using PostgreSQL, Sybase, and IBM DB2 LUW databases.
• Developed SQL queries and reports using Sybase Infomaker with cross database compatibility (PostgreSQL / Sybase / IBM Db2).
• Developed many database objects using Sybase T-SQL, IBM Db2 SQL/PL and PostgreSQL PL/pgSQL procedural languages (views, triggers, functions, stored procedures and MQTs).
• Collaborated with DBAs and DBEs to create physical and logical design of ERP database.
• Improved overall software performance by 80% refactoring Sybase PowerBuilder object notation to use builtin Get and Set functions.