EXPERIENCE SUMMARY

• Highly motivated, deeply driven Oracle Database Administrator with 7+ years of experience.
• Expertise in Oracle Database Administration, Database Architecture.
• Expertise in leading the teams for maintenance of 24X7 high-availability applications.
• Dealt with development and production 11g/10g/9i/8i databases in variety of environments including Sun Solaris, Red hat Linux IBM-AIX, HP-UX, Microsoft Windows 2000/NT Servers and Linux.
• Experience with Oracle 11g/10g/9i/8i Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
• Extensive performance tuning experience, specializing in instance tuning, Oracle10g and 11g RAC tuning.
• My Skill set includes defining, developing, and modifying database systems, building the logical design model of a database, administering databases.
• Experience in meeting schedules and budgets, working with developers in performance tuning design.
• Experience in OBIEE,ODIandBIPquery tuning in a multi-terabyte environment
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Expertise in Oracle Data Guard, Cloning of Database.
• Expertise in Backup and Recovery activities using RMAN utilities.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured the oracle10g RAC on RED HAT Linux AS4 and have migrated databases in different platforms to same single centralized database server.
• 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Experience in Managing/working oracle Golden Gate installation and configuration.
• Experience in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment.
• Experience in installing and configuring Golden Gate 9.5.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experienced in utilizing Golden gate replication technology for ORACLE Upgrades.
• Experience in implementing 10g Grid monitoring application to monitor the Oracle Applications and Database.
• Experience in creating and managing Standby database using Data guard.
• Created the Migration Scripts for the migration from old system to new system.
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Expert in configuration of Hardware Clusters Environment.
• Experience in disaster recovery environments configuration in 24*7 environments using 9i Data Guard, 10g data guard.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net backup and Commvalut backup utilities.
• Extensive experience with AWR, ADDM, ASH STATSPACK, ORADEBUG, HANGANALYZE, PSTACK, TRUSS.
• Extensive experience with DBMS API’S and V$VIEWS, TOAD, Quest Spot Light, BMC Patrol and 10g Grid.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on multi nodes with Automatic Storage Management (ASM), VCFS, OCFS
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Extensive experience with proactive monitoring the databases using 10g Grid Control Monitoring.
• Expertise in using Golden Gate to support data replication in the Oracle database environment.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Strong Object Oriented Analysis (OOA), Design (OOD) and Programming (OOP) skills.
• Expertise in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

TECHNICAL SKILLS

Operating Systems:Unix, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 4.3, 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x,5 and Windows 98/2000/XP

RDBMS:Oracle 11g RAC/11g/10g RAC/10g/9i, SQL Server 2000/2005.

Languages:SQL, PL/SQL, T-SQL, UNIX Shell Scripting.

Tools:RMAN, Oracle Enterprise Manager (OEM) Grid Control, ODI, SQL*Loader, Erwin, Golden Gate, Exp/Imp, Data pump, Toad, Autosys, OBIEE, ESSBASE.

Tuning Tools:Tkprof, Explain plan, Statspack, top, iostat, glance, netstat, topas, nmon, oem.

Networking/Database Communication mechanisms and Others: TCP/IP, SSH, Oracle Net Services (SQL * Net, TNS), JDBC, ODBC, Informatica MDM, TTS – Transportable Tablespaces, SAN SRDF Sync.

PROFESSIONAL EXPERIENCE

Client: Confidential, Orrville, Ohio
Period: September 2011 - Till Date
Designation: Senior Oracle DBA.

Responsibilities:

