SUMMARY

• Oracle certified Database Administrator with 8.3 + years of hands on IT experience in database administration, production support, installation, configuration, upgrades, patching, performance tuning, backup and recovery, Oracle Golden Gate, Oracel Streams, Dataguard setup, Oracle ASM, PL/SQL, space management, database security, cloning, migration, shell scripting,Oracle Primavera, OBIEE, Oracle Internals ( Wait events etc), Oracle RAC, WebLogic Administration, ebusiness Suite, MySQL and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems. Working knowledge on 12c Poc as well.
• Excellent experience in installation/creation, setup and configuration/replication of Oracle 8i, 9i, 10g and 11g in UNIX/Linux, Sun Solaris, IBM AIX, Windows and HP - UX Environments.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24*7 production database support with Support to developers & end-users.
• Installed & Maintained Oracle 10g,11g ASM & Oracle RAC Databases with ASM disks & Raw Device storage.
• Experienced in Installation of high availability RAC environment (multi-node clustering) and upgraded standalone databases to 10g/11g RAC environment along with load balancing.
• Experience in implementation,configuration and Administration of Oracle GoldenGate features to extract and replicate the data between various topologies.
• Experience in Oracle Streams Implementation
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes, Oracle Cost Based Optimizer tuning,optimizing Oracle Sql Queries and Using PL/SQL .
• Planning & Implementing the Maintenance activities to reduce Fragmentation in the Database and to improve performance.
• Performance Tuninng analysis w.r.t Database, O/S and Various Applications in Problem Resolutions along with Capacity Planning
• Hands-on experience on Oracle weblogic Fusion 11g Installation/Configuration/Maintenance and OBIEE
• Hands-on Experience Oracle Primavera Installation, Configuration and Maintenance.
• Using srvctl to manage database services & DNFS setup at DB level.
• Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using RMAN utility tool, activating and Re-building Physical Standby Database supported by DATAGUARD.
• Proficient in setting up the DataGuard Broker for High Availability to handle failover scenario’s
• Managed very large database (VLDB) of maximum size 15TB with 80 servers including 20 Productions, 15 Standby databases & remaining Non-prod Environments.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN, RMAN DUPLICATE, restore from Netbackup and using dd.
• Implemented RMAN backup (Full/ incremental/differential) and recovery, Incomplete recovery and disaster recovery(DR) using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Good Experience in Data Migration using DATAPUMP (expdp/impdp) & Traditional EXP/IMP .
• Expertise in maintaining Database Security using security compliance auditing policies .
• Having experience in Mining Archive logs etc.
• Experienced in usingOracle's Transportable Tablespace (TTS) feature which allows users to quickly move a user Tablespace across Oracle databases.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, SQL*LOADER,TOAD and Grid Control using OEM
• Database replication using materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Good Experience in RAC & Dataguard Switcover/Failover Testing Scenarios.
• Effective troubleshooting of database and Performance problems.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using EMC and Netapp Storage Area Network (SAN).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Knowledge on Times-Ten database
• Working experience on Oracle eBusiness Suite, MySQL
• Expertise on Oracle Database concepts, Relational Databases (RDBMS ) and Normalizations
• Working Knowledge on Cloureda Manager components like Hbase, Hadoop,Mapreduce etc.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Oracle 11g/10g (RAC / Data Guard/ Data Guard Broker / ASM / Physical Standby Databases/ Streams ), Oracle Application Server 10g

OPERATING SYSTEMS: Red Hat Linux RHEL(3/4/5.x), UNIX, AIX, Sun Solaris, HP-UX and Windows

LANGUAGES: UNIX Shell Scripting, SQL, PL/SQL, C/C++, ksh & Perl scripting

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, VERITAS Net Backup, SAN, SQL TRACE, Oracle SQL Developer, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM, TOAD

