BUSAYO MICHAEL

737-***-****

adjkur@r.postjobfree.com

A seasoned Database System Administrator with 9 years of IT experience in database planning, design and administration of RDBMS (Oracle, Sqlserver, PostgreSql, NoSQL ProgressOE), with increasing level of responsibilities and expertise in a wide range of disciplines specializing in Databases, DevOps, AWS cloud, Oracle Weblogic Application Server, Capacity planning and Performance tuning. A skilled IT professional, solving critical business challenges by aligning needs with enterprise innovations.

CERTIFICATIONS

Oracle Database Performance Tuning Certified Exper (OCE) 11g Oracle Database Administrator Certified Professional (OCP) 10g, 11g Oracle Database Administrator Certified Associate (OCA) 10g, 11g Progress Database Administration and Performance Tuning (BravePoint) PROFESSIONAL SUMMARY

• Strong experience in DBA tasks, Installation, configuring, maintenance, problem identification and resolution in Dev, Test and Production environments in 10g, 11g, 12c, 18c. Database Migration, Performance Tuning, Patch application, Upgrades, backup and recovery, Capacity Planning, database security and Data Analysis.

• Experience in Managing and Supporting Cloud based Applications and databases. Establish hosting standards for DR and RAC clustered environments. Work area mainly includes Database support & maintenance, performance tuning, memory management, query optimization, DR setup, RAC and Non RAC environments.

• Strong knowledge on Virtualization technologies, Installation and configuration of virtual machines hypervisors VMWARE ESXI, networking and storage.

• Experience in High Availability (HA) solutions such as RAC, ASM and Data guard. 24x7 production support. Experience with Oracle flex cluster, flex ASM, Instance caging and disaster recovery methodologies.

• Experience with version control, integration/ deployment, configuration, monitoring and release management tools such as git, Jenkins, Nagios, puppet and chef.

• Working experience in services like EC2, EBS, ELB, S3, RDS, VPC, SNS, Route 53, CloudFront, CloudWatch, Auto-scaling, IAM.

• Experience in flashback technologies, advisory frameworks, table partitioning, materialized views, parallel execution, Indexing, dynamic sampling, query and database optimization, real application testing, SQL performance analysis

• Expert Experience creating physical and logical volumes, volume groups using LVM Linux. Advanced knowledge in UNIX System Backup / Restore, Kickstart.

• Strong teamwork, decision-making, documentation and analytical skills. BPL PLASMA

Database Administrator

December 2018 -Present

Responsibilities: -

• Ensure best practices in database planning, design, configuration, performance, and resilience.

• Optimize database performance degradation and provide expert level advise to the infrastructure, application and management teams.

• Managed database enterprise environments and provide technical leadership that fosters database innovation and automation

• Support strategic planning for database architecture, resource management, capacity planning and growth

• Evaluate and propose design and process improvements to achieve performance and cost optimization

• Identify inefficiencies in current database designs and implement improved solutions

• Plan and implement capacity and resource expansion to ensure scalability of databases

• Ensure servers, databases, and related enterprise applications are maintained to provide optimal experience for our customers

• Ensure operational performance monitoring and reporting

• Implement effective risk management controls and own adherence to all database security standards.

• Lead incident resolution efforts and engages the appropriate resources to complete corrective actions as quickly as possible

• Manage root cause analysis and problem management activities for continuous improvement initiatives, incident reduction and performance enhancements.

• Plan and participate in Disaster Recovery exercises, system failover planning and testing

• Participate with agile team members and product owners to ensure database design and performance meet current and future business requirements

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

• Provide 24x7 on-call production support.

GFS Marketplace

Database System Administrator

Jan 2016 – December 2018

Responsibilities: -

• The primary responsibilities for this position is to design, document, implement, and maintain database architecture in support of Database and work with the storage, POS, BI teams and the Business unit.