• Involved in 35 production databases and 65 development/test databases.
• Working on AIX with OEM Grid control to maintain the database effectively.
• Proactively monitoring the database.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Implementation and configuration of OEM Grid on Oracle Server for maintenance and monitoring data.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Done performance tuning, instance tuning, Oracle10g and 11g RAC tuning.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imptables to setup identical databases in the production and development environments.
• Performed Cloning/Refresh to setup Test and Development database.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans while working with oracle structure.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Maintaining, Building and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Transformed logical database designs into physical databases.
• Build and implemented test, quality assurance, production databases and environments.
• Coordinated strategies to move data between databases.
• Monitored database space requirements and adjusted for future needs
• Performed OBIEE,ODIandBIPquery tuning.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Composed, maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Worked with Golden Gate Active-Active (Bidirectional) Replication.
• Resolved data integration issues.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Automate Logical Backups using export/import, data pump on applications through grid control.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Extensively worked with ASMCMD for managing ASM environment.

Environment:Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1) 11g (R1&R2) AIX,RS6000, SQL Tools, Solaris 3500, Solaris 10k,OEM Grid control, Golden Gate, RMAN, RAC, Data Guard.

Client: Confidential, Peapack, NJ
Period: April 2010 - August 2011
Designation: Senior Oracle DBA.

Responsibilities:

• Provided 24x7on call support for all the production and development databases.
• Responsible for Database Administration of Oracle RAC10g/11g and non RAC databases on ASM with size of databases varying from 20GB to 10TB.
• Managed Physical & Logical standby databases in RAC and non-RAC environments.
• Implemented 10g/11g Data guard with one physical database.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Implemented 11gR2 Data Guard using RMAN duplicate.
• Managed Oracle Grid control10g and configured Data Guard for OMR in Linux environment.
• Worked with Golden Gate Active-Active (Bidirectional) Replication.
• Performed Oracle database upgrade from 10g to 11g in Linux RAC environment.
• Worked with sysAdmin to configure Veritas Cluster Server Global Cluster Option (VCS -GCO) and coordinated Disaster recovery, fire drill for critical applications.
• Extensively used AWR, ADDM for database performance statistics.
• Performed Oracle database upgrades from 10g to 11g in Solaris RAC environment.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and STATSPACK.
• Worked with OIDCTL, a command line utility tool for starting and stopping the OID server.
• OEM / GRID (OGC) installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Implemented and supported Oracle RAC10gR2.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Installed, configured and maintained ASM enabled RAC10g database.
• Implemented streams and Logical standby replication.
• Responsible for configuring Streams.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Extensively used Oracle Application Server 10g, in deploying and integrating enterprise’s applications.
• Configured schema level logical backups (datapump) in 11g OEM Grid Control.
• Install and configure Oracle GoldenGate and Veridata, debugging GoldenGate issues such as abend.
• Worked extensively on Autosys in configuring, deleting, preparing and editing JIL for jobs, moving jobs in Crontab to Autosys.
• Extensively worked on configuring OEM grid control agent on new servers, registering new databases in 11gOEM Grid Control and automated RMAN and datapump backups in 10g/11g OEM Grid Control.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Performed Oracle Database upgrades from 10gR2 to 11gR1&11gR2 in RAC environment.
• Upgraded databases from 10.2.04 to 10.2.05 and 11.2.0.1 to 11.2.0.2.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Involved in Creating, configuring Access Control List (ACL) for 11gR1, 11gR2 databases.
• Checking database performance on a regular interval, which includes checking various log files.
• ASM implementation & maintenance.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Extensively on Oracle 10g,11g grid control (OGC), Putty, sql*plus, RMAN, Data Pump.
• Configured and automated RMAN backups through Grid Control.
• Worked on Oracle\'s Hyperion Performance Management applications (EPM) and Oracle Essbase.
• Worked on Profitability management in a comprehensive and fully integrated suite.

Environment: Oracle 8i/9i/10g/11g RAC/stand alone databases, HP-UX v11i, HP 700 Series, Sun 3500,3800,6800, Sun Enterprise 450 & 880, T2000, Solaris 9.0/10.0/11.0 ,10g/11g Data Guard, Golden Gate, ASM 10g/11g, 10g Data pump, Export/Import, Physical Backups, Oracle Enterprise Manager, 10g/11g Grid Control, Autosys and DBArtisan.

Client: Confidential, Scottsdale, AZ 
Period: April 2008 - April 2010
Designation: Senior Oracle DBA

Responsibilities:

• Part of 4 member DBA team for 24x7 supports for Oracle 9i/10g/11g productions, development databases.
• Administered databases on 9i/ 10g/11g in all environments on RHEL, IBM-AIX, HP-UX, Windows 2003.
• Migrated databases in all environments from Sun Solaris 10, IBM-AIX 5.2 to RHEL 4.1 using XTTS.
• Upgraded and Migrated Production, Development, QA databases from 9.2.0.8, 10.2.0.4 to 11.1.0.7.
• Installed, Configured and maintained multiple 10g RAC with ASM production, test databases.
• Installated 11gR1 RAC, Upgraded databases to Oracle 11g for test purposes and explored new features.
• Experience with SRVCTL, CRSCTL, Oracle Enterprise Manager (OEM) Grid Control, DBCA, VIPCA, OIFCFG, ASMCMD and SQL* Plus for administration of Services, ASM instances and RAC databases.
• Developed, Configured and maintained Dataguard (Standby database) for faster Disaster Recovery.
• Applied patches, patchsets and Critical Patch Update (CPU) using OPatch utility and OUI.
• Cloned/ Data Refresh from production to setup test and development environments using RMAN duplicate.
• Administered Very Large multi Terabyte Databases (VLDB) around 3TB+ on 3 Node 10g RAC in Data Warehouse and OLTP Environments including high-volume call center, production database.
• Excellent experience with OEM Grid control, TOAD which acts as a great platform where Database Quality, Performance and Availability functions for administration and development enable perform tasks.
• Designed Backup and Recovery procedures for production and non production environments using RMAN.
• Took periodic Complete, Incremental and Cumulative Backups of production and non-production servers using RMAN, SQL Backtrack using IBM Tivoli tape devices, Hot and Cold Backups.
• Recovered the databases, data files, blocks in case of disk failure, database crash and block corruption.
• Experience with SQL DML, DDL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Provided the support and tuned for OBIEE applications usingExplain Plan, SQL Trace, Tkprof reports, SQL Tuning Advisor and Optimized long running queries using partitioning of large tables, indexes, local indexes, parallel processing and tuning the ETL file load process.
• Performance monitoring, Database tuning , Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack, AWR (Statspack) reports.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR (statspack) reports, ASH, ADDM and OEM (Oracle Enterprise Manager) Grid Control.
• Creating and managing tablespace with different block-sizes to prevent row chaining.
• Export/Import, Datapump, TTS to migrate database objects from database to another/to other server.
• Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) using Flashback Recovery, TSPITR and from previous RMAN backups, Hot, Cold and user managed backups.
• Daily DBA activities: managing all the database files, alert logs, tablespaces, segments, extents, data blocks & physical storage, database network connectivity, database links, users, granting/revokingsystem/object privileges, querying data dictionary tables for metadata, setting init.ora parameters, database locking issues.
• UNIX Shell Scripts and crontab jobs to automate daily tasks including Backups, Exports/Imports, Startup and Shutdown of databases, monitoring tablespace growth, gathering CBO statistics, analyzing tables and indexes, trimming the alert log files, monitor backup logs and monitor the alert logs for errors.
• Experience with Oracle Streams and Materialized Views which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Involved in data modeling, physical and logical database design using ERWIN data modeler.
• Database growth, capacity planning, Space Management includes tablespace creation, adding datafiles.
• Experience in monitoring and tuning system resources associated with the database performance hit ratios, I/O, lock and latch contention.
• Find solution and resolve critical issues with Oracle Support and Root Cause Analysis (RCA).
• Documented all Oracle database operations and training of backup personnel.

Environment: Oracle 8i, Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1), AIX 5.2, 5.3 RS6000, Solaris 3500, Solaris 10k, Dell 5560 with Xeon Processors.

Client: Confidential, Hartford,CT.
Period: February 2006 - March 2008
Designation: Senior Oracle Database Administrator

Responsibilities:

• Worked as a team member to provided 24x7 support for Production and Development databases.
• Installation of Oracle binaries, administration of oracle 9i/10g/10g RAC production, test and development environments on RHEL, Sun Solaris platform in OLTP and Data Warehouse environments.
• Installed, configured 2 node 10g RAC with ASM for billing systems, account detail databases.
• Administrated Very Large Data Warehouse Databases (VLDB) ranging from 500GB to 20TB.
• Migrated databases around 1.7 TB (VLDB) across platforms from Sun Solaris 10 to RHEL 3.2 using TTS.
• Upgraded databases in production, test and development environments from 9.2.0.6 to 10.2.0.2 (Oracle 10gR2).
• Applying high priority, security patches, patchsets to oracle using OPatch Utility, runInstaller.
• Data Refresh/Cloning from production to setup test (QA) and development environments.
• Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.
• Had very good experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.
• SQL Query tuning, Database instance tuning, application tuning using sql trace, explain plan, hints, tkprof, AWR reports, Statspack reports, ADDM reports, initialization parameters, etc.
• Partitioned the large tables and indexes by determining the suitable methodology to improve performance and manageability, Extract, Transform and Load (ETL) data from flat files into database using SQL* Loader.
• Defining and implementing Backup and Recovery Strategies on production, test, development databases using RMAN, VERITAS Net backup, and RECOVERPOINT, Hot and Cold Backups.
• Recovered tablespaces, datafiles on Oracle 10g using Recovery Manager (RMAN).
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS).
• Crontab jobs and UNIX Shell scripts to automate backups, exports/imports, analyzing tables indexes, monitor tablespace growth, alert logs, startup, shutdown of databases, gathering statistics.
• Excellent day to day administration in every means and monitoring alert log files and trace files.
• Transfers of data from one database to other by using exp/imp, oracle data pump (expdp/impdp).
• Setting up Oracle read only replication with materialized views, Streams to develop scripts for automating the rebuilt process of replication and documented oracle database setup and administration of server environment.
• Assisting developers with SQL, PL/SQL coding to enhance the database performance.
• Find solution and resolve critical issues with Oracle Support.
• Database sizing analysis, recommendations and perform database re-organizations as required to assist performance and ensure maximum uptime of the database.

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440,IBM z/OS 1.12, Fire 880, Oracle 9i/10g/11g, HP Integrity RX 8640, RHEL AS 5, SQL * Plus, OEM, Erwin Data Modeler.

Client: Confidential
Period:May 2004- December 2005
Designation: Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 8i, 9i on HP-UX and IBM-AIX environments.
• Upgraded databases in production and development environments from 8i to Oracle 9i.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects and Implemented Hot, Cold and Logical backup plans, RMAN backups.
• Designed backup and recovery procedures for OLTP system. Conducted periodic hot and cold backups.
• Migrated Oracle databases across different platform, Instance cloning to create test, training databases.
• Created PL/SQL procedures (jobs) to automate maintenance tasks, triggers, functions, packages.
• Using TKPROF, EXPLAIN PLAN, Statspack reports for the better performance.
• Transfer of data from one database to another using export/import (exp/ imp) and SQL * Loader jobs.
• Setting and maintaining user accounts, granting required privileges and roles to users.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Diagnose and troubleshoot database problems and failures and tuning the database for optimal performance, loading data using SQL*Loader and partitioned large tables to increase the performance.
• Monitoring database for fragmentation and correcting them, reorganization of tables
• Handling day to day activities and generated scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth and space management including tablespaces and datafiles.
• Monitoring and optimizing database performance and responsible for optimizing the queries and application tuning and Kernel Configuration and alert log monitoring, database setup and design.
• Providing support to end users and developers.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, STATSPACK, TKPROF, UTL_SMTP,EMC ERWIN, SQL*LOADER

• Bachelor of Technology, Confidential University