SUMMARY

• Oracle certified professional with 13 years of IT and 10 years of progressive hands - on technical experience in managing mission-critical Oracle databases on various flavors of UNIX, Solaris and Windows NT.
• Experience in Oracle Installation, Database configuration and Administration, Backup and Recovery, Database Migrations, Standby database setup, and troubleshooting of issues in various Oracle Products/versions working on several OS platforms.
• Excellent experience with Oracle Real Application Cluster 11gR2 and 10gR2 with ASM, Oracle 9i/10g R1,R2/11g R1,R2 on heterogeneous operating systems including Sun Solaris, HP-UX, IBM-AIX,Windows, and Red Hat Linux.
• Experience in Installation, Configuration, Migration and upgrading (patches) Oracle databases.
• Experience in upgrading Oracle Databases from 9i to 10g and from 10g to 11g by applying Patches.
• Expert experience in Monitoring Oracle Databases using Oracle Enterprise Manager, Grid Control, TOAD, SQL Navigator, SQL Developer and Experience in Backup & Recovery with RMAN, Flash copy Backup, Veritas Net Backup.
• Experience in installing Oracle 10g Grid Control.
• Experience in Data Loading using External Tables and SQL*Loader.
• Experience in Capacity planning and experience in refreshing data from Production to Development databases, Test databases and Reorganization of Databases using Export/Import, Experience in Data Pump.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Worked on 3 nodes Linux RAC with ASM.
• Excellent experience in Performance tuning of oracle databases using AWR, ADDM and ASH, Tuning of SQL scripts by using Explain Plan, and Hints.
• Experience with Dataguard environment, Physical Standby Databases, and Logical Standby Databases.
• Created and configured a Physical Standby database to meet Disaster Recovery situations.
• Experience in Database design including creation, modification, and deletions of table spaces, data-files, rollback segments and schema's, Create Schema (Tables, Indexes, views, sequences, synonyms, users and roles).
• Experience in using 11g and 10g features like Flash-Back Recovery / Fast Recovery Area.
• Experience in RMAN database backup, Recovery, DATABASE CLONING using RMAN.
• Managing Database Structures, Storage allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Experience in configuring & supporting Gloden Gate replication tool.
• Worked on different types of storage structures (SAN/NAS).
• Experience on Unix Shell Scripting for automating teh DBA tasks.
• TEMPEffective and efficient team player with excellent interpersonal skills, analytical & problem solving skills.
• Good Knowledge of SQL Server.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, HP-UX, AIX, UNIX (Sun Solaris 8, 9,10/HP-UX 10.x,11.x/IBM AIX 5.1,5.2,5.3,6.1), RHEL 3.x, 4.x,5.x, Windows NT/2000/2003

Databases: Oracle 11g R2/R1,Oracle10g R2 /R1, Oracle 9i and Oracle RAC 10g / 11g

Oracle Database Tools: SQL*Loader, OEM and Secure CRT

Tools: & Utilities: RMAN, TOAD, SQL* Loader, SQL Developer, Import/Export, Data Pump, SQL* Plus, ASM, Oracle Enterprise Manager and SQL Navigator.

Languages: SQL and PL/SQL

Replication: GlodenGate, Shareplex

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr.Oracle Database Administrator

Environment: ORACLE 11g, 11g R2 RAC, OEM, GRID CONTROL, MDHA, Data guard, Sun Solaris, Linux, AIX, HP-Unix, RMAN and Data Pump.

Responsibilities:

• Supporting 24x7 production support environment.
• Administering database High Availability solutions like Multi datacenter high availability (MDHA) Real Application Clusters (RAC) and standby databases, as per defined standards. Maintaining teh environment to ensure high availability.
• Upgrading databases from 11g R1 to 11g R2.
• Applying Oracle interim and CPU patches, coordinating with application teams and System Administrators when applying OS patches.
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues.
• Resolving end user tickets opened using Service one.
• Monitoring backups using RMAN and performing recovery whenever needed.
• Performance tuning using AWR, ASH and ADDM.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Experience in monitoring and tuning system resources associated with teh database performance, hit ratios, I/O, lock and latch contention.
• Identifying problematic code, creation of indexes, re-writing queries as per teh requests using and optimized path, creation of materialized views, etc.
• Direct and/or assist in root cause analysis of performance defects
• Performing Backup/Recovery of Oracle databases.
• Setup of teh database environments for teh Dev and QA teams.
• Performed database cloning to setup test and development database.
• As a part of Database Performance tuning, used AWR report to check teh waits and as a part of application tuning, checked V$SQL and found SQL scripts which have more resource consumption and tuned teh scripts for better performance by using Explain plan and Hints.
• Reorganizing Tables and Indexes for improving performance.
• Performed Table Partitioning, created index organized tables.
• Data migration using Data pump and by using RMAN.
• Testing of Backup’s and Documenting backup strategies.
• Applying application schema changes in Production, Development, Performance and QA environments.
• Refreshing Development, Performance and QC environments as per application team requirement.
• Security management using privileges, profiles and roles.
• Writing new shell scripts and modifying existing shell scripts.
• Managing and administrating Oracle Data Guard.
• Participate in release activities (LTO readiness, Peak) right from teh initial plan reviews till teh implementation. Teh major release activities.
• Handling day-to-day activities

Confidential, Atlanta, GA

Oracle Database Administrator / Database Analyst

Environment: ORACLE 10g, 11g, 11g RAC, OEM, GRID CONTROL, Glodengate, Data guard, Sun Solaris, Linux, AIX, HP-Unix, RMAN and Data Pump.

Responsibilities:

• Supporting 24x7 production support environment.
• Designing, Implementing and administering database High Availability solutions like Real Application Clusters (RAC) and standby databases, as per defined standards. Maintaining teh environment to ensure high availability.
• Configuring and administering teh Gloden Gate replication tool for real-time data replication. Managing teh configuration and data changes in between Bothell and Windward data centers.
• Upgrading databases from 10g to 11g R1.
• Installing and administrating 11g R1 RAC databases.
• Applying Oracle interim and CPU patches, coordinating with application teams and System Administrators when applying OS patches.
• Initiated 10g,11g new features implementation such as Automatic Storage Management (ASM)
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues.
• Resolving end user tickets opened using WebTrax.
• Implemented database level performance tuning using AWR, ASH and ADDM.
• Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Identifying problematic code, creation of indexes, re-writing queries as per teh requests using and optimized path, creation of materialized views, etc.
• As a part of Database Performance tuning, used AWR report to check teh waits and as a part of application tuning, checked V$SQL and found SQL scripts which have more resource consumption and tuned teh scripts for better performance by using Explain plan and Hints.
• Performed Table Partitioning, created index organized tables.
• Data migration using Data pump and by using RMAN
• Implemented High availability using GlodenGate Replication. Implanted Bi-directional replication using gloden gate.
• Applying application schema changes in Production, Development, Performance and QC environments.
• Refreshing Development, Performance and QC environments as per application team requirement.
• Security management using privileges, profiles and roles.
• Writing new shell scripts and modifying existing shell scripts.
• Database cloning using cold, hot backups and RMAN
• Monitoring backups using RMAN and performing recovery whenever needed.
• Creating and Managing Data Guard sites.
• Setting up and configuring Backup and Recovery solutions for teh production databases, as per ATT defined standards and processes. And monitoring teh successful completion of teh backups on a daily & weekly basis.
• Participate in release activities right from teh initial plan reviews till teh implementation. Teh major release activities.

Confidential, Nextel, KS

Sr. Oracle Database Administrator

Environment: ORACLE 10g, 10g RAC, Oracle 9i, OEM, GRID CONTROL, Shareplex, GlodenGate, Data guard, RMAN, Data Pump and export & import, Sun Solaris, Linux and AIX.

Responsibilities:

