SUMMARY

• Over 7 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c. Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
• Implementation of high availability solutions with Oracle 10g, 11g&12c RAC, Standby Database Data Guard.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.
• Created 12c multitenant container database using DBCA
• Configured non - pluggable 12c database into pluggable container database.
• Applied various patch sets released through critical patch updates.
• Experience in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Upgrade/Migration of Databases from Oracle 10g to 11g as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from windows to Linux.
• Skilled in dealing with RAIDs on local server (Via RAID card BIOS) in ASM environment such as installation, taking backup, migration of database from Non - ASM to ASM environment.
• Experience in Upgrading databases and applied patch sets to multiple databases.
• Expertise in Database Space Management, Expertise in troubleshooting and performance tuning.
• Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Experience in using OEM, TOAD, Data Migrations using export/import.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH.
• Experience on working with data guard physical standby databases.
• Extensive performance tuning experience, specializing in tuning, Oracle9i and 10g RAC tuning, Load balancing.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup.
• Experience with mid-tier architectures, OEM, TOAD, Oracle grid-control.
• Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows Advanced Servers 2000/2003.

Databases: Oracle 10g, 11g and 12c

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools: & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN.

Languages: C, C++, JAVA, Unix shell scripts, PL/SQL

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential - Germantown, MD

Oracle Database Administrator

Responsibilities:

• Support HA and DR strategies for the Oracle database environment
• Support database replication technologies (e.g., GoldenGate, Dataguard)
• Perform Oracle software/database Installation and Upgrades
• Implement and Maintain proactive and real time monitoring tools (including but not limited to OEM)
• Perform backup and recovery activities using RMAN and other tools as required
• Perform performance tuning of the database and applications
• Support upgrades and patch management of Oracle environment
• Support on-call maintenance activities and participate in rotating on-call coverage
• Monitor and manage database utilization and performance and tune as appropriate
• Support O&M activities such as security, reporting, testing, troubleshooting application performance issues, and technical documentation
• Support Oracle System Administration activities such as user and system profiles, and creating user roles and responsibilities
• Serve as a database feature subject matter expert to the application teams

Environment: Windows, RHEL, Oracle 11g, Oracle 12c, Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Confidential - Columbia, MD

Oracle Database Administrator

Responsibilities:

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Export and Import of database objects to copy from one database to another database.
• Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
• Perform database monitoring and tuning to ensure databases run Confidential peak performance; troubleshooting production performance issues.
• Used tracing, ASH, AWR, ADDM, Explain plan and SQL tuning advisor to tune reports and jobs, from hours to minutes.
• Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).
• Investigating suspicious database activity using Auditing.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Environment: Oracle 10.1.0.4/10.2.0.4/11 gR2/12c, RHEL 5 and 6, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting,, TOAD.

Confidential -Waukesha, WI

Oracle Production Support Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential -Chicago, IL

Junior Oracle DBA

Responsibilities:

• Review of Database logical and Physical design
• Install, upgrade and maintain Oracle 10g, 11g on Sun Solaris and Windows 2003, Redhat4
• Installation, setup and configuration of DATA GUARD
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Implementing Database Security, Management of role-based security
• Applying Patches 10.2.0.4 and applying Oracle DST Patches on Oracle database
• Cloning databases using scripts as well as RMAN
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• 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
• Performed scheduling Control-m for scheduling jobs

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK