SUMMARY

• Over 7 years of IT experience with expertise in analysis, design, development, testing, migration & implementation, maintenance, administration for oracle databases
• Experience in Financial, Health and Telecom domains along with strong analytical problem - solving, organizational, communication, learning and team skills
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i to 9i and 9i to 10g and 10 to 11g applied oracle patches
• Installed Oracle 10g RAC and 11GR2 RAC software with ASM & OCFS2 File systems
• Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
• Created development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing environments.
• 24*7 production database support with Support to developers & end-users.
• Logical and physical modeling using Erwin.
• Have implemented ORACLE STREAMS for replication btw online and reporting databases.
• Implemented DATAGUARD on 2 node Rac for disaster recovery.
• Extensively worked in data center migration
• Good RMAN experience of Backup, Restore and Recovery in different scenarios and requirements using RMAN, Data pump and Flashback with different backup technologies TSM, SQL Backtrack and logical backups like export dumps.
• Extensive experience in Transformation, Loading Data into various Databases using Datastage, External Tables, Transportable Tablespaces.
• Performed Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, AWR reports
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance
• Good Knowledge in Golden Gate
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Performed User Account Management - Creating database Users, Schemas, Roles, Privileges, Password management, Connectivity issues related to Listener, tnsnames, ODBC.
• Have experience in setting up SQLServer2005, and have done backup, recovery and performance tuning. replication using snapshots, materialized views and advanced replication methods
• Extensive knowledge in reporting tools like Business Objects and crystal reports
• Strong understanding of business processes & interface with IT.
• Strong writing and documentation skills for the management, development and control of documentation and Involved in the end-user training

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Confidential, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11/g,10g/9i/8.x, SQLServer2005/08.

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.

SOFTWARE/APPLICATIONS/ TOOLS: ORACLE 8.x/9i/10g,OAS 10g Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters, VERITAS Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Upgraded database from 10 Gr2 to 11 GR2
• Applied PSU Patches
• Installed and configured Oracle 10g RAC and 11GR2 RAC software with ASM & OCFS2 File systems
• Performed and supported datacenter migration for multiple applications.
• Involved in DR plans and actively participated in Disaster recovery Tests.
• Implemented DATAGUARD on 2 node RAC and stand alone systems for disaster recovery.
• Experience in supporting databases on OS cluster (UNIX -HACMP).
• Coordinates with DNS team to configure SCAN IP’s
• Extensively used RMAN Backup & Restore for Database Migration
• Worked on Production Corruption issues of Databases using DBV, Backup Validate and Check Objects and fixed the issues.
• Involved in Regular DBA maintenance Jobs.
• Co-ordinate with development team & Migrating the data between production and the development database using Oracle utility data pump.
• Participated in Load testing and Analyzed AWR reports and implemented necessary changes.
• Performed Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning
• Currently involved in on-the-fly database support during database performance issues and outages.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using ADDM, AWR reports and Oracle Enterprise Manager.
• Performed the Auto setup of Oracle Recommended tools like RDA and OSW on Multiple Servers to monitor
• To resolve the issue with oracle support quickly provided crsd logs, cssd logs, RDA output and any trace files generated during that period at the time of creating Service Request

Environment: Solaris 5.X, Windows NT, Oracle11g R1/10g R2, 7x HP UX 10.2/11.X, Confidential AIX, RAC, AWR, ADDM, SQL trace, TKPROF, TOAD.

Confidential

DBA

Responsibilities:

