Candidates About

Summary

Over 8+ years of professional experience as an Oracle Database Administrator in providing 24/7 Production support which includes installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation. Expertise in different High-Availability techniques like configuration of RAC, Data-guard, replications using GoldenGate in standalone and HA environments. All my experience & knowledge has been gained across the major Oracle database versions (12c,11g,10g and 9i) and a wide range of operating systems (Linux, Sun Solaris, and HP-UX & AIX). I have been exposed to a wide range of technologies and developed a broad set of technical skills and a very strong background in Oracle Database on multiple flavors of UNIX operating system and Windows OS.

Education
Bachelor of Technology (Computer Science Engineering) JNTU, HYDERABAD, INDIA.

Certifications

Oracle Certified Professional (OCP) - Oracle Database 12C Administration.

Key Strengths

·         Handful of experience in Oracle Installations, Upgrades, patching in various environments ranging from 9i to 12c and providing 24/7 production support to various clients.

·         Oracle DBA support, applying patches and maintenance packs, upgrades, multi-tier installations, automatic routines DBA task, periodic refreshes, oracle support dealing with functional, developers and end users.

·         Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

·         Managing oracle databases in a EXADATA environment

·         Installed, validated and deployed Exadata X2-2, X3-2, X4-2 and X5-2 quarter, half and full rack.

·         Extensive experience in DBA activities including schema/user management, space management monitoring on Oracle.

·         Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.

·         Extensive experience and sound knowledge in performance tuning and application of implementing on development, QA production environments also trouble shooting database related problems in Oracle.

·         Refresh and Clone databases using RMAN and export/import/Data Pump methodologies on Databases Administration Also Configured Data Guard/replication replicated db's on Oracle.

·         Deep knowledge of Oracle 11g/12c Grid Infrastructure, Cluster ware, ASM, RAC internal, Active Data Guard in RAC environment.

·          

·         Configuration and maintenance of 11g/12c RAC with Dataguard setup for High Availability and Disaster Recovery(DR) purpose.

·         Configuration and Management of Dataguard 10g/11g/12c on RHEL, OEL and Sun-Solaris for Disaster Recovery.

·         Configured Physical Standby for Production databases and converted Physical standby to snapshot Standby and configured ACTIVE data-guard.

·         Proficiency with Installation and maintenance of replication tool Golden gate and troubleshooting lag issues.

·         Extensive skills in configuring Unidirectional, Bi-directional(active-to-active) Oracle Goldengate Extract/Replicat   for   multiple databases.

·         Strong experiences in configuration and building heartbeat monitoring in Oracle Goldengate. Develop flexible home-cooked Korn scripts to monitor the Goldengate lags.

·         Performed Upgradation/Migration of databases from lower version (9i/10g/11g) to higher version (11g/12c).

·         Extensive Experience on taking the logical backups of data using oracle DATAPUMP utilities expdp and impdp, also cross platform Data Migration using expdp and impdp utility

·         Implemented RMAN Backup and Recovery, Incomplete Recovery and disaster recovery(DR) using Data guard.

·         Have good experience in migrating data from Solaris, HP-Unix to Linux.

·         Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c.

·         Performed Zero-Downtime migration from AIX to RHEL and vice versa using Expdp and Goldengate and process improvement for Golden gate by proactive monitoring using Shell scripts.

·         Worked on disaster recovery, Database backup concepts such as user-managed backup, RMAN-managed backup with or without recovery catalog, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.

·         System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.

·         Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time media recovery, full/partial recovery.

·         Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery. 

·         Database refresh from production to QA, development and testing environments.

·         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.

·         Installation and configuration of Oracle Enterprise Manager Cloud Control 12c/13c.

·         Expertise in installation, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

·         Extensive knowledge in configuring TDE (Transparent Data Encryption) and SSL Authentication for Data Security and Authenticity of users.

·         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.

·         Extensive knowledge in configuring TNS service for remote database connections and resolving issues related to TNS and listener services.

·         Installation of Oracle Apex Application from Scratch including documentation, design and implementation of rich user interfaces using Oracle Apex.

·         Experience on PCT values at Block level to avoid row chaining.

·         Performance Tuning, Capacity Planning, database cloning and patch management.

·         Experience in SQL Tuning, SQL Optimization, cost-based optimization and Hints.

·         Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.

·         Experience in Shell Scripting for automated startup/response of RMAN backups and performance issues with the database.

·         Ensuring user security/database maintenance according to SOX, HIPAA and PCI compliance.

·       Extensive knowledge of server level Storage technology such as Disk RAID, oracle ASM, SAN and NAS.

·         Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

·         Using UNIX utilities to identify the system performance at various levels like I/O usage, Network response, memory and CPU utilization.

