SUMMARY

• An experienced Oracle Database Administrator with an outstanding record of implementing database services geared at optimizing RDBMS functionality and productivity across diverse environments.
• Over 5 years experience in Oracle database administration in a heterogeneous system environment including Solaris, UNIX, Linux and Windows supporting a variety of mission critical applications with Oracle 10g and 11g databases.
• Expertise in Oracle Database Administration.
• Expertise in Installing, Configuring and Upgradation of Oracle Databases from 10g to 11g across cross platform.
• Expertise in implementing new database features, and proactive monitoring of the databases using various shell scripts.
• Performance Tuning using ADDM,AWR,ASH, Oracle 10g/11g
• Hands on experience in hot/cold backup, recovery and cloning of databases using RMAN.
• Experience in data guard high availability.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Database integrity and advanced security implementations.
• Experienced in automating jobs using shell, pl - sql scripting.
• Deep understanding of technology with focus on delivering business solutions.
• Ability to learn and adapt to new Technologies quickly.
• Excellent communication skills

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, SQL Server 2005, 2008, Teradata, Informix, DB2, Mainframe Operating Systems Red Hat Linux, Sun Solaris and Windows.

Languages: SQL, PL/SQL

Utilities: RMAN, Oracle 10g Grid Control, Data Guard, SQL*Loader, EXP, IMP, Datapump, SQL developer.

Tools: EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, Toad, Pl/Sql, OEM 11g, Developer, ERWIN, putty.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Migrated and upgraded Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump.
• Upgraded Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching.
• Configured Physical Standby databases using data guard and converted Physical standby to Snapshot Standby and active data-guard depend on Business Requirement.
• Proactively monitor and identify areas that need to be improved in the application and database using Stats pack, AWR, ASH, ADDM and OEM Grid Monitoring.
• Restored and recovered database at the times of occurrence of critical failures.
• Implemented Oracle database backup & recovery solutions using RMAN
• Enforce security administration and system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems.
• Schedule Oracle jobs using CRONTAB.
• Cloning of production databases as needed for testing, development using RMAN, user managed and Grid Control.
• Data Refresh from Production to lower environments using RMAN Duplicate Database.
• Configured and Installed Oracle-Wallet-Management (OWM) for data security.
• Daily health check up of the database and SQL Queries using AWR, ADDM and TKPROF and Tuned the SQL's using TKPROF and STATSPACK reports.
• Alert log monitoring for critical databases every day in the production environment.
• Use BMC Remedy tool for all change management process.
• Generate AWR and ADDM reports for performance tuning and work closely with PL/SQL developers to tune TOP SQL running queries in databases.
• Apply various patches ( interim patches, patch sets, CPU, and PSU).
• Monitor system resource availability and respond to system memory and data issues.
• Monitor resource utilization from both database and O/S level making suggestions for upgrades for software and hardware (memory, CPU, disk) which resulted in higher overall system performance.
• On-Call 24x7 production DBA support.

Confidential

Oracle Database Administrator

Responsibilities:

• Deployment Team: Assess and validate Scripts, Working with Developers and Sys Admins.
• Wallet creation and Transparent Data Encryption Under 11g,
• Installation and maintenance of Oracle 11g/10g on Linux OS, Window OS
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Patching and Upgrades (CPU and PSU). Upgrade/Migration of oracle databases from 11.2.0.1 to 11.2.0.4.
• Applications and users support, maintaining a 0% down time
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN.
• Monitored database and SQL performance, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords resets and users account managment, network, etc).
• Handled daily production problems/change requests with Oracle.
• Monitoring of all Oracle Databases both Prod, Qa, Dv, Training using OEM Grid Control
• Tuning and Validating Backups and Monitoring All Database Backups.
• Handled daily production problems/service requests with Oracle.
• Performed daily database administration tasks: Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup as well as Logical backup (Export/Import).
• Installation and Configuration of new Database.