SUMMARY:

• Several years of specialized experience in database administration, providing support to developers, testers, help implementation teams and maintenance of Oracle 10g, 11g and 12c RAC databases
• Strong in Oracle DBA activities including installation, migration/upgradation of databases having more than 300+ users
• Experience in configuring & upgrading OEM
• Strong in configuration, backup, recovery, PL/SQL, SQL scripts programming
• Strong in database Refresh and database cloning
• Strong backup and recovery by RMAN
• Strong in HOT and COLD backup, Export & Import
• Expert in physical & logical backup by Shell Script, RMAN and DATAPUMP
• Worked on implementing Disaster recovery system, using RMAN for the data guard configuration
• Knowledge of shell scripts and Data Warehouse Technology
• Experienced in Tuning SQL statements using Explain Plan
• Strong in setting up Standby Database using RMAN tool, Activating Standby Database & Re - building Standby
• Strong in Database Migration
• Know how to Tune the Application, Database (Shared Pool, Redo log, buffer cache, undo segments, I/O distribution)
• In-depth expertise in relational database systems design and implementation, testing support for developers in development and staging environments and operational support for production systems
• Know how to maintain system security, how to unlock database table locks, how to monitor database alert logs
• Knowledge of administering all database objects including tables, synonyms, indexes, views, sequences, packages and procedures
• Experienced in planning and implementing backup and recovery strategies for the Oracle database
• Availability to 24x7 on-call support on rotation basis for Production Systems Support
• Excellent at putting standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Detail oriented, streamlining regular DBA tasks to reduce time spent on daily database monitoring including: alert log entries, backup completion, performance bottlenecks and connection-related issues using OEM
• Excellent analytical, problem-solving and learning skills as well as keen interest in the emerging technologies
• Great people skills, verbal and written communications and the highest level of dedication to technical excellence.

TECHNICAL SKILLS:

OPERATING SYSTEMS: UNIX LINUX WINDOWS

RDBMS: Oracle 12c Oracle 11g

LANGUAGES: SQL PL/SQL Batch and Shell Scripting

DATABASE MANAGEMENT: ASM

ENVIRONMENT: Data Guard Flashback RAC

TOOLS: /UTILITIES OEM 11g/12c/13c DBCA DBUA LSNRCTL TNSPING EXP IMP RMAN SQL*Loader Confidential (expdp, impdp) NETCA ADRCI SSH Oracle Universal Installer Oracle VM Virtual Box TOAD OS Ticket BMC Remedy Action Request System (ARS)

PERFORMANCE TUNING: EXPLAIN PLAN

EXPERIENCE:

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• Installed and created 11g/12c RAC databases, application software and software related to DBMS administration in WINDOWS, LINUX and UNIX environments
• Worked closely with the system administrator to perform software installations, configure ASM, hardware and software so that it functioned optimally with the DBMS
• Experience installing, configuring, applying patches and database re-organizing using oracle enterprise manager (OEM) and upgrading database versions
• More than 2 Terabytes of data migrated from 9i to 11g databases by export and import
• Monitored and administered DBMS security by creating, altering and dropping users, administering quotas on tablespaces, auditing, checking for security problems and granting user privileges and roles
• Monitored system performance and constantly tuned databases for efficient performance (disk space, memory, CPU, etc.) using OEM
• Performance parameters adjusted as needed
• Partitioned large tables to increase the performance, responsible for optimizing the queries and application tuning
• Experienced with working on non-prod databases which are resided on Virtual Machines and understanding the working process
• On-going SQL tuning using Explain Plan, created shell scripts, stored procedures, triggers, functions and cursors
• Developed an effective backup and recovery strategy to maintain the integrity of the database
• Performed database backup, restore and recovery using RMAN for hot and cold backups
• Implemented disaster recovery system, using RMAN and custom written shell scripts, created and maintained Oracle Data Guard configuration
• Loaded the data by SQL LOADER
• Scheduled routine DBMS maintenance and carried out this maintenance during off peak times
• Troubleshot the server operating system and database management system.

Confidential, Bowie, MD

Oracle DBA

Responsibilities:

• Created 10g and 11g databases and migrated database from 10g to 11g by Confidential
• Installed and used Oracle Enterprise Manager for some of the maintenance tasks
• Proficient in Installation and Setting up of 11g/10g with ASM and RAC databases
• Managed the database’s storage structures including tablespaces and redo logs
• Managed users and security
• Experience working with TCP/IP and DNS
• Managed schema objects such as tables, indexes and views
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Assisted in data restoration from back systems using RDBMS making backups, performing restore and recovery when necessary by RMAN
• Worked with DW team for loading data to warehouse databases
• Proactively monitored the database’s health and took preventive and corrective action as required
• Performed active monitoring, modified and updated the performance tuning scripts
• Provided Production DBA support, as needed, on a 24/7 basis
• Performed patches and upgrades of the database and software to new releases
• Administed batch inserts and created and run shell scripts
• Connected via SSH and migrated data between WINDOWS, LINUX and UNIX environments
• Supported vendor applications and Oracle software by means of telephone, remote software and emails