SUMMARY

• 9 years of professional experience in IT industry as an Oracle database administration in Linux, Unix and Windows platforms.
• Experience includes design, build, test and supporting next - generation database solutions in Oracle enterprise.
• Proficient in Database Administration, Database Installation, Upgradation, Migration, Patching, RAC installation, setting up and configuring DataGuard, Maintaining Exadata, Databases clone, Performance tuning and monitoring the database using OEM Grid Control, RMAN backups, GoldenGate replication, product support.
• Expert with planning, creation, administration and troubleshooting of ORACLE 19c,18c,12c,11g,10g OLTP (multiple instances)/OLAP Data Warehouse databases in production.
• Designed, documented, and deployed many infrastructure projects managed cost and cost avoidance for the client significant. Solutions proposed, architected, deployed include HP-UX to Linux platform migration, New oracle VM farm, disk snapshot and clones, advanced compression, Real Applications Clusters (RAC), Database migrations.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration.
• Implemented Active DataGuard for querying on standby to load balance the databases, snapshot standby databases for testing objects performance.
• Troubleshooting DataGuard using dynamic views, troubleshooting missing archive log scenario using Incremental backup, patching DataGuard environment.
• Expertise in Installing and configuring transactional level DDL, DML, Bi-Directional replication using GoldenGate v11 and v12, 18c and 19c
• Expertise in implementing (unidirectional, bi-directional and downstream capture) and configured Goldengate extract and replicate during the database character set conversion.
• Implemented Coordinated Replicat in GoldenGate with maximum performance depending on threads availability for large transactions replication in 12c.
• Experienced in Cross Platform Migration from Solaris to Linux and Upgraded database from 11g to 12c, 18c, 19c using GoldenGate with Zero downtime.
• For confidentiality and security purpose created password Wallet to avoid the password in the GoldenGate parameter file of the process.
• Hand on experience in advanced replication (Oracle Streams) to replicate data between production databases for local and downstream capture architectures.
• Expertise in monitoring database servers and optimized database performance using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control.
• Expertise in deploying agents from OEM, patching OEM, performing administrative tasks using OEM, AWR, ASH reports, scheduling jobs using Auto sys, blackout scheduling, SQL tuning advisor to tune sql’s on databases.
• Performed Data Redaction, Data Masking and configured Database Vault in 12c using grid control (OEM) to protect sensitive data.
• 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, Creating Views & Materialized Views.
• Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN, Snap Level backups.
• Expertise in installation, configuration of Oracle in Aws EC2-Console. Migrated development and production databases from data center to AWS RDS on oracle platforms. Troubleshooting performance related issues in AWS Oracle data warehouse environment.
• Good experience with AWS DMS, database tuning, caching application architecture of cloud computing & administration of EC2, auto scaling, Oracle 12c Cloud Control, BMC Tools.
• Experienced in functional and technical aspects of Oracle E-Business Suite/ Applications 10g and 11i deployment Requirements, Coding and Development. Also, supported EBS Financial, WebLogic Middleware Stack and Oracle Fusion Middleware.
• Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN).
• Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and nocatalog methods. Recovered dropped tablespace using RMAN performed TSPITR on dropped tablespaces.
• Hands on Experience in Data Center Migrations, Disaster Recovery Testing and Migrate/Convert Standalone Databases to RAC Databases and to ASM Storage.
• Performed tasks on RAC like Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover.
• Converted RDBMS and ASM instances to EDT time zone during daylight saving in RAC and stand-alone configurations. Converted data in DATE datatype columns to EDT time zone.
• Experience in applying Oracle rolling PSU and CPU Patches Quarterly on EXADATA RAC 11g,12c environment using response file
• Expert in Oracle Appliance such as ZFS Storage, Creating Snapshots, Creating Clones.
• Migrated databases into Exadata Machine with minimal downtime using DataGuard.
• Experience on Oracle Hybrid Columnar Compression with Exadata and ZFS Storage and Oracle Storage in production environments with Oracle Data Warehouses.
• Expertise in Oracle Transparent Data Encryption (TDE) such as Defining Keystore, Creating Wallet, Generating Master Key, Enabling Autologin, Rotating Master Key Encryptions.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics, Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms, OEM GC, Cost Optimizer, SQL analyzer, Performance Manager, Stats pack, scrutinizing the long-running SQL queries.
• Worked on Informatica Data Replicator (IDR) tool to optimized ETL procedures and removed load, query performance bottlenecks by using explain Plan.
• Have Ability to function independently and plan, evaluate and design solutions to problems and Ability to work well in a group environment.
• On-call team rotation and support: investigate, troubleshoot problems related to performance of database under SLA, perform root cause analysis (RCA) for high severity incidents in relation with problem management requirements for corrective actions

TECHNICAL SKILLS

Databases: Oracle 19c,18c,12c,11gR2,11gR1,10gR2,9i, SQL 2012/2008R2, MYSQL 5.7

Oracle Products: Oracle Real Application Cluster 19c/18c/12c/11g/10g, GoldenGate, DataGuard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle Streams, Oracle 10g/11g/12c (Grid Control), Oracle EXADATA X4-2, X5-2, RMAN, Oracle Wallet, ZFS, Transparent Data Encryption, Oracle Enterprise Manager (OEM) 11g,12c,13c.

Operating System: Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, 7.x, Oracle Linux, HP UNIX 11i, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages: SQL, PL/SQL, Unix shell scripting, Java, C, .Net, Python.

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, ERWIN, ETL

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, Minnesota

Oracle DBA

Responsibilities:

• Worked with Delta Oracle Engineers and service providers to deliver a highly available, resilient and performant database environment.
• Designing and implementing Exadata based Oracle RAC databases that meet business and infrastructure team requirements.
• Configured, documented and administered Oracle Golden Gate bi-directional replication and Oracle GDS in accordance with Oracle best practices and project requirements.
• Configured Oracle Streams in One Way Setup and Bi Directional Setup. Implemented Disaster Recovery database 12c Data Guard on physical standby database in maximum performance mode.
• Used OEM & Grid Control for database monitoring/performance/diagnostics.
• Ensured Delta’s Oracle database environment is secure, provide recommendations for improving database security and implementing approved security improvements.
• Upgraded 12c RAC to 19c RAC and Administering the RAC Environment through SRVCTL and CRSCTL.
• Configured Data Guard Broker, fast start failover and used for switchover and stopping and Starting Media recovery process, Instance status, check queries, Top wait events, redo transport status and Performed Disaster Recovery testing.
• Created volumes on ASM disk groups and maintaining ACFS Cluster File system in RAC and Applied rolling patches to fix known bugs as well as PSU.
• Used Different RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OS Watcher, Srvctl and Crsctl and resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services
• Implemented GoldenGate Replication 12c, 19c on ACFS and configured for Automatic failover of GoldenGate process and upgraded GoldenGate 11g, 12c to 19c.
• Configured Integrated Extract, Integrated replicate and coordinated replicate on Oracle multitenant database 12c and 19c
• Implemented and Installed Level 3 OEM Cloud Control 12c on Linux machine. Installed WebLogic server 10.3 during the Installation of Cloud Control 12c. OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of upgradation and migration.
• Monitoring Locking Activity/Long Running Transactions/Temp issues/UNDO Issues/RMAN Backup Issues/Tape Issues/DR Recovery Issues/monitor ORA errors like ORA-7445 and ORA-600 and apply patches if required or contact Oracle Support for Additional Information (by raising SR) Replication Maintenance
• Configured RMAN backups using NetBackup and DDBoost, Experience in backup and recovery. Cold backups, Hot backups, Logical backups, RMAN backups performed at different levels of Full backup, Incremental backup, Differential backups, Cumulative backups.
• Conducted database performance testing and tuning, user configuration, security and support processes including gather stats, database backup/recovery, partition administration.
• Coordinated downtime with application teams and system engineers to implement approved changes.
• Interface with Oracle support to resolve operational issues or questions.
• Building new or upgrading / patch existing databases and associated software in accordance with vendor best practices.
• Implemented Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import allowing users to quickly move a user Tablespace across Oracle databases
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Worked in migration project, performed new installations and migrated databases to new servers
• Worked on databases ranging 500GB to 10TB and participated in monthly on-call DBA schedule.
• Installed, configured, and maintained Oracle 12c, 19c on Linux and also Upgraded from 12c to 19c, and refreshed Oracle 12c, 19c databases using file system for storage to ASM.
• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, DataGuard and also, responsible for setup and implementation of 3 Node RAC on Linux in 12c.
• Upgraded 12c RAC to 19c RAC and Administering the RAC Environment through SRVCTL and CRSCTL.
• Installed GoldenGate for replication of database on 12c,19c RAC environment and Configured parameters for the Bi-directional replication to provide uninterrupted service in case of RAC instance/ node failure.
• Installed OEM 13c cloud control Agents on database 12.1.0.2 and Monitoring databases using Grid Control 12c and 13c for Configuration of error notifications. Database monitoring/health check alert scripts for database uptime/down status, and sizing issues using grid control (OEM).
• Configured Oracle Streams in One Way Setup and Bi Directional Setup. Implemented Disaster Recovery database 12c DataGuard on physical standby database in maximum performance mode.
• Configured DataGuard Broker, fast start failover and used for switchover and stopping and Starting Media recovery process, Instance status, check queries, Top wait events, redo transport status and Performed Disaster Recovery testing.
• Upgraded databases in Dataguard Environment from 12c to 19c for primary and standby.
• Worked on Oracle Exadata Applied patches on Exadata X4-2, X5-2 and Converted databases from ZFS filesystem to ASM filesystem. Supported Oracle Cluster series using ZFS Storage Subsystem.
• Worked on Cross Platform Migration from Solaris to Linux and Upgraded database from 11g to 18c using GoldenGate with Zero downtime.
• Introduced Oracle Advanced queuing technique in the database for the Java based applications to trigger the processes based on Oracle Advanced Queueing Technique.
• Configured a real-time downstream capture processes using GoldenGate and Active DataGuard.
• Used Logdump Utility to Investigate data on the trail and fixed the abended process by outer repositioning the process, defgen utility to create definition files in GoldenGate.
• Configured GoldenGate as CRS resource to provide uninterrupted service of RAC instance node failure and Implemented basic tasks on RAC like Mirroring OCR on different ASM diskgroups, Tuning Node Evictions by setting disktimeout, reboot time, miscount.
• Created volumes on ASM disk groups and maintaining ACFS Cluster File system in RAC and Applied rolling patches to fix known bugs as well as PSU.
• Implemented GoldenGate Replication 12c, 19c on ACFS and configured for Automatic failover of GoldenGate process and upgraded GoldenGate 11g, 12c to 19c.
• Configured Integrated Extract, Integrated replicat and coordinated replicat on Oracle multitenant database 12c and 19c
• Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied patches to GoldenGate environment 12.1.0.2 and 12.1.0.3.
• Upgrading GoldenGate from 11g to 12c, 18c, 19c and troubleshoot the several issues on GoldenGate using ggserrorlog, using log dump utility. Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate.
• Configure and build heartbeat monitoring in GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts.
• Experience in Metadata Modelling at three layers (Physical, Business and Presentation) using the Oracle BI Administration in OBIEE
• Performed EBS R12 platforms migration from AIX to Oracle Linux
• Monitored databases performance using Oracle Enterprise Manager (OEM) 11g,12c Grid control.
• Implemented ASM on RAC and stand-alone databases, managed disk groups with ASM.
• Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.
• Used Different RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OS Watcher, Srvctl and Crsctl and resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Expertise with EXADATA(X5-2) RAC and having good Experience with Oracle for Exadata or Database Appliance hardware issues. Expertise in Oracle for Exadata.
• Worked on single Command configuration on Exadata Machines. Knowledge to support Oracle Cluster machines using ZFS Shared Storage Subsystem.
• Extensively worked on Enterprise Data Warehouse (EDW) to ensure that Extract Transfer and Load (ETL) processing was completed. Participate and assist in meetings as a member of the Data Warehouse team and completed tasks in specified sprints.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Use Oracle Metalink Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support.
• Developed UNIX shell scripts to monitor various events in the database and also to maintain and cleanup oracle generated files/logs.
• Monitoring Locking Activity/Long Running Transactions/Temp issues/UNDO Issues/RMAN Backup Issues/Tape Issues/DR Recovery Issues/monitor ORA errors like ORA-7445 and ORA-600 and apply patches if required or contact Oracle Support for Additional Information (by raising SR) Replication Maintenance.
• Generating Weekly Adhoc reports. Tasked to complete Adhoc & weekly data requests for a variety of quality assurance processing.
• Provided on-call support 24x7 for any issues with system by receiving text messages when an issue arose and logging in remotely to resolve those issues.

