SUMMARY

• Over 5+ years of hands - on experience as an Oracle Database Administrator. I have complete life cycle knowledge including Installation. I have worked on different versions of Oracle release ranging from 9i, 10g, 11gR2 and familiar with 12c involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• 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.
• Expert in RMAN backups including full, incremental and cumulative
• Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes. implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard
• Extended Cluster setup with RAC 11GR2
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Database integrity and advanced security implementations.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases
• Experienced in automating jobs using shell, pl - sql scripting.
• Use BMC remedy tool to resolve critical, high and low tickets
• Deep understanding of technology with focus on delivering business solutions.
• Ability to learn and adapt to new Technologies quickly.
• Excellent communication skills

TECHNICAL SKILLS

Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. .Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, NX client, Winscp

PROFESSIONAL EXPERIENCE

Confidential, MD

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.
• Monitored database (RAC and STANDBY) and SQL performance, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• 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.