SUMMARY:

• Over 8.6 years of IT experience as Senior Oracle Database Administrator working with versions 12C/11G/10G/9i on a variety of UNIX (Solaris, HP - UX, AIX, OEL, RHEL), Windows Server 2003/2008/2012 with RAC, Streams, Golden Gate, Physical/Logical Standby, replication, installation, configuration, upgrade, migration, sizing, space management, backup and recovery, performance tuning and troubleshooting.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS, RHEL, OEL and migration of oracle server from 9i to 10g and 10g to 11g and 11g to 12c applied oracle patches.
• Installed Oracle 11g and 12c RAC software with ASM File system.
• Installation, maintenance and tuning of RAC Databases.
• Designed and implemented Oracle Real Application Clusters (RAC) on RHEL and OEL for an OLTP application with Transaction Application Failover and high transaction volume.
• Migrated across many platforms, and have worked on RAC nodes up to 8 node clusters. Installed 12c Enterprise Manager, 12c Database, and migrated to 12c RAC Cloud.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Managing users, privileges and tablespaces in Container (CDB) and pluggable databases (PDB) in Oracle 12c
• Experienced in setting up unidirectional and Bi-directional replication using gate 12.1 for high availability, reporting projects and alerts on exadata
• Oracle Golden gate process Administration, monitoring, processing and maintenance, managing Golden Gate file cleanup, troubleshooting errors and out of sync conditions.
• Experienced in installing and troubleshooting Goldengate issues using command level tools as well as LOGDUMP utility.
• Worked on logdump, keygen and defgen utilities in Golden gate and Configured Golden gate Director for monitoring alerts.
• Worked on Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
• 24*7 production database support including Support to developers & end-users.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and EMC Data Domain.
• Have worked on large-scale databases with size of more than 1TB in large system environments.
• Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC).
• Logical and physical modeling using Erwin.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to Monitor Tablespace and Extent Growth
• Experienced with tools/utilities: AWR Reports, Statspack, OEM Grid Control, SQL* Loader, Logminer, data pump, export/import, Golden Gate 11.1.
• Installing, configuring and managing of SQL server 2008/2008 R2/2012 and Open Edge databases.
• Migrated databases from SQL Server 2005 to SQL Server 2008/2008 R2/2012.
• Implementing database security and managing logins, server roles, database roles and database permissions.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.).
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views and advanced replication methods

TECHNICAL SKILLS:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 9, 10, AIX 5.1, 6.1, 7.1 IBM, Red Hat Linux RHEL 5.x, 6.x, 7.x and OEL 5.x, 6.x.

RDBMS: Oracle 12c/11g/10g/9i, Oracle 10G, 11G, 12C Real Application Clusters (RAC), MS SQL Server 2008, 2005

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.

SOFTWARE/ APPLICATIONS/ TOOLS: ORACLE 9i/10g/11g/12c, OAS 10g Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters, VERITAS Backup, EMC Storage, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager, EMC Data Domain, BMC BladeLogic, Golden Gate

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle DBA / SQL Server DBA

Responsibilities:

• Responsible for administration and supporting Oracle 10g, 11g and 12c databases.
• Provided 24x7 on call production support.
• Setup 8 Node Oracle 11gr2 RAC Cluster on RHEL, helped setup SAN, Switches, Operating System.
• Migrated existing databases, performance tuning, setup Oracle Grid for Databases, provisioning, application management and alerts.
• Involved in several database proof of concept tests which are done before the database migrations to test the scalability and performance of the databases in the new environment.
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experienced in setting up unidirectional and Bi-directional replication using goldengate 12.1 for high availability, reporting projects and alerts on exadata
• Experienced in installing and troubleshooting Goldengate issues using command level tools as well as LOGDUMP utility.
• Worked on logdump, keygen and defgen utilities in Golden gate and Configured Golden gate Director for monitoring alerts.
• Experience In creation and troubleshooting both classic and Integrated extracts.
• Experience In creation and troubleshooting classic, Integrated and Coordinated replicats
• Implemented JMS message capturing using GoldenGate.
• Rebuild the datastore as part of troubleshooting GoldenGate monitoring issues and reallocation of GoldenGate manager process during the database maintenance.
• Configuring both ACFS/DBFS file systems for storage of trail files for the GoldenGate replication.
• Successfully implemented Physical Data Guard and ASM for Critical environments for disaster recovery.
• Configured database encryption on UAT and Production databases using Oracle Transparent Database Encryption (TDE).
• Identified sensitive data that may require encryption and calculated the volume of data to be encrypted.
• Created a new Oracle Encryption Wallet, single sign-on (Auto Open) file for the Oracle Wallet and tablespaces for the application to hold objects to be encrypted and migrated data to the new encrypted tablespaces.
• Involved in Oracle Consolidation and Remediation (OCR) migration from Oracle 12c/11g Non-CDB to Oracle 12c multitenant (CDB/PDB) from Non-Exadata to Exadata.
• Managing users, privileges and tablespaces in Container (CDB) and pluggable databases (PDB) in Oracle 12c
• Upgrade Grid Control from 11g to 12c.
• Installing, configuring and managing of SQL server 2008/2008 R2/2012 databases.
• Migrated databases from SQL Server 2005 to SQL Server 2008/2008 R2/2012.
• Implementing database security and managing logins, server roles, database roles and database permissions.
• Implemented high availability features such as SQL failover cluster instance, mirroring and replication.
• Created POC using new high availability feature always on of SQL server 2012.
• Assisted development team with performance issues, refreshing development/test databases from production databases.
• Created maintenance plans to check database integrity, rebuild index, update statistics and execute SQL server agent jobs.
• Worked with Performance Monitor, SQL Server Profiler and Extended Event Profiler to troubleshoot SQL server issues related to CPU, Memory, File I/O Locking, Blocking and Networking.
• Setup Oracle 11g RAC Data warehouse. Implemented Data Guard, best practices. Tuning and scaling. Installed on Windows, Solaris, Linux and HP-UX. Database migration from AIX to RHEL using expdp/impdp and Oracle streams.
• Applied PSU grid patch on more than 100 clusters and PSU database patch on more than 250 databases.
• Worked on Golden Gate setup and issue tracking and resolutions with Oracle support.
• Setup Goldengate in RAC environment for near zero down time strategy and for replication purpose.
• Hands on experience on Oracle GoldenGate tool including creating multiple extracts and replicats, troubleshooting performance for high availability of replicated data.
• Migrated databases from AIX to SOLARIS using cross platform transportable tablespaces, moved the databases from raw file system to ASM.
• Maintained Oracle Exadata engineered system and databases, implemented and managed Database security, OEM monitoring, database performance tuning, backup & recovery using RMAN. Proactively identified and responded to issues that will impact the availability or performance of databases. Have Linux expertise as well as Oracle RAC, ASM and networking skills.
• Ensured consistent backup's using RMAN & consistent DR databases using Data Guard.
• Analyzed and determined the feasibility of leveraging the Oracle Enterprise Manager solution to report on performance, provide metrics, set up alerts and threshold criteria and become the centralized proactive maintenance solution for Exadata distributions.
• UNIX shell scripting, addressing Exadata Hardware alerts and issues in time.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Configured High Availability with Dataguard and setup RMAN for backups.
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins
• Data Modeling using ER-Win, Database Design and Creation.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.

