Oracle Database Administrator
I am an enthusiastic technology professional with in-depth experience as an oracle database administrator. I have supported thousands of users on both development and production environments. I am very comfortable working on Oracle database versions 10g, 11g and 12c. Some areas of my specialization include Installation and configuration, Database upgrades and patches, backup and recovery, performance tuning, security, database cross-platform migrations, RAC, Dataguard and Golden Gate, PL/SQL.
GE Healthcare - Richmond, VA
April 2017 – Present
Oracle Database Administrator
Installation of oracle 11g and 12c databases in production, development and test environments depending on project requirements.
Oracle HA Stack: Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.
Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC)
Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems
Upgrade DBs from 184.108.40.206 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
Applying upgrade patches, maintenance and interim (Opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production on a regular basis.
Creating and assigning appropriate roles and privileges to users depending on the user activities.
Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 10G to 12c.
Scheduled RMAN backups, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab.
Defragmentation of tables and indexes for improved performance and effective space management.
Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
Monitored and troubleshooted database issues with OEM grid control.
Built physical standby using RMAN Active duplication method as well for Disaster recovery site
Very comfortable in using ASM for creating diskgroups, adding additional storage (Disks) and troubleshooting ASM issues.
Setup the unidirectional replication on oracle 11g databases using Goldengate.
Monitoring and troubleshooting the gaps between source and target databases configured with Goldengate.
Successfully upgraded the databases from 11g to non CDB 12c.
Successfully migrated 12c Non CDB databases to pluggable databases.
Created Oracle Wallets and implemented Tablespace level TDE security.
Managed Database Maintenance Activities to achieve optimum database uptime.
Configuration of Listener and Tnsnames.
Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Windows, Linux Redhat)
Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle to meet the expansion needs of the company.
Experience in designing and configuring high-availability systems using DATA GUARD with physical standby effectively configured and used Data Guard Broker utility.
Successfully migrated Oracle databases to EXADATA using Golden Gate and switchover to EXADATA
Performed logical backups using Export/Import and Data Pump
Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, SQL Analyze, ADDM, AWR reports etc.
Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases
Administered databases of various sizes from 200GB to 6TB
Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
Designed Logical and physical database for business transaction functionality.
Provide production support for the deployed project till it is stabilized.
Fresenius Medical Care - Lexington, MA
May 2013 – April 2017
Oracle Database Administrator
Performed Installation and configuration of Oracle 220.127.116.11 database on Linux platform.
Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Supported off-hour on call support for database related issues.
Created logical and physical design installed and upgraded databases.
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 11gR2.
Configured Data Guard on both standby and primary for 15 production databases.
Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
Hands-on experience for various performance tuning issues using VM sphere client.
Monitored databases of size ranging from 80GB to 7TB
Experience in working with virtual machine and oracle virtual machine (OVM).
Experience in migrating from multiple Oracle 11gR2 database to oracle 12cR1 on virtual machine.
Hands-on experience in taking snapshots and rebooting the server's and performance monitoring for Oracle databases in virtual machines.
Experience in adding and expanding the disk volumes to oracle servers on virtual machines.
Experience in installing oracle software and creating standalone databases on virtual machines.
Hands-on experience in working with virtual machine under different operating system like Linux, sun Solaris and windows.
Setup RMAN solutions for all Oracle Databases -- provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
Applied patches 18.104.22.168 and 22.214.171.124, 10.2.0.4.
Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
Used EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Maintained the data integrity and security using integrity constraints and database triggers.
Provided 24X7 support for all the production and development databases.
Master’s in Business Administration (In-view)
Bachelor’s Degree in information technology 2006
Oracle Database 12C Administration Certified Associate (OCA)
Oracle Database 12C Fundamentals
Scrum Master Certified