SUMMARY

• Over 10+ years of professional experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation, setting up and configuring Data - guard, replications using golden gate in high-availability environments.
• Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.
• Handful of experience in Oracle Installations, Upgrades and Patches in various environment ranging from 10g/11g/12c.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g/9i for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
• Having Hands on experience working in both Application and Production support environment.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, DBArtisian, Autosys, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 11G/12C/13C cloud control and monitoring databases using OEM 11g/12c/13c.
• Configuration and Management of Data Guard 10g/11g/12c on RHEL, OEL and Sun-Solaris for Disaster Recovery.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.
• Experience in install, administer and troubleshoot Oracle Application E-Business suite R12.
• Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.
• Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract Pump and Replicat issues.
• Proficient in database upgrades from 9i/10g/11g to 11g/12c.
• Experience in migrating data from Solaris, HP-Unix, AIX to Linux.
• Good knowledge in administering OID and OUD.
• Installation and Configuration: Operating System, Grid Infrastructure (Clusterware, ASM, Disk Groups), Private Network for Interconnect and Public Network (VIP, SCAN), Shared Storage, Secured Shell, OCR and Voting Disk, Cluster verify utility (cluvfy).
• Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Knowledge of various storage solutions (SAN, NAS).
• Database refresh from production to QA, development and testing environments.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB vault.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.
• Experience in masking sensitive data using OEM/Datamasker.
• Experience in SQL Tuning, SQL Optimization, cost based optimization and Hints.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Have good experience in install and administering of MS SQL Server 2012/2014, Mongo, Postgress and MySQL databases.
• Extensively used BMC Remedy, Pac 2000, ServiceNow, Heat ticketing systems.
• Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.

TECHNICAL SKILLS

Operating Systems: Red Hat Enterprise Linux 4.x,5.x, 6.x, HP-UX 10.x, 11.xSun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c/11g/10g Real Application Cluster (RAC)ASM, MySQL, MSSQL Server 2012/2014, Postgress, Mongo

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities RAC, OEM Grid Control, SQL* Loader, ASM, SSMS, SSIS, VMwareRMAN, NETCA, DBCA, TOAD, Autosys, SQLNET, TFSODBC, Exp/Imp, Data pump, Data-Guard, Erwin, OEL, Oracle StreamsMS Visio, Commvault, BMC remedy, Pac 2000, ServiceNow, Heat, Crontab

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, Winscp

ERP Systems: Oracle E-Business suite R12.0.6, R12.2.4

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Senior Database Administrator

Responsibilities:

• Install, configure and administer 11g/12c RAC with ASM on RHEL and AIX systems.
• Install, Upgrade, Configure and Troubleshoot GoldenGate 12c software.
• Working as a DBA in the Database Support Team to support production and non-production environments.
• Oracle Database Administration 10gR2, 11gR2 and 12c on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control.
• Install the Oracle GoldenGate (OGG) software to implement one-way/two-way data replicate process, enable DML/DDL data replicate, setup the heart-beat table to monitor OGG replicate lag and provide real-time lag report.
• Implementing High Availability Oracle Golden Gate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments.
• Upgrading and migrating the database to different version depending on Business requirements. Applying CPU, PSU and other patches per audit/compliance requirements.
• Capacity planning system growth by forecasting future needs.
• Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.
• Migrated Oracle databases from legacy datacenter to new datacenters using Goldengate with very minimal downtime and configured DR/Active-Active databases for primary database as needed.
• Carried out Disaster Recovery tests using DataGuard broker and flashback.
• Created centralized database server standard build documents and backup standardization scripts and documents for the DBA teams.
• Create and manage LPAR’s on OVM as per the business needs.
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c/13c (OEM), developing and maintaining the Korn shell monitoring scripts to monitor database instance status, tablespace usage, Goldengate process running status, patching etc.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export /Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Involved in 24x7 production database maintenance and on-call support.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 12c/11g/10g, Red Hat Enterprise Linux 6.9, AIX 6.1, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, TOAD, SQL*LOADER, Performance Tuning, Expdp/Impdp, TDE,TFS, ServiceNow, WebLogic, Jira, Bitbucket, Rundeck, Veritas Netbackup, OAM, OVM.

Confidential, Shrewsbury, MA

Senior Database Administrator

Responsibilities:

• Install, configure and administer 11g/12c RAC with ASM on RHEL, Solaris, Unix Systems.
• Install, Configure and Troubleshoot GoldenGate 11g/12c software.
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Configured Active standby databases for production databases using Oracle Dataguard for disaster recovery. Tested switch over & fail over for standby database using Dataguard broker DGMGRL.
• Managing Complex MAA environment with RAC & Goldengate integrated with Active/Active Configuration.
• Configured RMAN (Full, incremental & cumulative), hot/cold backups from Commvault.
• Restore the databases, datafiles, tablespaces from the backups in case of any data loss/corruption.
• Expertise in patching CRS, Oracle & Grid homes using OPatch utility.
• Upgraded standalone databases from 9i/10g/11g to 12c using exp/imp, DBUA and manual upgrade.
• Upgraded 2 Node RAC databases from 11.2.0.3 to 12.1.0.2 using manual upgrade.
• Mask necessary PI/PHI/PCI data in QA/TEST/DEV database after refresh from PROD using DataMasker.
• Worked on Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB vault.
• Improved the security feature of the data in a schema with the database vault feature, redaction and created realm using 13C Oracle Enterprise Manager.
• Refresh the TEST/QA environments with Production data using RMAN duplicate & Data pump.
• Monitor Oracle databases using OEM 13c grid control. Worked with network & Linux admins to open ports and create firewall exceptions between host server and OEM grid control server.
• Experience in deploying J2EE applications in WebLogic, Apache Tomcat and JBOSS.
• Deployed Grid control agents on newly created environments for continuous monitoring and troubleshooting.
• Monitor and troubleshoot database growth, CPU usage, connectivity issues, memory, tablespace growth, blocking sessions, dead locks, network waits.
• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc.
• Analyze and tune database performance using ADDM, ASH & AWR reports.
• Create users, views and tablespaces, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracle databases. Also, created procedures, packages, functions, cursors and triggers as needed.
• Interact with My Oracle Support to resolve open Service Requests.
• Supported in house projects working with internal teams and worked with outside vendors to support application upgrades.
• Install, configure and administer MSSQL Server 2012/2014, MYSQL, Postgress and Mongo databases. Schedule Full, differential and TLOG backups in MSSQL Server.
• Experience in developing SSIS packages for data loading as per the requirements.
• 24/7 on-call production database support.

Environment: Oracle 12c/11g/10g, SQL Server 2012/2014, Red Hat Enterprise Linux 6.5, AIX, Solaris, Windows server 2012/2014, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, TOAD, SQL*LOADER, Performance Tuning, Expdp/Impdp, SSIS, DataMasker, TFS, ServiceNow, WebLogic.

Confidential, Camp Hill, PA

Senior Oracle DBA