ENVIRONMENT: Solaris 9.0/10.0, Linux Red Hat, Oracle 9i/10gR2/11g/12c Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, Toad, Erwin and Golden Gate.

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11g databases
• Installation, Upgrade and Configuration of Oracle (9i, 10g)
• Installed and created 10g databases and 11g OEM
• Implementation of 11g RAC and 11g Dataguard
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins
• Configuration, maintenance and tuning of Oracle 10gRAC and 11gRAC
• Installing and configuring Recovery Manager (RMAN) and Flash Recovery
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Managing users, privileges and tablespaces in Container (CDB) and pluggable databases (PDB) in Oracle 12c
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 10g Release 2 to Oracle 11g Release 2.
• Data Replication, Event Management and Notification
• Data Modeling, Database Design and Creation
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Data Warehouse Loading, Data Protection.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets
• Worked on Golden Gate setup and issue tracking and resolutions with Oracle support.
• Configured Golden Gate for replication between Oracle Databases. Used for Reporting. Setup Architecture, installed servers, setup replication tasks.
• Setup Goldengate in RAC environment for near zero down time strategy and for replication purpose.
• Hands on experience on Oracle GoldenGate tool including creating multiple extracts and replicats, troubleshooting performance for high availability of replicated data.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments
• Extensive UNIX Shell scripting in csh, ksh.
• Write SQL scripts to Monitor tablespace and Extent Growth
• Oracle replication using streams.
• Data Modeling, Database Design and Creation.
• Data Modeling using ER-Win.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Setup Oracle Grid Control. Database schema refresh.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost optimizer, SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics, Statspack etc.
• Expertise in interpreting EXPLAIN PLAN
• Create database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Taking Hot and Cold Backups, Exports etc.
• Oracle Grid control installation for monitoring databases.
• 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
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applying patches both Server side and Client side.
• Setting up new environments (Development, Production).

ENVIRONMENT: Solaris 8.0/9.0/10.0, Linux Red Hat, Windows 2000/2003 Oracle 9i/10gR2,11g Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad and Golden Gate.

Confidential, Chevy Chase, MD

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured Oracle data guard and Streams.
• Oracle Grid Control Management Server Installation
• Reverse engineering and forward engineering using Erwin.
• Data Modeling, Database Design and Creation using Erwin.
• Production to development refresh.
• Implementation of 10g Dataguard.
• Bi-directional streams implementation.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Generated Reports using crystal reports
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Worked on recovering tables and databases using Flash Recovery.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

ENVIRONMENT: Windows NT / 2000, HP-UX, AIX and Linux, Oracle 9i and 10g, TOAD 9.0.1, TOAD Space Manager with LiveReorg, Erwin 7.2, Citrix, Oracle Enterprise Manager, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential, Cherry Hill, NJ

Technical Lead

Responsibilities:

• Review of Database logical and Physical design
• Install, upgrade and maintain Oracle software products/versions for on Linux, Sun Solaris and HP-UX.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Installed RAC on Oracle 10g and worked on ASM feature with EMC Storage of Oracle.
• Worked with ETL tool Data Stage and Ware house tool Business Object.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
• Corporation and installation of patches.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Production support for Oracle running on UNIX.
• On-Call 24x7 DBA support for production databases.
• OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM),
• Data Migration as part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DATA guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

ENVIRONMENT: Solaris 8.0/9.0/10.0, OAS 10g, Linux Red Hat, Windows 2000/2003 Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad.

Confidential, Wilmington, DE

Consultant

Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Utilized SQL*loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Took a logical backup of the entire database using import/export utility.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

ENVIRONMENT: Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, Explain plan, STATSPACK, SQL* Loader, Windows NT/2000.

Confidential

Oracle DBA/Developer

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, Perfstat, TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

ENVIRONMENT: ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Erwin, Import/Export, UNIX AIX 5.1Windows NT.

Confidential

Oracle DBA

Responsibilities:

• Worked under Sr.DBA to perform oracle software installations.
• Installed patches, performed database version upgrades with the Sr.DBA support.
• Execution of SQL queries to monitor usage and performance.
• Extensive user support which includes creation of users, granting privileges, roles, helping in troubleshooting SQL queries.
• Creating user accounts and appropriate privileges as well as maintaining database security
• Enabled the Database in Archive Log Mode / No archive log mode
• Modifying the database structure, as necessary, to support activities of application developers
• Involved in doing Hot, Cold backup with and without RMAN.
• Backups using export and import of schemas.
• Used Stats pack for troubleshooting SQL query performance issues.
• Performed partitioning of large tables for increased performance.
• Creation of development and test databases using export/import of full database.
• Assisted in writing scripts for database jobs and scheduling them through CRON utility.
• Managing user, resources and privileges.
• Created and executed SQL reports for management.

ENVIRONMENT: Windows 98/NT / 2000, HP-UX, Oracle 9i/10g, TOAD, Database Tools/Utilities and OEM.