SUMMARY:

• Enterprise DBA support utilising around 8+ years of Experience in Oracle Database Administrator, providing 24X7 production and development support 11g/10g/9i/8i databases on different platforms like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise
• Implement enterprise wide Database Development standards to eliminate time on Database tuning.
• Database Installation and maintenance.
• Installation of Oracle Databases 8i/9i/10g RAC/11g RAC.
• Data Guard setup with Primary and Standby Databases.
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
• Implementation of Grid Control.
• Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
• Configuration of RMAN Backup using VERITAS Net backup.
• Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Physical database design, Logical database desin, normalization, de-normalization
• Capacity planning and bench marking
• Database security and auditing
• Setup procedure for Database statistics gathering – Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Collections of performance data for specific time range using STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL Trace.
• Analysis of Database Wait Events.
• Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
• Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
• Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.
• Database trigger, stored procedure & packages PL/SQL coding.
• Multiple upgrades of Sun Solaris and Linux servers from 8i,9i to Oracle 10g, Oracle 10g to Oracle 11g.
• Excellent problem solving skills.
• Excellent written and verbal communication skills.
• Result oriented, self motivated, Team Player, Ability to work independently.

TECHNICAL SKILLS:

Databases : Oracle 11g RAC, 10g RAC, 9i, 8i, 7.x, MS SQL
Server 2005/2008
DBA : Oracle 11g, 10g, Oracle Enterprise Manager, TOAD
System Administration : Red Hat Linux, HP-UX, Sun-Solaris, IBM-AIX
Windows 95/98/ME/NT/2003/XP
Backend Scripting : SQL*Plus, PL/Sql, UNIX Shell Script, Perl Scripting.
Network and Connectivity : Windows TCP/IP, VPN Connectivity, Oracle TNS
Listener
Development Tool : Visual Studio, Visual C++, Windows/SDK, Visual
Basic
Oracle Tools : RMAN, OEM/Grid Control, SQL*Loader, SQL Server,
Oracle Warehouse Builder, SQL*Plus, DBCA, Import/Export,
Data Pump, Streams, Golden Gate
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR,
ADDM

EDUCATION: Bachelor of Engineering in Computer Science & Information Technology.

PROFESSIONAL EXPERIENCE:

Confidential IL Feb’11 to Present
Role: Oracle Database Administrator L3

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supporting Oracle 11g RAC/10g RAC/9i Databases
• Responsible for upgrade and migration of data from 9i to 10g, 9i,10g to 11g and applying patches whenever required.
• Installed and configured Oracle 11g RAC high availability, Standby Database 9Active DataGuard) for disaster recovery and reporting purpose.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Developing and Implementing Disaster Recovery (DR) Plan
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of production Database to the test environment using Recovery Manager (RMAN).
• Monitoring Enterprise Manager Alert Logs for taking corrective actions including table space sizing.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Export and Import of Database objects to copy from one Database to another Database as well as copy the export dump file to tape that can act as a backup.

Environment: Oracle Database Oracle 11g RAC/10g RAC/9i/8i, Sun Solaris, HP-UX, RHEL,

Confidential, Columbus, OH Apr’09 to Jan’11
Role: Oracle Database Administrator

Responsibilities:

• On call 24x7 production support
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Installation and configuration of Oracle 10g RAC, Oracle 11g RAC, Standby Databases for high availability, disaster recovery and reporting purpose.
• Responsible for upgrade and migration of data from 9g RAC to 10g RAC.
• Cron job to monitor the replication between primary and standby every 15mins.
• Monitoring Table spaces and extent Growth.

Configured Databases for online backups and manage the complete Database recovery.
Cloning of production Databases to the test environment using Recovery Manager (RMAN).
Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management.
Created Users, Roles and Managing Security & Concurrent Managers administration.

• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Optimize and Tune Database /Application. Provide solutions and enhancements for existing and new environments.
• Implement new technologies and upgrade existing Databases /Applications.
• Study existing system by application areas.
• Developing and Implementing Disaster Recovery (DR) Plan
• Writing UNIX shell scripts for backup and recovery, Import and export procedures
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Configured and maintained huge OLTP and Data warehouse databases .
• Database security and auditing
• Ensure high availability of Databases at all time.

Environment: Oracle 9i/10g RAC/11g RAC, Red Hat LINUX, Solaris 10, IBM AIX, HP-UX, Windows 2003, MS,SQL Server 2000/2005/2008, OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL

Confidential, FL Aug’07 to Apr’09
Role: Oracle Database Administrator

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Installation and configuration of Oracle 10g RAC, Oracle 11g RAC, Standby Databases for high availability, disaster recovery and reporting purpose.
• Responsible for upgrade and migration of data from 9g RAC to 10g RAC.
• Migration of Database from 9i to 10g and applying patches whenever required.
• Installed and configured Oracle 10g RAC high availability
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Developing and Implementing Disaster Recovery (DR) Plan
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of production Database to the test environment using Recovery Manager (RMAN).
• Monitoring Enterprise Manager Alert Logs for taking corrective actions including table space sizing.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Export and Import of Database objects to copy from one Database to another Database as well as copy the export dump file to tape that can act as a backup.

Environment: Oracle Database Oracle 11g RAC/10g RAC/9i/8i, Sun Solaris, HP-UX, RHEL,

Confidential, IO Feb’06 to July’07
Role: Database Administrator

Responsibilities:

• 24x7 Production Database administration, support and monitoring to ensure a proactive problem recognition and resolution of Database issues
• Installations of Oracle Databases and clients.
• Supported different Databases like Production Development Testing UAT and Training.
• Installation and configuration of Oracle 10g RAC, Standby Databases for high availability, disaster recovery and reporting purpose.
• Intensively involved in the area of installations of Oracle Software, Configuration for Database and day-to-day routine works for database administration.
• Identify each object with sizing criteria including large, medium and small.
• Sizing estimations and create appropriate table spaces.
• Create Import/Export scripts.
• dentify potential failures of Export/Import Jobs and resolution of the problem including resizing the table spaces.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Create Database users and roles and implement appropriate user security.
• Fixing Printer Issues, Setting Profile Options, Creating &Assigning Responsibilities.
• Implemented Database auditing, data security and Remediate high-risk violation in production environment.

Environment: Oracle 10g RAC/9i/8i/8.x.x, AIX, SUN SOLARIS, HP-UX, OEM, ASM,

Confidential Mar’05 to Jan’06
Role: Database Administrator

Responsibilities:

• Installation, configuration and upgrading of Oracle server software, related products and applying the patches for database.
• Implemented the Database tuning to improve the performance of the database using the Prestart package.
• Highly experienced in troubleshooting problem queries that take long.
• Application tuning using Hints, Explain Plan, SQL trace, TKPROF using SQL Navigator Expert Tuning, Index Tuning utility.
• Created and maintained a remote copy of the Production Database, using Standby Database to protect data against hardware failures.
• In order to protect data in the Production Database, implemented Standby Database and Synchronization of Standby Database with the primary database.
• Monitored and allocated share memory, table space as needed and managed replicated servers.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Implemented multiplexing of control files and redo-logs for disaster recovery scenario.

Environment: Oracle 8i/9i, AIX, SUN Solaris, SQL Server 2000, PL/SQL, UNIX Shell Scripting, RMAN, Toad, on HP-UX, Sun Solaris 2.x.

Confidential Dec ’02 to Jan ’05
Role: Oracle Developer/DBA

Responsibilities:

• Responsible for implementing and maintaining the system.
• Health Check of the Database and Performing Database backup as per schedule.
• Shell Scripting, Automation of clonig and backup
• PL/SQL programming, writing Packages, Procedures, Functions and Triggers.
• Space management, adding space to Database as per requirement.
• Taking backups
• Database monitoring
• Creating users, roles, granting privileges
• Creating tablespaces, tables, indexes, views, synonyms, materialized views
• Performance monitoring and tuning

Environment: Oracle 8i/9i, Sun Solaris, SQL Server 2000, PL/SQL, UNIX Shell Scripting