Engineer Oracle
Resume:
OLAWALE OLADIPUPO
Database Engineer
**************@*****.***
PROFESSIONAL SUMMARY
IT professional with 7 years’ experience as an MS SQL Server, Oracle, AWS, Azure and PostgreSQL Database Administrator. I have worked on different platforms such as Linux, UNIX, Solaris, and Windows. I have hands on experience in database installation, configuration, production, development, and project support as well as performance tuning, upgrades and patches, backup and recovery, database security, database refreshes, database migration, Dataguard, RAC and Oracle Golden Gate. I also have hands on experience on Streaming Replication, Master and Slave for high availability. I am proactive, an exceptional team player with strong analytical and problem-solving skills.
TECHNICAL SKILLS
Migrations from MS SQL Server databases (2008, 2012,2017, 2019) to Azure.
Perform Installations, Upgrades, Patching,
Disaster recovery: SQL Recovery Tool, Backup and Restore, Fail-over clustering, Log shipping, Database replication, Always on and Availability groups. High Availability-, SQL Server: (Azure).
Performance Tuning (Partitioning, indexing, T-SQL, query optimization, Server tuning)
REPLICATION: SQL Server : ( Native SQL Server Replication (Snapshot replication, Transactional replication, Peer-to-peer replication).
Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
Database & Software experience such as Oracle - 10g, 11g and 12c (OLTP and OLAP databases) and PostgreSQL – 9.x, 10.x, 11.x.
Experience using Pg_Admin, Pg_Bouncer, Psql, Pg_Badge, Pg_basebackup, Pg_backrest, Pg_dump, Pg_restore, Pg_upgrade, Pg_Hero, EXPLAIN ANAYZE for managing and monitoring purposes on Postgres Servers.
Experience migration from oracle databases to PostgreSQL database in AWS cloud using SCT & DMS.
Experience in DEVOPS, JAVA.
Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS 2012, LINUX and migration of oracle servers.
Good experience in applying Patch set update (PSU) and Critical Patch Update (CPU Patches) on Databases.
Proactive monitoring, identifying areas that need to be improved in the application and database using EXPLAIN PLAN, SQL TRACE, AWR, ADDM, and 12c OEM Cloud control Monitoring.
Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g RAC servers for the purpose of disaster recovery procedures.
24/7 support for Production databases and responsible for round-the-clock database operations.
Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group.
Strong experience in Ansible automation Toll for Configuration Management & Deployment.
Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
Experience in Cloning the process of copying an existing Oracle installation to a different location.
PROFESSIONAL EXPERIENCE
BERGDORF GOODMAN -NEW YORK
JULY 2020 - Present
Database Engineer (SQL Server, PostgreSQL & Oracle)
Experience with High Availability and Disaster Recovery solutions for SQL Server.
Perform installations and upgrades of PostgreSQL Servers.
Create and maintain fully CI/CD Pipelines for code deployments using PowerShell.
Providing database security administration such as User ID’s, Passwords, roles, etc
Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade.
Managed and monitored databases on Oracle, PostgreSQL & SQL Server.
Providing 24/7 PRODUCTION SUPPORT based on a ticketing system.
Involve in installing / Configuring MS Server 2012,2014, 2017 and have configured MS SQL Server database on Azure.
Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
Expert knowledge in Oracle to Postgres DB Migrations.
Knowledge on MS SQL Server Backup, Restore and recovery.
Good at performance tuning of SQL Sever database, making good use of Explain plan and Activity Monitor
MasterCard – O’Fallon, MO
November 2019 – MAY 2020
Database Engineer
•Perform installations and upgrades of PostgreSQL Servers.
•Plan and perform DB Patching.
•Knowledge of Database backups / Troubleshoot failures, query execution plans, performance tuning techniques.
•Support Azure Cloud architecture design/planning, management, support, and oversight of the Azure PaaS/IaaS environment.
•Define maintenance plans.
•Configure / Troubleshoot Replication (BSR / xDB SMR / xDB MMR)
•Set up disaster recovery, Perform Fail-over and Fail-back.
•Experience in Scripting and Ansible automation Toll for Configuration Management & Deployment
•Hands-on knowledge in Oracle to Postgres DB Migration
•Monitor servers through PEM
•Experience with latest versions of PostgreSQL EDB.
•Capacity planning
•Script database changes
•Knowledge of NOSQL databases
•Experience in DEVOPS
•User Administration and Security
Quest Technologies - Marlboro, MA
February 2017 – Nov 2019
Database Administrator/ Engineer
Experience in Replication of Data bases using Oracle Streams and Logical Standby.
Exposure to cross platform migrations preferably oracle to PostgreSQL.
Documented and assisted as an oracle dba data migration from oracle databases to PostgreSQL database in AWS cloud.
Installed/configured SQL Server, PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSIONS 10).
Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade for SQL Server.
Proactively managed standby replication and hot standby for disaster recovery.
Managed and monitored these databases using pgAdmin, psql,
Used pg_Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY
Created roles, granting privileges, creating tables, use of indexes, and primary & foreign key constraints as required
Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.
Used Pg_Bouncer for connection pooling, pg_Badge for generating statistic reports
Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.
Working knowledge of pgAdmin and psql tools.
Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
Configured a replication between master and slave, and monitoring on-going replication
Upgrading database version using pg_dump/pg_restore and pg_upgrade tools and updating the latest security patches to database, which are provided by PostgreSQL open source community.
Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema.
Hands on experience on restoration techniques on PostgreSQL like pg_restore and (PITR) Point in Time Recovery.
Familiar backups (pg_basebackup, pg_backrest, pg_dump,) and restore, compressed (gzip) backups, database or schema refreshes
Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
Developed Shell scripts, SQL & PL/SQL scripts for monitoring GoldenGate processes and stats running.
Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
Worked with RAC implementation team. Added nodes.
Knowledge writing database triggers, packages, procedures, functions, utilities for application development.
Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
Maintained the data integrity and security using integrity constraints and database triggers.
Provided 24X7 supports for all the production and development databases.
Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
Generated AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events.
Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
Honor Health - Phoenix, AZ
February 2014 - January 2017
Oracle Database Administrator
Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
Implemented 11g Database compression feature for Development and test Instances to reduce the size of databases which help the client to save huge disk space.
Applied PSU and CPU Patches as a part of maintenance activity.
Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM), Active Session History (ASH), Explain Plan, and TKPROF utilities.
Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
Used Data pump for exporting and importing tables, schemas and table spaces.
Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, and Connection Manager.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
EDUCATION & CERTICATIONS
AWS Certified Solution Architect
EDB Certified Associate – Postgres
Oracle OCA
Sql Fundamental
Agile Scrum Master
Bachelor of Science
University Of Abuja, Federal Capital Territory - Major in Management Science
Contact this candidate