SUMMARY

• Around 8 Years of experience in Oracle 9i/10g/11g/11gR2/12c/18c and 19c DBA, and have been actively involved in Installation, Configuration, Upgradation, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Extensive knowledge on Installation, configuration, and migration of Oracle 19c,18c,12c, 11g (11.2.0.3, 11.2.0.4), 10g (10.2.0.3, 10.2.0.4, 10.2.0.5), 9i (9.2.0.8), on LINUX - RHEL, Oracle Enterprise Linux and Windows- 2000/2003, UNIX platforms (Solaris, HP-UX, AIX).
• Experience in database administration for Oracle 9i, 10g,11g and 12c wif experience wifin very large-scale database environment and mission critical large OLTP and OLAP systems.
• Expertise in creating Backups & Recovery procedures and Implementing Backup and Recovery strategies for hot and cold Backups.
• Experience in using RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard.
• Great Knowledge in cloning database using RMAN Duplicate.
• Performed FLASHBACK features to handle efficient database recovery.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Experience in Oracle Gloden Gate installation, configuration, troubleshooting GG issues.
• Worked on issues raised while replicating teh data using Gloden Gate.
• Installed and configured Oracle Enterprise Manager to monitor teh Databases.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer. Monitoring Alert log for any errors and issues.
• Implemented production and standby databases for Oracle Exadata and OLTP using customized shell scripts.
• Performance Monitoring and Tuning ofOracleApplication Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Worked on Data transferring wif export/import utilities and Data pump.
• Implemented TDE (Transparent Data Encryption) on multiple 12c and 11g databases at tablespace level.
• Data Loading using DATA PUMP utilities and DBVERIFY for corruption checking.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes wif ASM (automatic storage management).
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to teh development team and handling release schedules.
• Applying latest CPU, PSU patches fromOracleSupport to teh Test and Production Instances for resolving issues or Enhancing features.
• Keeping teh database up to date by applying teh latest CPU and PSU using teh OPATCH utility.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, V$ views, DBA views and Data modeling, Logical and Physical databases design.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.
• Have strong analytical, administration and problem-solving skills dedicated to maintain teh high quality standards. Good communication skills and ability to work independently.

TECHNICAL SKILLS

Operating Systems: LINUX- RHEL, Oracle Enterprise Linux and Windows- 2000/2003, UNIX platforms (Solaris, HP-UX, AIX).

RDBMS: Oracle 19c,18c,12c, 11g R1/R2, 10g R1/R2, 9i, Oracle Exadata Database Machine, Oracle Gloden Gate

Languages: UNIX Shell Scripting SQL, PL/SQL, C, C++, Java, J2EE, Perl, PHP, XML, HTML.

