SUMMARY

• 8 years of experience in oracle database administrator in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, ASM, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines. Performed Data masking and Data redaction and created vault in OEM.
• Extensive Experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience in using oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, upgrading databases and Network Configuration Assistant (NETCA) & NETMGR for creating a Listener, TNS names to establish a Client - Server environment
• Experienced in maintaining databases on large Production, Testing and DEV environments and Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.
• Experience with MySQL on both Linux and Windows
• Extensive experience in providing 24x7 on call support for Test, development and production databases using Maximum Availability Architecture using RAC and Dataguard
• Expertise in Implementing Oracle 11gR2 and 12c RAC implementation on ASM
• Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs
• RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OSWatcher, Srvctl and Crsctl
• Performed various tasks in RAC Cluster: pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM disk groups, Tuning Node Evictions by setting disk timeout, reboot time, miss count, Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover
• Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c
• Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using goldengate.
• Troubleshooting GoldenGate issues such as process abending, and lag on replication environments
• Troubleshooting GoldenGate issues in both development and production environments
• Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and GoldenGate replication
• Expertise in Dataguard Configuration, Implementing and Maintaining physical standby databases in 10g/11g/12c on Solaris, AIX, RHEL
• Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases
• Expertise in analyzing database objects, DB-links, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle
• Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, Applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker
• Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with Zero downtime.
• Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, and prod environment
• Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied Patches to GoldenGate environment 12.1.0.2 configured GoldenGate wallet for security purposes
• Expertise in implementing database Backup and Recovery concepts using RMAN utility.
• Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN
• Performed Various Tasks on RMAN: configuring backup, Block recovery, data file recovery, registering databases in catalog, TBPIR Table space point in time recovery
• Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces
• Excellent working knowledge ofOperation & Production Supportwith large mission critical systems in multiple technologies and platforms includingWebLogic, Apache, JBoss, WebSphere, UNIX, Windows NT, and Oracle
• Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database
• Extensively used Flashback for Supporting DML and DDL changes and Handled daily production problems/change requests(DBCRS) with Oracle Patching.
• Good experience in Patching PSU and CPU Patches Quarterly and Up gradation of databases from versions from 10g,11g to 12c
• Expertise in Upgrading databases from 10g to 11g and 11g to 12c and applied patches accordingly
• Excellent working knowledge in configuring multipleWebLogic domains including machines, manage servers, node managersandcluster environments
• Upgradation of WebLogic servers in development, testing and production environment and applying patches
• Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, ASH, SQL-Trace, ADDM, SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage
• Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database
• Worked on Exadata Database Machine X2-2 Half Rack, X3-2
• Experience in working different storage technologies (SAN/NAS, and Oracle ZFS)
• Implemented new Exadata Machine features like smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases
• Firewall Updates and VPN implementation
• Migrated databases into Exadata Machine with minimal downtime using Dataguard
• EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations
• Opened, resolved, or updated Tier II Support tickets for Manage Firewall clients
• Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (EBS and Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN)
• Integrated Sybase Replication into the company's semi-annual Disaster Recovery testing for the first time. Documented how to activate all 38 Sybase Replication connections (threads) in a DR setting while minimizing potential for data loss.
• Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control (OEM)
• Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql’s on database
• Configured, troubleshoot, and upgraded Checkpoint Firewalls for Manage clients, which included network and/or resource access, software, or hardware problems
• Use Oracle Meta-Link Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments
• Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams
• Have Ability to function independently and plan, evaluate and design solutions to problems as they occur and Ability to work well in a group environment and Good ability to mentor other DBAs in the group

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS: Oracle 12c/11g/10g/, Oracle 11g Real Application Cluster (RAC), ASM

Oracle Tools and Utilities: Data Guard, GoldenGate, Logdump, Defgen, Web logic server, OBIEE, WebSphere, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER

Languages: C, SQL, PL/SQL, AWK Scripting, Perl

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

Ticketing Tools: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, GIRA, BEAWebLogic8.1,9.2,10

PROFESSIONAL EXPERIENCE

Confidential, IRVINE, CA

Sr. Oracle DBA

Responsibilities:

• Installed, Configured and monitored GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on oracle 11g LINUX Server
• Administered Oracle Database 11g and 12c using Oracle Enterprise Manager (OEM), Toad, SQL Developer and Power designer
• Monitoring all the databases using OEM 11G/12c cloud control
• Migrated oracle databases using oracle11g GOLDENGATE
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly
• Performance tuning of oracle Database and poor SQL queries
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf
• Creating User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked on Client/Server tools likeSQLServer Enterprise Manager and Query Analyzer to AdministerSQLServer.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle11gR2 to the latest Oracle 12c and applied patches as required.
• Cloned database and schemas using Data pump for 11g and 12c versions.
• Involvement in space management, rectification of lock problems, user management.
• Supporting Application developers with various performance, connectivity and security related issues on various projects
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 11g and 12c databases.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Jobs and Backups using 12c OEM and CRONTAB.

