OBJECTIVE:

Strongly focused and knowledgeable Database Administrator with a wide breadth of software installation and maintenance knowledge. Expert communicator of complex technological concepts to professional and non - professional audiences. Leader of independent workshops in computer software design and implementation in the broader professional community.

SUMMARY:

• 3+ years of experience as an Oracle DBA with administration & maintenance of Oracle on operating systems such as Red Hat Linux, Sun Solaris, SUSE, HP-UX, IBM-AIX and Windows.
• 24*7 production database support to developers & end-users.
• Worked on upgrading of oracle databases from 11g to 12c.
• Worked on building and rolling out new 12c databases for test/dev/prod environments.
• Have knowledge on migrating the databases from stand alone to cloud environments.
• Implemented oracle 12c active standby database for test database environment.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database. Have knowledge on OEM 13c.
• Performed mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.
• Worked with projects/operations/professional services team and coordinated multiple tasks at hand with expertise and solid plan.
• Contributed as an efficient/reliable team member for all business-critical releases and changes.
• Worked under high stress situations many times and handled the situation very effectively.
• Implemented Oracle 11g Golden-gate for replication project.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Effectively communicating with PM'S while working on project related tasks.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Experienced in Installation, configuration and tuning of high availability Real Application Clusters (RAC) applications.
• Experience in applying Critical Patch Updates (CPU Patches) and patch set updates (PSU patches) on Databases, Application Servers and Middle Tiers.
• Experience in installing and configuring GoldenGate 11g/12c and using replication procedures to support data replication in the Oracle database environment.
• Experience in building Standby databases. Implementing FSFO (Fast start failover) on 11G databases and configuring disaster recovery site using Dataguard.
• Modeling and designing Data, OLAP, Logical and Physical Database Design of tables, tablespaces, Users, roles, privileges, creating storage structures or using ASM and Performance Tuning.
• Implemented efficient methods for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution, block corruption and Defrag scenarios across diverse environments.
• Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.

TECHNICAL SKILLS:

Database: OEM 12C, Oracle 12c, 11gR2, Oracle 11gR1

Oracle Products: Real Application Cluster, Goldengate, Dataguard, Import and Export, Data pumps, Automatic Storage Management, Oracle 11g/12c (Grid Control), OEM.

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL).

Languages: SQL, PL/SQL, C.

Tools: & Utilities:AWR, ASH, Toad, Putty, ERWIN, ETL tool

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Created blackouts in OEM to disable alerts from OEM while performing database maintenance activities such as PSU patching
• Performance tuning of the databases using: OEM, OEM12C, Toad, AWR, ASH, SQLT, DBMS stats, explain plan.
• Improved the security feature of the data in a schema with the database vault feature, redaction and created realm using 12C Oracle Enterprise Manager.
• Installed and configured the Oracle Goldengate and involved in troubleshooting Goldengate issues.
• Setup goldengate uni-directional and bi-directional replication between 2 data centers.
• Worked with app support team to understand the complete replication requirement.
• Enabled DDL replication in database and enabled supplemental logging.
• Efficient use of Imp/Export Jobs for schema migration and tablespace migration.
• Designed multiple extract and replicate parameter files for overall replication.
• Duplicate database using RMAN utility for Oracle 11g from Prod to Non-Prod databases.
• Analyzed goldengate issues from ggserr.log file and used logdump utility for troubleshooting.
• Configured multiple goldengate environments, few extracting from online redologs and few other extracting always from Archive logs.
• Designed a shell script for monitoring oracle goldengate instance.

Environment: OEM 12C, Oracle 11gR2/12C, Goldengate, putty.

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration, Upgrade, patching of Oracle RDBMS in development, test and production environments on Various OS Platforms like Linux, AIX and HP-UX.
• Refresh/Cloning of Database and applications for as and when needed.
• Involved in developing PL/SQL functions, procedures, packages, and triggers. Involved in creating tables, views etc.
• Monitoring and tuning using different Oracle utilities like AWR, SQL trace, TKPROF, Explain plan
• Implementing User management strategies: schemas, Objects, user profiles roles and privilege management etc. As per application requirements.
• Preparing the Documents: Installation/Upgrades/Patching/cloning/Issues /New activities are documented for the User and shared along with the team.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Applying Patch set update and critical patch updates
• Experience in code migration, database change management and data management

Environment:: OEM 12c, Oracle 12C/11g, Red Hat Linux 4.x, 5.x, Hp-Unix 7.1, Oracle 11g/12C, AWR, Explain Plan.