Responsibilities:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Clusterware, Oracle 11g/12c two node RAC for the database tier.
• Planning and implementing DR for Oracle 11g /12c Standby Database using Dataguard.
• Planned and performed migration of applications across the development, implementation, testing, UAT and production databases following SDLC.
• Experience in installing, configuring and administering various components of Oracle IAM Suite like Oracle Identity Manager (OIM), Oracle Access Manager (OAM), Oracle Enterprise Single Sign-On
• Experienced in user administration, privileged identity and access management, identity intelligence, role-based identity administration and analytics, Configuration of Roles, Policies and Certifications for Governance compliance.
• Experience on Role Based Access Control (RBAC) analysis and implementation.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Created ASM volumes using ASMCA and Created ACFS for GoldenGate v12.
• Installed GoldenGate on 12c RAC ACFS and configured Integrated Extract and Replicat.
• Multitenant database 12.1.0.2. Performed Cross platform migration and used Oracle GoldenGate to migrate database from IBM-AIX 6.1 to OEL 6.1.
• Extensively Used Logdump Utility to Investigate data on the trail and defgen to create definition files used for replication.
• Extensively Used OEM 11g/12c and Administering Oracle Database 10g, 11g and 12c databases and masking sensitive data in production databases.
• Experience in creating physical and logical database design Data Models using Erwin Tool. Generation of DDL scripts using Erwin Tools.
• Involved in every aspect of product testing in Oracle EBS R12.
• Installation and configuration of OBIEE, WebLogic, ODI.
• Supporting OBIEE admin, ODI admin tasks and Oracle DBA activities
• Packages migration using ODI smart import utilities.
• Upgraded databases from 11.2.0.4 to 12.1. 0.2 in QA and Prod environments.
• Worked on Oracle Enterprise Manager Express for Oracle 12c RAC standard.
• Working with logical backup using Data pump and Exports/Imports Utility.
• Database Load and Transformation Techniques (SQL Loader, External Tables, SSIS).
• Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.
• Installation and use of Oracle ASM (as well as traditional file system storage).
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Installed and configured Oracle 12c WebLogic server and Oracle 12c HTTP servers for the application tier and web tier.
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle EBS 12.0.6/12.2.4 , OBIEE, ODI, Oracle 11g/12c, Red Hat Enterprise Linux 5/6, AIX, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, LDAP, OIAM, TOAD, SQL*LOADER, Performance Tuning, Data pumps, Exports/Imports, BMC Remedy.

Confidential, Cincinnati, OH

Senior Oracle DBA

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure.
• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 10TB.
• Migrated databases from File-system to Automatic Storage Management (ASM).
• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.
• Implemented and customized Oracle Identity Access Management 11gR2 and Oracle Access Manager (OAM) 11gR2 according to client infrastructure requirements.
• Developed and configured the Roles with access policies to provision the users into the LDAP Groups in OID.
• Upgraded single instance databases from 11.2.0.1 to 11.2.0.3 on Linux.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Checking the Status of Application Listener, ICM, Forms & Report server, Apache server.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Involved in upgrade of Oracle Application E-Business suite from R12.0.6 to R12.2.4.
• Troubleshooting and resolving cloning related issues i.e. Oracle Application login page is blank, Responsibilities are not appearing after login, APPS password is corrupted, Forms are not opening, and (OPP) Output Post Processor is not coming up.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Worked closely with Functional/Developers and helping them in fixing issues.
• Worked on Active data guard, Fail over and Switch over cases.
• Hands on Experience in SQL Tuning and SQL Optimization.
• Created Oracle Tables, Table Partitions, Views, and Materialized Views.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Cloned schemas, objects and data on new server using Data pump utility.
• Good knowledge on SDLC methodologies like Agile, Waterfall and Iterative models.
• Decreased Contention by reducing the Wait Events as a part of Performance Tuning.
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions& data dictionary corruptions
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Responsible for all database activities such as User management, space management, database security management, rollback segments& creation of DB links between oracle servers
• Ability to work effectively and can liaise as a part of team monitoring proactively
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g, 11g Red Hat Enterprise Linux 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL*LOADER, LDAP, OIAM, OAM, Performance Tuning, Heat, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Confidential, Salem, OR

Oracle DBA

Responsibilities:

• Involved with installation and maintenance of Oracle 3 node RAC for high availability.
• Involved in change control process and Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively on monitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.
• Involved in Migrating applications from single node to multinode.
• Maintained 10g/11g RAC environment and troubleshooting issues.
• Responsible for implementing Load Balancing in RAC Database.
• Performed health checks in RAC instances using CRSCTL and SRVCTL utility.
• Having good experience in migrating single Instance database to RAC Environment.
• Performed Capacity Planning, Undo segments and Health check reviews in RAC.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Scheduling the databases backup using Crontab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas.
• Performed Migration of databases 10g on HP-Unix to Oracle 11gR2 on Linux.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Experience in troubleshooting the Oracle streams.
• Create and monitor database objects like Indexes, Views, Users, and DB Links.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also, wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQLtuning advisor.
• Perform a cross-platform database migration with impdp/expdp.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, OEM, AWR, ADDM for Generating reports.
• Created Partition’s estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Oracle Streams, Toad, OEM, ASM.