Environment: Oracle 12c/11g, AIX, RHEL, OEM 12c, RMAN and Data Guard, Goldengate, Explain Plan, SQLT, SQL Developer, Data Pump, Business Objects, PUTTY, FTP, SFTP, SCP.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, Migrating single Instance Databases to 3 Node RAC environments
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment
• Performed the 12c Upgrade of RAC cluster ware from 11g.
• Install, configure and administration of Bea WebLogic Server 8.1/9.x in various environments
• Duplicated issues and tested solutions to make sure problems were resolved properly.
• Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution
• Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.
• Implemented technical security controls through the Windows registry as well as Microsoft Group Policy
• Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.
• Deployed the applications, formats of WAR, JAR and EAR in WebLogic 8.1 SP5/9.x
• Troubleshooting multicast issues using WebLogic Java Utility Multicast Test
• Established performance tuning best practices used by the DBA and Development teams.
• Performed the Instance caging for the Exadata databases.
• EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations
• Enabled Flashback for database to create restore points and supporting DDL changes
• Applied PSU quarterly on 11g/12c GRID & RDBMS homes using Opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN
• Provided Manage Firewall Clients' with regular status reports of their trouble tickets
• Daily Health Check Up of the Database and SQL Queries and Performed large batch jobs, and tuning of SQL queries and database systems
• Excellent knowledge in using Oracle GoldenGate including maintenance and performance monitoring.
• Performance tuning GoldenGate replication and used Log dump and report files for troubleshooting.
• Installation and configuration of oracle Goldengate on 12c & 11g.
• Configuration and troubleshooting of GoldenGate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues
• Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM
• Worked on Exadata Production databases and providing the Technical support to Application Support team for performance and database related issues
• Creatively acquired a rack of servers, memory, ZFS Storage appliance and ethernet switches.
• Managed ZFS storage Smart storage for Exalogic
• Up gradation of GRID infrastructure from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2
• Performed health checks of RAC Cluster-ware components OCR, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C
• Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and Managing services using RAC Tools SRVCTL and Cluster-ware resources using CRSCTL.
• Oracle Enterprise Manager: Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding to the grid control
• Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS SCHEDULER
• Dataguard: Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business
• Configured Active Dataguard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Dataguard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing
• Worked on Service now Ticketing system to resolve the incidents based on Severity
• Used crontab utility for scheduling jobs.
• Perform Daily Monitoring ofOracleInstances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management ofOraclenetworking. Configured listener for external procedure calls.
• Also configured database cloning using RMAN.
• Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues
• Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures
• Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, WebLogic server 8.1/9.0,10g/11g, Goldengate11g, 12c, orachk Defgen, Logdump, ASH reports, Oracle Patching Opatch, Data Pump, putty

Sr.Oracle Database Administrator

• Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases
• Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate
• Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicate and replicated tables to different Instances using GoldenGate
• Upgradation of databases from 11.2.0.2 to 11gR2 and Applied patches to databases 10g/11g
• Configuredcustom execute queueinWebLogic 8.1
• Configured Disaster recovery databases using Dataguard: configured Active Dataguard, Dataguard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing
• Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database
• Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery
• Planning Recovery Procedures and Performing backups in Both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Configured repository database for setting up OEM 12c, used 10g,11g for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c
• Created User accounts, Roles and granting required access permissions and privileges
• Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes
• Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL profiles, Creating and rebuilding Index’s, re-organizing tables
• Used 11g new features Invisible Indexes, and turn off indexes temporarily to check how queries perform without Index’s and Worked on Oracle Database Appliance, patching creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment.

Environment: Oracle 11g/10g, Oracle 12c(Testing), Oracle Goldengate 10.4, Oracle Goldengate 11.2, Oracle Enterprise Manager Grid Control, WebLogic, Oracle Enterprise Manager (OEM), Sun Solaris, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring and alerts.
• Installed and configured 2 Node RAC on 11gR2 and performing Monitoring Health checks in RAC environment.
• Migrated Oracle R12.2.6 to Oracle Cloud and Upgraded over 65 Oracle 11.2 to 12c PDB database -- setup TDE security
• System is a multi-application tier node with a 3 node RAC environment and Implement Oracle TDE column encryption for advanced security.
• Setup, configure, developed database automatic monitoring of alert log, database status, space usage, connectivity, SGA etc.
• Installed 13 standalone servers on ASM and migrated databases to ASM environment.
• Developed, implemented, administered, and maintained policies and procedures for ensuring the security and integrity of the company's databases.
• Implemented database backup & recovery, data models, database designs,
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converting Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Responsible for Installing, Upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database Performance.
• Installed Golden gate on source and target side for Replication and implemented load-balancing topology using Goldengate.
• Implemented Oracle database backup & recovery solutions using RMAN
• Restored and Recovery of databases at the times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Identified and fixed the logical block corruption using RMAN.
• Handling service requests within Service line agreement.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF and Creation and administration of Virtual Machines using VMware.
• Designed bash scripts to automate application and system management activities.
• Performed DB migration from Windows to Solaris, implemented Oracle TDE to satisfy PCI requirements for credit card data encryption (Oracle Advanced Security).
• These scripts provided the following functionality: application startup and shutdown, monitored systems and applications health, and web site management.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in configuration files like Listener.ora, Tnsname.ora for Client - Server environment using network configuration assistant.

Environment: Oracle 9i, 10g, Sun Solaris, windows, Unix, RMAN, DBCA, Informatica, GOLDENGATE, Data guard, EXPLAIN PLAN, Cloning, OEM cloud control 12C, STATSPACK, RHEL 5.x/6.x, VMware, Web Servers, Oracle Transparent Data Encryption,TKPROF and putty

Confidential

Oracle Database Administrator

• Setup physical standby’s (DATAGUARD) for several Databases running 11g well(Container level and Non-CDB)
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI
• Assisted in keeping a daily log of Share point issues and submitting that log each week to IT management
• Converted physical standby to Snapshot standby and back to physical standby
• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Data pump including database links and network links.
• Upgrade the binaries by applying patch set and interim patches using Opatch and Opatch Auto.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory usage.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability
• Tested database performance issues (monitoring and tuning) to ensure database optimization
• Involved in gathering requirements from end users Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance
• Replication was configured to run even at the time of failover (Data Guard) of the source database
• Providing technical support to Application Support team for performance and database related issues
• Effective Production Support and off hour support, support ha5ndover

Environment: Oracle 11g, Red Hat Linux 5.8, OEM 12c, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, Opatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations