Ayokunle Giwa
Hicksville,NY
Summary
Senior Cloud / Database Administrator and outstanding performer in cloud database migrations and administration. Proven success in leadership, mentoring, operational excellence and organizational development. Recognized for inspiring management team members to excel and encouraging creative work environments.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Cloud Architect / DBA
Visiting Nurse Service
New York, New York
05.2014 - Current
- Designed, implemented and supported a Multi-Terabyte data warehouse database for reporting and analytics
- Led overall multi-cloud strategy comprising of Azure and AWS database products and services
- Migrated multiple on-prem SQLserver databases to AWS RDS and EC2
- Provided expert level performance tuning for various systems
- Participated in enterprise level technology evaluation and selection for cloud migration strategy for cost reduction
- Oversaw data analysis and database management for Oracle systems including applications upgrades
- Managed a team of six DBAs and ten data warehouse ETL developers
- Converted Informatica ETL jobs to use Azure based databases as target
- Configured extensive alerting and notification for AWS based databases
- Develop database structures, install, configure and implement applications, enhance system and ensure security
- Database administration on open source database technologies including MySQL, PostgreSQL and MongoDB
- Design scripts and develop tools to automate repetitive tasks and improve monitoring of system
- Migrated multi-terabyte Oracle database running on AIX to AWS RDS
- Migrated and upgraded ETL stack including Informatica PowerCenter and BMC Control-M running on AIX to highly available AWS EC2 Linux Red Hat servers
- Installed and configured Oracle Goldengate 12c on AIX
- Configured Oracle Goldengate 12c High Availability using Oracle DBFS and Data Guard
- Deep understanding Oracle Goldengate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate
- Developed home-cooked OGG lag monitoring shell scripts and configured OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 12c
- Led multiple technology enhancement projects
- Redesigned all vendor data feeds and flows to support AWS RDS database and Azure SQL use as endpoint
- Manage business continuity efforts with oversight for backup and recovery of data
- Author database documentation and guidelines to help support system operations for Multi-cloud operations
- Create and maintain data dictionaries, physical databases and logical database models
- Research and evaluate innovative technology solutions, collaborating with cross-functional teams to determine feasibility of deployment
- Implemented Oracle OBIEE version 11.1.1.9 for reporting and analytics and upgraded to 12c
- Developed and maintained backup scheme using RMAN
- Developed PL/SQL ETL code for various third-party vendor feeds
- Designed and Implemented multi-tiered AIX-based environment for deployment of Informatica ETL tool
- Administrator for Subversion code repository
- Modeled and designed databases in support of enterprise reporting and analytics
- Setup continuous integration methodology for release management using Jenkins and Subversion SCM for developed ETL code
- Release manager for ETL/data warehouse development
- Designed and implemented automation scripts using UNIX Korn shell
- Administrator for BMC Control-M enterprise scheduling tool
- Defined technical integration strategy and developed integration plans
- Designed and delivered mission-critical highly available database infrastructure to maintain consistent availability and performance
- Administered application stacks and executed performance tuning
Senior DBA Consultant
Weightwatchers Inc
New York, New York
09.2012 - 04.2014
- Production Oracle database systems support of the company's mission-critical global applications
- Troubleshooting production database issues in a highly dynamic environment
- Performance tuning of complex SQL and PL/SQL in support of multiple business areas
- Implemented Oracle physical standby databases in support of the enterprise-wide high-availability initiative
- Interfaced with business to capture requirements for new systems and database related enhancements
- Member of team supporting web-facing 6-node RAC database on Redhat Linux
- Support application release cycles for multiple applications
- Setup Goldengate 11g replication jobs and managed trails files
- Implemented Bi-directional Goldengate replication between geographically separated database across WAN
- Planned and installed Oracle software and databases on Oracle Sun platform
- General database maintenance activities on both RAC and non-RAC systems
Oxford Global Resources Remote Contractor
General Dynamics Corp Scottsdale AZ
Phoenix, AZ
01.2011 - 05.2011
- Planned and implemented Oracle IAS 10 R2 Upgrade
- Configuration, Installation, and implementation of Oracle Forms & Reports production servers
- Training of DBA team on the administration of Oracle IAS infrastructure and Middle Tier layers
- Comprehensive documentation of GD Oracle IAS 10g R2 Environment
Technical Manager
Database Services, HBO - Time Warner Corp
New York, NY
01.2008 - 11.2010
- Supported a team of 12 database administrators supporting various enterprise applications and report development projects
- Identify, evaluate and recommend enterprise-wide database systems technologies to support business growth
- Provide IT process performance improvement expertise across both application development and database groups within the IT department
- Member of the IT infrastructure committee charged with ensuring the organizations IT infrastructure keeps pace with growth and also identifies opportunities for enhancements that affect company bottom line
- Installed, configured and setup Goldengate data replication
- Liaise and deliberate with application development teams within the IT department
- Provide creative and innovative solutions to enterprise wide application integration and data management issues
- Perform proof of concept on enterprise data management solution and make recommendations to management
- Identify and coordinate training for database group within It department
- Manage relationships with IT solutions vendors
- Provide capacity planning for enterprise database storage
Senior Oracle DBA Consultant
WeightWathcers.com
New York, NY
07.2007 - 12.2007
- Lead project to migrate Windows 2003 based Oracle 9i database to Oracle 10g R2 on Redhat AS 4 (Linux) for both Itanium 64-bit and x86-32-bit servers
- Proof of concept project to select hardware / Operating Systems platform for migration to Linux/UNIX systems ( HP Linux / Itanium & Sun Solaris / SPARC) on Oracle 9.2.x
- Created databases, generated schemas from models and assisted with thetuning of both stored procedures and SQL statements
- Converted windows scripts to shell scripts for process automation
- Created shell scripts to automate several processes such as RMAN backups, schema migration from server to server
- Provided recommendations to management on best practices for Oracle on Linux
- Senior Oracle Database consultant
DBA Consultant
US Foods Inc
Ahwatukee, AZ
08.2004 - 07.2007
- Provided production database support for Oracle databases ranging from 7.3 to 10g
- Provided general database support tasks ranging from database creation, storage management on a terabyte-sized database, indexing strategies, backup using RMAN and Omniback to on-call production DBA support
- Developed Oracle Apex application for the automated staging, tracking, notification and migration of code and script patches / fixes from development to test and production systems Planned, sized, installed and configured Oracle database server software on HP Unix Operating system version 11
- Setup Oracle 10g databases using ASM
- Lead DBA on VLDB project involving pricing engine
- Implemented Oracle Enterprise Manager for 10g (Database monitoring, maintenance and patch management)
- Created a custom backup solution for a special pricing database using data pump and shell scripting
- Performed RAC 10g Installation configuration and administration, including troubleshooting and performance tuning
- OracleAS 10g Discoverer installation, configuration and troubleshooting
- Created UNIX shell scripts in support of general process automation project
- Tuned SQL queries extracted from Peoplesoft system
- Created Sarbanes-Oxley related internal audit compliance self audit reporting process
- Implemented Oracle auditing in support of SOX data security act
- Developed Oracle Apex application for the definition, tracking and application of patches across all US foods applications located on UNIX servers. This system was employed to address the separation of duties stipulation of the SOX compliance regime. The application combined JAVA, Shell scripting and PL/SQL (P.A.M.) Patch Application Manager)
- Provided general database troubleshooting services to a large team of developers and in-house DBAs
Senior Database Consultant
IT Workgroup Inc.
Scottsdale, AZ
10.2003 - 08.2004
- Designed databases for the custom medical practice management system (Venousoft) on Postgresql 7.3
- Created database code for the application (Pg/PSQL packages, procedures, functions and triggers)
- Setup backup scripts and provided database recovery services as needed
- Tuned application SQL and pg/Psql code
- Supporting a team of Java developers working on medical practice application
- Providing DBA support including schema generation, SQL tuning, Schema modification, Performance tuning
- Installed, configured and maintaining development, test and production databases
- Currently supporting clients Oracle databases remotely
- Provided remote database support for clients using the medical practice software
Education
Some College (No Degree) - Oracle,UNIX
Columbia University (CTA)
New York, NYBSC - Biology
University of Ilorin
NigeriaSkills
AWS Cloud platform including EC2, VPC, EBS, AMI, SNS, RDS, DMS, EBS, Cloudwatch, Cloud Trail, CloudFormation AWS Config, Auto-scaling, Cloud Front, IAM and S3
Provision and configuration of EC2 instances to meet high availability database and application requirements
Oracle database migration to Redshift (data warehouse) using SCT/DMS
SQL Server database migration to AWS RDS Aurora MySQL and EC2 instances
Experienced in Bash scripting DMS for the migration Terabytes of mainframe data to AWS S3 buckets for archival and query access
Used DMS to migrate Oracle Databases from on-premises to AWS RDS - Oracle, Postgres, MySQL (views, stored procedures, functions, materialized views)
Migrated MSSQL Server database from on-premise to AWS and provided day to day support
Created monitors, alarms, and notifications for EC2 hosts using Cloudwatch
SQL performance tuning on multiple database platforms
Oracle software / database planning & installation including multi-tenant environments
Database design (Logical & Physical)
Extensive hands-on experience with Oracle 10g/11g/12c/18c new features: Flashback Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin
Oracle Goldengate 11g/12c/18c
PostgreSQL 7x - 11x
Microsoft SQLserver 2008,2012,2014,2016
MySQL Database: MySQL 57/56,/ 55/51/50/ 41
MySQL replication MySQL Storage engine: InnoDB, MyISAM, Memory
Maintained Data Guard environment, able to manage many schemas, create DDLs when needed, optimize and develop complex queries and execute weekly deployments to various environments
Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance
Designed, developed, tested, deployed and maintained database security and audit solutions
Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner
SQL Tuning & Optimization
OEM Control & Grid/AWR/ADDM
Oracle ASM, RMAN/ Database Backup, Data Pump, Active Data guard / Physical & Logical standby database configuration
Oracle RAC database Administration, Installation, Tuning, and Troubleshooting
Proficient in PL/SQL, T-SQL & Pg/Psql
Systems administration on the following operating systems: AIX, HP/UX, Solaris, Linux (Ubuntu, Amazon Linux, Redhat, CentOS), UNIX, MS-DOS, Windows 2003/2008
Languages & Scripting: SQL & PL/SQL, T-SQL, XML, Korn Shell, Bash & Borne Shells
Affiliations
IOUG (International Oracle users group) Member.
NYOUG (New York Oracle users group) Member.
Oracle Technology Network - Member.
Certification
Oracle Certified Professional.
Timeline
Cloud Architect / DBA
Visiting Nurse Service
05.2014 - Current
Senior DBA Consultant
Weightwatchers Inc
09.2012 - 04.2014
Oxford Global Resources Remote Contractor
General Dynamics Corp Scottsdale AZ
01.2011 - 05.2011
Technical Manager
Database Services, HBO - Time Warner Corp
01.2008 - 11.2010
Senior Oracle DBA Consultant
WeightWathcers.com
07.2007 - 12.2007
DBA Consultant
US Foods Inc
08.2004 - 07.2007
Senior Database Consultant
IT Workgroup Inc.
10.2003 - 08.2004
Some College (No Degree) - Oracle,UNIX
Columbia University (CTA)
BSC - Biology
University of Ilorin