SUMMARY

• 8+ years of experience as an Oracle database administrator, providing 24X7 production development support for 11g/10g/9i databases on various platforms, which include HP - UX, SUN SOLARIS, Windows and Linux.
• Having hands on experience in database administration, production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Expertise in implementation of High Availability solutions using Oracle 10g/11g RAC with ASM, Physical and Logical Standby Databases (Data Guard).
• Experience in Oracle Database 10g/11g Installation and Administration
• Configuration of Oracle 11g/10g OEM Grid Control to monitor databases.
• Experience in active database cloning from non-RAC to RAC on ASM and vice versa using RMAN Duplicate (11gR2).
• Experience on table space management
• Software and firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching
• Trouble shooting and performance tuning golden gate replications.
• Experience on performance tuning issues.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Experience in Oracle Application Upgrade from 11i to R12.
• Experience in regular DBA activities such asUpgrades, Patches,TAR support,Cloning,Backups and Recovery Manager, Performance Tuning,Capacity Planningand documentation.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshootingSQL Server2008r 2/2005/2000.
• Experienced with installing, configuring and administering SQL Server 2000/2005/2008 databases including migrations from MS SQL Server to Oracle
• Experience in RAC 10g/11gr2 implementation.
• Experience on Data guard Configuration.
• Experience in upgrading RAC cluster and RAC databases from 11.2.0.3 to 12.1.0.2, 11.2.0.3 to 11.2.0.4, 10.2.0.2 to 11.2.0.1 and 11.2.0.1 to 11.2.0.2.
• Experience in backup and recovery of Golden Gate replication, and administers Golden Gate replication security
• SOA 10g implementation and configuration with RAC database.
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity
• Experience in various DBA activities like Installation, Upgrade, Monitoring, Cloning, Patching, Performance Tuning, Backup and Recovery and other activities of 11i/R12 Application (RAC/Non RAC)
• Experience withlogical and physical data modelingand database design usingErwin.
• Extensively worked in Oracle Technologies including Engineering, Architecture, Oracle Applications Installations and Upgrades, RDBMS installations and upgrades, Database Administration, Patching, Cloning, Performance Tuning, Backup, Restore and Recovery, Monitoring and Server Migration.
• Excellent shell scripting, batch programming. Automated several routine DBA tasks and schedule Jobs in cron
• Shell scripting for Unix, Linux Environment Systems and Batch Scripting
• Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Good Programming Skills inSQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, Logical and Physical Design, Backup and Recovery Procedures.
• Logical and Physical Database Design
• Capacity Planning and bench marking
• Have strong technical background, leadership skills and excellent analytical and problem solving skills.
• Proficient in Oracle Database Administration activities such asUpgrades, Migrations, Patches, Cloning,Backup & Recovery, Performance Tuning,capacity planning, shell scripting, and documentation.
• Excellent analytical, problem-solving and learning skills and ability to quickly embrace and understand new technologies as well as a keen interest in the emerging technologies.
• Experience in upgrading OEM and Enterprise Agents from 11g to 12c.
• Experience in configuring Fast Connection Failover (FCF) for JDBC Thin drivers, TransparentApplication
• Failover (TAF) for JDBC Thick Drivers, Services, Instance Caging, Database Resource Management for RAC databases to Distribute Work Load Management.
• Experience in Oracle Database performance-tuning with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ADDM, SQLT,SQLHC, SQL PROFILE, SQL BASELINES, SQLTRACE, ORADEBUG, 12cOEM Grid Monitoring, V$Views and custom scripts troubleshooting oracle databases using SQLtrace utilities.
• Expert in high availability technologies such as Oracle9i/10g/11g/12c RAC, Oracle Active passive Cluster
• Data Guard/Standby Database, Database Replication/Clone.
• Experience in Database Space Management, Memory Tuning and Application Tuning
• Installation/Configuration of RMAN with and without Recovery Catalog on Oracle 9i/10g/11g/12c.
• Responsible for database and application tuning, capacity planning and database stability.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

