Catherine Agada

Database Administrator, OCP

A certified oracle DBA with experience in all facets of information technology including physical and logical database design, implementation and management is seeking a database administrator's role to increased accuracy, performance, and efficiency in a long-time opportunity. I am skilled in collaborating with all members of the organization to achieve company objectives.

Profile Summary

Oracle Certified Professional (OCP: 9i, 10 & 11g) Database Administrator.

12 years of IT experience as Database Production and Application Support, Data and System Analyst.

Comprehensive knowledge in Database Architecture, Design & Implementation -Physical and logical.

Good understanding and Implementation experience in Data Guard, GG, RAC and Oracle Grid environment.

Large high-volume site support (OLTP & DSS) experience on transactional 24 x7 systems (Production & Appl. Support)

Efficient in Database Performance monitoring, Diagnostic and Tuning, Backup and Recovery, Upgrade, Patching and Managing users and security.

Cognitive about designing, deploying and operating highly available, scalable, and fault-tolerant systems using Amazon Web Services (AWS) – IaaS, PaaS, SaaS – Compute, Storage, Network, Security and RDB managed services.

Production support capable of managing incidents – reactive and proactive in terms of preventive maintenance and knowledgeable in terms of risk management.

Technical Skills

Database Admin: ORACLE 9i/10g/11g/12c

Database: Oracle RDBMS (OLTP & Data Warehouse), CACHE, Microsoft SQLSEVER 2012, Access

OS/Server: Unix-AIX, Solaris, HP, Linux (Red Hat), VMWare, Window, Apache web server, LDAP, Exadata

High Availability: Real Application Cluster (RAC), Data Guard, Oracle Golden Gate, AWS

Tools/Utility: Oracle OEM- Grid and Cloud Control, ASM, ACFS2, RMAN, AWR/ADDM. Stats pack, XML,

Citrix, Quest (Toad, Spotlight), SQL Server Mgmt. Tools (SSMS, SSIS, BIDS), Power Designer.

Application: TIBCO, RAC, ATG, Lawson, Artiva, HEAT, Remedy, MS Office, ILIEN, OC, ERP

Languages: SQL, PL/SQL, SHELL Script, Perl

General: Analytical, strong verbal and written communication skills and a team player.

EXPERIENCE

IDC Technology/Wipro (End Client – Mastercard) 12/2018– present

Oracle Database Administrator/DWH/PTS DBA

Provide database administration and support to Mastercard’s data warehouse (prod and dev databases, RAC, Linux and Exadata environments) for MC DW USA and Pune-India data segregation project. I was instrumental in converting data models into physical structures and building maintenance partition package for data load.

Monitor data warehouse and core OLTP databases for performance and other issues that affect users, storage, connectivity, and job failures. My efforts in pro-active monitoring and debugging resulted in a reduction in downtime and improvement in performance.

Work with change management system (remedy) handling 100+ change requests reflected in code deployments, database hotfixes, user and incident tickets.

Use Power Designer data modeling tool to generate and implement scripts for tables, partitions/sub-partitions, indexes, and other objects, including creating enhancements to existing data model and related platforms.

Perform data loads and refresh using Data Pump and export/import utility.

Monitor and provide first-level database production and non-prod support to Mastercard multiple application and databases on a shift rotation and point of contact for Transaction processing (PTS) database.

Create and troubleshoot replication with Oracle Golden Gates, correcting lag, abended and other issues.

Work with offshore team, providing KT and guidance to other team members.

Key cube Consulting Inc 05/ 2013 – 10/ 2018

Database Engineer

Consulted in medium to very large 24x7 database environments; monitored alerts and supported RAC, non-RAC, Data Guard databases on Unix and Linux servers. Using Oracle OEM & scripting analyzed challenging performance-tuning situations for solutions and worked closely with developers to build and update features. Projects & clients include:

Innovation2U Chicago ( 01/2017– 10/2018)

Oracle Production DBA

Managed technical projects for database upgrades, resource capacity planning; platform and application migration.

Provided new oracle grid installations and configurations, patch fixes and upgrades of oracle database software: – I achieved success in planning and upgrading the older oracle releases from 10g to 12c on very large databases.

I enhanced data access performance through partitioning, replicating objects and building indexes. – monitored as well as troubleshoot performance on memory utilization, slow running queries, and from alerts logs using. I resolved locks and wait events, load balancing and other performance derogation events that results from users, system, network or job scheduling events.

Participated in a 24/7 hours on-call rotation. - I investigated and resolved database and application issues raised from monitoring events, operation support and user calls at any time.

Took ownership of complex database incidents and work with oracle support to resolve in speedy and timely manner resulting in 99% up time for company critical databases.

Managed RMAN backups, performed media recoveries and participated in disaster recovery drills.

Deployed and maintained database security and audit solutions per client’s SOP and compliance requirements.

Build physical standby database for high availability using Data Guard technology and resolve Lag events.

Gained exposure to setup and AWS infrastructure with various services available using management tools to monitor, deploy and manage services (CloudFormation, CloudWatch, Auto Scaling, Trusted Advisors, etc.).

HCL America, (End Client Wolters Kluwer) Houston, TX` (02/2016– 09/2016)

Application Support DBA

Performed daily DBA administrative tasks such as creating and managing users, physical and logical storage (file system and ASM), proper backup and recovery availability, and including ongoing projects or tasks assigned.

Configured and troubleshoot oracle golden gates issues.

Monitored and resolved application issues by ensuring that database are available and running on high performance in production and staging (QA).

Planned and managed change control deployments, working with developers to test, approve and move codes (Liquibase XML) in oracle and Sql Server environments for updates, new functionalities and fixes.

Cloned and refresh databases, including data archive with security features (encryption). - I Supported core business end of month activities including Disaster Recovery drills, data refreshes and index rebuild.

TM FLOYD AND COMPANY (End Client Computer Data Services), Dallas, TX (12/2014 – 12/2015)

National Data Warehouse/Database Administrator

Continually ensured upkeep of NDW application server hosting, Application (Informatica) and Database (Oracle and SQL Server) for production and FIT environments.

Produced innovative remedial solutions to correct security risk findings and troubleshot performance on applications for MicroStrategy and Oracle database.

Supported ETL data workflow process building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehouse.

Configured LDAP proxy servers, updated SSL certificates, monitored NGD Dashboard for application and

infrastructure performance issues, and deployed codes and applications in Oracle and MS SQL databases.

BELLSOFT (End Client ALCON LAB) (05/ 2013 – 12/2014)

Application Engineer/DBA

Supported data center move and data migration from Unix to Linux platform. I was part of a team instrumental in planning and implementing a successful Cyber Vision data center migration, transporting large data across platform (AIX to Linux) and integrating replication to improve performance and access during the move.

Provided technical support on issues involving database, O/S, and Oracle-supported applications, including Tibco Administration on Apache Tomcat, Hawk, EMS, portal builder, and business connect.

Utilized SQL Performance Advisory packages to improve database performance, proactively tuning database. Patched Oracle software. Developed and approved technical SOP documentation on supported systems.

Education & Training

Master of Public Administration, Policy Analysis and Computer Security, John Jay College, New York, NY

Oracle RDBMS – Database Administration 9, 10, 11R2

LeaderQuest – MS SQL Server 2012 Administration & Data Warehouse Implementation SQL Server

Contact this candidate