Environment: Oracle 19c,12c,11g, Oracle Exadata X5-2, X6-2, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, Oracle ZFS NAS, RAC11gR2, 12c, 19c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL GoldenGate, Linux 5.8, Sun Solaris, Red Hat Linux, RMAN, SQL server, DataGuard, GoldenGate, OEM, Grid Control, STATSPACK, AWR, Exports/Imports, Oracle-Wallet-Management, WebLogic server, Fusion Middleware, PL/SQL Tuning, Data Pump, Business Objects, putty, TOAD 11.6.

Confidential - Boston, MA

Senior Oracle Database Administrator

Responsibilities:

• As an Oracle DBA, Supported Educational Testing Center by implementation of High Availability solutions with Oracle 11g RAC, Standby Database (Active DataGuard) to ensure high availability, data protection and disaster recovery for enterprise data.
• Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database.
• Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.
• Implemented and Installed Level 3 OEM Cloud Control 12c on Linux machine. Installed WebLogic server 10.3 during the Installation of Cloud Control 12c. OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Supported University systems with Ellucian Banner ERP systems within and outside of the organization. Upgraded all databases from 11.2.0.4 to 12.1.0.2 using Banner application in Oracle Databases by following Ellucian schedule.
• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Configured RMAN backups using NetBackup and DDBoost, Experience in backup and recovery. Cold backups, Hot backups, Logical backups, RMAN backups performed at different levels of Full backup, Incremental backup, Differential backups, Cumulative backups.
• Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 12c platforms.
• Missing archive log scenarios in Dataguard environment resolved by restoring archive logs from backup and incremental backups through RMAN
• Implemented the DataGuard with delay shipping of the archive logs in order to avoid the logical corruption on the physical standby database.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of upgradation and migration.
• Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Expertise in upgrade process from 10g to 11g and 11g to 12c and data migration using Expdp and Impdp. Identified and fixed the logical block corruption using RMAN & logical backup using Data pump Expdp and Impdp Utility.
• Knowledge in Oracle Retail suite of Merchandising and Store level applications such as RMS, RPM.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performed cross platform migration of databases from IBM - AIX, Solaris, HP-Unix to Linux 11g using RMAN, FLASHBACK and Data Pump.
• Worked with developers on preparing, testing and deploying application releases to non-production and production environments.
• Worked closely with application and development teams to resolve production issues. Created database services for different applications. Applied one-off patches to fix problems, upgraded Grid and RDBMS software to higher versions.
• Configured AWS EC2 redshift Instances using AMIs and launched instances. Created highly available and scalable infrastructure in AWS cloud by using various AWS services like EC2, VPC, RDS.
• Participated in installation and support of Oracle Financial Accounting Hub (FAH) application.
• Attended Developer’s code review meetings and Iteration meetings made recommendations to improve Efficiencies.
• Expertise in optimizing SQL queries by reading Explain Plan Statistics, developed backend interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Upgraded the Oracle 11g database to 12c version and also applied patch set and interim patches whenever required to make the database software up to date.

