SUMMARY:

• Skilled Cloud/Oracle DBA with 7 years of experience.
• SQL*Plus and Linux proficient, creating Database using DBCA or manually.
• Experienced in creating EC2 virtual servers on a cloud environment, datapump, cloning databasesupgrade and installing/patching Oracle software in a cloud environment.
• Installation and Administration of RHEL Linux/ Ubuntu.
• Bash Shell Scripting for task automation.
• RMAN backup, cloning and recovery of databases.
• Linux scripting with decision making trees to automate repetitive tasks such as backing up of databases, logging, data entry and notifying the DBA via email if errors occur.
• Database monitoring and extensive performance tuning.
• Experience in Dataguard implementation and maintenance: Both Physical & Logical standby.
• Experience in managing Oracle 11gR2 RAC environments .
• Taking care of issues reported using the JIRA ticketing system.
• Proficiency with Office Application Software.
• Problem solving, creative designing, analytical and troubleshooting skills, critical thinking and good communication skills.

TECHNICAL EXPERIENCE:

Languages: SQL*Plus, Linux Shell Scripting, PL/SQL, PHP, MySQL, HTML5, APACHE, CSS, XML, Java, JavaScript, Visual, C, C++.

Software: Putty, MobaXterm, SQL Developer, TOAD, Eclipse (Android Developer), NetBeans, JCreator, GitHub.

OS: LINUX - Red Hat Enterprise, Linux Ubuntu, MAC OS X, Windows - NT 2000, Windows 2003, Windows XP, Windows Vista, Windows 7.

PROFESSIONAL EXPERIENCE:

Oracle DBA Consultant

Confidential, Gaithersburg, MD

Responsibilities:

• Administering a 6.5 TB production environment with a three - node Real Application Cluster hosting Oracle 12C (12.1.0.2) on Red Hat Linux (RHEL 6.5) operating system with Weblogic servers as the application servers.
• Administering a 600GB development database environment on single instance servers hosting 12C (12.1.0.2) database on Red Hat Linux (RHEL 6.5) operating systems.
• Administering a 500GB QA environment with single instance Oracle database servers on 12C (12.1.0.2) on Red Hat Linux (RHEL 6.5) operating systems.
• Create, implement and manage custom Oracle databases on Linux and windows platforms.
• Creating and maintaining Oracle database objects (schemas, tables, indexes etc.).
• Providing Oracle database administrative support to various user groups (application developers, data managers etc.)
• Creating a database recovery catalog and registering databases to the recovery catalog database.
• Performing backup and recovery tasks on Oracle database using RMAN Incremental backup and hot backup, cold backup. Using shell scripts for all.
• Scheduling backups using the crontab utility.
• Performing capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance.
• Using RMAN to restore and recover control and data files respectively.
• Performing a flashback and point in time recovery.
• Supporting system administration groups with maintaining oracle database servers and in pre production, test, training, and development environments.
• Analyzing and tuning voluminous SQL code.
• Tuning database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
• Control and monitor user access to the database using roles and profiles.
• Performing data migration from a database in one server to a database housed on another server using database link.
• Migrating data using the data pump export (expdp) and import (impdp).
• Creating non-default listeners for database, registering database and listeners to OEM Cloud Control 12C.
• Perform Patch Set Updates (PSUs).
• Confugured Amazon AWS EC2 cloud server and created Database.
• Migrated schemas and applications to the Amazon AWS EC2 cloud instance.
• Experience in Dataguard implementation and maintenance: Both Physical & Logical standby.
• Experience in managing Oracle 11gR2 RAC environments.
• Upgraded 11G databases to 12C.
• 24/hr support provided during on-call rotation.

Oracle DBA Consultant

Confidential, Bowie, MD

Responsibilities:

• Managed a half-terabyte sized production database environment.
• Supported system administration groups with Oracle database server maintenance and in pre-production, test, training, and development environments.
• Worked in an Oracle 11gr2(11.2.0.3) database environment hosting WebLogic application servers.
• Providing 24/7 database administration support in both development and production environments.
• Provided Oracle database administrative support to various user groups (application developers, datamanagers, etc.).
• Implemented and enforced database security by creating users, roles, and privileges.
• Created and maintained Oracle database objects (schemas, tables, indexes, etc.).
• Database monitoring and extensive performance tuning.
• Analyzed and tuned SQL code.
• Tuned database objects to run smoothly by analyzing query paths and using efficient indexing.
• Wrote shell scripts to automate and perform backup and recovery tasks on Oracle databases using RMAN backups (Incremental backup), hot and cold backups.
• Performed capacity planning in terms of memory and disk usage, established benchmarks for business and technical performance.
• Using RMAN to restore and recover control and data files respectively.
• Migrated data using the data pump export (expdp) and import (impdp).
• Scheduled backups using Linux’s crontab utility.
• Performed flashback and point in time recoveries.
• Experience in Dataguard implementation and maintenance: Both Physical & Logical standby.
• Experience in managing Oracle 11gR2 RAC environments
• Performed Patch Set Updates (PSUs).
• Created database recovery catalogs.
• Effectively migrated databases within the same downtime window.
• Created non-default listeners for databases both manually and used Oracle Net Configuration Assistant