SUMMARY:

• Over 5+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Financial, Pharmaceutical, Insurance Industries.
• Wrote several Purging shell scripts on Linux which have been using as standard script at the workplace
• Provided root cause analysis and permanent fix of production problems
• Installation, administration and maintenance of Oracle 11g and 12C
• Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g and from 11g to 12C) and patching
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean - up, data archiving, etc
• Developed RMAN scripts for database backup and recovery including- hot and cold backup
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12C, 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Performed backup & recovery of large databases and provided 24X7 production support to high critical databases
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Design, development, and testing of backup and recovery to ensure complete recoverability.
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Security management for database, network, and operating systems.
• SQL Net installation/configuration/troubleshooting (Server and Client side).
• Storage Management including fragmentation detection, tablespace growth ratio.
• Excellent interpersonal and strong analytical, problem-solving skills.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 7.1, AIX 6.1, HP-UX, SOLARIS, Windows 2010

RDBMS: Oracle 12C/11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Rockville MD

Oracle DBA

Responsibilities:

• Install client/server Oracle and MS SQL Server Software
• Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1 to 11.2.0.3 to 11.2.0.14 to 12.1.0.2
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple tablespaces from logical and physical data model
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Prepared scripts to tune developer SQL codes to maximize result return time
• Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.
• Performed cold and hot backup using Rman.
• Provided remote technical support using SSH and terminal services
• Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard and Golden Gate.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespaces, tables, indexes, set privileges and user logins
• Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules. Oracle scripting in Windows/ Solaris and UNIX platform.
• Backup / Recovery methodology specification for mission critical databases
• Performed hot and cold Backups.
• Scheduled daily Exports/Imports to serve as temporary backups.
• Installation and configuration of Oracle 10g, 11g and 12C Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.
• Capacity planning and creating databases for development, staging and production.
• Database and Data Migration using Export/Import, Migration Utility.
• Performed bulk data loads using SQL Loader.
• Set up and configured SQL*Net and on servers and client machines.
• Administration of RAC and DATAGUARD databases in Oracle 11g.
• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems. Resizing Tablespaces, Tables, indexes, Rollback segments.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Designed, tested and documented Oracle RAC database procedures
• Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations
• Resolving RAC specific issues such as node evictions
• Performed proactive and reactive tuning/managing database space utilization and growth
• Implementing Oracle ASM and resolving ASM related issues
• Detailed analysis of the business and users requirements by doing various information gathering techniques.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), Oracle 12C, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Oracle DBA

Responsibilities:

• Managed Oracle Databases on Windows and Linux platforms.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Monitored the alert logs and troubleshot the errors.
• Scheduled the backup jobs such as export through crontab in UNIX environment.
• Rebuilt indexes and analyzed tables to ensure good performance of database.
• Installed Oracle 10g and 11g on multiple platforms.
• Performed upgrades from 10g to 11g databases.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0