Tools: /Utilities: RMAN, ASM, OEM, SQL*Loader, Export/Import, TOAD, Data pump, VB, Putty.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK, AND ASH.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained 11gR2 and 12C, RAC/Single Instance Database on RHEL Linux and Sun Solaris platforms and Upgraded from Oracle 11.2.0.4 to 12.1.0.2
• Installed and configured 3 Node RAC in 19c, 18c releases.
• Involved in teh upgrade projects from 12c to 18c and from 12c to 19c.
• Responsible for teh configuration and maintenance of Standby databases (Data guard -Physical standby) for high availability and disaster recovery purpose.
• Responsible for testing and conducting of DR drills by converting teh Physical standby database to teh Snapshot standby database.
• Applied PSU, one-off patches using OPATCH utility to keep teh databases up to date.
• Implemented Oracle database backup & recovery solutions using RMAN, configured incremental backups on teh databases on daily and weekly basis.
• Refreshed databases using Oracle data pump utilities (Expdp & Impdp).
• Implementation and configuration of Oracle Enterprise Manager (OEM) agents for monitoring and maintenance of databases.
• Wrote shell scripts and configured CRON jobs for teh proactive monitoring, alerting and health checks of databases.
• Responsible for database performance tuning and query optimization using AWR, ADDM reports, SQL Trace, Explain plain, SQL tuning advisor.
• Worked on resolving performance issues at DB level and also at teh SQL level.
• Fixed performance issues by checking teh query Explain plan and by applying SQL Profile and SQL plan baselines.
• Administering and monitoring of databases using tools like OEM, TOAD, New Relic.
• Performing day-to-day regular DBA activities like creating User accounts, Rolesand granting requiredaccess permissions and privileges based on teh requirement of teh application team and developers wif teh required approvals.
• Responsible for providing database users list report as per teh SOX compliance for teh quarterly and annual audits.
• Responsible for teh monitoring teh Database growth and increasing teh tablespace sizes, Reorg of Tablespaces, Identifying and recompiling invalid schema objects.
• Gathering and scheduling schema, table stats and monitoring performance of teh system.
• Oracle Gloden Gate s/w installation, Configure, maintain, troubleshoot, and provide production Support.
• Gloden Gate One way & Bidirectional replication configuration and support.
• Worked wif teh application team and developer to implement teh partitioning strategy for large tables for better performance and manageability.
• Involved in teh rehydration of AWS EC2 instances wif teh latest AMIs using JENKINS jobs provided by teh Cloud governance team.
• Providing 24*7 on-call support for teh production databases on weekly basis.
• Worked wif Oracle-support to resolve critical database issues.

Confidential, Mason, OH

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Exadata 11gR2 and 12c single instance and RAC databases on UNIX and LINUX platforms. Upgraded databases from 11.2.0.2 to 11.2.0.4. Installed, configured and maintained 12c agents.
• Implemented Oracle Real Application Clusters (RAC) on Linux for an ORMB (Oracle Revenue Management and Billing) OLTP application wif high transaction volume.
• Upgrading Oracle Databases from 11.2.0.4 to 12.1.0.2
• Worked on Multiple Oracle Exadata 12c and 11g RAC 2-node cluster databases.
• Applying Quarterly Critical patch updates (CPU) for Oracle Databases and Applications and doing Patching analysis for teh same.
• Scheduling and making successful backups of databases using traditional methods (COLD & HOT), Logical (EXP & EXPDP) and RMAN.
• Responsible for creating RMAN catalog Database and Registering teh Databases in Catalog Database.
• Refreshing of Databases from Production to Performance databases and other lower environments using data pump utilities (Expdp & Impdp).
• Installed agents on database servers and configured enterprise manager.
• Logical and physical database design.
• Implemented TDE (Transparent Data Encryption) on multiple 12c and 11g databases at tablespace level.
• Migrated Database between servers using Data pump Export/Import.
• Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer. Monitoring Alert log for any errors and issues.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management wif role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and using AWR, ADDM reports.
• Experience in applying critical patch update (CPU), and individual patch sets software upgrade for Oracledatabase server and Application server
• Creating and maintaining documentation for teh various existing processes and for new installations.
• Adding Table spaces and maintaining its sizes, scheduling dba jobs and crontab’s for alerts.
• Providing 24x7 for PRODUCTION environments and worked wif ORACLE TEAM on issue resolution.
• Best in solving teh user related issues, interacting wif user/developers.
• Database health check, pinning of objects, monitoring teh Database Growth and increasing teh tablespace sizes, Reorg of Tablespaces, Identifying and recompiling invalid schema objects.
• Gathering and scheduling schema stats and monitoring performance of teh system.

Environment: 11.2.02/11.2.0.4 , 12.1.0.2, LINUX, UNIX, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures, ASM, RMAN, RAC, Data Guard, TOAD SQL Developer, Putty.

Confidential, St. Louis, MO

Sr. Oracle DBA

Responsibilities:

