SUMMARY

• 7 years of experience in Oracle 11g,10g, Database Administration in Production, Test and Cluster Server environment.
• Experienced in creation ofOracle Database10g and 11g on Red - Hat Linux, HP UX, Sun Solaris, IBM AIX and Windows environment.
• Expert in measurement and planning Database Storage Structures.
• Maintained Databases by evaluating high availability options and disaster recovery plans implementing 11g Oracle RAC and Data Guard according to business requirements.
• Configuring the physical & logical standby databases with different protection modes using sqlplus & RMAN.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Implemented Security at database level, user level and the data level using Auditing and Protegrity.
• Establish Backup policy using RMAN and Network backups. Also managed Backup, Restore using Data Pump, Traditional Export and Import and Recoveries using RMAN and conventional UNIX shell scripts.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Used AWR, ADDM and statspack Reports for trouble shooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Collections of performance data for specific time range using STATSPACK.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Experienced in database reorganization regularly for removing row migrations and fragmentation using export and import utilities. Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.
• Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
• Skilled in monitoring Oracle Database using Quest Toad and OEM, to minimize the performance problems.
• Expert in providing the full database dumps and schema level dumps to DEV database environments.
• Prepared documents detailing various database design and maintenance procedures.

TECHNICAL SKILLS

RDBMS: Oracle, SQL Server, MySQL, DB2.

Database Advance Feature: RAC, Data Guard, Standby Database, Oracle Streams, Advanced Replication/Materialized View, Data Warehouse, Grid Control, Data Mirror.

Oracle Utility: RMAN, OEM, Export/Import, Data Pump, SQL*Loader, DBVerify, Log Miner, ASMCMD.

Performance Tuning: Grid control, Toad, Quest SQL Optimizer, STATSPACK, TKPROF, AWR, ADDM, ASH report, DBArtisan, OS Watcher. operating systems: UNIX, Linux, SunSolaris, HP-UX, AIX, Windows 8/7/XP/2000/2003.

Languages: SQL, PL/SQL, JAVA, JDBC, HTML, XML, C, C++.

Tools: TOAD, DBArtisan, ERWIN, SqlDeveloper, Sql Loader Utility, OEM Grid Control, RMAN.

PROFESSIONAL EXPERIENCE

Confidential, Newark, CA

Oracle DBA

Responsibilities:

• Created and maintained various databases for Production, Development and Testing using Oracle 10g, 11g.
• Active member of the on-call team to support Clients of different Applications relating to our team 24/7, to keep the High critical systems running.
• Participate in storage capacity measurement and planning.
• Created and managed tablespaces monitored the datafiles' space, resizing and adding new datafiles etc.
• Managing database security, creating and assigning appropriate roles and privileges to users depending on the user activities.
• Created new user accounts, profiles, and roles assigned them to different users.
• Used RMAN to configure various operations in data guard.
• Developed Oracle backup and recovery scripts using RMAN utility.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications.
• Validating and testing daily backups and coordinating with the customers during maintenance activities and system reboots.
• Installation issues e.g. Root.sh has not executedsuccessfully on 2 node and patching issues, vipca fails.
• Doing the RCA (Root Cause Analysis) for Node Eviction also for CRS reboots & other issues.
• Troubleshooting RAC startups, crashes, evictions, reboots, corruptions, failover & failback of VIP.
• Monitoring the performance of Redo Transport Services.
• Used Real Application Testing to Root Cause Analysis the problems in production Database.
• Used AWR, ADDM and for trouble shooting performance issues and Capacity Planning.
• Monitor long running queries/ Error Logs /Schedule Tasks/database activity/eliminate Blocking and Deadlocks user counts and connections/locks etc.
• Implemented Partitioning on huge tables to improve the performance and reduce the maintenance to finite window operations.
• Did Database Reorganization regularly for removing row migrations and fragmentation using export and import utilities Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.
• Generating traces of the user sessions using oradebug utility to study the performance.
• Implementing the necessary modifications in database architecture for best possible performance.
• Transported the tablespace from production database and plugged-in it in development database for the usage of developers.
• Attended the technical presentations/demonstrations from the vendors, evaluated the vendor products against the business needs and recommended the most efficient & cost effective solution.
• Provided remote support for offshore team.

Environment: Oracle Database 11g, 10g, Sun Solaris, Linux, HP UX, Windows 2003/ 2008, SQL SERVER 2005, Real Application Clusters, Data Guard, PL SQL, RMAN, AWR, ADDM,TKPROF, Toad, Grid Control, SQL*Loader, SQL Developer.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Involved in Capacity Planning, projection of database growth and advising for the hardware configuration.
• Provided technical support to internal developers, offshore developers and external clients.
• Create target Database in 11g utilizing Linux platform.
• Identifying the Database objects require migration.
• Identify each object with sizing criteria including large, medium and small.
• Sizing estimations and create appropriate tablespaces.
• Creating, configuring databases for mission critical business applications. Migrating databases from one to another platform. Configured and Maintained Standby databases.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Create Import/Export scripts.
• Configuring Database to schedule Database monitoring scripts.
• Configuring Database to make ready for Hot Backup using Veritas NetBackup and Oracle RMAN.
• Identify potential failures of Export/Import Jobs and resolution of the problem including resizing the tablespaces.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them as required.
• Create Database users and roles and implement appropriate user security.
• Involved in Setting up enterprise wide RAC implementation strategies.
• Installation propagation problems. Enable tracing for OUI & checking which IP is used for copying the binaries from one to another node.
• Stopping CRS reboot loops when CRS problem occurs.
• Proactively monitored the databases using tools and scripts.
• SQL performance diagnostic activity for slow performing applications including Explain Plan generation, Tracing of User and Database sessions and output generation using TKPROF.
• Compared Object Count from Source with the Target System and compared AWR reports to resolve Performance issues.
• Evaluated various tools for monitoring, administration and deployed Oracle 11g Grid Control.
• Database links were created to access the data from remote databases.
• Snapshots were used to get the remote database data into the local database.
• On call 24/7 support to databases on weekly rotation.

Environment: Oracle Database 10g, 9i, 8i, AIX, Linux, SQL SERVER 2000, Oracle Real Application Clusters, Oracle Data guard, Windows NT, Windows 2000/2003 server, Grid Control, Shell Scripting, PL/SQL, Unix Shell scripting, DBCA, RMAN, Toad, SQL*Loader, Quest tools.

Confidential, Pasadena, California

Oracle DBA

Responsibilities:

• First line Oracle support on multiple platforms (HP-UX, Linux, WIN, and AIX) with production instances 30+, development instances 100+.
• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Installed and configured Oracle 10g, 11g ASM and database software on Linux / HP UX or Oracle Enterprise Linux Operating System.
• Prepared a step by step installation document for the 11g RAC on Linux operating system.
• Designed, Engineered and Implemented the Oracle HIGH AVAILABILITY databases using Data guard and Oracle 11g /10g RAC databases for various applications such as DW / OLTP on RHEL.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Analysis of user requirement troubleshooting and handling queries on specific issues.
• Evaluated Oracle database new features, industrializing them as per the business needs.
• Implemented Jobs and Events through OEM and set the mailing options to the DBA/EPT operations Data Centre for the job success/failure and event escalation.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.
• Tuning of SQL statements, SGA etc., taking periodical snapshots, interpreting statspack reports to check the DB performance.
• Worked with External Tables and partitioned some of the large database tables.
• Tuned OLTP and DSS type queries, explain plans for developers, and reorganized tables and indexes.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.
• Patch and Upgrade Oracle - All the databases are patched up to-date with latest Oracle CPUs.
• Developed and Implemented disk backup & recovery strategies for Cluster Databases to minimize the potential loss of data due to disk failure.
• Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts and tuned various parameters
• Monitored the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, vmstat and top.

Environment: Oracle 11g, 10g, AIX, Linux, HP UX,Windows 2003, Oracle GRID, ASM, Oracle RAC, Toad, Sql Server 2005, MySQL, Oracle RAC, Oracle RMAN Standby databases, Oracle Sqldeveloper, AWR, Sun Solaris.

