PROFESSIONAL SUMMARY:

• 8 years of experience as Oracle DBA proficient in database administration, production support, installation, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, capacity planning and database security with Oracle ( 10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2003/2008 Platform.
• Planning, designing, developing, deploying and supporting RAC/ASM on MAA environment.
• Experience in Installation and Configuration of Oracle Real Application Clusters (RAC) on 2/4 nodes with Automatic Storage Management (ASM) on Oracle Enterprise Linux 5 and Red hat Enterprise Linux 5.x
• Experience with very large scale database environment and mission critical OLTP and OLAP systems.
• Experience working on Oracle 12c container and pluggable databases and new features of Oracle 12c multi-tenant databases.
• Installed and Configured Physical data guard replication across data centers for Disaster Recovery
• Experience setting up Active Dataguard (11g) for reporting and backup recovery.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Advanced Backup and recovery using Oracle's RMAN software, used offline/online for recovery in a production environment with shell scripting.
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Designed and Implemented Oracle Golden Gate solution for multi-site replication.
• Experience in setup of Oracle Grid Control 11g and Oracle Cloud Control 12c for monitoring production/dev/QA databases
• Experience working with Exadata administration. Exadata Half Node configuration utilizing teh smart scan, Flash Cache, Storage Indexes and Exadata Storage server software and features.
• Provided service focused technical support Confidential and onsite to achieve effective troubleshooting, resolution of issues, and maximum customer satisfaction.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (me/O, Memory & SQL Tuning etc) by using tools/utilities like tkprof, sql PROFILE, Automated Workload Repository (AWR), and Automatic Database Diagnostics Monitor (ADDM).
• Experience in Migrating SQL Server 2000/2005/2008 to Oracle Using OMWB, SQL Developer.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement teh business logic.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Good knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNAMES, V$ and DBA Views.
• Performed various database upgrades ranging from oracle 9i to 10g, 9i to 11g and 10g to 11g
• Good knowledge on setting PFile & SPFile
• Experience writing/setting up script to clone databases from Production to Test and Development using RMAN.
• Refresh of database to and from lower environments using export and import Datapump -expdp and impdp.
• Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 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
• Good exposure on Oracle Advanced security features like TDE (Transparent Data Encryption), Data vault and Audit vault.
• Good team player, self-motivated, dedicated in any work environment.
• Experience On-Call 24x7 as production support DBA and supporting SQL server 2008 R2/2012 and Sybase ASE as secondary DBA.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows 2008 R2, 2012.

RDBMS: Oracle 10g/11g/12c Real Application Clusters (RAC), SQL Server2008.

Languages: SQL, MYSQL, PL/SQL, C, C++, XML, Shell Scripting, Perl scripting.

Software/ Application Tools: OEM, DATAGUARD, GoldenGate, Exadata, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, ETL, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD.

High Availability Tools: RAC and Data Guard.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines,IA

Oracle DBA

Environment: Oracle 11gR2, 12c, SQL Server, OEM 12c/13c, RMAN, Data guard, AIX 6.1, RHEL, RAC, ASM, SQL Developer, PL/SQL, Toad, dbsmart, PAC2000, GoldenGate, Exadata, Database vault.

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problemrecognition and resolution of database issues.
• Experience in Administration of Oracle Databases 11g, 12c databases including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore and, Also supporting and maintenance of ERP systems.
• Applied patches and Migrated Databases and maintain an updated platform matrix and also Cloned/Refreshed Databases from Production Database using RMAN and Hot Backups
• Installed and configured Oracle GoldenGate 12c, Configured Extract, Data pump and Replicate processes in a production environment.
• migrated databases using GG and RMAN for 2 node RAC
• Installed 11.2.0.3 RAC (3 node) from teh Scratch and teh maintenance of teh high available Databases.
• MigratedOCRandVOTING disksto newer disks by adding newer disks fromSANand dropping teh old disks by usingASM’s native rebalancingfeature.
• ImplementingPhysicalandLogical Standbyset upData guardConfigurations.
• Troubleshooting Exadata smart scan/offloading issues and experience working with Exadata Storage Server software, managing cell disks, grid disks and ASM disks.
• Experience in optimizing database access and allocate/reallocate database resources for optimum configuration, database performance and cost.
• Experience working with Amazon Web Services (AWS) Cloud solution, installed and maintained AWS database.
• Used transportable tablespaces (TTS)to move teh data Oracle on a different platform and also much faster than performing either an export/import or unload/load of teh same data.
• performance analysisusing AWR/ASH/ADDM reportsand wait event analysis.
• Handling large database environments usingOracle Enterprise Manager (OEM)on daily basis observing teh performance of teh production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical me/O and Memory Usage.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh database and viewing alert log and trace files.
• Day to day DBA activities like managing teh Oracle databases, users, roles, profiles, access & backups in both Production and non-production environments.
• Refreshing data from production to lower environments using datapump utility.
• Performance tuning me.e. Tuning RAC, tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms.
• Tuned SGA by Library Cache, Dictionary Cache. Tuned OS by reducing paging/swapping. Tuned me/O which includes separation of data files and redo log files.
• Oracle Grid Control Management Server Installation.

Confidential, Memphis, TN

Oracle DBA

Environment: Oracle 11gR2, SQL Server, DB2, OEM, RMAN, Linux, HPUX, PowerBuilder, RAC (Real Application Cluster), ASM, SQL Developer, PL/SQL.

Responsibilities:

• Build, Configuration, Administration and Maintenance of Oracle 11gR2 Real Application Cluster Databases on 3node and 2 node
• LINUX platforms and achieving High Availability along with migration of third party databases fromSQL Server, DB2to Oracle.
• Upgraded Grid Infrastructure and Oracle Database from 11.2.0.2 to 11.2.0.4.
• Upgraded enterprise manager from grid control 11g to cloud control 12c release 5 worked on ASM feature of Oracle.
• Handled cross platform migration of huge database HPUX to LINUX 6.8 using Transportable tablespace, Expdp &Impdp
• Hands on experience in troubleshooting RAC environment, using srvctl, crsstat and crsprofile.
• Experience in working with teams for maintenance of 24X7 high-availability applications and databases as well as third party vendor applications and tools.
• Continuous Performance monitoring and tuning of teh databases and SQL queries using EXPLAIN PLAN, creating SQL baseline, SQL Profiles, SQL Tuning Advisor.
• Configured physical stand by with maximum availability mode.
• Monitoring of database objects like rollback segments, temp segments and tablespaces.
• Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh fromProd to Dev. Troubleshooting Day-to- Day Users Issues in various modules.
• Involved in applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) forcreating a Client-Server environment using Listener, TNS names etc.
• Creating and dropping of users, granting and revoking rights as and when required.
• Advanced Backup and recovery using Oracle's RMAN software, used offline/online for recovery in a production environment via Korn shell scripting.
• Checking of Oracle files for abnormal behaviors
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces.
• Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Performing Build activities.
• Involved in 24x7 support for production databases.