• Prepare server for hosting databases: OS Configuration, package installations, configure storage, install & configure Oracle software, ASM instance, Listeners, backup scheduling, VM snapshot, monitor and manage databases.

• Install, configure and maintain Oracle, sqlserver and Progress OpenEdge Dev, Test and Production databases running Redhat, HP-UX and windows.

• Manage 177 OpenEdge NoSQL databases for all stores across North America.

• As a strong team player, share knowledge within the DBA team and participate in discussions with DBAs, Sysadmins, Architects, Developers and Project Managers

• Perform routine database maintenance such as database upgrade, application of patches, monitoring, performance tuning, backup / recovery and troubleshoot Nagios system alerts.

• Implementation of high availability solutions with Oracle RAC, ASM and physical standby database (DATAGUARD). Converted some single instance databases to clustered databases.

• Migrated database backup from NetBackup to EMC Avamar, ensure that the scheduled nightly backups complete, test database restores to ensure consistency and maintain data integrity

• Perform database refresh, schema changes based on user’s request.

• Illustrate key concepts in oracle 12c such as Application Continuity (AC), Fast Connect Failover (FCF). Flex cluster, flex ASM. Job scheduling using CRON at the OS level and Shell Scripting for automating DBA tasks.

• Tested and implemented the use of RMAN to migrate databases from file system to ASM, Troubleshoot and optimize database performance. Perform hot, cold and logical database backup. Restored OCR file from backup.

• Work closely with the point of sale (POS) team to ensure that all databases are up and running to allow Agora application constant access to the database.

• Troubleshoot and optimize database performance issue to ensure best performance.

• Periodically use Avamar administrator and RMAN to take on-demand database backup before and after regular maintenance.

• Troubleshoot and maintain databases including index rebuild, tablespace Sizing, rename datafiles, Undo Sizing, Redo Sizing, Analyzing explain plan, AWR, ADDM and ASH reports.

• Administration of RHEL 7 which includes installation and configuration on both physical hosts and virtual machines. Configure Nagios, LDAP, Samba, Apache, NFS on Linux environments. Setup and configure failover load balancing using IP bonding for network cards.

Pragmatics Inc.

Database Management Specialist

July 2015 – December 2015

Responsibilities: -

• Analyzed, compared Oracle and Sqlserver databases and made recommendations on the RDBMS to implement for efficient business function.

• Worked on the Centers for Medicare and Medicaid services (CMS) Health insurance Marketplace project.

• Established baseline of existing 'as-is' Linux, Oracle and Marklogic environments by reviewing physical, data and application architecture.

• Reviewed data designs, accessed system performance, scalability, flexibility and stability.

• Monitor, optimize all databases for efficient and optimum performance, also, worked on deploying some of these databases to IaaS, PaaS solutions.

• Installed, configured and managed oracle databases on Linux & Windows platforms.

• Analyze system errors as well as specific database performance bottlenecks by providing prompt response to ensure uptime and service.

• Managed databases by ensuring that all servers were operational, and all automated jobs were constantly completed. Created automation scripts to capture database threats and unauthorized database access.

• Utilized a mix of Cron and dbms_scheduler packages for automating tasks both on the OS and the database and also monitored system performance to identify contentions and bottlenecks.

• Worked with developers to provide database support and also troubleshoot a variety of database performance issues.

• Monitored databases resource usage, enforced effective user management and performance tuning.

• Responded to Nagios database alerts, troubleshoot and resolved server generated database alerts.

• Applied quarterly patches to prevent database against vulnerabilities, database upgrades, managed users accounts, test refresh, schema changes and recovered database tables using flashback drop.

Micro-Systems

Database Administrator / Engineer

February 2012- July 2015

Responsibilities: -

• Oracle DBA supporting projects from DEV-PROD involving daily administration of databases running on RHEL, Solaris, HP-UX and windows.

• DBA for projects involving administration, troubleshooting and tuning of oracle 10g, 11g databases, ensured that all databases were up and running.

