SUMMARY:

• 7 years of experience in Oracle Database Administration, Design & Development, Implementation and Testing of Relational Database Management systems for Business solutions Extensive experience in database development and production system support, Oracle Database Administration on 24x7 critical production and large databases using Oracle 12cRAC,11gRAC, 10g RAC and 12c Standalone database ExaData, GoldenGate architect / Real Application Clusters (RAC),OEM 12c,NetBackup admin and, Linux with an integrated business solution provider through a long time commitment, contributing to the company's growth.
• Providing EXADATA DBA support to multiple Cluster, Non - cluster and ASM Database in production, development and Testing Servers on UNIX, UNIX and Solaris Environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates in various environment ranging from 9i/10g/11g/12c.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c database with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Having Hands on experience working in both Application and Production support environment.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c, Configuration and Management of Data Guard 10g/11g/12c on RHEL, OEL and Sun-Solaris for Disaster Recovery.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.
• Installed and maintained Oracle 12c/11g/10g RAC with ASM & 0CFS2 File systems.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.
• Extensive troubleshooting of typical Oracle Goldengate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsd / logdump/discardfile & ggserr.log analysis.
• Performed Upgradation of databases from lower version (9i/10g) to higher version (11g/12c).
• Implemented RMAN Backupand Recovery, Incomplete Recovery and disaster recovery using Data Guard.
• Have good experience in migrating data from Solaris, HP-Unix to Linux.
• Worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.
• Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and datapump export/import.
• Knowledge of various storage solutions (SAN, NAS).
• Database refresh from production to QA, development and testing environments.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity. Querying Oracle dynamic performance views.
• Analyzed STATSPACK/AWR Reports to identify on-going/proactive issues and Proactive Database tuning to keep hit ratios at a minimum standard guideline using STATSPACK and AWR reports.
• Support databases in Exadata environment andworkedonExadatax3-2,x4-2, x2-2 machines
• Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.
• Performing Database or schema level refreshes using the traditional EXPORT/IMPORT and Data pump or Backup utilities.
• Experience in SQLTuning, SQL Optimization, cost based optimization and Hints.
• Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Extensively used BMC Remedy, Pac 2000 ticketing systems.
• Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.
• Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS:

Operating System: UNIX, LINUX, SOLARIS, AIX, HP-UX and WINDOWS NT/2000, XP, 2003

RDBMS: ORACLE 12c/11g/10.x/9.x and SQL Server 2008/2005

Oracle Tools/Utilities: Golden Gate, Data Guard RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM (13c), ODM, ERWIN, NETCOOL

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Oracle Database Administrator

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC EXADATA databases on Linux and Configured 3 Node RAC on Grid Infrastructure.
• Administered and monitored over 200(Oracle+ETL) databases both on l0g/11g/12c of sizes ranging from l00GB to 3TB.
• Patching Storage server using PATCHMG R utility (OFFUNE/ONLINE).
• Migrating databases from NON-EXADATA to EXADATA (RAC).
• Analyzing database performance before migrating to Exadata.
• Troubleshooting Exadata smart scan/offloading issues
• Monitoring the Infiniband Switches/ports .DB/CELL nodes (ILOM/OEM).
• Enabling Hybrid Columnar compression. HCC
• Hands on Deli and CellCIi utilities
• Enabled Load balancing using DBRM & IORM
• Responsible for using Flashback query mechanism along with automatic undo management
• Experience in Creating Physical and logical database design Data Models using ER Studio.
• Installed 12Cgrid control and Used Oracle Enterprise Manager Grid control 11g/12cfor monitoring databases
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Worked on Active data guard, Fail over and Switch over cases.
• Hands on Experience in SQLTuning and SQL Optimization.
• Analyzing Explain Plan and TK proof trace files.
• Comparing SQL Baselines and SQL performance Analyzer
• Analyzing SQL Advisor and SQL profile Analyzer.
• Creating Tuning reports using SQLTRPT, AW RTRPT utility Analyzing AWR.ADDM.ASH reports
• Creating Oracle SQL profiles.
• Working with Apps team on SQL Query tuning, Troubleshooting Bottle Neck issues.
• Created Oracle Tables, Table Partitions, Views, and Materialized Views.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• Creation of Users and granting them the required Roles and Privileges accordingly
• Cloned schemas, objects and data on new server using Data pump utility
• Decreased Contention by reducing the Wait Events as a part of Performance Tuning
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions&data dictionary corruptions
• Implemented and supported Golden Gate replication in production databases.
• Installed and configured Golden Gate on 11g RAC database running on ASM for replication.
• Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process.
• Involved in installation and configuration of Golden Gate 11.1 and 12 c versions.
• Configured unidirectional Golden gate replications at table and schema level.
• Troubleshooting GoldenGate issues such as process abending and lag on replication environments.

Environment: Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX, TOAD, SQL Developer.

Confidential ,Coppell, TX