WEB TOOLS: HTML/DHTML,Java script & XML

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g & 10g RAC databases.
• Involved in Installation/Creation and configuration of Oracle 10g &11gRAC using Cluster ware/Grid Infrastructure and ASM.
• Successfully upgraded Oracle 10g/9i databases to Oracle 11gR2 on Linux platforms.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Experienced in Cloning & Refreshing databases using RMAN, RMAN DUPLICATE, dd, SRDF copy etc.
• Performed Database Migrations using Physical / Logical backups.
• Experience and Knowledge on Oracle Internals like Wait Events, Data Dictionary etc.
• Implemented Active Data Guard, Data guard along with DGBroker(Oracle Fast start Failover) for Physical Standby databases in Oracle 10g &11gRAC environment for the Production an Non-Prod databases.
• Working Knowledge on Oracle 12c Poc .
• Experience in implementation,configuration and Administration of Oracle GoldenGate features to extract and replicate the data between various topologies
• Configured LDAP for TNS connectivity.
• Performance Tuning analysis w.r.t Database, O/S and Various Applications.
• Successfully Migrated Non RAC single instances to Real Application Cluster (Oracle RAC) database instances.
• 24x7 remote support and on call Production Database support for Database developers & end-users.
• Have Co-ordinated & Participated in quarterly Enterprise Release Management organization database Migrations/releases.
• Experienced in implementing Oracle Database advanced security practices.
• Successfully configured and installed Oracle Golden Gate for database replication
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)
• Experienced in performing the Hot / Cold & Logical backups
• Remedy Case Resolutions for L1/L2 support in Production databases.
• Experience in implementation,configuration and Administration of Oracle GoldenGate features to extract and replicate the data between various topologies.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same along with OS and database capacity Planning
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Hands-on experience on Oracle weblogic Fusion 11g Installation/Configuration/Maintenance and OBIEE.
• Hands-on Experience Oracle Primavera Installation, Configuration and Maintenance.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete, data file & incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Expertise on Oracle Database concepts, Relational Databases (RDBMS ) and Normalizations
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) in managing database issues.

Environment: Oracle 11g/10g/9i, Linux, Sun Solaris, HP-UNIX, Windows, Oracle Enterprise Manager, SQL* Loader, SQL *Plus, OraDebug, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN, Shell Scripting, TOAD, Exp/Imp, Expdp/Impdp.

Confidential, Oakland, California

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g & 10g RAC databases.
• Monitor and Tune Oracle Databases Instances
• Monitor Database performance, Waitevents, troubleshoot and resolving issues.
• Monitor Database backup’s and recovery plans.
• Work with development teams for schema design and query tuning.
• Design database security roles and enroll database & audit security features
• Co-ordinate with system administrator and application development teams for Capacity Planning and Application design.
• Cross-train the Site production team in running and maintaining production Databases.
• Develop and monitor SQL*LOADER scripts and ETL processing
• Partitioning the tables for performance improvements.
• Monitoring HDFS(Hadoop Distributed Filesystem ) operations.
• Working on the Cloudera Manager components like Hbase, Hadoop, Mapreduce etc.
• Experienced in Cloning & Refreshing databases using RMAN, RMAN DUPLICATE, dd, SRDF copy etc.
• Performed Database Migrations using Physical / Logical backups.
• Experience and Knowledge on Oracle Internals like Wait Events, Data Dictionary etc.
• Performance Tuninng analysis w.r.t Database, O/S and Various Applications.
• Partitioned large tables to increase the performance.
• 24x7 remote support and on call Production Database support for Database developers & end-users.
• Experienced in implementing Oracle Database advanced security practices.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)
• Experienced in performing the Hot / Cold & Logical backups
• JIRA Case Resolutions for L1/L2 support in Production databases.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Resolving TAR issues 24x7 while assisting the functional team and oracle support (Metalink) in managing database issues.

Environment: Oracle 11g/10g/9i, Linux, Sun Solaris, HP-UNIX, Windows, Oracle Enterprise Manager, SQL* Loader, SQL *Plus, OraDebug, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN, Shell Scripting, TOAD, Exp/Imp, Expdp/Impdp,hadoop,Hbase

Confidential, San Jose, California

Sr. Oracle DBA

Responsibilities:

• Setup multi-site architecture via MVDC (Metro Virtual Data Center) using Oracle 11g Data Guard Broker in 4-Node RAC Environment
• Installation, configuration, maintenance and tuning of Oracle 11g & 10g RAC databases.
• Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware/Grid Infrastructure and ASM.
• Successfully upgraded Oracle 10g/9i databases to Oracle 11gR2 on Linux platforms.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Experienced in Cloning & Refreshing databases using RMAN, RMAN DUPLICATE, dd, SRDF copy etc.
• Performed Database Migrations using Physical / Logical backups.
• Experience and Knowledge on Oracle Internals like Wait Events, Data Dictionary etc.
• Implemented Active Data Guard, Data guard along with DGBroker(Oracle Fast start Failover) for Physical Standby databases in Oracle 10g &11gRAC environment for the Production an Non-Prod databases.
• Worked as a Lead Initiator for Data Center Migration project.
• Working experience on Oracle eBusiness Suite.
• Experience in implementation,configuration and Administration of Oracle GoldenGate features to extract and replicate the data between various topologies
• Configured LDAP for TNS connectivity.
• Performance Tuninng analysis w.r.t Database, O/S and Various Applications.
• Partitioned large tables to increase the performance.
• Successfully Migrated Non RAC single instances to Real Application Cluster (Oracle RAC) database instances.
• 24x7 remote support and on call Production Database support for Database developers & end-users.
• Have Co-ordinated & Participated in quarterly Enterprise Release Management organization database Migrations/releases.
• Experienced in implementing Oracle Database advanced security practices.
• Successfully configured and installed Oracle Golden Gate for database replication
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)
• Experienced in performing the Hot / Cold & Logical backups
• Remedy Case Resolutions for L1/L2 support in Production databases.
• Experience in implementation,configuration and Administration of Oracle GoldenGate features to extract and replicate the data between various topologies.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same along with OS and database capacity Planning
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Hands-on experience on Oracle weblogic Fusion 11g Installation/Configuration/Maintenance and OBIEE.
• Hands-on Experience Oracle Primavera Installation, Configuration and Maintenance.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete, data file & incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
• Hands-on Experience Oracle Primavera Installation, Configuration and Maintenance.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Expertise on Oracle Database concepts, Relational Databases (RDBMS ) and Normalizations
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) in managing database issues.

