Michael has 7+ 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.
Provide support for database related issues, including performance, security, locks, bugs, connectivity, and auditing.
Establish the needs of users and monitor user access and security. Monitor performance and manage parameters in order to provide fast responses to front-end users.
Maximize service availability and oversee database security.
Participated in cross platform migrations such as Oracle to PostgreSQL. Documented and assisted in Data MIGRATION from ORACLE Databases to PostgreSQL database on premises and in AWS Cloud.
Managed and monitored databases using pgAdmin and queried using tools like DBeaver and Sql workbench. Used pgBadger, pgHero and pgbouncerHero for Performance TUNING as well as SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY.
Tuned PostgreSQL server settings and troubleshooted performance issues. Managed Users and Tablespaces on PostgreSQL Servers.Migrated databases from Oracle10G,11g and 12c to PostgreSQL and applied patches whenever required.
Proactively monitored the SQL database servers to ensure high performance and RDBMS optimization design. Reviewed the performance of databases tuning on a periodic basis.
Documented and assisted in Data migration from Oracle Databases to PostgreSQL database on premises and in AWS Cloud. Involved in Installing/configuring PostgreSQL version 9.6 to 11.
Create and configure Oracle security and policies using Oracle Enterprise Manager. Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT. Participated in 24 X 7 Production & Development database support and administration.
Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.
Worked with the Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF.
I migrated oracle databases Using the schema conversion tool(SCT) which converted the objects, schemas, and store procedures. The Data Migration Service (DMS ) was used in transferring the data to PostgreSQL.
I have used Tools like SCT and DMS, Ora2pg, MTK, ANSIBLE, GIT, JENKINS. Championed database migration from Oracle to PostgreSQL on-premises and on AWS, using Migration Tool Kit, Ora2pg, DMS, and SCT.
