Manager Oracle

GERTRUDE SENWU MBA

Phone: 240-***-****

Email: *************@*****.***

PROFESSIONAL SUMMARY

Over 6 years’ experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows. Experience On-Call 24x7 production support DBA

Experience in Installation and Configuration of Oracle Real Application Clusters (RAC) on 2 and 3 nodes with Automatic Storage Management (ASM) on Oracle Enterprise Linux 5 and Redhat Enterprise Linux 5.x, Data Guard

Installing and configuring and performance tuning of Oracle RAC 3+ nodes.

Experience with very large scale database environment and mission critical OLTP and OLAP systems.

Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.

Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN)

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.

Advanced Backup and recovery using Oracle's RMAN software, used offline/online for recovery in a production environment via Korn shell scripting.

Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.

Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.

Experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities like TKPROF, SQL PROFILE Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM)

Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS

Data transferring with export/import utilities and Data Pump and SQL* Loader.

Performing complete and incomplete recovery during disasters, failures and user errors.

Configuring user creation, their roles and privileges profiles to control access over database objects.

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc

Resolved database network problems using Oracle Net Configuration Assistant (NETCA).

Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.

Good Knowledge in setting PFile & SPFile parameters, maintaining Data Files, Control Files, and Redo Log Files.

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.

Deployed Standby databases using Data Guard 11G (Maximum Performance).

WORK HISTORY

FITCH RATINGS, NEW YORK AUGUST 2014 – PRESENT

Role: Oracle Database Administrator

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Responsibilities:

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Administer over 600 databases across Development, QA, UAT and PROD environments via use of command line and Oracle tools-Oracle Enterprise Manager Cloud 12c.

Manage large complex Oracle RAC clusters with 50+ applications.

Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.

Upgraded databases from 11g to 12c.

Set up Active Data guard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.

Designed Golden Gate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.

Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 5 using Golden Gate.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.

Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.

Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.

Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.

Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Successfully implemented oracle 11g grid control in different environments.

Experienced in handling database issues using OEM as well as command prompt.

Upgraded the databases to version 12c from 11g and 10g

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6.

Applying upgrade patches, maintenance and interim patches on all the databases.

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Successfully implemented 10g RAC on nodes for high availability.

Experience in Working with RAC Databases.

Participated in a 2-Node RAC database configuration.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Performed Online and Offline backups with RMAN, export/import and expdp/impdp.

Implemented Point in time recovery using RMAN.

Configuration and implementation of Oracle) for high availability.

Performed Schema as well as Table Level Replication using Oracle Streams.

Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

Tuning SQL queries when the performance is poor.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

Installed the Oracle software using silent feature and also created databases

Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

Supported & maintained the Production/Development databases on various servers

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

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

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

WALGREENS – CHICAGO, IL JANUARY 2011 – JULY 2014

Role: Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, Data Guard, RAC, RMAN, OEM, Data pump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.

Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.

Worked as a member of production DBA team in perfect coordination with seniors and team members.

Implemented ASM on RAC. Managing disks and disk groups with ASM.

Keeping the databases up to date with respect to Latest PSU's and very comfortable in applying patches.

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

Installing oracle and creating oracle databases using DBCA.

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

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

Upgrade Grid Control from 11g to 12c -- Configuration of OEM.

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

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.

Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Installed, configured and maintained 11g R2 databases on standalone servers and Real Application Cluster (RAC) 2 Node RAC

Managed Oracle Real Application Cluster (2 Node RAC) running on ASM storage

Hands on experience in migrating Non-RAC environments to RAC environments both manually and by using R-CONFIG

Created custom services on RAC database for distribution of load across the nodes

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

Having good experience in build stage, installed Oracle databases on ASM using DBCA. Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

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

Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.

JA LAUNCH POINT – CHICAGO, IL JAN 2010 – DEC 2010

Role: Junior Oracle Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0.

Responsibilities:

Estimating table sizes, table spaces.

Perform database cloning/exp/imp to setup identical databases in the production and development environments.

Creation of new scripts to automate the procedures to generate statistics on database space management, performance and proactive monitoring.

Performed smoke testing during the installation of every full build for application to validate the fitness of the application for testing.

Participated in prioritizing the requirements to better manage the project.

Worked with application developers to address and clarify data requirements to resolve technical and functional issues.

Enforced corporate business rules through adequate user/resource/object management.

Reconcile functional and technical problems through interaction with the client by researching and identifying the defined issue and by fully testing and confirming possible solutions to the problem.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

EDUCATION: BACHELOR’S DEGREE IN COMPUTER SCIENCES

Contact this candidate