Manager Oracle

Stella Wangia

Oracle Database Administrator

*************@*****.***

Tel: 469-***-****

PROFESSIONAL SUMMARY

Over 5 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD

• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database.

• Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11g and 12c.

• Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments for high availability and load balancing.

• 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

• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

• Experienced in maintaining large Production, UAT, IST and DEV environments.

• 24/7 support for Production databases and responsible for round-the-clock database operations. Offered

solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.

• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.

• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.

• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs.

• Planned and Implemented DR & High Availability oracle solutions using Data Guard, Streams.

• Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM)

• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.

• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)

• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.

• Experience in Cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

FedEx, Pittsburg PA July 2014 – Present

Role: Oracle DBA

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.

• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

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

• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.

• Supported functional data warehouse projects.

• Worked with database export & import scripts to backup database structures and automation procedures.

• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.

• Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.

• Implemented classic Golden gate replication as well as integrated replication. Implementing and maintaining database security (create and maintain users, roles and assign privileges)

• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.

• Monitored the Applications and database using OEM and OAM.

• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.

• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

• Built 4 node RAC 10gr2 Standby database and set up DG BrokePerformed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for

Day-to-Day activities and Windows Task Scheduler)

• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication

• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)

• Index creation and management for optimization of DB Processes.

• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

• 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.

Edgemark Systems, Silver Spring MD April 2012 – June 2014

Role: Oracle DBA

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Responsibilities:

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

• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.

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

• 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 24X7 supports for all the production and development databases.

• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.

• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.

• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2..

• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.

• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

• Monitored the production Oracle alert logs for database errors and data issues.

• Used EXPORT/IMPORT to do table level and full database defragmentation

• Managed RAC Linux servers running Oracle in cluster environments.

• Performed patching of Oracle databases with latest patches from Oracle.

• Install and configure block change tracking to work with RMAN Merged incremental backups.

• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

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

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

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

Con-way, Portland, Oregon April 2010 - March 2012

Role: Oracle DBA

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Responsibilities:

• Support 24X7 Production database administration.

• Support and monitoring to ensure a proactive problem recognition and resolution of database issues.

• Installed and configured Oracle RDBMS on UNIX and Windows environments.

• Creating primary database storage structures (table spaces, rollback segments, etc).

• Applied patches, keeping applications software bug free, and improving data integrity.

• Developing Hot, cold and logical backup scripts to automate the backup procedures.

• Developing, Testing and Implementing Sound backup and Recovery Strategy.

• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.

• Writing scripts for the system and database for the effective functionality and report generation.

• Planning for storage spaces requirements and placing them for optimum I/O performance.

• Tuning the databases for optimal performance.

• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

EDUCATIONAL QUALIFICATIONS:

Mountain View College Dallas TX

Business Administration

Contact this candidate