Environment: Oracle 11g/12c,BANNER-ERP,DataGuard, ASM, Banner, Oracle Enterprise Manager(OEM) Grid Control 12c, 11g, GoldenGate, RMAN, RemoteNG, Putty, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris.

Confidential

Oracle Database Administrator

Responsibilities:

• Production Support DBA, Configured and tested Replication using GoldenGate where Source Database on Sun Solaris 10 SPARC 64 bit with Oracle 11g and Target Database on Linux with Red Hat Enterprise Linux Server release 5.4 with Oracle 11g Database with 2 node RAC on ASM.
• Installed and configured Oracle spatial database application simulating a system to keep track of all the transport services, for department of transportation and performed backup files, point in time recovery and remote backup of spatial databases.
• (SAN/NAS). Used Oracle utilities like IO Calibration to understand the response time of storage and report to SAN if response time is more.
• Deployed agent and implemented GoldenGate plugin in the OEM to monitor the GoldenGate.
• Configured integrated replicat by converting the classic replicat to improve the performance of the process in the GoldenGate.
• Adding a new node to RAC cluster and installed Oracle RDBMS software on new node of cluster and created ASM volume using ASMCA and created ACFS for GoldenGate 11g.
• Divided replicated tables among multiple GoldenGate processes to speed up performance.
• Troubleshooting typical Oracle GoldenGate technical problems such as unique key violation long transaction abending by using GGSCI, Logdump, discard file analysis etc.
• Installed configured and maintained databases on high availability systems like DataGuard and Real Application Cluster environments. Setup and maintain Oracle DataGuard (Physical) with Fast Start Failover, Active DataGuard.
• Configured Oracle DataGuard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing.
• Setup multiple DataGuard Setups (DataGuard Broker-DGMGRL) for 2 Node 11g RAC Clusters.
• Managed the centralized storage technologies including the various SAN and NAS environments.
• Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11g on ASM and performing health checks on RAC using SRVCTL and CRSCTL.
• Extensive experience with Database Cloning and Refreshing pre-prod databases.
• Managed and monitored the Oracle Real Application Cluster running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Worked closely with system administration and network teams to ensure standard and consistent platform, storage provisioning and configuration. Apply patches and bug fixes. Design and implement new functionality. Converted standalone databases to RAC.
• Using Oracle Data Pump utility and performed Database Migration and Upgradation of databases.
• Developed Recovery Manager (RMAN) scripts for database backup and recovery for hot and cold backup options for both RAC and standalone instances.
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
• Worked on analyzing database objects, creating indexes, creating materialized views, Store Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.
• Worked with Informatica Data Replicator (IDR) tool during Extraction/Transformation/Loading using Informatica Power Mart/Power Center with flat files, Oracle, Exadata and Teradata. Good understanding of ETL/Informatica replication. Worked with Informatica developers to export utilities in Exadata.
• Implemented advanced features of Oracle 11g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning
• Worked on Database backup options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups and data transfer using Data Pumps and Export/Import utilities.
• Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.
• Good Knowledge in Installing, Configuring, Upgrading MySQL 5.0/5.6/5.7 databases running on OEL
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Maintenance: Setup cron jobs to monitor database status and to alert on-call DBA, to backup databases, to monitor space usage, and to generate status reports. Refresh non-production databases using Oracle export and import, using RMAN restore and recovery. Provide 24/7 general database support.
• On-Call 24x7 DBA support for production databases.

Environment: Oracle 11g RAC& 11g RAC, SAN/NAS, OEM Grid Control, Sun Solaris, HP-UX, RHEL, MYSQL 4, 5, Windows 2000/XP, MYSQL, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.