Environment: Oracle 11g/10g/9i, Linux, Sun Solaris, HP-UNIX, Windows, Oracle Enterprise Manager, SQL* Loader, SQL *Plus, OraDebug, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN, Shell Scripting, TOAD, Exp/Imp, Expdp/Impdp.

Confidential

Lead Oracle DBA

Responsibilities:

• Troubleshooting 24*7 production Database environment issues to support and monitor for a proactive problem recognition and resolution .
• Worked as a Lead Oracle DBA to architect & design databases for various business critical applications.
• Migrating the database from existing Oracle RAC/Non RAC systems to High End servers.
• Applied Patches/Patchsets to all Oracle versions, OMS and to Oracle 10g IAS
• Upgrading Dev/UAT and production databases to Oracle 10g/11gR1.
• Installing and configuring Grid control, Configuring Targets & alerts in OEM for all critical systems for Proactive database monitoring.
• Migrated databases from file system to ASM
• Installed & Manitained the Oracle 10/11g RAC ASM Configured Databases.
• Used RMAN for backup and recovery. Performed Hot & Cold backups along with backup validations and restorations.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Cloned Databases using RMAN DUPLICATE, RMAN & standard dd methods.
• Responsible for optimizing the queries and application jvm tuning.
• Implemented Oracle Physical Standby dataguard setup for Major oracle 10g/11g databases.
• Installation of 10g Application servers and deployment of the Applications
• Performing switchover between Primary and standby databases.
• Performing DR Drills twice an year.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical I/O and Memory Usage.
• Devised & Implemented backup strategies using hot, cold, and Logical exports based on the business requirements.
• Oracle GoldenGate setup and administration
• Oracle Streams setup and administration
• Performance Tuninng analysis w.r.t Database, O/S and Various Applications.
• Management of schemas, objects partitioning the tables & indexes.
• Experience and Knowledge on Oracle Internals like Wait Events, Data Dictionary etc.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users..
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Made performance improvements to the database by re-building Partitioned tables, IOT’s, Materialized Views and Bitmap Indexes, by maintaining Aggregates, Compression, partitioning, indexing, use of Hints, Stored outlines, gather Statistics .
• Used transportable table space (TTS) feature to for cross platform data Migrations.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Cloned schemas, objects and data on new server using logical datapump features.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Experience in various recovery scenarios.
• Generating stats pack reports on regular basis to identify the database performance at peak load
• Implemented scripts to monitor the health of the databases and application servers
• Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance
• Planning and implementing the Archival policies as per the requirements.
• Working with the solution design team and identifying solutions to the new business functionalities.

Environment: Oracle 11g/10g/9i, Linux, Sun Solaris, HP-UNIX, Windows, Oracle Enterprise Manager, SQL* Loader, SQL *Plus, OraDebug, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN, Shell Scripting, TOAD, Exp/Imp, Expdp/Impdp

Confidential

Oracle DBA

Responsibilities:

• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Migrated data from one database to the other using RMAN and Export / Import Utility.
• Migrated database from one version to its higher version.
• Installation of oracle 9i/10g software and database creation
• Developed scripts for simplification of routine database tasks.
• Resolving the Change and Service requests by implementing the same in Databases
• Configured Oracle Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Configured and maintained Version Control System and code promoter for the Project.
• Configured PACE and SMART for performance analysis and Application Monitoring.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Modified Korn, shell scripts as per technical specifications.

Environment: Oracle 9i/10g, Linux, HP-UX, PL/SQL, Database Tools/Utilities, SQL *Plus, Exp/Imp, RMAN, Shell Scripting, PVCS, TOAD.