PROFESSIONAL SUMMARY:

• Over 11+ years Oracle DBA and SQL Server Consultant and with significant experience of IT / ITES Arena, holding first class degree of Bachelor of Technology in Information Technology Stream.
• Concrete experience in administrating and implementation of Oracle 12c, 11g, 10g RAC, Dataguard (Physical, Logical and Cascaded Standby Databases) and MS SQL Server
• Experience in Oracle Exadata Administration (DMA) on Exadata X5 - 2 High Capacity
• Strong knowledge and experience in administration Oracle Enterprise Manager Grid Control 11g,and 12c Cloud control
• Extensive knowledge on database administration of Oracle 10g, 11g with experience within very large scale production database environment.
• Excellent knowledge and experience in implementing and administration of Oracle High Available Database Architecture
• Excellent experience in administration, installation and configuration of Oracle 10g and 11g on AIX, Solaris, HP Unix, Linux and Windows platforms
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Worked different media management tolls like Symantec Netbackup, CA Bright Store Arch Server Backup.
• Implemented and designed RMAN backup policies in large scale database environments.
• Sound knowledge in developing UNIX shell scripting and developed different shell scripts for oracle database requirements.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Performance tuning of the database - Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Good experience in Data Migration using export/import, datapump, transportable tablespace.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Experience in MS SQL Server Administration
• Experience in MS SQL Server Backup, Recovery, DB Refresh, Creating New Databases, Export Import
• Knowledge on Oracle Support Process for Technical requests using Metalink, ITIL and other support procedures.
• Good Interpersonal communication skills and Documentation Skills.

TECHNICAL SKILLS:

Operating Systems: HP: UX 10.x, 11.x, Sun Solaris 9.0/10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, SUSE Linux ES 10,11 and Windows 2003,2008.

RDBMS: Oracle 12c,11gRAC/10gRAC/10g. MS SQL Server 2008,2012,2014

Languages: SQL, PL/SQL, UNIX Shell Scripting

DB Management: TOAD, Oracle EM Grid 11g, Oracle EM Cloud 12c

Technologies: RAC, OEM Grid/Cloud Control, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, Data pump, Data Guard, VMware MS Office, Golden Gate.

Oracle Exadata: Oracle Exadata X5: 2 High Capacity

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

Backup tools: Symantec Netbackup, CA Bright Store Arc Server Backup

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Oracle DBA/Lead Consultant

Responsibilities:

• Supporting Oracle 12c,11g on Different AIX systems.
• Administration on Oracle Exadata X5
• Installed and configure Oracle EM 12c Cloud control and configured agent over 200 servers
• Solved different Backup and Recovery issues
• Responsible for Performance tuning Activities and solved critical performance issus.
• Handling User tickets in Remedy tool with predefined SLA
• Database Upgrades
• MS SQL Server Administration
• Worked on tasks like MS SQL Server Backups, Recovery,, DB Refresh, Creating New Databases, Export Import
• Day to Day database activities like space management, security and user management.
• Analyze database objects, Gather Statistics, Rebuild indexes
• Perform other adhoc duties/requests as assigned.
• Developed different shell scripts for RMAN backup, and other database activities.
• Applied Security Patches for Oracle databases
• Performed Test Database Refresh/Cloning activities.

Environment: Oracle 11 Databases, SQL Server 2012, Operating Systems: AIX, Oracle EM 12c Cloud Control, RMAN, Oracle Exadata X5-e High Capacity

Confidential, CA

Sr. Oracle Database Administrator

Responsibilities:

• Supporting Oracle 12c,11g RAC, 10g RAC on Different Operating systems.
• Configured Data guard configurations and supporting on machine critical applications
• Installed and configure Oracle EM 12c Cloud control and configured agent over 200 servers
• Solved different Backup and Recovery issues
• Responsible for Performance tuning Activities and solved critical performance issues.
• Handling User tickets in Service Now tool with predefined SLA
• Upgraded databases from 9i,10g to 11g
• Reorganized the tables using DBMS REDEF Package.
• Day to Day database activities like space management, security and user management.
• Analyze database objects, Gather Statistics, Rebuild indexes
• Perform other adhoc duties/requests as assigned.
• Developed different shell scripts for RMAN backup, and other database activities.
• Implemented Oracle Golden Gate.
• Implemented RMAN Backup configurations using catalog database with NetBackup tool
• Applied Security Patches for Oracle databases
• Performed Test Database Refresh/Cloning activities.

Environment: Oracle 11g RAC Databases, Dataguard, Operating Systems: RHEL 5.5, SUSE Linux ES11, Solaris 5.10, AIX, HP UNIX, Oracle EM 12c Cloud Control, RMAN

Confidential, San Roman, CA

Oracle Database Administrator

Responsibilities:

• Responsible for monitoring the RMAN, COLD, HOT and Export Backup of about 130 databases in the datacenter.
• Handling the activities associated with cloning of production database to various systems and supporting the application team for database related activities.
• Analyzing and verifying the backup and restoration of production databases.
• In charge for applying CPU Security Patches according to release of oracle support, configuring the EM Grid Agents and administration target database using em grid control
• Accountable for updating activities of oracle database servers like 9i to 10g, 10g R1 to R2, 10g to 11g.
• Evaluating and troubleshooting the database & application issues.
• Recovering the database using HOT, COLD, RMAN and Flash Back Technology.
• Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production.
• Worked as a member of the production control team for controlling over 50 Production Databases.
• Provided 24/7 support for the following Production Databases.
• Involved in all the process of System Development Life Cycle (SDLC) for implementing a project.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Created and managing the database objects such as tables, indexes and views.
• Setup, Configuration and maintenance of Oracle 10g RAC software on different environment.
• Served as a full life cycle Oracle Developer, from problem recognition through development, maintenance and documentation with major emphasis on End User Support and Dataflow Automation.
• Written complex queries, functions, stored procedures and created Views and Materialized views.
• Generated SQL and PL/SQL scripts to install, create and drop tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Environment: Oracle 10g,11g RAC Databases, 9i,10g,11g Databases, Data guard, RMAN, Flash Back, Oracle 11g EM Grid Control,

Operating Systems: SUN Solaris, Windows 2003, HP Unix, IBM AIX, Linux

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Involved in designing Oracle Fusion Middleware Solution for Ministry of Interior using Oracle High available products. Oracle Products includes Oracle 10g RAC Database, Oracle EM Grid Control, Oracle Internet Directory, Application server 10g, Infrastructure, Oracle Web center, Oracle Communication and Mobility Server, Oracle Middle ware products application servers mid tier, content mid tier
• Executed the designed oracle fusion middleware architecture in committed time frame and Oracle RAC Database on Sun Solaris using ASM.
• Responsible for migration of existing 8i Database to 10g Database and Performed application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, Stats pack, SQL trace, TKPROF, OEM Performance Manager, and custom scripts

Environment: Oracle 10g RAC Database Oracle Enterprise Manager Grid Control 10.2.0.4Oracle Application Server 10g, Oracle Web center, Internet Directory. OS: IBM AIX 5L 5.3, Windows 2003

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Handled the operations associated with designing and executing optimum minimal architecture for a RAK Bank datacenter.
• Deploying and supporting oracle 10g RAC and single instance databases using ASM, GPFS and JFS and Data guard setup with Physical databases on IBM AIX 5.3 OS.
• Providing support and executing different configuration change activities like Public, Private, Virtual IP change configuration, changing ocr, voting disk locations of existing Oracle RAC Database with minimum downtime.
• Accountable for the execution of Security policies for Banks oracle database environment. This document outlined all standards for the DBA Operations Group including installing / upgrading creating databases, DBA tools, administration and monitoring, naming standards.
• Managing the activities correlated with designing backup policy for newly implemented Databases.
• Preparing and submitting the documents on business continuity plan for oracle databases
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN

Software / Tools / Technology Used Oracle 10g RAC Database, Data guard, RMAN

OS: IBM AIX 5L 5.3Hardware: IBM Power 5 Servers, EMC Clariion, Symmetrix

Confidential

Datacenter Support Engineer/Oracle 10/11 & SQL Server 2008)

Responsibilities:

• Handled the implementation process of Oracle 10g RAC using SUN Cluster on and Data guard setup Sun Solaris 5.9 and 5.10 OS.
• Provided supported to 30 Oracle 10g, 9i databases includes RAC databases and single instance databases accountable for designing, implementing and supporting the data movement between different databases in the datacenter using database links and scheduled procedures.
• Involved in execution of oracle application server 10g (9.0.4) for Production and Disaster recovery sites.
• Implemented Oracle Data guard Physical, Logical and Cascaded Standby Databases
• In charge for configuring Oracle 10 g enterprise managers grid control for monitoring the databases and application server instances available datacenter.
• Monitored the activities dealt with designing of security policies for Confidential ’s oracle database environment.
• Responsible for Continuity plan of database
• Migrated existing 1 TB 9i Database to newly created High Available 10g RAC database with minimum downtime
• Organized instance, network, segment, operating system(Sun Solaris) tuning activities using EM Grid control, AWR, ADDM tools
• Developed RMAN scripts for database backup and recovery
• Reviewed and evaluated the Backup policy for all Databases in the datacenter. Implemented Database backups using RMAN, export / import and Shell Scripting utilities.
• Handled the operations allied with all database backup and restore operations.
• Analyzed and resolved the database issues and supported all datacenter activities 24/7 environment.
• Patching and Up gradation on Oracle High Available Configurations
• Responsible for Data movement and Purging activities

Environment: Oracle 10g RAC Databases, 9i, 10 Databases, Data guard, Oracle 11g EM Grid Control Oracle Application Server 10g(9.0.4), Ms Sql Server 2008

OS: SUN Solaris 9,10, Linux AS 2, windows 2000 and 2003

Hardware: SUN Fire 880,890,Sun Storage Edge3910, 6140,Sun L100 and L500Tape Library, SUN Cluster 3.1, SAN, Dell Power Edge 6900, 6800

Backup Tool: CA Bright store Arc Server Backup 11.5