571-***-****

ac7vvd@r.postjobfree.com

ORACLE DATABASE ADMINISTRATOR

SKILL SUMMARY

I am a seasoned Oracle Database Administrator looking for a challenging position to leverage my education and work experience for the maximum benefits of my employer.

I am fluent in English, French and Mandarin(Chinese), I thrive well in a multicultural environment

Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)

Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.

Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.

Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.

Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database.

Using list partitions for large tables and bitmap indexes for the OLAP databases.

Scheduled Cumulative Incremental backups using RMAN Cloned databases using RMAN Utility.

Installation and configuration of GoldenGate and Replication of data using Oracle Golden Gate.

Resolved/Diagnose Node Eviction issues.

Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements and design indexes to improve response of queries.

Automated monitoring of Golden Gate process and heart beat monitoring.

Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.

Experience in the Upgrade of Oracle Databases in patch set Level and also in version Levels (10g to 11g) and (11g to 12c).

Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB

Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g..

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.

Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.

Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.

Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.

Configuration and Management of Data Guard on RHEL, OEL.

Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.

Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.

Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).

Proactively monitoring the database's health and taking preventive or corrective actions

Proficient in Database Design (Physical and Logical Database Design) and Normalization.

Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN.

Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.

Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.

Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

Automated many common tasks using crontab including Backups, exports and imports,

WORK EXPERIENCE

NY TIAA- CREF - Charlotte, NC

July 2016 – Present

Oracle Database Administrator

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris,RHL and Windows environments.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Implemented Dataguard, creating both logical and physical standby databases in 11g and 12c RAC environment for production database.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

Installation of 12c OEM and customize it to our needs.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.

Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.

Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack for best performance.

Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.

Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.

Administer RAC Database servers using SRVCTL, VIPCA, OEM Grid control, V$/GV$ views and System wide tuning using UTLBSTAT and UTLESTAT.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

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

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

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.

Worked with PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors and triggers.

Alert management, Created and setup alerts to send notification to Users from application wherever necessary.

Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.

Proficient in troubleshooting Node Eviction in Oracle RAC Environment

Applied PSU patches and other database related patches.

Have a good experience in administering Oracle Clusterware components.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace. Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 12.1.0.1 RAC databases.

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

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

Sun National Bank - New York,

March 2013 – June 2016

Oracle Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms and RHL.

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.

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

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

Documented the Standard Processes for peers to follow.

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

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

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.

Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.

Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.

Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.

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

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

Refreshed/cloned databases using RMAN utility.

Experience in User Management by Granting, Revoking Privileges according to requirement.

Experience in Space Management by Monitoring and Managing Tablespaces.

Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.

Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.

Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

EDUCATION

BSc and a Diploma in TRS engineering with a specialty in computer analyzed makeup (CAM) and equipment time management system (ETMS) and Solid background as an Oracle DBA for the past 5 years.

Contact this candidate