Resume

Sign in

Oracle Data

Location:
Houston, Texas, United States
Posted:
January 29, 2018

Contact this candidate

Resume:

Dingana Nwana

Houston, Texas

757-***-****

ac38wz@r.postjobfree.com

ORACLE DATABASE ADMINISTRATOR

DBA with 5 years of experience as an Oracle Database Administrator. Worked on Oracle 12c, 11g, and 10g versions. Work areas include production and development and test support, installation and configuration, backup and recovery, performance tuning, database cloning and refreshes, security, database upgrades and patching, database migration.

Authorized to work in the US for any employer, I am US Navy Veteran and I currently Hold a US Government Secret Security Clearance.

Work Experience

ORACLE DBA

Capital One

Houston, TX

December 2016 – October 2017

Responsibilities:

• Successfully installed and configured Oracle 11g and 12c databases on Linux, windows and AIX OS platforms.

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

• Loading data from flat files to database using SQL*Loader, External Tables.

• Extensively used AWR, ADDM and explain plan for periodic performance tuning.

• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

• Implemented oracle 12c active standby database for test database environment.

• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment. .

• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.

• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.

• Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.

• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.

• Administer User Management, Privileges, Roles, Auditing, Profiling, Authentication.

• Import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 11g and 12c database environments.

• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

• Implemented Flashback technology of the Oracle 11g and 12c along with Recyclebin for a faster recovery of the databases and database objects.

• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

• Refreshed/cloned databases using RMAN utility.

• Performed Database upgrade from Oracle 10g (10.2.0.5) to Oracle 11g (11.2.0.4) and also, upgraded from Oracle 11g (11.2.0.4) to 12c for Standalone and RAC database.

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

• Involved in the installation, configuration and extended support to Oracle 11g and 12c two Node RAC (Real Application Cluster) with ASM file system on RHEL Linux platform.

• Installed and configured ASM environment and migrated databases from NON-ASM to ASM.

• Used TOAD and OEM for database management and monitoring

• Made optimal use of Oracle Support in resolving the SRs.

• 24 X 7 Production & Development database support and administration.

• Worked with the engineering team to implement modern design systems of databases used by the company.

• Designed databases for referential integrity and involved in logical design plan.

• Execution and monitor database backups and rotating archives of backup files

• Recovery and restore of transactional data, and Database disaster recovery automation

• Responsible for supporting integrity, availability of database systems for high traffic business critical network of web application.

Environment: Oracle 11g, 12c, IBM AIX V6.1, RHEL 6.7, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, MySQL, OEM, TOAD 10.0.

ORACLE DBA

Mr.Franklins.com

Houston, TX

September 2014 – December 2016

Responsibilities:

• Install client/server Oracle Software, setup and configuration of Data guard

• Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs.

• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems.

• Backup / Recovery methodology specification for mission critical databases

• Performed hot and cold Backups.

• Scheduled daily Exports/Imports to serve as temporary backups.

• Installation and configuration of Oracle 11g and 12c Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs

• Worked on different platforms, load user data to reproduce the problem, apply new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.3

• Database reorganizations and refresh schema-using Export/Import.

• Creating the database, table spaces, tables, indexes, setting privileges and user logins.

• Creating physical databases with multiple table spaces from logical and physical data model

• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

• Prepared scripts to tune developer SQL codes to maximize result return time

• Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.

• Performed cold and hot backup using Oracle's Data pump.

• Provided remote technical support using SSH and terminal services

• Troubleshooting, Restructuring and tuning for optimal performance of existing databases.

• Cloned databases using scripts as well as RMAN.

• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

• Refreshed schema using Export/Import

• Capacity planning and creating databases for development, staging and production.

• Performed proactive and reactive tuning/managing database space utilization and growth

• Implementing Oracle ASM and resolving ASM related issues.

Created and maintained PL/SQL packages, stored procedures, functions,

Environment: RHEL, Solaris, Red Hat Linux, Windows, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL*Plus, PL/SQL, SQL Developer, TOAD, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN.

ORACLE DBA

USS BATAAN, US NAVY

NORFOLK, VA

June 2013 – July 2014

Responsibilities:

• Extensively involved in installing the oracle RDBM software, creating and configuring the databases (PROD, DEV, and TEST)

• Extensively used BMC Remedy, Citrix ticketing systems for resolving user request associated with database issues.

• Worked on all database activities such as User management, space management and database security management on 10g, 11g and 12c databases on SOLARIS, LINUX and WINDOWS servers.

• Worked on administering 10 Production databases and more than 40 non-production databases of size ranging from 100GB to 5 TB on Solaris/AIX/LINUX servers.

• Performed high level Troubleshooting and Tuning, Written Shell Scripts for monitoring performance and health checks using scripts, AWR, ASH,ADDM, SQL tuning advisors and OEM.

• Applied Patches including PSU and Bug fixes for database performance issues.

• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.

• Involved in writing UNIX shell scripts for backup and recovery, Import and export procedure, PL/SQL functions, procedures, packages and triggers.

• Hands on experience in creating new redo log groups on ASM and NON-ASM environment to resolve performance issues by extending the existing redo logs.

• Evaluating and performing the Backup and Recovery Procedures periodically using RMAN.

• Restored backups from tapes and disk and validated the backups, performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.

• Worked on a 24x7 Production database and applications support on an onshore/offshore model.

• Analyzed the user requirements, designed partitioned tables and created indexes for improving performance and manageability because many queries can prune partitions.

• Performance tuning and testing stored procedures, indexes and triggers using SQL server profiler, execution plans and SQL Tuning advisor.

• Hands on experience in enabling auditing and finding the schemas failed login attempts, created and dropped users, granting and revoking rights as and when required.

• Assisted IT Analysts on technical database issues and features.

• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.

• Performed timely database refreshes at schema and table level based on the requirement.

• Supported multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.

• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.

• Installed Oracle 12c database in the test environment and tested the upgrade from Oracle 11g to 12c.

• Tested database performance issues (monitoring and tuning) to ensure database optimization.

• Expertise in Oracle networking, Performed Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

• Proactively managed the databases, set up notifications, alarms using shell scripts for managing any exceptions in day-to-day management of the databases.

Environment: Oracle 10g, 11gR1,11gR2, 12c, RHEL 5/6/7, SOLARIS 10/11, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, DATAPUMP, RMAN, TOAD, TDE, Shell Scripting.

EDUCATION:

BBA in Management Information Systems, University of Houston.



Contact this candidate