TECHNICAL SKILLS

RDBMS: Oracle 8i,9i, 10g and 11g

ERP Administration: Oracle Applications 11i, R12

Others: 10g Application Server/10g Web logic/ 10g OEM Grid/RMAN/11g Discoverer

Oracle Tools and Utilities: SQL*NET, Export & Import, RMAN, Putty, Toad and Backup Tools like Commvault and Bright store

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Operating System: Linux 32 bit/64 bit, AIX,HP Linux, Suse Linux, Sun Solaris and Windows XP, Windows NT4.0/2000

Programming Languages: SQL*Plus, PL/SQL, Shell Scripting, awk, Batch(DOS), MS SQL 2005,Microsoft Office, C,C++,Java, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

DBA Consultant

Environment: Prod, UAT, Test, Dev Operating System: Redhat Linux, Hp Linux, Windows, Solaris, AIX

Responsibilities:

• Migration from AIX to Linux, Upgrades 10g to 11gr2RAC
• Non-ASM to ASM conversion.
• Managing 170 DBs
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Retiring DBs
• Expertise in Replication of Oracle Databases using Golden gate, Logical Standby, Streams, CDC
• Experience in backup and recovery of Golden Gate replication, and administers Golden Gate replication security
• Experienced in configuring Golden Gate and troubleshoot the issues related to Golden Gate
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Handling Escalations, Sev1 Cases and other Critical cases.
• Upgrade from 11i to R12
• Highly experience in Cloning of Oracle application environment using Rapid clone and adconfiguration.
• Upgraded CRS, ASM from 11.1.0.7 to 11.2.0.3 (grid Infrastructure) & Database from
• RMAN Backup and cloning Database using RMAN Active Duplicate
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Experienced inTrouble shooting and performance tuning golden gate replications.
• Exposure to Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Managing Workflow and its components through OAM.
• Setting up profiles for users.
• Helps in Performing Golden Gate replication monitoring, tuning, and capacity planning
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
• Gather stats using DBMS stats and FND stats to improve performance.
• Tracing Concurrent requests, forms, and database session.
• DB Refreshes(Created Shell script and automated)
• Providing support (24*7) and troubleshooting user (remedy) tickets.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Confidential, Freeport, TX

DBA

Environment: Prod, UAT, Test, Dev, ASCP instance and 10g Discoverer Linux, Solaris, AIX

Responsibilities:

• Provide Technical Help to DBA’s, wherever necessary, for the execution of work.
• Perform reviews, analyze defects and take appropriate measures for their elimination prior to submission to Client
• Migrated database from AIX to Redhat Linux.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Applied RDBMS, CPU/Quarterly patches using Opatch.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Configured AUTOCONFIG for handling customizations and Security issues.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Identifying the best plans using sql tuning advisor and migrating the sql profiles from one database to another database using ‘dbms sqltune package’.
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Database Refresh/clone doing complete/incomplete recovery using cold and hot backups.
• Highly experienced with Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Experience withlogical and physical data modelingand database design usingErwin.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Attends Status meeting with Client on periodic basis for the Projects.
• Delivery Weekly status report of DBA team to Client.
• Handling Escalations, Sev1 Cases and other Critical cases.
• Acts as Escalation Point for Database issues and Conduct Root-Cause Analysis.

Confidential, Mt Laurel, NJ

DBA

Environment: Prod, UAT, Test and Dev RedHat, Linux, HP-UX, Sun Solaris, Windows 2000

Responsibilities:

