SUMMARY

• Over 7.5 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, IBM AIX, 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 AIX, Solaris, and Linux Servers.
• Good experience in Transportable Table spaces, Database links and Materialized Views.
• Experience in upgrading databases from 9i to 10g, 10g to 11gR1 and 11gR1 to 11gR2 and 11gR2 to 12c on both standalone and RAC databases
• Experience in applying PSU/CPU’s on both standalone and RAC databases, and also applied one-off patches when required
• Experience in performing Switch-over and Switch-back from Primary to its corresponding Standby database when required for both Primary and Standby database
• Experience in performing Cross-platform migration using Transportable table spaces and expdp/impdp oracle utilities
• Experience in implementing Oracle TDE
• Experience in using Flash Back Restore Point and restoring the database to the same when required
• 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 Gloden Gate by creating extract process, extract pump, and replicate.
• Implemented Gloden Gate for replication and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Gloden Gate issues such as extract, replicate rebuild.
• Experience in using Gloden Gate in moving large volumes of transactional data and configuring Gloden Gate director for alerts monitoring.
• Experience in upgrading Gloden Gate from 9.5 to 10.4, 10.4 to 11.1 and 11.1 to 11.2
• Performed data replication, transformation and delivery of database transactions using Gloden gate replication tool.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• 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.
• Hands on experience in complete recovery, incomplete recovery (PITR, TSPITR), Flashback Recovery, Disaster Recovery, recovering data files and control files.
• Expertise in managing database security by creating new users, roles, profiles and providing required user privileges in development, test, and production environments.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (KSH and CSH),
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Managed and supported 24X7 Production Database support on call.
• Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking and grasp quickly.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 8, 9, 10.AIX 5.1, 5.2, 5.3, 6.1RHEL 4.x, 5.x, 6.x .Linux Enterprise Server 10.Windows NT/2000.

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

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, Power designer, TOAD, Oracle SQL Developer.

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

Languages: SQL, PL/SQL, Shell Scripting, PERL.

PROFESSIONAL EXPERIENCE:

Confidential, PA

Oracle Database Administrator

Environment: Oracle 10g, 11g, 12c, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, Oracle Spatial, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, HTML

Responsibilities:

• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Oracle Grid Control 11g Installation and Configuration.
• Implemented Oracle 12c active standby database for test database environment.
• Installed, Configured Oracle 12c Gloden gate on Oracle 12c Database.
• Setup 11gR2 Oracle RAC cluster on Linux platform.
• Worked on upgrading Gloden gate software from 10 to 11 and implemented replication between version 11 and 10.
• Worked on log dump, keygen and defgen utilities in Gloden gate.
• Configuration of Physical Standby database in maximum performance mode for 3-node RAC database.
• Extensively used Log dump utility to troubleshoot data related issues
• Controlling and Maintaining System Security through Profiles, Roles, Privileges and Auditing. Ensuring database security and integrity with auditing features
• Migration of databases from 10g and 11g using transportable table space and data pump export/import utilities from HP-UX to Linux.
• Configured Physical Standby database using Active Database Duplication.
• Implemented Oracle transparent data encryption by creating Wallet.
• Performed rolling patch upgrades on RAC environment for bug fixing.
• Experience in the installation ofOracle Grid Control agents.
• Refreshed non-production database from Production standby database on NetApp using Snapshot/Flexclone technology.
• Applied PSU/CPU patches once every 6-months to all non-prod and prod environments on both standalone and RAC systems.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• 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.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN.
• Replicated data using Oracle Gloden Gate and import/export.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM and Monitoring alert log/system log.
• Managing Database Locks and blocking sessions.

Confidential, NJ

Oracle Database Administrator

Environment: Oracle 10g, 11g R2 RAC, GridControl 10gR5, ASM, RHEL 4, 5, Shell Scripting.

Responsibilities:

• Involved in the installation of 10g RAC on LINUX environment.
• Administered Oracle 11g R2/10g production, test, development environment on RHEL, 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.
• Tuning carried out using performance analysis of ADDM, AWR reports.
• 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.
• Upgraded GlodenGate from 11.1 to 11.2
• Configured replication between source and Target using Gloden Gate on RAC systems.
• Performed database cloning to setup test and development database.
• Involved in upgrading of Database from 10g to 11g and applying patches whenever required.
• Excellent noledge ofRAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfigutilities.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Configure and implement RMAN backups. Ensured the successful RMAN Backups and database cloning for Development, Test and QA environments.
• Involved in Disaster recovery testing to ensure 100% data recovery in the event of failures.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring and Batch performance.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experienced with precise (DB performance tuning tool) and DATAGUARD implementation
• Configured DDL replication and Bi-directional replication from source to target.
• Generated ERD, OOM, PDM, CDM and Class Diagrams with Data modeling tools ERWIN.
• Importing data from flat files into database using SQL loader and External Tables.

Confidential, NY

Oracle Database Administrator

Environment: Oracle 11g/10g/9i, RHEL 4, IBM-AIX

Responsibilities:

• Monitored the growth of the database objects for capacity planning.
• TEMPHas 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.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Monitoring and management of various database components (logical & physical) like table spaces, segments (tables, index, rollback).
• Export and import of database objects.
• Creation of table, index, synonyms, database link and other objects.
• Liaising with the different project team components for deployment of releases on the various models.
• Administering over 100 database instances (oracle 9i and 10g) for various Dev, CST and IVVT teams.
• Routine reorganization of databases, (disaster) hot backup recovery exercises.
• Validation of SQL and PL/SQL scripts before deploying into the production database.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process.
• Continuous database observation and highlighting of any issues anticipated in the database so as to avoid the database crashing.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Check database logs (alert log, trace files, crsd, asm logs), promptly solved many critical issues in production and other environments; analyze the root cause and provide permanent solution or best practice suggestions
• Performed other Oracle DBA responsibilities performance tuning, monitoring table spaces, monitoring users, etc. as well as much problem solving.

Confidential

Oracle Administrator/Oracle Developer

Environment: SCO UNIX, Oracle 9i, 10g RMAN, SQL Server 2005, SQL * Loader, Erwin, TOAD.

Responsibilities:

• Design and creation of client Database instances per requirements including production and test environments.
• Organizing Oracle Database operations, installation, creation and configuration of Databases. Configuration of Oracle Instance with SGA, PGA and Background Processes.
• Managing Logical objects like Tablespaces, segments and extents. Maintaining indexes and performing management of Undo Data. Create Users and Roles with appropriate privileges and roles.
• Define Database level autantication and OS level autantication 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.
• Integrated the Backup Status Reporting for all the databases using shell script in Korn Shells.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.
• SQL query optimizing using CBO (cost base optimizer), bind variable, TKPROF, stats pack and instance as per company’s requirement for high tuning.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.
• Create table, view and materialize view, private and public synonyms. Create user define packages and use pre-define packages.
• Responsible for integrity and concurrency of data, locks and latches. Managing Oracle Forms and Reports Services.
• Working with management system like DBMS and RDBMS with specific functions, database tools and utilities. 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.