SUMMARY

• Over 8 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 on Linux with ASM)
• Oracle DBA, 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 Upgradation of Oracle databases.
• Experienced in applying patches including Patch sets 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 Golden Gate technology.
• Proficient in working with Data Guard 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, Stats pack, 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/ Data Guard for OLTP and DATAWAREHOUSE and experienced in Data Modeling.
• Proficient in flashback technology and other features such as log miner, 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 cron job and implemented VERITAS NetBackupto performs daily backups.
• Performed full, incremental and cumulative backups using RMAN. Expert in performing manual recovery using RMAN with and without catalogue.
• 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 resolve network problems.
• Setup and Management of Auditing, Oracle Security and SQL Navigator. Job scheduling using corn 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 player and a highly motivated individual strong commitment to quality and customer service.
• Worked on oracle transparent data encryption (T.D.E), finding the pan Data in database and encrypting columns and table spaces as needed.

TECHNICAL SKILLS

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, Golden Gate, Toad, SQL Developer.

Databases: Oracle 8i, 9i, 10g RAC, 11gR1 RAC, 11gR2 grid control RAC, 12c.

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior Oracle Database Administrator

Responsibilities:

• Maintained monitoring and backup procedures for the database by automating the backups and disaster recovery support for the production and development of Oracle database.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of the environments.
• Provided strategic and technical expertise in Oracle database Infrastructure and Project application by developing on APEX.
• Cluster Database Installations and Upgrades quarterly patches for all the databases i support
• Worked on ASM migration working with Linux admin on adding new luns to cluster and removing the old luns.
• Worked on preparing game plans for migration on 11g to 12c Exadata
• Ability to configure cluster databases and worked extensively with cluster configuration standards and an ability to troubleshoot RAC related OS and network integration issues on Linux and/or Solaris platforms.
• Used Data pump Export/Import Utilities for User migration, Tables, Databases, etc.
• Shared rotating on-call responsibilities for incident escalations, peer reviews and approving tasks prior to implementation.
• Provided on call support on a regular basis.
• Performed database maintenance by moving, rebuild, or change database objects as required in production environments.
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at operating System.
• Carrying out application performance tuning and testing.
• Applied patches on oracle 11g Cluster ware and Rac databases.

Environment: Solaris, RAC, DBCA, OEM Grid Control, Exadata, Data Guard, TOAD, SQL/PLSQL, Oracle 12c, OEM 12c, Oracle Apex.

Confidential, MO

Responsibilities:

• Worked on developing scripts to convert databases from physical standby to snapshot standby and then back from snapshot to physical standby
• Work closely with development team deploying the code and troubleshooting the errors.
• Worked on oracle transparent data encryption(column and tablespace)
• Created standby databases for newly cloned production databases
• Worked on patching oracle databases every quarterly for the databases which I am primary on
• Managed undo segments, processes, memory, online redo log files, data files.
• Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Monitored and troubleshot top CPU/memory consuming processes
• Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• 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).

Environment: Solaris, AIX, LINUX,RAC, DBCA, OEM Grid Control, Exadata, Data Guard, TOAD, SQL/PLSQL, Oracle 10g/11g/ 12c, OEM 12c, Oracle Apex.

Confidential, CA

Senior Oracle Database Administrator

Responsibilities:

• Maintained monitoring and backup procedures for the database by automating the backups and disaster recovery support for the production and development of Oracle database.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of the environments.
• Provided strategic and technical expertise in Oracle database Infrastructure and Project application by developing on APEX.
• Cluster Database Installations and Upgrades quarterly patches for all the databases i support
• Worked on ASM migration working with Linux admin on adding new luns to cluster and removing the old luns.
• Worked on preparing game plans for migration on 11g to 12c Exadata
• Ability to configure cluster databases and worked extensively with cluster configuration standards and an ability to troubleshoot RAC related OS and network integration issues on Linux and/or Solaris platforms.
• Used Data pump Export/Import Utilities for User migration, Tables, Databases, etc.
• Shared rotating on-call responsibilities for incident escalations, peer reviews and approving tasks prior to implementation.
• Provided on call support on a regular basis
• Performed database maintenance by moving, rebuild, or change database objects as required in production environments.
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at operating System.
• Carrying out application performance tuning and testing.
• Applied patches on oracle 11g Cluster ware and Rac databases.

Environment: Solaris, RAC, DBCA, OEM Grid Control, Exadata, Data Guard, TOAD, SQL/PLSQL,Oracle 12c, OEM 12c,Oracle Apex.

Confidential, CARY, NC

Senior Oracle Database Administrator

Responsibilities:

• Primarily responsible for managing large Oracle RAC based environments.
• Automated the scripts for billing using oracle, SQL, PL/SQL, UNIX shell scripting.
• Performing the capacity planning for databases.
• 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.
• Modified and debugged stored procedures and triggers.
• Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.
• Provided 24x7on call production support.
• Installed and configured one to one Golden Gate replication and resolved out of sync issues.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• Involved in creation of Data Warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Monitored and troubleshot top CPU/memory consuming processes.
• Scheduling Automatic scripts for GoldenGate reboot.
• Performed performance tuning by using Explain Plan, Tkprof, Stats pack, AWR, ADDM and ASH.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Stats pack snapshots and reports.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.

Environment: Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 9i, Linux, Solaris OEM Grid Control, Oracle Streams Data Guard, TOAD, Solaris 11, Golden Gate, Oracle.

Confidential, Dayton, OH

Senior Oracle Database Administrator

Responsibilities:

• Primarily responsible for administering and monitoring 200+ mission critical Oracle 11g/10g/9i 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.
• 24x7 Production Oracle Applications Administration.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and Golden Gate Technology.
• Involved in data modelling 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.
• Upgraded Oracle 10.2.0.3 Applications Database 11ion Linux.
• Performed performance tuning by using Explain Plan, Tkprof, and Stats pack, AWR, ADD and ASH.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and Data Pump.
• Successfully installed and configured Oracle Golden Gate for Replication in Development and Test environment.
• Remodelling 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.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Upgraded EBS Database to 11g (11.2.0.3) RAC in both TEST and PRODUCTION environment.
• 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.
• Assisted developers in getting database connection from the client using SQL *net.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Performing conceptual data modelling, 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: 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, Solaris 11, Golden Gate, Endeca, Oracle E-Business Suite (EBS), VERITAS Net Backup, Data Pump, Tuning, SQL* Loader.