SUMMARY:

• Over 8 years of experience in Oracle (9i/10g/11g/12c) Database administration and having in depth experience with all facets of Installation, RAC, Data Guard, Streams, Flashback, Backup and Recovery, Cloning, Patches, Upgrades, Security Management, Disk Space, File System Management, Performance Tuning and shell scripting in HP - UX, Sun Solaris, and UNIX/Linux environment.
• Experienced in high availability environments like clustered environments (RAC) and implemented 10g/11g/12c/RAC with ASM file system.
• Experience in configuration and maintaining Oracle Physical Standby Database using Oracle Data Guard 10g /11g/12c.
• Experience in configuring ASM instance, disk groups, failure groups, stripping and mirroring concepts for ORACLE databases in LINUX environment.
• Installed and configured OEM Grid Control agents 10.2.0.5/11 g on Solaris, and Linux Servers.
• Experience in upgrading databases from 10g to 11gR1, 11gR1 to 11gR2 and 11gR2 to 12c.
• Proficiency in using AWR/ASH/ADDM reports to troubleshoot and perform root-cause-analysis for performance related issues
• Experience in complete range of Oracle DBA activities including day-to-day production database monitoring, Backup &Recovery using RMAN, Troubleshooting production issues, Physical Database Design.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Installed and applied various patches which includes patch set, CPU/PSU, One-off patches and also upgraded oracle database 9i to 10g and 10g to 11g.
• Expertise in managing database security by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (KSH and CSH).
• Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking and grasp quickly.

PROFESSIONAL SKILLS:

Operating Systems: Sun Solaris 9, 10.RHEL 5.x, 6.x .Linux Enterprise Server 10.Windows NT/2000.

RDBMS: Oracle 12c/11g/10g/9i, RAC, SQL Server 2005/2008.MySQL 4.x,5.x.

Database Server: Oracle Application Server 10g, HP 700 Series, HP Superdome, Sun Enterprise 450 & 880, Dell PowerEdge

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, EMC NetWorker, Erwin, QUEST, Shareplex, TOAD,Informatica, Oracle SQL Developer.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, SQL Tuning Advisor, ASH/ADDM reports.

Languages: HTML, CSS, Core Java, JDBC, SQL, PL/SQL, Shell Scripting, PERL.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Database Administrator

Responsibilities:

• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 7 node RAC environment.
• Oracle Grid Control 11g Installation and Configuration.
• Implemented Oracle 12c active standby database for test database environment.
• Installed, Configured Golden gate on Oracle 12c Database.
• Setup 11gR2 Oracle RAC cluster on Linux platform.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Setup and Configure Exadata V2 cluster with Golden gate replication. Exadata maintenance and best practices.
• Worked on upgrading Golden gate software from 10g to 11g and implemented replication between version 11g and 10g.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Exposure to both Project Support as well as Production Support in L2/L3 role
• Worked on log dump, keygen and defgen utilities in Golden gate, wrote many shell scripts to monitor golden gate processes.
• Configuration of Physical Standby database in maximum performance mode for 7-node RAC database.
• Involved in 24x7 supports for 30TB, 4 Node production RAC database with on-call pager.
• Controlling and Maintaining System Security through Profiles, Roles, Privileges and Auditing.
• Configured Physical Standby database using Active Database Duplication
• Applied PSU/CPU patches once every 6-months to all non-prod and prod environments on both standalone and RAC systems.
• Configuring and managing ASM instance and migrating database from NON-ASM to ASM.
• Responsible for RMAN backups and created RMAN scripts for full / incremental backup, DATAPUMP scripts.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Implemented and maintained Oracle 11g Data guard /standby databases for fail-over purposes.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues.
• Managing Database Locks and blocking sessions.