• Upgrade of Database from 10g to 11gr2
• Installation and configuration web cache 10G
• High availability DR BUILD CONFIGURATION
• Convert NON-ASM to ASM
• Configured oracle applications Release 11i with 11g RAC.
• Database DB refresh, Performance Tuning
• RMAN backups and restores, cold and hot backups to tapes and file system.
• PCP configuration.
• Highly experience in Cloning of Oracle application environment using Rapid clone, OEM GRID and adconfig.
• Experience in Installing, Configuring, Managing, monitoring and troubleshootingSQL Server2008r2/2005/2000
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity
• Experience in installation and using Oracle Enterprise Manager (OEM) 10g GRID for some of the maintenance tasks.
• Patching security vulnerabilities as part of every quarterly release.
• Interaction with Oracle Support Services to resolve mission critical issues.

Confidential

DBA

Environment: Prod, UAT and Dev Platform:RHEL

Responsibilities:

• Created scripts to load data from production databases to report data warehouse databases.
• Developed over 100 SQL and Shell scripts for database performance monitoring and tuning, database administration; documented over 20 backup and/or recovery cases.
• Implemented and maintained high availability solutions using Standby Database, Data Guard, RAC; Analyzed and implemented different backup and recovery strategies.
• Upgraded and migrated databases (9i, 10g), designed and implemented solutions for data extraction, conversion, and replication and archiving.
• Developed solutions, PL/SQL procedures, scripts dealing with schemas such as tables, indexes, partitions, views, triggers, for daily production and performance.
• Experience on Data Guard, Creation of Physical Standby/Logical Standby, resolving the Physical Standby database gap.
• Performed efficient and accurate Database conceptual/physical/logical modeling based on sophisticated yet successful system requirements analysis.
• Responsible for database and application tuning, capacity planning and database stability.
• Installed and configured the oracle 9i RAC on sun fire servers using VERITAS Enterprise edition cluster file system. Setup and maintained Logical Standby Database using Data Guard.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Wrote shell scripts to implement periodic security management on the production databases
• Used Crystal Reports Tools when worked with Development teams and QA teams.
• Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
• Wrote packages, functions and procedure for reporting.
• Data Loading Experience inSQL Server 2008using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Designed and implemented procedures and jobs for oracle database providing 24x7 support. Deployed disaster recovery plans and OEM emailing.
• Estimated current and future requirements in terms of storage and other resources including capacity planning
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY, AUTOSYS for Windows and as well as for UNIX Databases.
• Cloned the database from Production to QA for testing purposes periodically.
• Applied patches for upgrade of the Database/oracle Applications.

Confidential

DBA (implementation and Support)

Environment: Dev and Prod Platform: Linux

Responsibilities:

• Performing Daily Health check to ensure the proper functioning of the production database and the Application server, ad-hoc support.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Patching Quarterly released security vulnerabilities released by oracle support.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.
• Installation of Oracle Application 11i
• Experience in backup and recovery of Golden Gate replication, and administers Golden Gate replication security
• Setup and configure Standby databases for high availability.
• Using autoconfig to configure Oracle Applications.
• Installation and using Oracle Enterprise Manager for some of the maintenance tasks.
• Using autoconfig to configure Oracle Applications, Implementing Change requests.
• Designed, documented, implemented and maintained all Disaster Recovery procedures
• Providing ad-hoc support to the development team, maintenance of the Database. Monitoring database growth and managing space.
• Oracle Application Maintenance.
• Helped performance teams by providing TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADD).M reports for database tuning.
• Backup and Recovery using RMAN, Oracle Database cloning/refresh and Troubleshooting Refresh related issues.
• Diagnose and troubleshoot Database issues.
• DBA activities like Disk space management, User management, restarting Services(Database, E-Business and SOA
• Database Installation.
• SOA Installation and integrating Database with RAC
• SOA upgrade from 10.2.0.3 to 10.2.0.4
• O E M configuration
• Database Maintenance
• Cloning Oracle Applications with rapid clone for development and testing and incorporating customizations. Using autoconfig to configure Oracle Applications.
• Maintenance of oracle applications through AUTOCONFIG.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Troubleshooting Refresh related issues.
• Interaction with Oracle Support Services to resolve mission critical issues.