SUMMARY:

• Over 7 years of experience as anOracle Database Administratorhaving hands on experience indatabase installation, administration, configuration, production support, performance tuning, backup and recovery, space management, database security, cloning and migration.
• Extensive knowledge on database administration forOracle 8i, 9i, 10g & 11g with experience withinvery large scaledatabase environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.
• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (10g RAC/11g RAC)
• Experience in designing and configuring high-availability systems using physical standby (Active DataGuard).
• Expertise in setting up Data Guard Fail-Over|Switch-Over|Read-Only scenarios
• Experience in Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Fabricated multiple CLONING databases using manual method and RMAN utility.
• Created development, testing, staging, production, RACand standby databases for OLTP, DSS and Data Warehousing.
• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL
• Performed FLASHBACK features to handle efficient database recovery.
• Qualified at writing SHELL Scripts
• Experience in using RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard.
• Experience Auditing and Database Security.
• Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
• Having hands on experience in Hot/Cold Backup, Recovery, RMAN backup and recovery
• Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic shared memory management (ASMM), ASH and Buffer Cache Advisors.
• Hands on experience in Performance Tuning and Memory (SGA) Tuning
• Gathered database/Objects statistics
• Performance monitoring and tuning using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, Pinning objects.
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Monitoring & Reorganizing Tablespaces/Tables/Indexes.
• Skilled in using tools such as SQL Developer and TOAD.
• Experienced in converting Business Requirements to Technical Specifications.
• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

TECHNICAL SKILLS:

RDBMS: Oracle 8i/9i/10g RAC/11g RAC, MS Access, SQL Server Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3,6.1,7.1, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP. Languages: C, C++, Java, PL/SQL, SQL,HTML Utilities & Tools: Oracle Enterprise Manager/GridControl, SQL Trace, 10g&11g RAC, Oracle Streams,Oracle GoldenGate, Oracle Scheduler, SQL Developer, Putty, RAID Systems, isqlplus, DBCA, DBUA, Oracle Data Guard, RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, DBLINK, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, ASH, AWR, and ADDM. High Availability: Real Application Clusters (RAC), Oracle Golden Gate, Oracle Streams, Cloning, Active Data Guard, SQL*Loader, RMAN, Export/Import, Data pump

EDUCATION: Bachelor of technology, Computer Science & Engineering

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH Aug 10- Till Date Oracle DBA Responsibilities:

• 24x7 production database and applications support
• Installation, configuration and maintenance of Oracle 10g and 11g databases.
• Implementation multi node RAC on Oracle 10g and Oracle 11g.
• Involved in Installing, Configuring, Administration and tuning ofOracle 10g RAC/11g RAC.
• Upgraded Oracle databases from 9i to 10g / 10g to 11g.
• Migrated databases from Sun Solaris to IBM AIX
• Backup and Recovery of OCR/ Voting disk, Checking the validity and existing dump of OCR files
• Managing services on multiple nodes using srvctl.
• Involved in the implementation of Oracle 10g/11g Data Guard on physical standby databases
• Defining and implementing database monitoring controls, executing SOX related controls.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index 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.
• Performed SQL and PL/SQL tuning, monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Involved in PL/SQL and UNIX shell scripting and automating them using Cron Utility.
• Cloning databases using scripts as well as RMAN for test and development.
• 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.
• Installation and configuration of GoldenGate for Replication.
• Involved in Capacity Planning for databases based on the future business growth requirements.
• Partitioned large tables to get the better performance and manageability.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
• Worked on import/export, Data Pump and SQL- loader.
• Working with Oracle Support for resolving the database related unresolved issues.

Environment: Oracle 9i/10g/11g, RMAN, RAC, RMAN, ASM, OEM, DATAGUARD, DATAPUMP, GoldenGate 11x, TOAD, SQL, PL/SQL, AIX, HP-UX, Solaris, RedHat Linux.

Confidential, Charlotte, NC Dec 08 - Jul 10 Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Provided primary administrative support for Oracle9i/10g/11g databases in LINUX/UNIX and Windows environments.
• Installation, Configuration and administration of 10g/11g RAC environment.
• Involved in Migration of Databases from AIX to Linux using RMAN and Oracle transportable tablespace (TTS).
• Creating Test and Dev instances as required using RMAN and Scripts.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Performed logical backup using export/import and data pump utilities.
• Wrote UNIX shell script to perform backup and schedule it with Crontab.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Optimize SQL queries for better performance.
• Carried out Optimizing performance and Query tuning using Statspack, Tkprof, and OEM.
• Use Explain Plan for monitoring the query execution.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Installation and configuration of Oracle Client software and Tools.

