SUMMARY:

• 9+ Years of experience as Oracle DBA ( 12c /11g / 10g / 9i ) on different UNIX (RHEL, HP - UX, Sun Solaris, Linux, AIX) and Windows environments.
• Experience in Installing, Maintaining, Upgrading and Patching Oracle versions 12.2.0.1,12.1.0.2, 11.2.0.4, 11.2.0.3, 11.1.0.7, 10.2.0.5 and 9.2.0.8.
• Experience in System monitoring and Database Performance Tuning using tools like Explain Plan, SQL Trace, TKprof, AWR, OEM, SQL Plus, SRVCTL, DGMGRL and also Cluster Interconnect Tuning (RAC).
• Upgraded Oracle databases to 12.2.0.1 from 12.1.0.2 and 11.2 versions.
• Implemented Oracle Golden Gate in both Unidirectional and Bidirectional replication and also GG Heterogeneous replication using Golden gate (Oracle 12.1.0.2, 11.2.0.3 to SQL Server 2008 R2).
• Managed Oracle and SQL server in High Availability environments using Failover, Clustering, Mirroring, Data Guard and Cloning technologies.
• Migrated database from 9i, 10g, 11g to 12c by using Scripts and applied patches using OPatch utility.
• Upgraded Database to 12c (12.1.0.2) from earlier versions 11.2.0.4, 11.2.0.3, 10g and 9i using Manual and DBUA methods in RAC and non-RAC environments.
• Involved in Installation, Configuration and deployment of Oracle Database and Real Application Clusters (RAC) on multi nodes with Automatic Storage Management (ASM) and experience in adding and removing nodes.
• Experience in Database full Backup (hot and cold), Incomplete Backup, Data Pump Export/Import, SQL Backtrack and Restore procedures.
• Web Logic 11g/10g Administration, Monitoring and Troubleshooting using Admin Console.
• Experienced in setting up Load Balancing, Startup, Shutdown of Individual instances on RAC database.
• Installed and upgraded OEM 13c from 12c, 11g & 10g Grid agent on servers and configure OEM Grid control.
• Handled VLDB (very large databases) ranging from 300 GB up to 40 TB+ in OLTP, Data Warehouse environments.
• Creating Schemas, Users, Roles and Privileges in Oracle Databases.
• Experience in maintenance of Production, Testing, Development for RAC, Standby databases (both physical and logical), Data guard for OLTP and Data Warehouse environments
• Prevent issues and reduced the problem tickets by proactively designing the systems and processes for monitoring the databases.
• Upgraded Oracle Grid Infrastructure ASM, RAC clusters from 10g, 11g to 12c and 12.2.0.1.
• Installation and Configuration of Oracle 12c, 11g and 10g Real Application Clusters (RAC) on multi - node with Automatic Storage Management (ASM).
• Expertise in Upgrade and Migration of Oracle Database to higher version and cross- platforms using Oracle Data Migration Assistant.
• Experience in Performance Tuning of database, instances, SGA, I/O and Rollback segment using different methods and detecting locks.
• Involved in Disaster Recovery planning, detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
• Experience of Installing, Upgrading, Patches, TAR support. Duties included database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Configured and Maintained Physical & Logical Data Guard for High Availability and offline reporting.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Experience in Performance Tuning (I/O, Memory & SQL/PLSQL Tuning) using SQL PROFILES, EXPLAIN PLAN, TKPROF, and STATSPACK.
• Experience in full Software Development Life Cycle (SDLC) of database administration.
• Monitoring and Management of various Database Components (Logical & Physical) like Table Spaces and Segments.
• Sound working knowledge about various Logical Volume Managers (LVMs), RAID technology, etc.
• Experienced working on OLTP, Data Warehousing, and ERP environments.

TECHNICAL SKILLS:

Operating System: HP-Unix (11i), AIX 5.2, 5.3.6.1 Solaris 9, 10 & SUSE Linux 9.3 servers, Windows 2003/2008R2 Server, RHEL 5.x, 6.x and 7.x

Database: ORACLE 8i/9i/10g/11g/12c, SQL server 2005/2008R2

Tools: &Utilities: Grid Control/ OEM (Oracle Enterprise Manager), RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus, SQL Trace, MS Project Management, TOAD, Data Guard, Putty, MS Visio, DB Designer, OPatch, Spotlight, Kintana, Telnet, Winscp3, Humming Bird (Exceed), Virtual Network Computing with PC Anywhere and VNC.

Programming Languages: C, SQL, PL/SQL.

Scripting Languages: UNIX Shell Script, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Broomfield, CO

Sr. Oracle DBA

Responsibilities:

• 24*7 production database support for multiple environments.
• Installed and Upgraded Oracle databases from 11g to 12.1.0.2 and also from 11g & 12.1.0.2 to 12.2.0.1.
• Upgraded GI (Grid Infrastructure) from 11g to 12.1.0.2 and 12.2.0.1
• Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
• Installed and configured RAC multi nodes (2-node & 4-node) with ASM storage for Oracle Databases 12c / 11g / 10g.
• Configured DDBoost for RMAN backups to TAPE and creating backup jobs and scheduling them via autosys.
• Installed OEM agent on multiple servers and promoted database targets.
• Created standard document and worked on multiple server decommission and database decommission process.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on CLOB storage reclaim process for older partitions.
• Performance tuning, optimization, sizing and capacity planning for all databases quarterly.
• Created several PRIMARY & STANDBY logical and physical databases for Oracle Data Guard and setup in broker configuration.
• Installed and configured OEM 13c cloud control and upgraded from earlier versions 12c / 10g.
• Installed Real Application Cluster (RAC) on multi node (2-node & 4- node and 6- node) architecture for 12.1.0.2, 11.2.0.4 Databases with Automatic Storage Management (ASM).
• Generated Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)reports for the health check of the databases.
• Configure and build Golden Gate Extracts/ replicat for multiple databases and maintaining uni-directional and bi-directional golden gate replication.
• Cloning & duplicating databases using Snapshots as well as RMAN backups.
• Working knowledge of UNIX, AIX, and Linux (RHEL) operating systems (OS), network administration and security.
• Created and administered ASM instances and maintaining ASM disks and disk groups like adding additional LUN's for ASM storage, adding disks to ASM disk groups.
• Technical expertise with Oracle, including database RAC, Golden Gate, Data Guard, Exadata, performance and tuning, troubleshooting, etc.
• Provisioned multiple servers in C3 (Cloud Computing Concept) cloud using standard templates for 11g and 12c databases.
• Re-linking the binary files after cloning when binary level issued occurred.
• Supported Exadata Patching, Physical unix server patching.

Environment: Oracle 12c, 11gR2, Red hat Linux 5.x /6.x, Oracle 11gRAC, Toad, SQL-Developer, PL/SQL, Oracle Exadata EX2, SQL*Loader, ODBC, OEM, ASM, OLTP, 11g Grid Control, Oracle RAC Grid Control, and Data guard.

Confidential, Paramus, NJ

Sr. Oracle DBA

Responsibilities:

• 24*7 production database support for several environments.
• Installed Oracle Databases for database versions 11g (11.2.0.4 and 11.2.0.3) and 12C (12.1.0.2) and Upgraded Oracle Databases from 11.2.0.4 / 11.2.0.3 to 12.1.0.2.
• Installed Real Application Cluster (RAC) on multi node (4-node) architecture for 12.1.0.2, 11.2.0.4/3 Databases with Automatic Storage Management (ASM).
• Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.
• Managing Oracle Streams used for replication of data between two databases in different data centre’s in Master - Slave mode.
• Experience in monitoring Cassandra, Mongo DB and Windows 2008/12 Databases.
• Configured and enabled Multi Tenant option in Oracle 12c (12.1.0.2).
• Design, develop, and manage data on Cassandra cluster
• End-to-end performance tuning of Cassandra clusters against very large data sets.
• Installed OEM 13c, 12c cloud agents and migrated the targets from 10g OEM to 12c / 13c.
• Applied CPU & PSU security patches in both RAC and standalone systems in ASM & non - ASM environments.
• Investigate Replication failures using Log Dump utility.
• Work on 12c Cloud with following things: Verify all Instances are up, verify DBSNMP is running, verify enough resources for acceptable performance, Verify rollback segment, identify bad growth projections in 12c.
• Installed SSL certificates in Linux server, Windows application servers for EBS and Longview applications.
• Cloning & duplicating databases using Snapshots as well as RMAN backups.
• Develop custom utilities to automate manually intensive tasks including mass schema changes.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Performance tuning, optimization, sizing and capacity planning
• Setup and installed Oracle Golden Gate for data replication from Oracle to non-Oracle and vice-versa.
• Using TKPROF, AWR, ADDM, STATSPACK, and EXPLAINPLAN for monitoring database performance.
• Writing and modifying UNIX shell scripts to manage Oracle environments and for monitoring Backend Oracle Processes.
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Created and maintained 2-node and 3-node RAC environments in both ASM and non-ASM environments.
• Created and administered ASM instances and maintaining ASM disks and disk groups like adding additional LUN's for ASM storage, adding disks to ASM disk groups.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database and analyzed the schemas.
• Created PRIMARY & STANDBY logical and physical databases for Oracle Data Guard.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and performance issues.
• Database Capacity Planning & configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Technical expertise with Oracle, including database RAC, Golden Gate, Data Guard, Exadata, performance and tuning, troubleshooting, etc.
• Creating & Managing Database Structures, Storage planning, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Installed and configured OEM 13c cloud control and upgraded from earlier versions 12c / 10g.
• Taking Backups on scheduled time and monitoring scheduled Backups through RMAN.
• Data Refresh from Production to SIT/UAT/LT and Development environments using RMAN Duplicate Database.
• Installed and exported APEX and schemas export and from one Env to other Env and applied latest patches.
• Installed and Configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM.
• Setup, Configured and supported Physical Standby (Data Guard) databases for high availability and disaster recovery.
• Responsible for quarterly patching and bug fixes using EM12c.
• Managing replication using Golden Gate and using Golden Gate to migrate data from Oracle on Windows to Unix / Linux.
• Setting up and configuring Oracle Golden Gate replication on both source and target for zero-downtime migrations.
• Generated Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)reports for the health check of the databases.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery.
• Configured backup settings, created jobs for the backups and maintenance for the database servers in the grid control.
• Involved in Data Migration / Conversion Process from different data sources like DB2 and MSSQL databases.

Environment: Oracle 12c, 11gR2, Red hat Linux 5.x /6.x,, Oracle 11gRAC, Apache Cassandra 3.0, Toad, SQL-navigator, PL/SQL, Oracle Exadata EX2, SQL*Loader, ODBC, OEM, ASM, OLTP, 11g Grid Control, Oracle RAC Grid Control, and Data guard.

Confidential, GA

Sr. Oracle DBA

Responsibilities:

• Worked as an Oracle Production DBA 11gR2/10g on RHEL 5.x, HP-Unix 11.x.
• Upgraded Oracle Database from 10g to 11g (11.2.0.3) for EBS supported databases in RAC & non-RAC environments.
• Improve recovery process using Replication, Backup/Recovery (operating system and RMAN) and Data Guard (Physical Standby Database)
• Installed and configured RAC multi nodes (2-node & 4-node) with ASM storage for Oracle Databases 11g / 10g.
• Experienced and in setting up/installation configuration of release 11g R2 RAC with ASM and 11g CRS.
• Performed Tuning, coding and Monitored Oracle Real Application Clusters (RAC) nodes and OEM.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day to day management of the databases.
• Monitoring WebLogic11g/10g server health and security
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Investigate Replication failures using LogDump utility
• Deploying different applications like WAR files, EJB jars files and enterprise application archives (EAR) on WebLogic Servers.
• Supports multiple distributed environments to monitor the systems for recoverability, efficiency, reliability, availability and data integrity.
• Involved in Oracle partition tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Create, configure and tune web logic domains/applications for performance.
• Configure and build Golden Gate Extracts/replicat for multiple databases and maintaining uni-directional and bi-directional golden gate replication.
• Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Implemented SSL certificates for Oracle Databases.
• DDL replication using Golden Gate and Test initial Data Load option of Golden Gate during environment build.
• Migrated database from ASM to Non-ASM using RMAN.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Trouble shooting and performance tuning Golden Gate replications
• Configure error handling for restart, logging, production support and status reporting in GG
• Upgraded the data’s from Existing Oracle 9i to Oracle 10g to 11g.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Setup GoldenGate Database User with necessary privileges
• Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration. Implemented Oracle Enterprise Manager Grid Control and configured agents.
• Database administration activities including Table Spaces allocation, user enrollments and database re-organization.
• Re-linking the binary files after cloning when binary level issued occurred.
• Configured Transparent Application Failover (TAF) and Load balancing on RAC.
• Identified heavy resource consuming transactions/jobs to all request, developers to tune the components OEM Automatic Workload Repository Snapshots.
• Ensuring that adequate recovery procedures are in place, based on Database backups being done and verified.

Environment: Oracle 11g/10g HP-Unix 11i v3, Solaris 10, AIX 5.2, RAC, RMAN, OEM, Windows 2003 Servers, Oracle RAC, Oracle OEM 11g, OLTP, TOAD.

Confidential, Richmond, VA

Oracle DBA

Responsibilities:

• Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.
• Upgrade of database from 10.2.0.4 to 11.1.0.6 by applying patches using OPatch utility.
• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, Grid Monitoring.
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Stats pack, ASH.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Golden Gate 11g Installation and configuration and troubleshooting using Log miner
• Cloned database for test environment from PROD.
• Migrated 10 databases (14TB+) from SQL Server 2000/2005to Oracle 11g database.
• 24x7 on-call production database support.
• Administering Real Application Cluster (RAC) 11.1.0.7 databases running on Cluster File system.
• Migrated database objects from database to other server by using Export/Import, Datapump.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Installation and Configuration of Oracle Golden gate software for oracle to SQL Server replication
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX KShell Scripts.
• Golden Gate DDL and DML replication across Database
• Responsible for scheduling and holding design reviews as needed to support the development processes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily backup’s logs and alert logs
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and use data pump jobs for loading the subscriber and history related data at replicated site.
• Configured user log on load balancing and failover on RAC database
• Database Capacity Planning& configuration (redo and stream sizes), design staging schema and use of DBMS STREAM ADM packages.
• Plan Golden Gate setup to achieve Unidirectional replication
• Handful of experience with ERWIN tool for data modeling.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Applied patches and database re-organization using oracle enterprise manager (OEM).
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Assisting developers in getting database connection from the client using SQL *net and Net8.
• System wide tuning using UTLBSTAT and UTLESTAT (stat pack).
• Maintained very Large Multi Terabyte (VLDB) around 14TB+ in Data Warehouse Environment for DSS.
• DBA activities which includeCreating Users, Roles and Profiles, Privilege management with role-based security of databases, table spaces, indexing, data maintenance, roles, user management, and maintenance.
• Load data from OLTP systems into data warehouse databases.
• Documentation of Oracle database operations and training of backup personnel.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, RHEL 4.x, SUN SOLARIS 10, HP-UX 11AIX 5,Toad, SQL, PL/SQL, ERWIN, Data Guard, Data Pump, OEM, RMAN, SQL*Loader, Streams, Shell Scripting, SQL Server, Data Warehouse, OLTP.

Oracle DBA

Confidential, Dunwoody, GA

Responsibilities:

• Worked as Oracle DBA (10g) on HP-UX 11i v3.
• Installed and configured Oracle Database Software 10g.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters ( RAC) on 2 nodes (HP-UX v3.0) with Automatic Storage Management (ASM).
• Installed and Configured Oracle 9.2.0.1 (9i) database to Oracle 10g.
• Maintained & monitored the Real Application Cluster (RAC) set up and stand alone Database using OEM and TOAD.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Worked in advanced recovery methods like PITR. Logical backup using and full/ partial export/import and Data Pump.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Upgraded Oracle Database to 10g from 9i and analyzed performance issues after upgrading.
• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Used SQL* loader to move data from legacy systems.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.

Environment: Oracle 10g/9i, HP-UX 11i v3, RAC.

Oracle DBA

Confidential

Responsibilities:

• Installation and configuration of Oracle Database Software 10g.
• Oracle 10g,OEM, SQL * plus, SQL * Navigator, DBA studio, imp/exp, RMAN, SQL, PL/SQL, SQL* loader, Net8, TKPROF, Oracle Tuning pack, Diagnostic pack, Red Hat Linux, and Windows
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Involved in the project implementing and configuring Real Application Clusters (RAC) 2 nodes on Oracle 10g with Automatic Storage Management (ASM).
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Data modeling with extensive normalization activity.
• Installation and configuration of Statspack and analysis of Statspack. Performance report and subsequent tuning, monitoring of production database.
• Data Migration (from 9.2.0.5 to 10.2.0.1) on AIX 5.1, which is made on a Linux Advance Server.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
• Using RMAN for backup and recovery.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Installing and troubleshooting Red Hat Enterprise Linux 5.0 for Oracle 9i and 10g and RAC setup.

Environment: ORACLE 10g, Red Hat Linux Enterprise Server, AIX 5L 5.1, OEM, Window 2003 Server.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g Database on AIX 5L v5.1 and Linux advance Server on Development, Test and Production Systems.
• Created and maintained Databases and their objects like table spaces, tables, indexes, views.
• Migrated Databases from 9.2.0.8 to Oracle 10.2.0.3
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Administered database using Oracle Enterprise Manager.
• Team member of Backup and Recovery Group (consist of 4 DBAs) responsible for Disaster recovery and Standby Database. Full/partial export/import.
• Created and executed various database queries.
• Performed RMAN and backups like hot /cold backups.
• Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.
• Implemented security protocols for the database.
• Performed database cloning to create Test and Development environments from Production.
• Scheduled jobs to run on daily/weekly/monthly basis.
• Involved in design physical and logical models of the database.
• Provided 24x7 on-call supports. Willingness and flexibility to work beyond regular hours based on business demands.

Environment: Oracle 9i/10g LINUX (RED HAT Advance Server), AIX, RMAN Restoring and Recovery, Data Loading, Data pump.