Anwu Patric
Phone: 470-***-**** Email: acqbck@r.postjobfree.com
ORACLE DATABASE ADMINISTRATOR
SUMMARY OF QUALIFICATIONS
An accomplished, enthusiastic and result driven IT Analyst and Oracle Database Administrator with over 6 years of experience. System implementation consultant in large enterprise environments; supporting disaster recovery and high availability database systems. Good track record in providing solutions to clients and customers on various projects.
AREAS OF EXPERTISE
-
-Experience in installations, planning, configuration, deployment, database security and supporting production and non-production environment
-Experience implementing and managing Oracle RAC/ASM/standby DataGuard on 10g, 11g, and 12c
-Experience maintaining database including database security, capacity planning, monitoring, and performance tuning (I/O, Memory & SQL Tuning etc.) Using Stats pack, Explain plan, ADDM, TKPROF and analyzing AWR report
-Experience in upgrade, regular security patching, interim patching for various bug fixes on database products and upgrading all Oracle software
-Experience implementing backup and recovery and disaster recovery strategy, VMware Administration
-Experience in troubleshooting Oracle database issues, and modifying Store Procedures (SQL scripts, DBMS packages), Job scheduling
-Knowledge of ETL and experience writing import SQL scripts providing efficient IT service support, improving business IT operation through IT service delivery, Program/Project Management
TECHNICAL SKILLS
RDBMS: Oracle 10g/11g, 12c, MS Access, MS SQL server 2008
Languages: SQL, PL/SQL, Java, HTML, XML, VBScript, UNIX Shell Scripting, Oracle Spatial
Operating Systems: Oracle Solaris, Linux (Redhat Linux), Windows
Utilities: SQL*PLUS, Putty, UNIX Shell Scripting, MS Office Suite, OEM, Data Pump, SQL*Loader, ETL, SQL TRACE, CRON, TOAD, Explain Plan, RMAN, OEM, TKPROF, STATSPACK, AWR, and ADDM
Environment: ASM, UNIX, Sun Solaris 10, HP-UX 11 (64 bit), IBM AIX 5.0, Enterprise Linux 6.0
Other Tools QC/ALM, QTP/UFT, SoapUI, Web Services, SAP, MS Visio, SharePoint
CAREER HISTORY & PERFORMANCE
Tech Consultant - Oracle DBA Accenture, Atlanta, GA. Jun, 2010 – Present
Oracle Database Administrator
Worked with infrastructure and application team in designing and supporting mission critical Oracle databases and ensured high availability and compliance with business requirements
Install, configure and upgrade databases to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle12c features
Work closely with Developers and QA Testers to debug PL/SQL programs and install production programs after User Acceptance Test approval.
Monitor and support Backup and Restore/Recovery using RMAN, Data pump (Import & Export) utility.
Linux Shell scripting to automate some database administration tasks; use PL/SQL programming, and SQL.
Managed, and maintained multi-terabyte databases exceeding 15TB and assisted in creating Enterprise data strategy across all solutions
Implemented and deployed, managed Oracle Spatial using various ESRI files from different vendors (i.e. NavTeq, TomTom, Nokia, etc); supported ArcGIS infrastructure; used spatial programming; spatial models and algorithms
Worked as a part of team and provided 24x7 supports on a production database and system support environment.
Provided support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster and system management
Maintained and supported Client’s databases including daily monitoring, resolved performance related issues via table partitioning, indexing, instance tuning and performance analysis using ADDM, analyzed AWR report
Provide support for Oracle Enterprise Manager Grid Control and Agents
Implemented and supported highly available RAC clusters for companywide single sign on application.
Performed database tuning/optimization, SQL tuning, use SQL Trace, Explain plan for long running SQL queries, index creation for performance improvement.
Experience in capacity planning/management, monitoring of database space and estimating growth requirements.
Implemented Database backup and recovery and logical (Hot/Cold) backups with Oracle backup utility such as RMAN
Monitored and reorganized database objects Tables & Indexes which minimized fragmentation in the database, partition, compression used logical backup and restoration (Export and import Datapump)
Managed high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
Performed Database refresh/cloning using RMAN to duplicate production database to non-prod and testing.
Experience performing Backup and recovery using RMAN complete recovery, tablespace recovery and controlfile recovery.
Assisted in creating Enterprise data strategy across all solutions
Provided KT (Knowledge Transfer)/ workshop sessions to Clients technical and customer management team
Performed root cause analysis on Clients database issues, RMAN failures, database poor performance issues and deadlocks
Designed and implemented database security schemas(grant/revoke/users access) installed routine security related patches
Performed maintenance/tuning to ensure maximum performance, analyzed slow-running SQL queries, gathered statistics, use of Explain Plan and recommended solutions
Performed installation, configuration, created database objects, users with appropriate roles and maintained database instances
Performed database refresh from production environment to test environment
Evaluated clients Oracle database requirements and develop optimal solutions to address their needs
Performed database, schema, tablespace cloning/refresh using Data pump (Import and Export) utility and RMAN
Participated in large, complex Oracle database deployments, Migrations, consolidations and upgrades projects in various platforms such as Oracle Solaris
Tuned the database and handled Incident tickets to meet Clients Service Level Agreement (SLA)
Troubleshoot database issues, rebuilt indexes and gathered/update statistics of tables to improve the performance.
Created primary database storage structures (tablespaces), primary objects (tables, views, indexes)
Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users
Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability, document problem resolutions.
Efficient in sending daily operational report to the top management regarding the whole operation of the day, including any hitches and making recommendations
Experience in maintaining referential integrity in application SQL, stored procedures, and triggers.
Performed database monitoring and space management, reviewing and implementing schema design
Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle GoldenGate (OGG) in Oracle to Oracle environment.
Installed and configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
Experience in Supporting Bi-directional GoldenGate replication between databases.
Setup and configure GoldenGate Manager Processes, Extract Processes, and Replicat Processes for a unidirectional replication.
Created and implemented replication between 2 databases running on Unix RAC for multiple schemas.
Validated replication for insert, update functionality between source and destination databases.
Managed Replication related errors such as ORA -0001 during and after code deployment activity.
Supports, maintains and troubleshoots Oracle Golden Gate for data replication and high availability databases.
Oracle DBA FST Financial MTG, Atlanta, GA Dec, 2007 – May 2010
Led the effort that provided the installation of Oracle software’s and creation of Oracle database on both Linux and windows environment
Interfaced with Key Stake holders during System Development Life Cycle (SDLC) to gather information, and pertinent data
Monitor and support Backup and Recovery (point in time recovery) using RMAN, Data pump (Import and Export) utility
Managed tablespaces, Rollback Segments, Redo Logs and other database objects
Monitored Oracle trends for hardware usage and user load (OEM, AWR report)
Performed status checks, monitored Alert log, Trace files and database upgrade from Oracle 10g to 11g
Wrote and modified Stored procedures, complex SQL queries, PL/SQL, Shell scripts for data extraction from SQL Server
Set up and managed database security by creating new users, roles, profiles, and provided required user privileges in development, test, training and production environments.
Created and monitored standby databases and ensured minimum downtime
Provided assistance in NetApp SAN/NAS, EMC NAS/SAN storage configurations
Assisted in the performing database tuning and performance monitoring.
Used DDL and DML to write triggers, stored procedures to check the data entry and payment verification
Assisted in performing backup and recovery of database and tablespaces
Assisted in managing online redo log files, archive log files, control files and other oracle related files.
Maintained strong relationships with all lines of business and business units, through customer focused service delivery.
Effectively handled communications with various vendors, customers, team members and management
QA Analyst Allstate Consulting Services(Chemtura), Atlanta, GA Jan 2003 - April 2007
Provided testing support to various applications developed on multiple clients’ production environments
Managed Business, Functional and Technical Specification Requirements document.
Created Test Plans, Test Requirements and Test Cases, ensured schedules are met and performed various tests on SAP application.
Validated program objectives and Specifications by testing new programs; compared programs with established Standards, and making changes.
Collaborated in the analysis of Defects with Developers to re-create and correct defects.
Resolved tasks and resources needed in applications, and created test assignments, test strategies to meet requirements.
Created test assignments, Test Strategies to meet requirements, and resolved the tasks and resources needed in various applications.
Executed test cases and performed Integration Testing, User Acceptance Testing, Configuration, Compatibility, Client Server Testing and Regression Tests.
Managed Defects report, follow up defects, and retested application to ensure that defects were fixed.
Planned, organized and documented Testing methods for multiple projects, and Created Processes and approaches according to standards.
EDUCATION AND TRAININGS
DeVry University (Keller School of Management), Duluth, GA 2013
Masters of Information Systems Management Cumulative GPA: 3.93
Oracle Database 11g Administrator Certified Associate (OCA)
Oracle Database 11g: Structured Query Language (SQL)
Project Management KT