Environment: Oracle 9i, 10g RAC,11g RAC, OEM/Oracle Grid control, HP-UX, AIX, RedHat Linux, DATAGUARD, PL/SQL, Data Pump, RMAN, ASM, ERWIN, TOAD and SQL *Plus.

Confidential, Richfield, MN Oct 07- Nov 08 Oracle DBA

Responsibilities:

• Installation of Oracle Database Software 9i/10g.
• Worked with other DBA's for Capacity planning of new Databases. Data replication between different Oracle databases using DBLinks.Setup test environment to simulate the migration process.
• Involved in Installing & Administering Oracle Real Application Cluster (RAC) 10g on ASM
• Convert database from Non RAC database to RAC database using RMAN and ASM.
• Implemented Oracle Uni-Directional Streams for a 10g database.
• Migration of Databases from Solaris to Linux.
• Upgraded from 9.2.0.7 to 10.1.0.2 database and installed patches for new Oracle software and doing TAR support.
• Export/Import (Data Pump) of data using batch method. Backup and disaster planning using User Managed/RMAN.Prepare approach and steps of migration which will be carried for OLTP and DWH databases of production data. Installed and generated Statspack report on each server for benchmarking the database statistics.
• Enhancement of the existing PL/SQL objects like Procedures, Functions, Packages, views, materialized views. Tuning & review of some bad performing PL/SQL codes and SQL's.Assisted in designing both physical and logical models for new databases.
• Responsible for database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention and application tuning.
• Created PL/SQL Packages to move / transform data from OLTP to DWH.Gathering statistics of data objects using Analyze and DBMS_STATS.Developed scripts to monitor the storage usage, object status for daily jobs. Database & Instance configuration using Grid control, ADDM, ASMM, etc.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature. Created snapshots for some most queried tables to get the most refreshed data. Planned and installed replication of database also.
• Involve in the database community meeting with the client to discuss the methodology and decide the strategy of migration. Preparation of database migration document. Effort estimation for Data migration for all the databases. Helped in preparation of Project plan for the Migration.

Environment: Oracle 9i/10g RAC, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, Streams, TOAD, SQL, PL/SQL, AIX, UNIX, HP-UX, Solaris.

Confidential, Hyderabad, India Apr 05 - Sep 07 Database Administrator

Responsibilities:

• Install / upgrade the Oracle databases and Oracle applications software & patches.
• Involved in Upgrading the database versions from 8i to 9i
• Backup and Recovery (using Cold Backups, hot backup, export/imports)
• VERITAS Net Backup 5.1 Backup & Media Management
• Restoration .Cloning the database and Recovery Drill
• Extensive knowledge of maintaining using Standby databases for high availability
• Managing a database development effort, monitoring multiple databases and tuning, database testing, verification and validation
• Basic SQL, monitoring system processes, setting up user privileges/passwords and all related activities
• Table spaces and rollback segments maintenance
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Worked on call for 24x7 production Databases in Data center.
• Maintenance of Oracle Databases on the Production Machines
• Maintaining archived data on tape
• Involved in setting up backups, database re-orgs, upgrades and monitoring of databases to identify performance issues.
• Performance monitoring / tuning.
• Tuning and monitoring multiple instances of Oracle on various platforms using Oracle Enterprise Manager.
• Design and Implement Backup & recovery procedures and ensure reliability of Database Backup and Recovery schemes
• Using export and Import utilities to take Logical backups
• Handling complete and incomplete recovery in case of database failure
• Performing database re-organization to get rid of fragmentation and also preventive maintenance
• Monitor database growth and size databases as required
• Monitor disk space usage, balance I/O load.
• Troubleshooting connectivity issues and network problems
• Monitoring alert logs, error trace, free spaces, file systems etc.
• Extensively worked on SQL* Loader to load data from other databases and text files into Oracle Database
• Writing Shell scripts for automating backup and monitoring for the database

Environment: Oracle 8i/9i/10g, Oracle Enterprise Manager, REDHAT LINUX, WINDOWS, PL/SQL, TOAD and SQL *Plus.