• Installed Oracle 10gR2/11g R2 on 4 node Rac .on RHEL- 4.0 and AIX 6.1 with New SAN Storage.
• Opatch is used for Patched Oracle Database Server 9i,10g/11g.
• Upgraded databases from 10.2.0.4 to 10.2.0.5
• Upgraded database from 10.2.0.5 to 11.2.0.1/11.2.0.2.
• Configured Oracle Data Guard for 4 node RAC Primary and standby.
• Monitored Shareplex replication between 8i and 10g databases.
• Performed data center migration.
• On-Call Production support (24*7) for Oracle Production Databases on RAC and Non-RAC environments on RHEL 3.0 to 5.1, AIX, SUN SOLARIS-10.
• Installed oswatcher to monitor on RAC Systems
• Had good coordination with SA team provided specific values for few system parameters like file-descriptors and huge pages based on application requirements.
• Monitored and Tuned database to optimize the performance and satisfy the availability.
• Performance Tuning by using Oracle utilities like Explain Plan, Stats Pack, and for addressing performance bottlenecks is performed.
• Performed Backup & Recovery by using RMAN.
• Expertise in using Cloning, Tar-Untar, Relink concepts for Database Migrations.
• Monitored the Oracle streams for replication from online database to reporting database. taken Export and import of different databases using Oracle DATA PUMP Export / Import utilities
• Adopted general DBA tasks like Indexes, Partitioning, Flashback Utility etc
• Table fragmentation tuning, partitioning the large table by date.
• Used Materialized Views for Replication and synchronization data with other branches.
• Provided all kinds of DBA support to development teams as well as production support to various tasks.
• Trouble shooting and resolving any database and/or application issues or errors that occurred
• Developing shell scripts and using various tools monitored the various database activities. written UNIX shell Scripting like Korn & Perl for day - day activities for monitoring the database..
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Modified database structures including table spaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Developed scripts to monitor the storage usage, object status for daily jobs.

Environment: Oracle 10gR2, SAN, HP-UX 11.31, Linux AS 5, AIX 5.3, OEM (Grid Control), RMAN, SQL*Plus, PL/SQL, SQL*Loader, AWR, Explain Plan

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Setting up Oracle 10g databases on Solaris, Red hat Linux, installing Oracle Enterprise Manager on Workstation to monitor multiple Oracle instances.
• 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 Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Supported Migration of Databases using Golden Gate. Installed, configured Golden Gate and its Processes with File permission for Cross Platform Migration, Replication.
• Oracle Database Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g, 9i.
• Managed application development rollovers to production. Implemented data security using database roles and views.
• Continuous monitoring of Database Performances and identifying any bottlenecks hindering the performance of the database
• Database Fail over / Switch over activities for maintenance and time-to-time DR drills with Oracle9i/10g Data guard.
• Preparing OS Environment for Database, especially RAC environment doing thorough testing of all RAC nodes using FEMA guidelines at Server Level, Interconnect, Failover/load balance and Database level.
• 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, and Oracle Enterprise Manager.
• Create, maintain and refresh required Oracle instances/databases for development, test and production environments, install patches.
• Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation.
• Implement backup and recovery procedures using RMAN for Oracle databases and test regularly in conjunction with Operations.

Environment: Oracle 10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, OEM (Grid Control), RMAN, SQL*Plus, PL/SQL, SQL*Loader, AWR, Explain Plan

Confidential, Portland, OR

Oracle DBA

Responsibilities:

• Installed and configured 10g/9i on Sun Solaris.
• Supported production environment on 7/24 basis for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Used Flashback technologies-Flashback Table, Flashback Query & Flashback Database
• Extensive use of tools like TKPROF, Stats pack for tuning application and instances.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Design Evaluation and Analysis of data model.
• Effectively involved in pl/sql activities like wrote some stored procedures, functions and triggers.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Used hints for SQL tuning and optimization.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Involved in mapping and data resolution using the Meta Data Information of PLM and Data Mart.
• Performed tuning of Packages and Procedures using the Profiler utility.
• Monitored and tuned Java Applications. Involved in Java Memory management and Log analysis.
• Import and Export of Schema and databases across various stages of the project.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, Sun Solaris.

Confidential

Development Database Administrator

Responsibilities:

• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager
• Configured users into consumer groups and set the resource utilization based upon business activity using Resource Manager.
• Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
• Refreshed PROD, DEV, UAT databases using Data pump, RMAN, and Transportable Tablespaces etc.
• Administrated database regarding space related issues- monitoring Tablespaces, users’ security of data accessibility and Configuring Archive log destinations and Flash Recovery Area (FRA).
• Create Triggers and defined constraints to maintain the data integrity in the databases.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.
• Security Management that includes enrolling users and maintaining system security by controlling and monitoring user access to database.