Experience Summary:

• Around 7years of experience as a Senior Oracle Database Administrator in the Database Installation, Development and Production System Support leading Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, UNIX shell scripting, korn shell scripting and documentation.
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.
• Strong experience with Oracle Databases (11g/10g/9i/8i), RAC on Unix/Linux/Windows/VMware platforms.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.
• 2 years of good experience in installing, configuring, administering and troubleshooting Oracle Data Integrator (ODI) 10.1.3.5.0 , 10 1.3.5.2, 10.1.3.5.3
• years of Extensive Experience in Installing and Upgrading Oracle 9i/10g databases on production, test and development environments on Solaris, AIX and Linux boxes.
• 3+ years of Proficient Experience with Standby Database, Data Guard, Replication.
• 5 years of experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes on Linux/Aix/Solaris.
• 5 years of experience in Installing, Implementing, Configuring and Running Oracle 10g RAC.
• 4+ years of experience in Installing guest operating systems on VMware and installing and configuring 9i/10g databases and Oracle 9i/10g RAC
• 6+ years of strong experience in Hot/Cold Backup and Recovery
• Strong Experience in Cloning of databases using RMAN, VERITAS Net Backup.
• racle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• 6 years of experience in Implementing Streams, Data Pump, Export and Import utilities.
• 6years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• 6 years of Proficient experience in Database performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan.
• Experience in Troubleshooting oracle databases using sqltrace utilities.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• 5 years of proficient experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, Oracle Data Dictionary – meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Good Knowledge in Data Modeling tools like Erwin.
• Migration between ASCII-based characters
• Experiencing in basic and advanced replication
• 6 years of Experience in using OEM,TOAD
• 6 years of Experience in Implementing and configuring 10g OEM Grid Control..
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Installation, Configuration and Updating of Oracle Business Intelligence tools.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Technical Disciplines:

Technical Skill Set:

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, Windows 2003, Windows 2008

RDBMS

Oracle 11g/10g/9i/8i

Languages

SQL,PL/SQL C, C++, Perl, Korn, UNIX Shell Scripting, Java.

Tools

RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK , AWR .

Database Modeling

Erwin 4.0, Rational rose, UML 2.0

Other

EMC, NetApp, Veritas NetBackup

Professional Experience:

Confidential

Role: Sr Database Administrator

Roles and Responsibilities:

• Supporting Oracle Databases 10g RAC on Linux Itanium.
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Creating and dropping of users, granting and revoking rights as and when required..
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• uning heavy data loads. Monitoring and Performance tuning.
• Using TKPROF, EXPLAIN PLAN and AWR for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts, Korn and Perl scripts. Good Experience tranfering files by using scp, sftp, ftp and pscp.
• Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Performed and Monitored Database using tools TOAD and OEM 10g
• Monitoring of database for growth and performance
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Environment: Oracle Server 10g/11g, SQL, PL/SQL, Linux Itanium, Solaris 10, Shell scripting, TOAD, OEM 10g, Informatica, Datastage

Confidential

Role: Sr Database Administrator

Roles and Responsibilities:

• Strong working experience in 24 X 7 Production database administration, data warehouse systems and monitoring to ensure a proactive problem recognition and resolution of very large database issues.
• Creating of databases for Testing, Development and Production on VLDB systems.
• Converted a single instance database to Oracle RAC 10g
• Installed and Upgraded Oracle 11g database from Oracle 10g database on test and development environments.
• Installation, Configuration and Administration of 4 node Oracle 10g RAC.
• ASM and CRS installation and new database creation for 10g RAC.
• Experience in configuring Oracle Advanced Security Option (ASO) and Secure Sockets Layer (SSL) on both server and client machines.
• Implemented Streams on both 9i and 10g Databases, Export & Import on 9i Database, DataPump in 10g Database.
• Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented and Involved in Hot, Cold and Logical backup plans
• Oracle 9i & 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Proactive database monitoring using 10g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures
• Written Korn, Perl, shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• nstallation of Oracle version 10g on Solaris, HP-UX and AIX boxes.
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Upgrading of Database from 9.2.0.6 and to 10.2.0.2
• Was involved in developing a disaster recovery (DR) plan and Stand by Database
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack , Diagnostics Pack and STATSPACK
• Rebuilding of Indexes
• Conducting sizing & capacity planning for Oracle databases.
• Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent OLAP patches.
• Experience in reading Alert. Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Serves.

Environment: Oracle Server 10g, RHEL 3, 4, Windows, Shell & Perl scripting, TOAD, Oracle 9iAS , OEM 10g

Confidential

Role: Sr Database Administrator

Roles and Responsibilities:

• Advised and made recommendations to improve the overall database design
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN)
• Was involved in developing a disaster recovery (DR) plan
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack , Diagnostics Pack and STATSPACK
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication)
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS
• Automation of tasks like backup/refresh and other jobs using.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one of Patches etc).
• Oracle Applications Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Installed and Configured Single Sign On and Implemented SSL Security.
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Planning and Administration of backup and recovery strategies.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle OID Implementation and Support.
• Oracle DataGuard Implementation for HA and remote DR site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Oracle Server 10g, RHEL 3, 4, Windows, Shell & Perl scripting, TOAD, Oracle 9iAS , OEM 10g

Confidential

Role: Database Administrator

Roles and Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, Perfstat, TKPROF, AWR, ADDM utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Erwin, Import/Export, UNIX AIX 5.1, Windows NT.

Confidential

Role: Database Administrator

Roles and Responsibilities:

• Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process
• Defragmentation of database using export and import
• Vast experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by working in development area in using ESTAT/BSTAT and more with STATSPACK as the main tool to tune SQL queries
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Extensive use of SQL*LOADER to enable data migration into Oracle Database
• Daily monitoring of the database and space issues
• Performed Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Install Oracle SOA Suite with Oracle Application Server.
• Design trouble shoot and implement BPEL solution for integration between applications task workflow.
• Create and configure Business rules, integrate the same with the BPEL workflow.
• Design develops integration of BPEL events with BAM to pump real-time data.
• Involved in a project implementation of Installation and Configuration of SOA suite Version 10.1.3.3 including Application Server with OC4J, ESB, BPEL, OWSM (Oracle Web services manager) & UDDI Registry.
• Developed, deployed and managed SOA suite using Oracle Fusion Middleware (OFM).
• Applied patches using ADPATCH, ADCTRL utilities
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely with user groups to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• mplemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Registering reports and printers in Oracle Application Servers.
• Troubleshooting and Administration of oracle10g Application Server
• Expertise in database migrations from Solaris to Linux.

Environment: Oracle Server 9i/8i, SQL*Plus, SQL*LOADER, PL/SQL, HP UX, Windows, C++, UNIX shell script Database Size: over 3TB, Oracle Applications 11.5.7