Michael has 10+ years of extensive experience as an Oracle Database Admin and PostgreSQL DBA/Applications Engineer. He has knowledge and hands-on experience in database design, migration, upgrades, database security, backup and recovery, cloning, replication, performance monitoring, and tuning. Michael is proficient in an assortment of tools and technologies including Oracle 11g-12c and PostgreSQL 9.4-11.6. He is a leader with strong verbal and technical skills, personalized client service experience, decisive decision-making skills, and a successful track record of performing under pressure in a fast-paced, rapidly changing environment.
Working on the first financial platform for the global majority to reinvent financial infrastructure powered by advanced technology and human creativity.
Worked on database migration from Oracle to PostgreSQL on-premises and on AWS using Migration Tool Kit, Ora2pg, DMS, and SCT.
Rewrote and implemented a backup strategy following company SLA, executing a backup schedule for both physical and logical backups using pg_base_backup, pg_backrest, pg_dumpall, and pg_dump.
Worked with the data pump to take the logical backups of databases and performed point-in-time recovery (PITR) using RMAN.
Participated in 24x7 production & development database support and administration.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, STATSPACK, and SQL Trace & TKPROF.
Migrated Oracle databases using the Schema Conversion Tool (SCT) to convert objects, schemas, and stored procedures. Used Data Migration Service (DMS) to transfer data to PostgreSQL.
Worked on database migration from Oracle to PostgreSQL on-premises and on AWS using Migration Tool Kit (MTK), Ora2pg, DMS, and SCT. Also worked with Ansible, Git, and Jenkins.
