SUMMARY

• Oracle Database Administrator with over 6+ years of experience which includes Installation and Configuration, Migration, Database Backup & Recovery, Data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 10g /11g R2/12c databases documentation in heterogeneous environments. Worked on various Oracle versions like 10g, 11g, 12c, DBaaS, EXADATA servers and Databases across various platforms such as Linux .
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
• Used EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
• Worked extensively on Performance tuning of Queries by maintaining, partition, indexing and use of Hints, Stored outlines, Statistics.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Experience in Multitenant Databases (Oracle 12c Container and pluggable databases)
• 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.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Worked extensively on creating development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
• 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”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Implemented Oracle golden gate for real time data replication.
• Delayed the replication of data on Confidential across different time zones.
• Troubleshoot golden gate configuration issues.
• Experience in configuring and deploying Golden Gate for High Availability and real time replication.
• Implemented and configured Golden Gate 11g,12c for Unidirectional Bidirectional replication and zero downtime migration.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9. AIX 5.2. RHEL 6.5.x . Linux Enterprise Server 9, 10.

RDBMS: Oracle 12c, 11g, and 10g

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, and Cisco VPN Client, sql developer,DELPHIX,foglight,OEM

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

Oracle Database Administrator V/AppDBA

Responsibilities:

• Migrated Oracle databases to DBAAS environment and worked on oracle Exadata server.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Applied PSU patches 12.1.0.2 Oracle databases in standalone and RAC environment.
• 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.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using opatch auto for Grid and opatch apply for standalone.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 12c, 11g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 12c, 11g.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Confidential - Austin, TX

Oracle Database Administrator

Responsibilities:

• Upgraded the databases to version 12c from 11g and 10g
• Up-gradation and Migration of Database from 10g to 11g and then to 12c and also applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Successfully implemented 11g RAC on nodes for high availability.
• 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.
• Involved in construction of DR sites for all the Production environments.
• Installed 12c database
• Worked on Multitenant databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining partitions, indexing and use of Hints, Stored outlines, Statistics.
• Used Oracle 12c database and cloud control 12c to monitor all databases.
• Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the database.
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, and operating system.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of Oracle OLTP environment.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - Bronx, NY

Oracle DBA

Responsibilities:

• Performed Installation and configuration of Oracle 11.2.0.1 database .
• 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.
• 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.
• 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 11.2.0.2 and 11.2.0.3, 11.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.
• Administration of ASM storage, services, addition and deletion of nodes.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
• 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. Created the database, tablespace, tables, indexes, set privileges and user logins.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Provided OS (RAM, I/O, CPU) tuning for Oracle Database.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applied patches both Server side and Client side.
• Worked extensively on Performance Tuning, Memory (SGA) Tuning.
• Cloned databases using scripts as well as RMAN.
• Installation, setup and configuration of Data guard. Active Data guard
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues
• OLTP modelling and database consolidation