Senior Oracle Database Administrator

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC EXADATA databases on Linux and Configured 2/3 Node RAC on Grid Infrastructure.
• Administered and monitored over 120 databases both on l0g/11g/12conprod/test/dev
• Administering Oracle Databases 10g/11g/12c of sizes ranging from l00GBto 1TB.
• Migrated databases from File-system to Automatic Storage Management (ASM).
• Involved in migrating applications from Solaris l0g/11g to Linux 1L2.0.3 using Transportable Tablespace, RMAN Convert.
• Patching Storage server using PATCHMGR utility (OFFUNE/ONLINE).
• Migrating databases from NON-EXADATA to EXADATA(RAC).
• Analyzing database performance before migrating to Exadata.
• Troubleshooting Exadata smart scan/offloading issues
• Monitoring the Infiniband Switches/ports .DB/CELL nodes (ILOM/OEM).
• Enabling Hybrid Columnar compression. HCC
• Hands on Deli and CellCIi utilities
• Configure Exadata machine into OEM and setup monitoring templates.
• Enabled Load balancing using DBRM & IORM
• Responsible for using Flashback query mechanism along with automatic undo management
• Experience in Creating Physical and logical database design Data Models using ER Studio.
• Installed 12Cgrid control and Used Oracle Enterprise Manager Grid control 11g/12cfor monitoring databases
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Worked on Active data guard, Fail over and Switch over cases.
• Hands on Experience in SQLTuning and SQL Optimization.
• Analyzing Explain Plan and TK prof trace files.
• Comparing SQL Baselines and SQL performance Analyzer
• Analyzing SQL Advisor and SQL profile Analyzer.
• Creating Tuning reports using SQLTRPT, AW RTRPT utility
• Creating Oracle SQL profiles.
• Analyzing AWR.ADDM.ASH reports
• Extensive working knowledge on OEM Historic Reports, AWR warehouse.
• Working with Apps team on SQL Query tuning.
• Troubleshooting Bottle Neck issues.
• Created Oracle Tables, Table Partitions, Views, and Materialized Views.
• Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• Creation of Users and granting them the required Roles and Privileges accordingly
• Cloned schemas, objects and data on new server using Data pump utility
• Decreased Contention by reducing the Wait Events as a part of Performance Tuning
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions&data dictionary corruptions
• Generate and interpret Automatic Workload Repository (AWR). Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Implemented and supported Golden Gate replication in production databases.
• Installed and configured Golden Gate on 11g RAC database running on ASM for replication.
• Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process.
• Involved in installation and configuration of Golden Gate 11.1 and 12 c versions.
• Configured unidirectional Golden gate replications at table and schema level.
• Troubleshooting GoldenGate issues such as process abending and lag on replication environments.

Environment: Oracle 11.2.0.3/11.2.0.1/11.1.0.7/10.2.0.4, Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX, TOAD, SQL Developer.

Confidential, Philadelphia, PA

Sr. Oracle DBA

Responsibilities:

• 24*7 on call rotation supporting over 300+ production database.
• Worked on Oracle 11g and upgraded to 12c.
• Successfully Maintained RAC environments of 3Nodes with ASM file system using cluster ware Responsible for applying quarterly PSU security patches.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Installed and configured extended 11g RAC on Linux.
• Created oracle database tables, materialized views, objects with storage parameters based on quarterly growth requirements of the system.
• Installing Oracle Golden Gate for EBS Reporting Databases
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
• Upgrade/Patch/Clone/Migrate Oracle EBS Application Tier.
• Supported in improving DBRM to extensively work with I/O band width and intra database allocations through the resource manager of EXADATA.
• Responsible for RMAN backups and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.
• Configured VMWare with Oracle 11gR2 and 12c RAC.
• Install and configure Oracle GoldenGate and Veridata
• Provided the support for Exadata databases.
• Created Users, Roles and Profiles, Privilege management with role-based security.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.
• Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ADDM, ASH, SQL Traceand other custom utilities.
• Designed, developed and maintained PostgreSQL database architecture.
• Created Streams environment in unidirectional and table level for replication of data
• Responsible for deployment of the Veridata and its Agents and perform data comparison while data sources are online.
• Managed and administered all NoSQL database systems.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Integration of Exadata monitoring and escalation.
• Experience in Filtering of database changes at the database level, schema level, table level, and row/column level with xstream.
• Experienced in using 11g features like Database Replay, Partitioning, LogMiner, and Schema Management.
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL).
• Performed logical backups of schemas and database using Data Pump (expdp/impdp) as per requirement.
• Installation of Oracle 11g Grid and respective agents on databases, application servers, predefine templates with group option to monitor Prod, UAT and Dev Databases.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Performed Cross platform migration using transportable, tablespaces and RMAN.
• Done migration of non ASM database to ASM database.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Trouble shouted the ODI connection with oracle by fixing the tnsnames. or file, TNS listener and DNS entries.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Involved in the deployment process from dev to production environments.
• Implemented and supported Golden Gate replication in production databases.
• Installed and configured Golden Gate on 11g RAC database running on ASM for replication.
• Managing the existing Golden Gate replication processes and setting up new Golden Gate replications for ETL process.
• Involved in the installation and configuration of Golden Gate 11.1 and 12 c versions.
• Configured unidirectional Golden gate replications at table and schema level.
• Troubleshooting GoldenGate issues such as process bending and lag on replication environments.

Environment: Oracle 9i,10.2.0.4,11.1.0.6, IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, IBM AIX, Web Sphere, Solaris5.9, TOAD, SQL Developer.

Confidential, NY

Sr Oracle DBA

Responsibilities:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure/Cluster ware, Oracle12c two node RAC for the database tier.
• Configured DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• Created ASM volumes using asmca and Created ACFS for GoldenGate vl2.
• Installed GoldenGate on 12c RAC ACFS Configured Integrated Extract and Replicat on Multitenant database 111.0.2 and Performed Cross platform migration and used Oracle GoldenGate to migrate database from IBM-AIX6.1toOEL6.1.
• Configured Bidirectional Oracle GoldenGate replication Active/Active across various sites.
• Configured Extract and Replicate pumps for GoldenGate replication 11g/12c and Troubleshooting issues in GoldenGate Environment.
• Used Log Dump Utility to Investigate data on the trail and defgen to create definition files used for replication.
• Performed Zero-Down Time migration from Hp-Unix to Oracle Enterprise Linux using Expdp and Golden Gate and Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Used OEM 11g/12c and Administering Oracle Database 10g, 11g and 12c databases and masking sensitive data in production databases.
• Creating physical and logical database design Data Models using Erwin Tool.
• Generation of DDL scripts using Erwin Tools.
• Patching & upgrades on Oracle12c database (whilst minimizing or eliminating the impact to live services, i.e. using rolling node patching).
• Migrating databases from NON-EXADATA to EXADATA(RAC).
• Analyzing database performance before migrating to Exadata.
• Troubleshooting Exadata smart scan/off loading issues
• Monitoring the lnfiniband Switches/ports, DB/ CELL nodes.(ILOM/OEM).
• Enabling Hybrid Columnar compress ion. HCC
• Configure Exadata machine into OEM and setup monitoring templates.
• Setup multiple 11gR2 Active Data Guards on Exadata database machines.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Upgraded databases from 11.1.0.4 to 12c in CW and Prod environments.
• Worked on Oracle Enterprise Manager Express for Oracle12c RAC standard.
• Working with logical backup using Data pump and Exports/imports Utility.
• Database Load and Transformation Techniques (SQL Loader, External Tables).
• Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.
• Installation and use of Oracle ASM (as well as traditional file system storage).
• Monitored DR (DataGuard) implementations regarding connectivity issues and "logshipping" to failover site.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between Oracle servers.
• Installed and configured Oracle12c WebLogic server and Oracle 12c HTTP servers for the application tier and webtier.

Environment: Oracle 9i,10.2.0.2,11.1.0.7, Maestro 7.0, HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3, WebSphere, Solaris5.9, Informatica Power center 8.1x and 8.6.

Confidential, NJ

Oracle DBA

Responsibilities:

• 24x7 production database support
• Installed and maintained 10g/11gR2 databases for testing, development and production
• Database Monitoring and administration of database using Enterprise Manager Grid control (OEM).
• Upgraded Oracle Database from 9i to 10g, 10g to 11gR2.
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
• Installed and configured oracle grid control.
• Used in Oracle Streams for replications of data between remote databases
• Performed logical backups of schemas and database using Datapump as per requirement.
• Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Prepared backup schedule which include offline, online and logical backups.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Generated performance reports and Daily health checkup of the database using utilities like AWR, Statspack and ADDM to gather performance statistics.
• Partition of tables to improve performance.
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
• Worked on SQL* Loader to load data from flat files, checking for Row Migration and Chaining on Highly used transaction tables.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
• Checked alert logs and background trace files on daily basis and resolved problems.
• Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i,10.2.0.2,11.1.0.7, Maestro 7.0, HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3, WebSphere, Solaris5.9, Informatica Power center 8.1x and 8.6.

Confidential

Jr. Oracle DBA

Responsibilities:

• Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.
• Upgrading database from 8i to 9i and troubleshooting issues during upgrade, applying patches to fix issues.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Administration of databases- Physical and logical structures.
• Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.
• Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.
• Identify and troubleshoot long running queries, locked sessions to improve overall performance.
• Established and wrote the Database Administrators Procedures document for the IT department.
• This document highlights all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Reported the database storage capacities to Project Management and organized the capacity planning of the production database.

Environment: Oracle 9i,10.2.0.2, Maestro 7.0, HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3, WebSphere, Solaris5.9, Informatica Power center 8.1x and 8.6.