Environment: Oracle 11g, 12c, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager(OEM), Exadata, TOAD, SQL Developer, SQL*Loader, Windows, Red Hat Enterprise Linux, ASM.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Administered Oracle 11g R2/10g production and development environment on Sun Solaris, RHEL, and IBM-AIX.
• Installed, configured and supported RAC Grid Infrastructure 11gR2 on Linux and Oracle Data Guard.
• Installed, setup and configured OEM (11g, 12c) and support, solve issues.
• Responsible for migrating & upgrading databases to new data center of varying sizes from version 10.2.0.4 to 11.2.0.1.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Worked on tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Configured replication between source and Target using Golden Gate on RAC systems.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Installation, Configuration of Oracle E- Business Suite 11i/R12.
• Supported existing MySQL systems and Ensured MySQL servers run at optimal health.
• Involved in upgrading of Database from 10g to 11g and applying patches whenever required.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Experience with precise (DB performance tuning tool) and DATAGUARD implementation.
• UNIX Admin Experience like Installation, Disk partition, Unix File Systems, Patch/ package installations, file system backups and administration.
• Generated ERD, OOM, PDM, CDM and Class Diagrams with Data modelling tools like ERWIN.
• Dimensional Modelling (Data Marts, Facts and Dimensions) in both Star Schema and Snowflake Dimensional modelling using Erwin.

Environment: Oracle 10g, 11g R2 RAC, OEM, Oracle E- Business Suite, SQL server 2008, T-SQL, MySQL 5.x, Sun Solaris, RMAN, ASM, UNIX, Shell Scripting.

Confidential, Buffalo, NY

Oracle Database Administrator

Responsibilities:

• DBA support for primary E-commerce site, several related customer facing OLTP and data warehouse systems.
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM.
• Integrated data from Flat files and other Databases to load into Oracle tables using Informatica.
• Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Setup the Streams Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed the RMAN complete recovery, table space recovery, data file recovery, control file recovery, online redo log file recovery.
• Liaising with the different project team components for deployment of releases on the various models.
• Validation of SQL and PL/SQL scripts before deploying into the production database.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Designed and maintained logical and physical enterprise data warehouse schemas using ERWIN.
• Performed other Oracle DBA responsibilities performance tuning, monitoring table spaces, monitoring users, etc. as well as much problem solving.

Environment: Oracle 11g/10g,RAC, Sun Solaris, RMAN,UNIX, Oracle Streams, Data Pump, Informatica, PL/SQL, Shell Scripting, OEM, SQL Server 2008R2/2005,SQL developer.

Confidential

Oracle Administrator/Oracle Developer

Responsibilities:

• Organizing Oracle Database operations, installation, creation and configuration of Databases.
• Design and creation of client Database instances per requirements including production and test environments.
• Managing Logical objects like Table spaces, segments and extents. Maintaining indexes and performing management of Undo Data.
• Define Database level authentication and OS level authentication using password file.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Performing hot/cold backup. Setting up of RMAN on the database to perform necessary back-up.
• Use of 10g flashback features such as flashback query, flashback table as well as undo management.
• Check database logs (alert log, trace files, crsd, asm logs), promptly solved many critical issues in production and other environments
• Integrated the Backup Status Reporting for all the databases using shell script in Korn Shells.
• Performed SAN requirement analysis and configuration for the new RAC databases (Linux RHEL), configured SAN, raw partition for OCR, Voting Disk, Oracle Home, ASM HOME.
• Configured ASM disk groups to store Data files, redo log files, and control files and ASM Management using RAC utilities like SRVCTL, OCRCHECK and OCRDUMP+.
• Created physical standby database (DATA GUARD) as DR Solution for production database using RMAN create standby database command.
• Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control to 10.2.0.4
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.
• Creation of table, view and materialize view, private and public synonyms.
• Load Data from flat file to the Database using SQL * Loader.
• Also maintain 24 X 7 uptime for the database while carrying out the activities.

Environment: LINUX, UNIX, Oracle 9i, 10g RMAN, SQL Server 2005, SQL * Loader, SAN, Erwin, TOAD, PL/SQL, J2EE, Java1.4, JSP, HTML.