• Performed administrative maintenance, monitoring onOracledatabase systems in a global 24x7 operational environment.
• Installed, configured, and maintained Oracle10g and 11gR2, RAC/Single Instance Database on Linux and Upgraded from Oracle10g to 11g.
• Upgraded databases from 10.2.0.4 to 11.2.0.4 and 12.1.0.2 on SOLARIS/LINUX environments.
• Responsible for mapping ASM volumes to teh SAN disks, process to copy teh data from old to new.
• Storage/Database migration from EMC-Vmax storage arrays to other Vmax storage arrays and Hitachi storage arrays.
• Involved in Performance Tuning/Troubleshooting complex queries and server performance issues and Recommend improvements in teh reporting and batch processing code bases based on analysis of system snapshots
• Involved in implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding teh indexes and shrinking tables at regular intervals as a part of maintenance activity for better performance.
• Planning and scheduling Backups,DatabaseRecovery, taking Logical Backups (wif Export /Import),Databasebackup (Hot & cold) and automate all teh process.
• Performed in managing teh databases using teh OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Applied Patches like CSU, PSU and Bug-fixes for database performance issues.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
• Refresh teh test and development databases from teh source production databases on a regular basis using export/import utility.
• Applying Patches 11.2.0.3 and applying Oracle DST Patches on Oracle database.
• Diagnose and troubleshoot Database problems and failures like instance crashes, internal errors, etc.
• Involved in RMAN Duplicate Database Cloning.
• Good experience in SQL, PL/SQL, Shell Scripting.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Experience in shell scripts through Cron-jobs to automate different types of backups including RMAN. Implemented and maintainedDatabasesecurity and atomized Administrative tasks.
• Support & Maintenance of Production, Development and Test Databases on various servers.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and recoveries.
• Performed cross platform migration using transportable table spaces and RMAN.
• Restoration and Recoveryof databases at teh times of occurrence of critical failures.
• Worked wifData Pumpto take teh logical backups of databases.
• Installed, configured and supported uni-directional and bi-directional replicated environments utilizing Gloden Gate.
• Responsible for automation of startup and shutdown on all production and development databases.
• Responsible for using Flashback query mechanism along wif automatic undo management.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 11g R2 (11.2.0.4), Oracle Exadata Database EX2, windows XP, SQL*Loader, OEM, PL/SQL Developer, Import/Export, RMAN.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.
• Up gradation of Database from 11g to 12c and applying patches whenever required.
• Installed, configured and monitored multi nodeOracle12c/11g R2 RAC, Exadata.
• Converted a single instance database toOracleRAC.
• Implementation and Configuration of OEM &OracleManagement Server for maintenance and monitoring.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Experience in Oracle Gloden Gate installation, configuration, troubleshooting GG issues.
• Worked on issues raised while replicating teh data using Gloden Gate.
• Involved in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer. Monitoring Alert log for any errors and issues.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked wif various features: Streams and Automatic Storage Management (ASM).
• Analyzed teh user requirements, designed partitioned tables and created indexes for improving performance and manageability because many queries can prune partitions.
• Evaluating teh Backup and Recovery Procedures periodically & performing backups and recovery by using RMAN.
• Expertise in Data Loading using DATA PUMP utilities and DBVERIFY for corruption checking.
• Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Designed and effectively implemented teh Database part of teh full Data center migration from one city to another wif minimal downtime wif solid backup plan which involves databases of size greater than 1 TB.
• Management of security, granting and revoking permissions to users/roles as and when required.
• Performed Database, OS and application tuning.
• Writing UNIX shell scripts for backup and recovery, Import and export procedure, PL/SQL functions, procedures, packages and triggers.
• Working wif QA and Development teams for teh regular database support.
• Performing teh daily Maintenance tasks and interacting wifOracleCustomer service when required.
• Assisted IT Analysts on technical database issues and features.
• Able to work effectively wif multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.

Environment: Oracle 12c, 11g R1, R2 (11.2.0.1) (11.2.0.2) (11.2.0.4), Oracle Exadata Database EX2, RHEL 4.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, RMA, RAC, Data Guard wif physical and logical standby databases.