• Security implementation through basic and advanced security measures such as the application of quarterly patches and deleted all orphaned accounts.

• Installed and configured physical standby databases on oracle 11g for the purpose of disaster recovery measures.

• Troubleshoot and resolved log gaps on standby databases.

• Constantly monitor the performance (v$) at peak load ofdatabase and also ensured that applications closed connections after session ends.

• Optimized SQL queries and memory by performing routine checks of the SGA, CPU, disk I/O's.

• Provided 24x7 database support for high availability solutions managing oracle RAC and Data Guard.

• Worked closely with developers to optimize the performance of the databases and Optimized queries.

• Created and managed database structures, indexes, storage allocations, segments, constraints, database access and assigned roles and privileges.

• Involved in the installation, configuration and maintenance of oracle 11g RAC databases. Provided weekend and off-hour maintenance for Databases and provided support for performance enhancement.

• Actively participated in upgrading Oracle 10gr2 to Oracle 11gr2. Monitored and resolved database connectivity issues. Provided assistance in logical/physical data modeling using Erwin tool.

• Oracle side configuration, third party backup software and backup and restore testing.

Zenith

Database Administrator

January 2010- January 2012

• Implemented new SQL server databases 2005, 2008, created login for users and managed their permissions. Involved in capacity planning, security management and implementing Sqlserver installation.

• Managed more than 25 databases, troubleshoot database issues and documented root cause analysis. Day-to-day activities such as ensuring both scheduled and on demand backups completed successfully.

• Scheduled database backup, test database restore to ensure data integrity and validity. Applied patches and service packs for sqlserver 2008. Created new tables, views, indexes and user defined functions.

• Monitored and optimized the performance of the databases using SQL profiler, Explain Plan and index tuning. Disaster Recovery planning and implementation, Database mirroring, Log shipping.

• Created triggers using T-SQL, stored procedure which suites the business logic. Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

• Administration of the SQL Server by creating users & login ids with appropriate roles & privileges to users and roles, Optimized database performance using SQL Analyzer and Profiler for studying the behavior of SQL statements and procedures.

• Transformed data from various data sources like access, excel, flat files, ole db connection by creating various SSIS packages. Worked on DTS Package, DTS Import/Export for transferring data from Oracle databases to SQL Server. EDUCATION

Bachelor of Science (B.Sc)

Technology Management

July 2003- October 2008

ADDITIONAL INFORMATION

Environment: VMWARE, HP Blade servers, IBM Blade Center Servers, Kickstart, Apache, Tomcat, DNS, DHCP, NFS, SAN, LDAP, Samba, MS windows, Unix ( Solaris 8/9, HP-UX 10.x), EMC Avamar, Linux enterprise server, RHEL 5.x, 6.x, 7.x Databases: Oracle […] Oracle 10g, 11g, 12c, 18c, 19c MSSQL 2008, 2012, 2014, PostgreSql 10x, OpenEdge 11x.

Hardwares: HP DL380 G5/G6/G7/Gen8, Dell PowerEdge 1950, 2300, 2450, R810. […] sun StorEdge 6320.

DatabaseTools: SSMS, Enterprise Manager, cloudcontrol, rman, asm, expdp/Impdp, AWR/ STATSPACK.

Web/Application Servers: Apache (httpd), apache-tomcat, jboss, Weblogic. Tomcat, Apache, WebSphere, Apache Http Server, IIS 4.0/5.0, MQ Series. Networking: NFS, AutoFS, DNS. tcp/ip, DHCP, Cisco Routers/Switches, and LAN Programming Languages: Shell scripting Bash & Korn Shell, PL/SQL. Other Skills: VSphere, Advanced Business Language (ABL), git, github, Jenkins, Maven, Puppet, Nagios, Dockers, HVR, EC2, IAM, S3, route53, RDS, ELB, EBS, CloudWatch.

Contact this candidate