SUMMARY

• 11+ years of progressive experience in the field of Information Technology and 8+ Years in managing mission-critical Oracle databases.
• 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 8i/9i/10 g R1,R2/11 g 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.
• 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 Golden Gate replication tool.
• Experience on Unix Shell Scripting for automating the DBA tasks.
• Effective and efficient team player with excellent interpersonal skills, analytical & problem solving skills.

EDUCATION: Bachelor of Science

Technical Skills

Operating systems LINUX, SOLARIS, HP-UX, AIX, MS-DOS, NT, Windows 95/98/XP/7 and 2000

Databases Oracle 11gR2/R1,10gR2 /R1, 9i, RAC 10g, 11 g R1, 11 g R2.

Oracle Database Tools SQL*Loader, OEM and Secure CRT

Tools & Utilities RMAN, TOAD, SQL* Loader, SQL Developer, Import/Export, Data Pump, SQL* Plus, Data Guard, RAC.

Languages SQL and PL/SQL

Replication GoldenGate, Shareplex

Trainings: Oracle 11g Performance Tuning from Oracle University, Bangalore
Oracle Database 11g New Features for Administrators from Oracle University, Bangalore
Oracle Database 10g RAC for Administrators from Oracle University, Bangalore

Work Experience (In Reverse Chronological Order)

Company : Confidential Atlanta, GA
Role
Duration : 2011 March – till date
Environment : ORACLE 10g, 11g, 11g R2 RAC, OEM, GRID CONTROL, Goldengate, Data guard, Sun Solaris, Linux, AIX, HP-Unix, RMAN and Data Pump.

MRE & SAM (Marketing Rule Engine & Solicit Address Manager)
MRE is an AT&T Enterprise application based on the Convergys Dynamic Decisioning Solution (CDDS) product that centralizes Business Rules & Policies and evaluates them in real-time to take appropriate Actions as defined by Business. CDDS also has a Recommendations Engine that provides self-learning capabilities. The high performance in-memory database component allows decision making in real-time with sub-second response time.
The MRE rules engine uses over 270 customer attributes and Dynamic Discovery Questions (DDQ) to target offers with a high propensity of acceptance. This project involves application support DBA roles.

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 the environment to ensure high availability.
• Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between Bothell and Windward data centers.
• Upgrading databases from 10g to 11g.
• 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, ADDM and Statspack.
• Identifying problematic code, creation of indexes, re-writing queries as per the requests using and optimized path, creation of materialized views, etc.
• As a part of Database Performance tuning, used AWR report to check the waits and as a part of application tuning, checked V$SQL and found SQL scripts which have more resource consumption and tuned the 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
• 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.
• Managing Data Guard sites.
• Setting up and configuring Backup and Recovery solutions for the production databases, as per ATT defined standards and processes. And monitoring the successful completion of the backups on a daily & weekly basis.
• Participate in release activities right from the initial plan reviews till the implementation. The major release activities.

Company : Confidential KS
Role : Sr.Oracle Database Administrator
Duration : 2006 June – 2008 Sep (offshore)
Duration : 2008 Sep – 2011 Feb (on Site)
Environment : ORACLE 11g, 10g, 10g RAC, Oracle 9i, OEM, GRID CONTROL, Shareplex, GoldenGate, Data guard, RMAN, Data Pump and export & import, Sun Solaris, Linux and AIX.

Sprint Nextel, the third largest wireless carrier in United States providing various telecom services to more than 50 million customers. This project involves production support DBA and application support DBA roles.

Responsibilities

Installation and configuration of Oracle 9i, 10g, 11g 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 Sprint policy.
• Configured ASM for Oracle database files
• Configuring and administering the Golden Gate & shareplex replication tool for real-time data replication. Managing the configuration changes in co-ordination with Amdocs.
• Monitoring Statspack, AWR 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 the production databases, as per sprint defined standards and processes. And monitoring the successful completion of the 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 and roles.
• Writing new shell scripts and modifying existing shell scripts.
• Work with Oracle technical support in case of any critical errors in the database.
• Meeting the P1/2 tickets resolution SLA as defined, for the service tickets management. And focus on complete and accurate RCA for P1/2/3 outages.
• Participate in major release activities right from the initial plan reviews till the implementation.

Company : Confidential MALAYSIA
Role : Oracle Database Administrator
Duration : 2004 Feb – 2006 Feb
Environment : Oracle 9i, and Redhat EL4.

On line a collection is a tool, which is developed in java as a front end and oracle as aback end, which is used for the clients to collect the bills from the consumer’s. This system, developed to computerize the bill collection transactions in all collection centers of this distribution company. Along with transaction recording, this system distributes collection data to appropriate ‘Billing Server’ for further process and provides various levels of reports to various levels of authorities like center wise reports for collection centers, district wise collection reports for district level authorities etc and This system implemented at all collection centers that are fall under this distribution (TNB) company and is working fine at all centers.

Responsibilities

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

Company : Confidential Kuala Lumpur, Malaysia
Role : System Administrator
Duration : 2003 Jan – 2004 Jan
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 the 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 the clients
• Configuring LAN Terminal Servers for connecting Dumb Terminals
• Providing Facility Management Services
• Taking back-ups, updating anti-virus signatures in clients
• Providing online help for the customer support engineers who are at 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.

Company : Confidential

Role : Jr. Hardware & System Administrator

Duration : 2000 Sep – 2002 Dec
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 the 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.