Resume

Sign in

Oracle database administrator

Location:
Charlotte, North Carolina, United States
Salary:
80,000.00
Posted:
March 23, 2019

Contact this candidate

Resume:

PROFESSIONAL SUMMARY:

Over * years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with UDB, Oracle 10g and 11g.

Experience as On-Call 24x7 production DBA support, application DBA, system administrator

Very strong *Hands ON* experience in DB Platforms - Oracle, DB2/UDB, AWS

Experience Data Modelling and PowerShell Shell scripting

Monitored physical I/O and Proper sizing of rollback segments.

Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.

knowledge of infrastructure management systems with outstanding leadership ability and creative problem-solving skills in both strategic and tactical areas.

excellent communication /documentation skills and strong aptitude to analyse and resolve problems.

Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.

Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams and proposed solutions.

Responsible for RMAN backups, and improvement to backup with incremental backup by adding block change tracking feature of Oracle 11gR2.

Created Users, Roles and Profiles, Privilege management with role-based security.

Maintaining and scheduling Cold Backups, Hot Backups, backups of Archive logs and automating cleaning of archive logs.

Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

Upgraded from Oracle 10g through 11g to 12c and to 12c 2-node RAC

Created and installed wallet for Transparent data encryption (TDE)

Provided database related services to their development & QA environments.

Installation and configuration of RAC (Real Application Cluster) on different nodes with ASM

Supported Server migrations, Application upgrades/Migrations and Data centre movements

Configured Offline and Online Disaster recovery sites to maximize the database availability

Applied Oracle Patches (CPU/PSUs and One-off patches)

Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.

Experience in installation, upgrades, patches and TAR support.

Worked on Data transferring with export/import utilities and Data pump.

Participated in planning and implementation of off-site Disaster-Recovery planning and testing

Worked with development and operations staff in resolving problems quickly and efficiently

Resolve the bottlenecks in database environments using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, Listner,

Professional Experience:

Wells Fargo – Charlotte, NC July 2018 – Present

Oracle DBA

•Upgrade, enhance and migrate Oracle server-based application that meets user requirements.

•Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms.

•Follow database development standards for Microsoft enterprise and application databases.

•Design database Backup and Restoration Strategy

•Monitor backups regularly

•Deploy database change scripts provided by third party vendors.

•Document the logical and physical components of operational databases and their functionality

•Review, design and develop data models in conjunction with the application development teams

•Understand table indexing and query strategies, database objects maintenance and

performance issues

•Database upgradation, enhancement and migration.

•Analyse problems as assigned and provide solutions to address business needs.

Ally Financial - Detroit, MI August 2015 – March 2018

Oracle DBA

Installation of oracle 11g databases in production, development and test environments depending on project requirements.

24/7 production support of processes such as incident change and problem management, with responsibility of supporting critical applications, performing dedicated maintenance activities, live database performance tuning, cause analysis and recommendations

Capacity planning: Allocate system storage and plan future storage requirements.

Oracle HA Stack: Install, Configure, Setup, Maintain and Support UDB and Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications

*Hands ON* experience in DB Platforms - Oracle, DB2/UDB, AWS

Involve in 24/7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification

Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Creating and assigning appropriate roles and privileges to users depending on the user activity.

Configuring database auditing (i.e. standard, value based and fine grained)

Defragmentation of tables and indexes for improved performance and effective space management.

Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM

Monitored and trouble shooted database issues with OEM grid control.

Built physical standby using RMAN Active duplication method as well for Disaster recovery site

Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.

Setup the unidirectional replication on oracle 11g databases using Goldengate.

Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Managed Database Maintenance Activities to achieve optimum database uptime.

Configuration of Listener and Tnsnames.

Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)

Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle.

Experience in designing and configuring high-availability systems using DataGuard with physical standby,

Effectively configured and used DataGuard Broker utility.

Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.

Performed logical backups using Export/Import and Data Pump

Perform database security by creating and configuring Data base wallet for TDE Transparent Data Encryption options

Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.

Created database link between two databases to access the table data from one local database to remote database using distributed database feature.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed projects till they are stabilized.

Written SQL scripts to create database objects like tables, views and sequences.

Created procedures and functions using PL/SQL.

Preparation of High Level & Low-Level Design documents. on UDB

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, AWS, ADDM, DataPump.

Barclays - Dallas, TX April 2012 – August 2015

Oracle Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7support for all the production and development databases.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and opatch utility

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Use scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually when required.

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

OTHER EXPERIENCES

Government High School Akum (Bamenda – Cameroon)

Sept 2009 to April 2012

• Taught Biology to all the grade levels of senior secondary and high school

• Taught computer science for beginners to students of the 6th and 7th grades

• schools sport coordinator and staff in charge of FENASCO games

• coordinated the schools science club.

Government High School (G.H S Bombe Bakundu) Kumba – Cameroon)

Sept 2004 to August 2009

• Taught Biology to all the grade levels of senior secondary and high school

• Taught introductory Chemistry to students of the 5th to 7th grades

• assisted as school secretary in the principal ‘s office.

• coordinated the schools science club.

Education:

Bachelor’s Degree in Education (Biology) University of Yaoundé 1- Cameroon

Certification:

Oracle certified database administrator

Technical Skills:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle: Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant,

Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex

DBUA, ADDM, Oracle Migration Workbench, Remedy, Service now.

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Victor Amungwa

Oracle Database Administrator

Phone: 443-***-**** / 443-***-****

Email: ac8ve2@r.postjobfree.com



Contact this candidate