·         Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

·       Experience with different tools monitoring software and worked on Enterprise ticketing systems like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.

·         Extensive experience in providing 24x7 on call support for Test, development and production databases.

 

Technical Skills

 

Operating Systems	Red Hat Linux RHEL 4.x, 5.x, 6.x,7.x, HP-UNIX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.x,6.x,7.x
RDBMS	Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC), ASM, MySQL, SQL SERVER 2008/2012
Storage	Oracle ASM, Open Filer
Tools	RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC, Export/Import, Datapump, Data-Guard, Erwin, OEL, Log-miner, APEX, MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab.
Languages	SQL, PL/SQL, UNIX Shell Scripting.
Tuning Tools	TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR
Administration	Unix Administration, Oracle Administration
Terminal Emulation	Putty, Telnet, FTP, TOAD

 

 

Professional Experience

 

Client: Novartis, Fort Worth, TX                                                 Aug 2016 – Till Date

Senior Oracle DBA

 

Environment: Oracle 12c/11g/10g, RHEL 5/6/7, OEM, RMAN, Grid, Data guard, ACFS, RAC, ASM, Golden Gate, TOAD, APEX, SQL*LOADER, Performance Tuning, Exports/Imports

 

Responsibilities:

 

•         Administered/monitored over 1500 databases on 10g/11g/12c on prod/test/dev environments with database sizes ranging 5GB to 50TB.

•         Performed installation and maintenance of 2 node and 3 node Oracle 11g/12c RAC with Physical Standby on IBM-AIX and Linux platforms with Dataguard Broker.

•         Worked on Data Guard Broker configuration for 2 node RAC with Physical Standby Environment and performed Switchover operations using DG Broker.

•         Upgradation/Migration of databases to 12c from 10g/11g including 2-node RAC with standby Database and Standalone databases.

•         Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, cluster and system management.  

•         Engineering, implemented, documented and support builds of new clusters to use Oracle 10g/11g/12c RAC on HP-UX and Linux.  Including installing cluster ware, ASM (and shared disks) and creating new databases.  

•         Utilized raccheck utility to diagnose CRS, ASM and RAC database setup issues.

•         Worked on 11g/12c cluster maintenance using CRSCTL and SRVCTL Utilities for Oracle 11g/12c RAC environment, resolving issues related to OCR files and VOTING DISK administration.

•         Configuration and administration of full rack Exadata databases.

•         Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.

•         Upgradation of Oracle Goldengate from 11g to 12c in Exadata machine environment design Goldengate HA solutions by using Oracle 11.2.0.4 Cluster ware functionality.

•         Resolved smart scan performance problems, like passthrough mode and selective fallback to block IO with Exadata Snapper

•         Performed SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.

•         Developed and implemented Exadata software patches across all components of Exadata database Machine

•         Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

•         Created and maintained physical, logical and snapshot standby databases for Disaster Recovery(DR), near real-time reporting, load-testing and production database backup.

•         Initiated media recovery, Instance and crash recovery using RMAN and performed Database point-in-time recovery and Tablespace Point-in-Time Recovery (TSPITR).

•         Monitored DR (Data Guard) sites and resolved issues related to connectivity and "log shipping" to failover site.

•         Worked on resolving Archival GAP (DG Sync) in Data Guard Environment and ensuring Standby and Primary are in sync.

•         Implemented Disaster Recovery on 10g/11g/12c Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

•         Prepared Root-Cause Analysis(RCA) Report for Failover and Switchover issues and worked on issues related to Automatic Switchover.

•         Restore and Refresh of database/schema’s using RMAN and Data pump utilities.

•         Extensively used data pump/Goldengate for cross platform (Linux to AIX, AIX to Linux and AIX to windows) data migration at table, schema and database level.

•         Configuring and troubleshooting issues related to Extract, Replicate and Pump for Golden Gate 11g/12c replication.

•         Configured Active-Active replication on various platforms.

•         Upgrading Goldengate from 11g to 12c and Expertise on Oracle Goldengate and troubleshoot the issues related to GoldenGate independently.

•         Configured error handling for Oracle Goldengate restart, logging, production support and status reporting.

•         Used Log Dump Utility to Investigate data on the trail and defgen to create definition files used for replication.

•         Configuration and built heartbeat monitoring in Oracle Goldengate. Developed flexible home-cooked Korn scripts to monitor the Goldengate lags.

•         Weekly Data Refresh/Restore from Production to Development and Test environments using data pump export/import.