• Installation and configuration of Oracle 9i, Oracle 10g, servers and creation of databases in LINUX and SUN SOLARIS environments.
• Installing and configuring 10g Real Application Clusters (RAC). Troubleshooting performance problems.
• Monitor CPU usage, I/O contention, memory paging on UNIX server.
• Upgrading and Migration of databases from 9.2.0.8 to 10.2.0.4 and applying quarterly patches as per Confidential policy.
• Configured ASM for Oracle database files
• Configuring and administering teh GlodenGate (Unidirectional and Broadcast environments) & Shareplex replication tool for real-time data replication. Managing teh configuration changes in co-ordination with Amdocs.
• Experience in replication using GlodenGate.
• Replication and Extracting data and applying on production using GlodenGate.
• Monitoring Statspack, AWR, ADDM reports frequently for any long running queries and providing suggestions to application developers.
• SQL statement tuning using Explain plan, SQL trace using TKPROF utility and Autotrace utility.
• Responsible for all end to end technical activities starting from setting up daily monitoring, space requirements, backup and recovery strategies, migration, upgrade, estimation of space growth, user administration, job monitoring etc.
• Setting up and configuring Backup and Recovery solutions for teh production databases, as per Confidential defined standards and processes. And monitoring teh successful completion of teh backups on a daily basis.
• Monitoring backups using RMAN and performing recovery whenever needed.
• Managing Physical Standby databases.
• Table re-organization for faster performance using export/import and data pump.
• Resolving end user tickets opened using HP Open View.
• Contacting Oracle Support (Metalink) for database issues.
• Data migration using exp / imp and data pump.
• User management and space management (current and future).
• Security management using privileges, roles and SOX compliance procedures.
• Writing new shell scripts and modifying existing shell scripts.
• Work with Oracle technical support in case of any critical errors in teh database.
• Meeting teh P1/2 tickets resolution SLA as defined, for teh service tickets management. And focus on complete and accurate RCA for P1/2/3 outages.
• Authors and peer-reviews knowledgebase articles documenting fault root causes and their respective resolutions.
• Participate in major release activities right from teh initial plan reviews till teh implementation.

Confidential

Oracle Database Administrator

Environment: Oracle 9i, and Redhat EL4.

Responsibilities:

• Loading database tables using SQL*Loader.
• User management.
• Create database objects.
• Installing Oracle software and creating teh databases.
• Establishing and maintaining Database backup and recovery policies.
• Managing database storage.
• Implementing and maintaining database security.
• Trouble shooting of problems dat arise with teh oracle server and various development tools.
• Using teh utilities like Export, Import, and SQL Loader.
• Monitoring database and archive log backups.

Confidential

System Administrator

Environment: Windows NT/2000

Responsibilities:

• Supporting Windows 2000 Advanced server & Red hat Linux 9.0 operating systems
• Configuring I Mail Server for web mail, which enables all teh users of domains hosted by us utilize mailing facility
• Setting up and Configuring FTP servers and Terminal Access Servers to enable clients to upload data, files and remote administration
• First level hardware support for Sun Sparc Enterprise Server, Desktops, printers and connectivity devices
• Supporting Solaris 2.6 operating system and configuring it for LAN clients
• Installation of Oracle 8.1.5 on Sun Sparc 2.6
• Installation and trouble-shooting FTP services to teh clients
• Configuring LAN Terminal Servers for connecting Dumb Terminals
• Providing Facility Management Services
• Taking back-ups, updating anti-virus signatures in clients
• Providing online halp for teh customer support engineers who are Confidential client site
• Leading a team of customer support engineers
• Maintaining all day-to-day activities, documentation for FM activities as per ISO standards
• Maintenance of Windows NT 4 server with Windows 98 clients, trouble-shooting iLinkNet and Outlook mail clients
• Maintenance of client infrastructure consisting 140 desktops, 70 printers, 3 servers, fiber optic backbone and Zyxel ISDN BRI model Router
• Maintaining Lotus Domino Server, Windows NT Server
• Trouble-shooting system peripherals, network setup.
• Handling Annual Maintenance Contracts, hardware trouble-shooting in Desktops, printers and other peripherals.

Confidential

Jr. Hardware & System Administrator

Environment: Windows 98 / 2K

Responsibilities:

• First level hardware support for Desktops, printers and connectivity devices.
• Supporting Windows operating system and configuring it for LAN clients.
• Installation and trouble-shooting Hardware devices to teh clients.
• Configuring LAN Terminal Servers for connecting Dumb Terminals.
• Updating anti-virus signatures in clients.
• Maintaining all day-to-day activities, Maintenance of Windows 98 clients, Trouble-shooting Outlook mail clients.
• Trouble-shooting system peripherals, network setup.
• Handling Annual Maintenance Contracts, hardware trouble-shooting in Desktops, printers and other peripherals.