Michael O.

Michael O.

Senior PostgreSQL/Oracle Application Engineer & DBA

United States of America
Hire Michael O. Hire Michael O. Hire Michael O.

About Me

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.

PostgreSQL 7 years SQL 6 years PL/pgSQL 4 years PL/SQL 4 years DBA 7 years Oracle 7 years SQL Server 6 years AWS 5 years Axure 4 years

Work history

UpStack
UpStack
Senior PostgreSQL/Oracle Application Engineer & DBA
2021 - Present (4 years)
Remote

  • Providing support for database-related issues including performance, security, locks, bugs, connectivity, and auditing.

  • Establishing user needs and monitoring user access and security.

  • Maximizing service availability and overseeing database security.

  • Monitoring performance and managing parameters to provide fast responses to front-end users.

DBAOraclePostgreSQLPL/pgSQLSQL ServerAWS
Tala
Tala
DevOps Engineer
2022 - Present (3 years)
Remote

Working on the first financial platform for the global majority to reinvent financial infrastructure powered by advanced technology and human creativity.

DevOpsArgoMariaDBTerraformSnowflakeFiveTranETLMySQLAmazon EKS Finance
Raymond James
Raymond James
PostgreSQL/Oracle Applications Engineer
2016 - 2021 (5 years)
United States of America

  • Participated in cross-platform migrations such as Oracle to PostgreSQL.

  • Managed and monitored databases using pgAdmin and queries using tools like DBeaver and SQL Workbench.

  • Tuned PostgreSQL server settings and resolved performance issues.

  • Documented and assisted in data migrations from Oracle to PostgreSQL database on-premises and in AWS Cloud.

  • Managed users and tablespaces on PostgreSQL servers.

  • Migrated databases from Oracle 10g, 11g, and 12c to PostgreSQL and applied patches whenever required.

  • Used pgBadger, pgHero, and pgBouncerHero for performance tuning and EXPLAIN ANAYZE and pg_stat_activity for SQL tuning.

PostgreSQLOracleDBAPL/pgSQLAWSMySQL WorkbenchDBeaverJenkinsChefAnsibleContinuous Integration (CI)Continuous Delivery (CD)pgHeropgBadgerpgbouncerHeroShell ScriptingPowershellGithubData MigrationDatabase Migration Oracle 10gOracle 11gOracle 12cpgAdminPL/SQL Tuning Performance Tuning
American Modern Insurance
American Modern Insurance
Database Administrator
2015 - 2016 (1 year)
United States of America

  • Proactively monitored the SQL database servers to ensure high performance and RDBMS optimization design.

  • Documented and assisted in data migration from Oracle to PostgreSQL database on-premises and in AWS Cloud.

  • Created and configured Oracle security and policies using Oracle Enterprise Manager.

  • Reviewed the performance of database tuning on a periodic basis.

  • Handled logical and physical database backups, helping develop and implement best practices for disaster recovery and backups.

  • Involved in installing and configuring PostgreSQL versions 9.6 to 11.

DBARDBMSSQLPostgreSQLRMANRTO/RPOSQL ServerOracleOracle Cloud ServicespgHeroAWSOracle Enterprise Manager (EM) Data MigrationDatabase Migration Oracle Database Tuning Disaster RecoveryDatabase Backups
Cummins
Cummins
Oracle/PostgreSQL Database Administrator
2013 - 2015 (2 years)
United States of America

  • 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.

DBAPostgreSQLOracleAWSPL/pgSQLMigration Tool KitOra2pgDMSSCTUnixLinuxRMANTuning PackDiagnostics PackSTATSPACKSQL Trace & TKPROFSQLDatabase Migration

Portfolio

PostgreSQL/Oracle Application Engineer & DBA - Migration
PostgreSQL/Oracle Application Engineer & DBA - Migration

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.

PostgreSQL/Oracle Application Engineer & DBA - Migration
PostgreSQL/Oracle Application Engineer & DBA - Migration

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.

PostgreSQL/Oracle Application Engineer & DBA - Migration
PostgreSQL/Oracle Application Engineer & DBA - Migration

Migrated Oracle databases to PostgreSQL on-premises, EDB PostgreSQL, AWS RDS, and Aurora. Migrated SQL Server database to Azure and AWS.

Education

Bachelor's Degree, Cybersecurity
Bachelor's Degree, Cybersecurity
University of Maryland Global Campus
2018 - 2021 (3 years)
BSc International Management
BSc International Management
Anglia Ruskin University - UK
2010 - 2013 (3 years)