•         Generate and interpret Automatic Workload Repository (AWR), Active Session History(ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.

•         Created ASM volumes using asmca and Created ACFS for Golden Gate v12.

•         Developed data models, SQL Queries, SQL Query tuning process and Schemas.

•         Experience on PCT values at Block level to avoid row chaining.

•         Performance Tuning, Capacity Planning, database cloning, and patch management.

•         Worked on Oracle server and storage configuration with Storage Pool, RAID, ASM and space management.

•         Storage array configuration and administration with RAID, ASM, DM-Multipath.

•         Applied Patches in standalone and golden gate environments.

•         Database Refresh activities, Database movement from one machine to another.

•         Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.

•         Monitoring Day-to- Day Backups, Log’s and recovering them as per the requirement.

•         Registering database in recovery catalog for backups and resolving issues related to scheduled backups.

•         Taking incremental, cumulative backups using RMAN and scheduling database backups using Crontab.

•         Installing Oracle Enterprise Manager OEM 11g/12c/13c Grid Control GC for various database activities like monitoring Target databases servers, scheduling jobs, monitoring performance issues, implementing suggestions and setting up alerts.

•         Installation and configuration of Oracle Enterprise Manager Cloud control 12c/13c on RHEL and upgradation from 11g to 12c/13c.

•       Ensuring user security/database maintenance according to SOX, HIPAA and PCI compliance standards.

•         Configured TDE (Transparent Data Encryption) and SSL Authentication.

•         Configured Oracle Advanced Security to implement Transparent Data Encryption at table space level, table level and column levels. Also configured Redaction using OEM’s Policy expression builder.

•         Configured TNS services for standalone Databases, also resolving issues related to TNS and Listener services.

•         Data masking of sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER and enabled oracle vault features from OEM.

•         Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

•         Implemented Flashback Technology, Table, Drop and Database to undo specific transactions, recovered database objects and flashback entire database to a desired time.

•         Developed and maintained operational and system level documentation. Developed applications using Oracle Application Express (APEX).

•         Worked with Oracle Support Mechanisms like My Oracle Support (Metal ink) and Raising Service Requests.

 

 

 

Client: Renaissance Venture Capital Fund, Ann Arbor, MI        July 14 –  May 16

Senior Oracle DBA

 

 

Environment: Oracle 10g, 11g,12c RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Exports/Imports

 

Responsibilities:

 

•         Worked on Configuration, maintenance and troubleshooting of Oracle 10g/11g/12c RAC and Standalone databases on various platforms.

•         Administered and monitored over 500 databases on 10g/11g/12c on prod/test/dev environments sizes ranging from 5GB to 10TB.

•         Supporting/monitoring 3-node Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities

•         Designed, implemented and supported highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options. 

•         Tuned SQL queries of Oracle RAC databases, Implemented the database with ASM and SAN storage skilled towards database tuning

•         Migrated databases from File-system to Automatic Storage Management (ASM).

•         Involved in migrating applications from Solaris 10g/11g to Linux using Transportable Tablespace, RMAN Convert.

•         Upgraded 10g RAC database to 11gr2 RAC databases

•         Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments from MS SQL Server to Oracle Exadata.

•         Duplicate all the non-production databases on Exadata server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC Hybrid Columnar Compression techniques.

•         Successfully setup and managed oracle Data guard on Exadata utilizing multiple networks for redo transport.

•         Upgradation of single instance databases from 11.2.0.1 to 11.2.0.3 and 12c on various environments.

•         Responsible for using Flashback query mechanism along with automatic undo management.

•         Experience in Creating Physical and logical database design Data Models using ER Studio.

•         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.

•         Worked on Active data guard, Fail over and Switch over cases.

•         Performed several quarterly CPU PSU patches on multiple databases.

•         Created Oracle Tables, Table Partitions, Views, and Materialized Views.

•         Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.

•         Worked on database security, Transparent Data Encryption, Created tables with Encrypted Columns and Managed Encryption Keys

•         Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.

•         Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.

•         Monitoring and supporting day today activities of the production and development databases and work on urgent issues when fired by pager and Creating Custom Concurrent Managers and Assigning Work shifts to it and Finding long running requests and sessions terminate them if needed.

•         Creation of Users and granting them the required Roles and Privileges accordingly

•         Cloned schemas, objects and data on new server using Data pump utility

•         Decreased Contention by reducing the Wait Events as a part of Performance Tuning.

•         Building and implementing backup and recovery using Recovery Manager RMAN, RMAN scripts and customized shell scripts on Oracle 11g data pump export/import for data transfers between various Oracle environments and for logical backups.

•         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.

•         Develop stored procedures, functions and business logic in PL/SQL to support in-house database applications and websites.       

•         Responsible for all database activities such as User management, space management, database security management, rollback segments& creation of DB links between oracle servers

 

 

 

Client: Bremer Bank, Eau Claire, WI                                                 Aug 11 – May 14

Senior Oracle DBA

 

 

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN,