SUMMARY

• A talented, accomplished IT professional with over 6 years of IT experience working as an Oracle Database Administrator, specialized in creating database architectures for the most powerful and complex systems.
• A competent professional with 6+ years of IT experience as a Database Administrator & Data Analyst.
• Experience in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
• Experience in administering application schemas and end users by creating and assigning proper profiles and roles to maintain the security.
• Planned and implemented DR & high availability solutions using Standby Database and Oracle Data Guard methodology.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Experienced in using 11g features Data Pump, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Hands on experience in SQL, PL/SQL, OLAP, Logical and Physical Database Design.
• Delivered SQL and Database performance tuning services via V$/GV$ views, AWR reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps for 11g.
• Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive and ASM.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, Cloning, Capacity Planning, script development and documentation.
• Experience in upgrading the oracle database from10g to 11g.
• TEMPHas a good exposure of SQL Server, Report Generation.
• Experience in end - to-end implementation of the SDLC, including finalization of specifications, design, development, implementation, quality of Products.
• Reviewing the functional specifications and Requirements documents.
• Experience on high volume databases with sizes varying from 100GB to TBs of data.
• Experience with Performance Tuning - proactive and reactive for optimal performance to meet Business SLA*s.
• Experience in high volume transaction environments.
• Experience in supporting multiple production databases concurrently running different applications.
• Expertise in creation and implementation of Backup and Recovery methods and disaster recovery methodsusing RMAN, logical, hot backups, Flashback Recovery and Block Media Recovery methods.
• Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.
• Experience in handling Log sync issues between primary and standby databases in Data Guard.
• Created and modified Database objects likeTables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored ProceduresandPackages.
• Interface with Oracle Corporation for technical support.
• Efficient at using ASP.NET, C#, Html, JavaScript.
• Ability to work in a team and as an individual. Possess strong communication and interpersonal skills.
• Excellent analytical and problem solving skills with understanding of project management.
• Participated in 24*7 on-call rotation, off-hour production problem resolution activities
• Enthusiasm in learning new technologies.

TECHNICAL SKILLS:

Languages: C# 2.0, SQL, PL/SQL, SQL*PLUS, MSSQL

Web Technologies: ASP.NET, HTML, JavaScript.

Databases: SQL Server 2005/2008, Oracle 11g

IDE: MS Visual Studio 2005/2008

Operating Systems: AIX 6.1, UNIX, Windows 2005/2003/7/ XP

Packages/Utilities: Export/Import, STATSPACK, 11g RAC, Partitioning, ASMRMAN, EXPDP/IMPDP, DBCA11g Data Pump, Oracle Enterprise Manager (OEM) 11g, AWR / ADDM / ASH

Tools: Oracle Performance Pack OEM, TOAD, Putty, SQL*PLUSOracle Diagnostic Pack, Data pump API, SQL Trace and SQL tuning Advisory

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, Georgia

Environment:Oracle 11g databases, 11g Data Guard, RMAN, Export/ImportSQL*Loader, SQL Server, DBCA, TOAD, OEM.

Roles & Responsibilities:

• Installation of Oracle RDBMS server software and version upgrades.
• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Installation and configuration of release 11g R2 RAC with ASM and Raw Devices.
• Installed, configured, administered multiple 4+ node RAC clusters in DEV, QA regions and administered 5 node Production RAC Cluster.
• Experience in adding/removing nodes to and from the RAC Cluster and reconfiguring the cluster.
• Monitoring the services in RAC Clusters
• Applying Patch Set on the RAC Clusters
• Performing Backup/Recovery of all the Oracle databases using RMAN
• Preparation of design specifications document.
• Involved in designing the database, identification of the objects and creating tables.
• Designed and created database objects such as Tables, Views and Indexes.
• Writing DDL, DML and complex queries in SQL.
• Reading Alert Logs and User trace Files and Diagnosing the Problem
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non Production environment, Creation Duplicate Databases using RMAN Backups.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecksusingSQLTRACE, AWR, and ADDM.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.
• Importing data from flat files into database using SQL loader and External Tables.
• Supported production, development and testing databases with database ranging from 2TB to 16TB.

Advisory Services Portal

Confidential, Phoenix

Environment:Oracle 11g databases, 11g Data Guard, 11g RAC, Export/ImportSQL*Loader, SQL Server, OEM, DB2.

Roles & Responsibilities:

• Configured Data Guard to provide high availability by implementing Physical standby database.
• Responsible for providing 24x7 supports for prod and non-prod Oracle databases.
• Managed databases running on 4 node 11g RAC.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• PL/SQL, Performance Tuning and Monitoring.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Recovered databases using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM and SQL Trace for database performance statistics.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Used external tables and SQL*Loader to import data from flat files.
• Performed version upgrades and patch installs.
• Experience in configuring and administering databases with OEM Grid Control.
• Provided technical resolution to Oracle database related problems.
• Developed and maintained database standards and conventions; analyze impact of data change.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance issues.
• Experience in working with Oracle Architecture, I/O tuning, Memory tuning, Capacity planning, space management, Performance tuning and optimization.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Applying RDBMS patches, security patches, proactive monitoring of databases.
• Strict adherence to policies and procedures - specifically in regard to change management and project management.
• Perform database administration tasks as part of a scheduled change management task.
• Proficient in communicating directly with internal resources on a daily basis.

Confidential

Power Plant Engineers

Environment: ECC 6.0 with EHP4, AIX 6.1, Oracle 11g, SQL, PL/SQL, EXPDP/IMPDP, OEM, RMAN, BRTOOLS.

Roles & Responsibilities:

• Installing the Oracle 11g. Database Performance tuning, including query tuning & optimization.
• Creation of the Roles & Profiles for all the end users as per Authorization Matrix.
• Implementedbackupandrecoveryprocedures(Cold/Hot backups, RMAN Incremental backups)
• ConfiguringData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• Create Production Support databases for testing every Week for developers usingData pumpIMPDP from Production Backups.
• Perform Daily Backup Routine task.
• Transport of all Customizing & Workbench Requests in Quality & Production Environments.
• Applying Background Jobs.
• Supporting SAP Security operations: on-going Security maintenance (jobs, roles& users), security incident management.
• Expertise in Oracle Database Administration & able to perform database activities like space management, Instance management & SAP Table Reorganization.
• Performed system Restore & Recovery of online & offline backups via BRTOOLS.
• Responsible for all kind of support activities.
• Perform support activities like Daily Health Checks, User administration, Spool administration, Profile Maintenance, Job Scheduling, Backup Management.

Disaster Recovery Server Implementation

Confidential

Environment: ECC 6.0 with EHP4, BI 7.01, XI 7.11, EP 7.01, AIX 6.1, Oracle 11g

Roles & Responsibilities:

• File System Backup of Primary Servers.
• Restore of Backup in DR Servers.
• Configuration changes as per Oracle Data guard.
• System Check after DR synchronization.
• Daily Monitoring of DR servers.
• Manage user accounts and access privileges
• Conduct regular performance tuning of all SAP Systems.
• Identify long running jobs & queries causing lot of overhead.
• Planning & performing Database Backup.
• Expertise in using profile Generator (PFCG) for creation & maintenance of Roles/Activity groups according to the Business Requirements & using SAP Supplied User Role template.
• Actively participated in defining, Configuring & maintaining the Transport Management System (TMS) env.
• Eliminating the Deadlock Situation
• Security support for integration testing, user acceptance testing & training efforts.
• Participate in 24*7 “on-call” support rotation for oracle database systems in Production Environment.

Fund Management Implementatio

Confidential

Environment: ECC 6.0 with EHP4, AIX 6.1, Oracle 11g, SQL, PL/SQL, EXPDP/IMPDP, OEM, RMAN

Roles & Responsibilities:

• Creating a new Client in our ECC Development system for initial Testing as required by the Functional Team.
• Apply the OSS Notes.
• Creating the SAP Users & Roles according to Authorization Matrix.
• Performed the Request transports.
• Register objects at Service Market Place.
• Database Performance Tuning.
• Backup and Recovery of Database.
• Perform Database Activities like Space management, Instance management & SAP Table Reorganization.
• Planning & Monitoring the Database Backup during heavy users access (Load Balancing).
• Involved in all aspects of Client Management -Creating, Deleting & Copying Clients.
• Participate in various Auditing Activities to ensure dat Governance compliance is as per the company policy.
• Production Basis Support in 24x7 multi-instance NW Systems: ECC 6.0 with EHP4.

Power grid Co-operation

Confidential

Environment:Asp.net, C#, SQL, SQL*PLUS, Oracle11g, RAC, OLTP, Windows2000, AWR, TOADRoles

Responsibilities:

• Worked on Windows and Oracle platforms
• Managed User access
• Altering, creating the access of the existing and new user.
• Create and Administrate user accounts.
• Perform backup and recovery of a database
• Monitor, Troubleshoot and maintain a database
• Monitoring & managing Tablespace using segment space management tool.
• Creating and managing database objects, index, users, roles, privileges, profiles.
• Monitoring index and rebuild index.
• Experience in Backup and Recovery used physical backup (hot & cold) and logical backup using Export/Import.
• Setting up RMAN backups and maintaining catalog schema
• Performance Monitoring/Tuning and Database Security for Databases.
• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Installed Oracle 10g on Production DB Servers, applied Opatch to fix the non bugs.
• Involved in System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Experienced with Data Guard implementation and Point in time Recovery.
• Importing data from flat files into database using SQL loader and External Tables.
• Provide after-hours support during critical activities such as month end closing/opening procedures.

hicle Tracking System

Confidential

Environment:Asp.Net, C#, Google Map API, XML, CSS, JavaScript, Oracle10g/11g, PL/SQLRoles

Responsibilities:

• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Refresh/Cloning of Database for development and testing purpose
• Standby Database (Data Guard) setup and configuration.
• Working with programmers at early design stage to choose right data model relationships, creating required indexes and materialized views.
• Involved in Upgrade/Migration of the oracle databases.
• MigratedDatabasefrom Oracle 10g to 11g R1 RAC to achieve high availability of production database.
• Implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Performing monitoring and performance tuning
• Defining and Setting backup and recovery procedures.
• Managing, troubleshooting and resolving oracle database issues.
• Enabling and analyzing trace files for any errors occurred while database runtime.
• Performing monitoring and performance tuning using different tools like AWR, SQL trace.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Responsible for continuous database monitoring and reorganization for ensuring performance.

Account Management System

Confidential

Environment:Asp.Net, C#, CSS, JavaScript, Oracle10g, UNIX, TOAD, SQL*Loader, AWR, ADDM.

Roles & Responsibilities:

• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Preparation of design specifications document.
• Designed and created database objects such as Tables, Views and Indexes.
• Involved in designing the database, identification of the objects and creating tables.
• Tested and corrected errors and refined changes to data base.
• Implementing Database Security, Management of role-based security.
• Bug’s resolution, resolution of simple product problems.
• Development and modification of reports like Order Reports ( Report Designer)
• Maintain and resolve various database issues.
• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Handling day to day activities along with schema and space management.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc)
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloning databases using scripts as well as HOTBACKUP