Confidential, Des Moines,IA

Sr. Oracle DBA

Environment: Oracle 11gR2, 12c, SQL Server, OEM 12c Cloud Control, RMAN, Data guard, AIX 6.1, RHEL, RAC, ASM, SQL Developer, PL/SQL, Toad, GoldenGate, Exadata.

Responsibilities:

• Responsible for maintaining & monitoring Critical OLTP application production and test databases (25+) for ICMP & AOW on RAC Real Application Clusters of 3 nodes and 4 nodes.
• Handled RAC 3 node and 4-node Builds, installation, configuration and SCAN listener’s configuration including role based service setup and building Active dataguard for production systems.
• Performed database management activities on Exadata X3, utilizing features of Exadata like smart scan, flash cache, storage indexes etc.
• Provided technical assistance for designing, installation and upgrading of existing Oracle databases in Exadata platform.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Experience Building Oracle Dataguard, Physical Standby and Active dataguard for Disaster recovery and managed through Dataguard broker.
• Configured GoldenGate 12c RAC for Active-Active Replication between teh Datacenter for High Availability.
• Experience setting up backup and recovery policies with RMAN.
• Troubleshooting archive log transport failures for standby database
• Installed and configured GoldenGate in a prod and non-prod env, configured extract, data pump and replicate.
• Played a vital role in streamlining and consolidating all production and non-production databases on AIX, Linux.
• Creation of oracle users, oracle roles, granting privileges and profiles etc.
• Experience with My Oracle Support (MOS)/Metalink for Oracle SR, patch download.
• Deployed scripts for monitoring Goldengate lag and process (Extract, Datapump and replication).
• Resolved replication & lag issues in GoldenGate
• Scheduled backups (like Expdp, RMAN, and Archive log).
• Experience working on STAMP, PeopleSoft & Clarity applications and databases.
• Troubleshooting Exadata smart scan/offloading issues and experience working with Exadata Storage Server software, managing cell disks, grid disks and ASM disks.
• Working with SAN team and raising SAN storage requests to add additional space to ASM disks when needed.
• Worked on OEM 12c Cloud Control, scheduling jobs in Autosys and crontab & deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM and modifying shell scripts where needed.
• Experience with variety of enterprise scheduling tools like Autosys and BMC Control-M.
• Experience setting for RMAN backups to tapes and disks and maintaining backup and recovery policy to ensure database standards at client is met.
• Performance testing (Stress testing) of third vendor applications for DB parameter settings, capacity planning (Memory, Space, CPU) and SQL tuning.
• Responsible for Data refresh operations from prod to other environments using export Datapump and import as per business needs.
• Writing PL/SQL, stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
• Taken care of major releases in production environment.
• Worked with Oracle Support Team to resolve ORA-00600 and ORA-07445 errors in production databases and other Oracle bugs and applying patches when required.
• Performance Tuning me.e. Tuning RAC, tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms using AWR/ASH reports.
• Plan Goldengate setup to achieve unidirectional heterogeneous replication from SQL Server 2012R2 to Oracle 11.2.0.4.
• Perform POC for testing DDL and DML replication across Databases using Goldengate 12c.
• Responsible for performing on-call duties for Oracle, Sybase and SQL Server databases as secondary DBA and handling critical priority tickets/incidents and resolving them on time. Performance tuning by analyzing SQL Execution plan, backup & recovery (RMAN, if required), managing users & privileges, resource limits etc.

Confidential, Richmond, VA

Oracle Database Administrator

Environment:Oracle11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, OEM 11g grid control, LINUX, IBM AIX, TOAD,SQL Developer, TKPROF, SQL Tuning, Data Modeling, Builds.

Responsibilities:

• Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Installed and configured Oracle GoldenGate 11g, Configured Extract, Data pump and Replicate processes in a production environment.
• migrated databases using GG and RMAN for 2 node RAC
• Experience working on huge databases sizes of around 6-10 TB in Datawarehouse environment and BI side working with ETL developers and Informatica for data analyze and transform.
• Experience working with Amazon Web Services (AWS) Cloud solution, installed and maintained AWS database.
• Installation of 11.2.0.3 RAC (3 node) from teh Scratch and teh maintenance of teh high available Databases.
• MigratedOCRandVOTING disksto newer disks by adding newer disks fromSANand dropping teh old disks by usingASM’s native rebalancingfeature.
• Installation ofASMLIBrpm packages. Initialize teh asmlib using oracleasm init command. Portioning teh disks using fdisk/dd command.
• Performance Tuning me.e. Tuning RAC, tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms
• Tuned SGA by Library Cache, Dictionary Cache. Tuned OS by reducing paging/swapping. Tuned me/O which includes separation of data files and redo log files
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restoreof all teh Oracle databases usingRMAN.
• Performance data loads and refreshes in Datawarehouse environment.
• Performed migration of teh oracle databases whosedatabase sizes vary from 300 to 500GBfromOracle 10.2.0.4/11.1.0.7/11.2.0.1toOracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• ImplementingPhysicalandLogical StandbysetupsData guardConfigurations.
• Set upActive DataguardConfigurations for oracle database11.2.0.3for thirty databases whose size varies from2TB to 5TB on a 3 node RAC.
• Generate ADDM and AWR reports to ensure optimal database performance tuning and use SQL Tuning Advisor and SQL Monitoring to tune SQL queries for long running SQL.
• Responsible for AWS/Amazon EC2, S3, RDS, VPC, Snapshots, Load Balancing, Cloud Formation, Auto Scaling.
• Maintained standby databases, in both local and Confidential locations, for fail-over purposes.
• Knowledge ofExadata Storage Servers, ranScripts for Health Check on Exadata Storage Servers.
• DevelopedRMAN Cold Backup Scriptto take backups automatically every week for about200 databasesvary in size from200GB to 2TBand automated teh process throughcrontab.
• ImplementedOracle Patches CPU & PSUon teh Compliance databases Device a plan to patch them.
• Checking DatabasesBackup and Restore validityperiodically, and Data refreshes from Production to Non-Production environment, CreationDuplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results usingExplain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations usingADDM reports. Analyzed teh trace files UsingTKPROFutility.
• Involved in Production Support for Critical Application Databaseswhen needed.
• Installingagent 12con teh server. Adding High Available Database withCRS, SchedulingBackupsthroughOEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR,Crontab(UNIX).
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—halping to transform business requirements into environment specific databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.

Confidential

Intern/Oracle Database Administrator

Environment: Oracle 10g, 11gR1, Redhat Linux 4.x, Sun Solaris, OEM 11g Grid Control.

Responsibilities:

• Proactive database monitoring using automated scripts based onv$views.
• Developer Environments setup using database cloning.
• 24 X 7 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, Testing and Implementing Sound backup and Recovery Strategy.
• Gathering database statistics and indexing teh required tables for performance improvement.
• Developing Hot, cold and logical backup scripts to automate teh backup procedures.
• Planning for storage spaces requirements and placing them for optimum me/O performance.
• Tuning teh databases for optimal performance.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for teh system and database for teh effective functionality and report generation.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored teh production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.
• Experience on OEM Diagnostics & Tuning Packs.