PROFESSIONAL SUMMARY:

• 9 years of working experience in database administration, design, development, performance tuning, and high availability solutions. Database management skills with extensive experience in managing Oracle implementations, upgrades, data replication, database security, PL/SQL development, backup and recovery, space management, disaster recovery solutions, and patch management in a UNIX/Linux and Windows environment. Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two - node and four-node on Linux with ASM)
• Oracle Database 10g Administrator Certified Associate and Oracle 9i Database Administrator certified professional.
• Oracle DBA, Mysql, Microsoft Sql Server providing 24/7 support for both development and production databases on various platforms. Responsible for round-the-clock database operations and offering solutions for Production/Development of database applications.
• Exposure to several industry sectors - Finance/Mortgage, Internet/Web advertising, Telecom, State, Retail, Power, Banking/Credit card processing, Federal and Manufacturing.
• Installation, Configuration and Maintenance of Oracle 9i/10g/11g RAC on two node and four node configurations.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Installation and configuration of 10g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Deployed agents on various targets.
• Expertise in Migration and Up gradation of Oracle databases.
• Experienced in applying patches including Patchsets and CPU/ PSU, One-Off patches on Standalone, RAC and Standby Databases using Universal Installer and OPatch Utility.
• Configured and administered replication using Oracle Streams and Oracle GoldenGate technology.
• Proficient in working with DataGuard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Proficient in Exalogic maintenance/support//backup/recovery.
• Experienced in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, Statspack, TKPROF, AWR,ADDM and ASH.
• Experience in Upgrade of Oracle E-Business Suite (EBS) to 11.5.0.2.
• Proficient in maintenance of Production, Testing, Development, RAC, Standby databases/ DataGuard for OLTP and DATAWAREHOUSE and experienced in Data Modeling.
• Proficient in flashback technology and other features such as logminer, Automatic Storage Management(ASM).
• Provided primary database administrative and Architect support for DB2 databases.
• Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjob and implemented VERITAS NetBackup to perform daily backups.
• Performed full, incremental and cumulative backups using RMAN. Expert in performing manual recovery using RMAN with and without catalog.
• Installed, configured, and maintained Oracle Fusion Middleware with SOA, OBPM Suite and WebLogic Server. 
• Expertise in working with the tools like OEM, TOAD, Export/ Import,SQL * Loader, SQL Analyzer and managed system events and jobs using OEM.
• Performed Data Archiving whenever required for moving data to a separate storage device.
• Skilled in performing Logical backup using Traditional export/import and Data pump export/import.
• Experienced in Space Management, Resource management and Capacity Planning.
• Extensively worked with NETSTAT,NET Manager and Ping Utility to resolve network problems.
• Setup and Management of Auditing, Oracle Security and SQL Navigator. Job scheduling using cron utility and Shell Scripting for automating DBA tasks. Experienced in SQL/PLSQL programming.
• Refreshing the Production over the Dev, UAT and keeping the Test Instances in sync with other instances
• Expert in Cloning and Manual creation of Oracle Databases.
• Generated Materialized views to cache data that was frequently needed, to improve performance.
• Good experience in Creation and Maintenance of Database Objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views and Indexes. Monitoring and managing local table partitioning.
• Excellent communication, analytical and interpersonal skills. Good team member and a highly motivated individual, strong commitment to quality and customer service.

Database Utilities: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, Erwin, TOAD, Data Pump (expdp, impdp), Autosys, Query Analyzer, VERITAS NetBackup, Developer 2000, SQL*Plus, SQL*Loader, GoldenGate, Commvault, Toad, SQL Developer

Databases: Oracle 8i, 9i, 10g RAC, 11gR1 RAC,11gR2 grid control RAC. Mysql 5.0.1 to Mysql 5.5.36, Sql Server 2008 R2, Sql Server 2012, Sql Server 2014.

Tool/Utilities: TKPROF, STATSPACK, Explain Plan, OEM.

Operating Systems: Windows NT/2000/2003/XP/2008, RHEL, Oracle Linux, Solaris 8/9/10/11, AIX, HP-UX.

Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Cypress, CA

Senior Oracle Database Administrator

Responsibilities:

• Primarily responsible for administering and monitoring 76 mission critical Oracle 12c/11g/10g OLTP Production, Development, SIT, UAT and other environment databases.
• Provided 24x7on call production support for ORACLE, MySql and Sql Server Databases.
• Installation, Configuration and Maintenance of Oracle 11g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
• Installed and configured one to one GoldenGate replication and resolved out of sync issues. Handling GoldenGate replication issues which are responsible for out of sync in Test environment.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Created jobs on Mysql and Sql Server for automatic monitoring, differential backup and full backup.
• Upgraded Oracle 10.2.0.3 Applications Database 11i on Linux.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and GoldenGate Technology.
• Involved in data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams. Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Implemented Data Guard with maximum protection and maximum performance configurations and worked with Data Guard fail over and switch over cases.
• Installed Oracle Discoverer and Integrated with EBS.
• Installed, Configured and Managed11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases. Experienced in working with tools like TOAD.
• Upgraded Oracle 10.2.0.3 Applications Database 11i on Linux. Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and DataPump.
• Remodeling the existing system using ER/Studio for logical/Physical data modeling.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and used data pump jobs for loading the subscriber and history related data at replicated site.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for product integration with client's applications.
• Regular DBA activities like database auditing, space management, database issues, locking, managing user groups, tuning, re-organization, re-building of Indexes.

Environment: Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 10gR2, Oracle 10g, Linux, HP-UNIX Windows, DBCA, OEM Grid Control, Exadata, HP Data Protector, SOA Suite 11.1.1.3, Oracle Streams Data Guard, TOAD, Oracle JDeveloper 11.1.3/4,Solaris 11, GoldenGate, Endeca, Oracle E-Business Suite (EBS), VERITAS Net Backup, Data Pump, Tuning, SQL* Loader

Confidential, Charlotte, NC

Senior Oracle Database Administrator

Responsibilities:

• Primarily responsible for administering and monitoring 200+ mission critical Oracle 12c/11g/10g OLTP production databases.
• Installed and configured Oracle (10g&11gr1/r2) databases on Linux 5,HP-Unix 11.X.
• Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2).
• Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
• Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and GoldenGate Technology.
• Involved in data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Implemented Data Guard with maximum protection and maximum performance configurations and worked with Data Guard fail over and switch over cases.
• Installed Oracle Discoverer and Integrated with EBS.
• Installed, Configured and Managed11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases. Experienced in working with tools like TOAD.
• Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and DataPump.
• Remodeling the existing system using ER/Studio for logical/Physical data modeling.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and used data pump jobs for loading the subscriber and history related data at replicated site.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats including verifying daily backup logs and alert logs. Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Assisted developers in getting database connection from the client using SQL *net.
• Involved in data loading using SQL*loader calling UNIX scripts to download and manipulate files.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for product integration with client's applications.
• Installed and configured one to one GoldenGate replication and resolved out of sync issues.
• Regular DBA activities like database auditing, space management, database issues, locking, managing user groups, tuning, re-organization, re-building of Indexes.
• Provided 24x7on call production support.

Environment: Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 10gR2, Oracle 9i, Linux, HP-UNIX Windows, DBCA, OEM Grid Control, Exadata, HP Data Protector, SOA Suite 11.1.1.3, Oracle Streams Data Guard, TOAD, Oracle JDeveloper 11.1.3/4,Solaris 11, GoldenGate, Endeca, Oracle E-Business Suite (EBS), VERITAS Net Backup, Data Pump, Tuning, SQL* Loader

Confidential, Philadelphia, PA

Senior Oracle Database Administrator

Responsibilities:

• Supported 100+ databases including RAC Production database , a Data warehouse database and lot of Development and Test databases.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Installed and configured Oracle 10g databases on HP-Unix 10.x and AIX 5.2.
• Installed and configured Oracle RDBMS on UNIX and Windows environments. Created primary database storage structures (tablespaces etc.).
• Create and maintain DB templates, RAC environments,
• Involved in database administration including 10g RAC Database cloning, tuning, patching and monitoring concurrent manager processing.
• Creating data modeling for new developments using Erwin modeler.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
• Integrating Oracle Applications R12/11i with OID/SSO.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Integrating Oracle Utilities Applications with Spatial GIS database.
• Oracle Database and Oracle Applications cloning/refresh.
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Managed undo segments, processes, memory, online redo log files, data files.
• Installed and Configured Oracle Applications 11i e-business suite using Rapid Install.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Configured and installed one to one replication using GoldenGate between heterogeneous environments.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 11g,10g,9i, 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 10gR2, ,HP-UNIX, AIX, Windows, RAC, DBCA, OEM Grid Control, Exadata, Data Guard, TOAD, SOA Suite 11.1.1.3,ASM, VERITAS Net Backup, RMAN, Solaris 10, Oracle E-Business Suite (EBS), GoldenGate, STATSPACK, SQL* Loader, SQL/PLSQL

Confidential, Lincoln, RI

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle Database Software 10g on Sun Solaris and Linux-4x,5x.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Configured initial and incremental load using GoldenGate.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios using RMAN.
• Involved in NoSQL and relational data modeling.
• Installed, configured, supported and troubleshoot databases on Veritas Cluster on top of Solaris 9.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Monitored and troubleshot top CPU/memory consuming processes.
• Scheduling Automatic scripts for GoldenGate reboot.
• Performed Table space Management and Rollback table space Management.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Converting single instance database to Real Application Cluster (RAC).
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin .
• Transaction Management and Security Management.
• Plan, coordinate, and implement network security measures.
• Supported Developers and end-users in troubleshooting issues.
• Provided System support for both development and 24*7production environments.

Environment: Oracle 10g,9i,Sun Solaris 9, Linux-4x,5x, Windows, RAC, OEM, Oracle Streams, GoldenGate, RMAN, StatsPack, Export/Import, SQL*Loader,SQL/PLSQL

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Installed, Configured and Managed Oracle9i on HP-UX and IBM-AIX environments for production, test and development.
• Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Involved in logical backup using full/ partial export/import and Data Pump.
• Supported and troubleshoot databases on VERITAS Cluster on top of Solaris 8.
• Performing the capacity planning for databases.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control.
• Configured and troubleshoot ASM Cluster File System (ACFS) for Grid/RAC cluster.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Created and maintained materialized views.
• Modified and debugged stored procedures and triggers.
• Interacted with the users and Troubleshooted the problems related to the privileges & resources.
• Monitor database activity and file usage, and ensure necessary resources are present, so that databases function properly by removing or deleting old or obsolete files.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Contributed to team effort by accomplishing related results as needed.

Environment: Oracle 10g,9i,Sun Solaris 8, Linux-4x, 5x, RAC, Windows, OEM, Oracle Streams, RMAN, Stats Pack, Export/Import, SQL*Loader, SQL/PLSQL.