Confidential, Madison, Wisconsin

Oracle DBA

Responsibilities:

• Install Oracle DB 10g, 11g RDBMS, applying Oracle Critical patch updates, manages DB upgrades and migrations.
• All the Production and Development database Instances are Configured to an Oracle Management Server and managed through an OEM Repository and Console.
• Successfully migrated Oracle 10g OEM to Oracle 11g Grid Control.
• Core Database administration includes Creation of the database, sizing the database structures, Tablespace management, user management, taking backups, restoration of the data, managing.
• Created new user accounts, profiles, and roles assigned them to different users.
• Managing database security, creating and assigning appropriate roles and privileges to users depending on the user activities.
• Implemented Maintenance scripts from single server to collect the stats of remote databases on different servers.
• Developed backup scripts that include database exports, tape backups and printing of reports etc. Implemented nightly cron jobs using UNIX shell programs.
• Used the standby database for doing different operations like taking backups, recoveries, collecting statistics and running various reports without disturbing the production database.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications.
• Implemented the database tuning to improve the performance of the database.
• Resolved inconsistency issues, shared memory allocations, long transactions, locking issues and deadlocks.
• Application tuning using Hints, Explain Plan, SQL trace, TKPROF using SQL Navigator Expert Tuning, Index Tuning utility.
• Reorganizing the database at regular intervals to remove row migrations, fragmentation in the database using export and import utilities.
• Used SQLLoader utility to load data into oracle database from external files.
• Providing the full database dumps and schema level dumps to DEV database environments.
• Creation of new database links and materialized views and setting up of database jobs for their refreshment.
• Setup and maintain documentation and standards.
• Perform Oracle 24/7 OLTP systems tuning.

Environment: Oracle 11g/10g/.x., Oracle Designer2000, OEM, Oracle Data guard, Unix Shell scripting, RMAN, SQL*Plus, SQL*Loader, Toad, HP-UX, Solaris, AIX and Windows NT&Windows 2000 server.

Confidential

Oracle DBA

Responsibilities:

• Designing system architecture, Sizing the hardware servers, Network architecture etc. for running Oracle Databases and Applications in Production environment.
• Upgraded all the instances from 9i to 10g and then to 11g.
• Used DataGaurd (Standby Database) for OLTP instances.
• Implemented the Real Application Cluster.
• Building and refreshing the materialized views.
• Schema Management using Sql*Navigator, DBStudio and DBArtsian.
• Creating and dropping users, allocating resources, creating and updating Schemas.
• Proper distribution of data to avoid fragmentation and routinely generate the Report for database health as manually Defragment data.
• Reorganizing the database at regular intervals to remove row migrations, fragmentation in the database using export and import utilities.
• Complete responsibility and control for writing DDL, DML and security of databases.
• Decided and Implemented table and Index Partitioning of major Tables for better performance, handling and management of data.
• Configured Listener for external procedure.
• Tuned the System Global Area (SGA) components dynamically according to the requirement after observing different Hit Ratios, caching of small tables in the Database Buffer Cache, keeping the mostly used and huge packages in the Shared Pool.
• Implemented Partitioning on huge tables to improve the performance and reduce the maintenance to finite window operation.
• Configured, Optimized and monitor Rollback Segments for OLTP system and Batch processes.
• Checking and monitoring initialization parameters based on database performance and creating and monitoring scripts for automating daily tasks.
• Developing backup and restore procedures using RMAN with recovery catalog, configuring and managing Flash recovery areas on remote sites.
• Validating and testing daily backups and coordinating with the customers during maintenance activities and system reboots.
• Monitoring disk space and database space usage to ensure proper functioning of production databases.
• Cloning the database and the database refresh of the TTD environments with the production databases.

Environment: Oracle 9i/10g/11g, Oracle 10g Real Application Clusters, Oracle Designer2000, Oracle Data guard, SQL*Loader, RMAN, PL/SQL, HP-UX, Linux, Windows NT, Windows 2000.