Confidential, Plano, TX

Sr. Oracle DBA

Responsibilities:

• Responsible for new Installations ofOracleRAC, ASM, OEM on 10g, 11gR2 under Windows, RH Linux.
• Expertise in 24x7 production database and applications support.
• Installation, configuration and maintenance of Oracle 11gR1 and 11gR2 databases and worked on configuring 11gR2 RAC wif ASM.
• Working on troubleshooting cluster interconnect performance issues and configured SCAN for 11gR2 RAC clusters.
• Worked on rolling upgrade of RAC cluster from 10.2.0.5 to 11.2.0.3 using logical stand.
• Involved in Installing, Configuring, Administration and tuning of Oracle 10g RAC/11g RAC.
• Upgraded Oracle databases from 10g to 11gR2 and Migrated Database between servers using Data pump Export/Import.
• Knowledge of teh OracleGlodenGateinstallation, configuration, troubleshooting GG issues.
• Backup and Recovery of OCR/ Voting disk, Checking teh validity and existing dump of OCR files.
• Involved in teh implementation of Oracle 11g Data Guard on physical standby databases.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (wif Export/Import Data pump utilities).
• Worked on Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space.
• Responsible for applying CPU patches on most of teh production databases.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for teh same.
• Performed SQL and PL/SQL tuning, monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely wif teh Oracle developers for teh better performance in Applications in writing teh Packages, Triggers, Materialized Views and Indexes on teh tables.
• Involved in PL/SQL and UNIX shell scripting and automating them using Cron Utility.
• Cloning databases using scripts as well as RMAN for test and development.
• Tuned teh Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gatheird DBMS statistics
• Monitored teh database objects growth, managing teh extents growth and de-fragmenting teh objects, which are running out of maximum extents. Monitoring teh excessive fragmentation of table spaces and taking remedial steps.
• Working wif Oracle Support for resolving teh database related unresolved issues.

Environment: Oracle 10g/11g, RAC, RMAN, ASM, OEM, DATAGUARD, DATAPUMP, GlodenGate, TOAD, SQL, PL/SQL, RedHat Linux.

Confidential, Morrisville, NC

Sr. Oracle DBA

Responsibilities:

• Involved in Installation of Oracle 11g database in ASM (Linux).
• Upgraded databases fromOracle9i to 10g,Oracle10g to 11g.
• Created users & privileges wif appropriate roles and levels of security
• Expertise in maintaining teh Cold and Hot backups of teh databases
• Performed Day to Day activities such as checking alert logs and scheduled tasks
• Created and managed table spaces monitored teh data files space, resizing and adding new data files etc
• Exporting & importing data into teh databases, using Oracle utilities such as exp/ imp, and Data pump
• Monitoring and performing daily incremental backups, weekly backups using Rman utility.
• Involved in recovering of teh data block using Rman utility and complex backup and recovery issues.
• Database Restore using RMAN, Cold Backup and Import
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing teh index as per teh fragmentation level and minimize teh performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Monitoring teh CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Applied bug patches according to teh Oracle Critical Patch alerts.
• Configured teh automated alerts for teh production servers, which alerts DBA wif teh alert log errors and proactively space related errors.
• Identified and trouble shot everyday issues like locking and scripts execution.
• Working wif teh application support people to resolve database related issues and running teh scripts for teh application support people.
• Creating Users and Database links, snap shots on production and development servers.
• Checking CRON jobs and restarting teh failed jobs.
• Implemented automated backup strategy using teh UNIX shell script and CRON Utility.
• Used SQL*Loader to load data from flat files to Oracle database.
• Monitoring of teh scheduled backup’s on Regular basis.

Environment: Oracle 10g/11g, ASM, Red Hat Linux 4.x/5.x, Windows 2003, OEM, SQL*Loader, Grid Control, RMAN, ASM, Data guard, TOAD, Data pump.