Oracle Database Administrator, Senior

High skilled oracle database administrator with 8 years of experience in oracle database version 10g, 11g, 12c and 19c in development and production environments
I have proactively monitored and tuned system available resources using tools and utilities like OEM, customized scripts, AWR report, ASH, the Explain plan SQL tuning advisor to keep the performance of database systems up and running. Possess complete SDLC knowledge with great working experience on Oracle 10g, 11g, 12c and 19c versions.
TECHNICAL ENVIRONMENT
OPERATING SYSTEMS: Red Hat Linux RHEL 5.x/6.x/7.x, AIX 6.x, MS SQL SERVER, Solaris10/11and Windows 2000-20xx
RDBMS:Oracle 10g/11g/12c/19c
LANGUAGES:SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash Scripting
SOFTWARE/ APPLICATIONS/ TOOLS:Oracle Enterprise Manager (OEM) , Oracle Data Guard, Agents, RAC, ASM, Sql Developer, TOAD, Exp/Imp, DBCA, DBUA, Recovery Manager (RMAN), DataPump (expdp/impdp), SRVCTL, AWS, SQL*Plus, Recovery catalog, Crontab, Golden Gate, Data Guard, TDE, Data Redaction etc.
TUNING TOOLS:SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH, SQL TUNING ADVISOR, ADDM, ORACLE DATABASE REPLAY, SQL ACCESS ADVISOR etc
ORACLE DATABASE
-Golden gate for replication
-Data guard for disaster recovery
-RAC for availability
-Performance Tuning/Analysis
-Testing
-AWS migration
-ASM
-Production Support
-OEM Grid/ cloud control
-Shell Scripting
-Multitenant Architecture
-Installations and Configurations
-Upgrade and Patches
-Database administration
-RMAN (Recovery Manager)
-
-Data pump and export/import
-Transportable Tablespace
-AWR, ADDM, ASH, Explain plan
-SQL TRACE, TK PROF
-SQL Tuning & Access Advisor
MS SQL server
Backup and recovery
Use SSMS
Mirroring
Performance tuning
Upgrade and patching
DATABASE $ SOFTWARE SUPPORTED
Oracle- 10g,11g,12c, and 19c
MS SQL server- 2012,2014
OPERATING SYSTEM
Linux (Red-Hat), Unix, Solaris, Window, Aix
PROFESSIONAL EXPERIENCE
Taylor Farm - Annapolis, M. DJune 2020 - Present
Role: Oracle Database Administrator
-Installation, configuration, Maintenance and Support of Oracle 11g , 12c and 19c RAC Databases
-Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
-Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Data pump and Normal) for restoring the specific objects at the database level.
-Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
-Applying Rolling PATCHING in the RAC environment to enhance availability.
-Refreshing Dev and Test instances with data from Production on a regular basis.
-RMAN point in time recovery and Instance recovery done on 11g.
-Developed compliance reports and performed auditing at higher levels.
-Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
-Experience in UNIX/SHELL scripts for providing the reports and daily production exports.
-Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
-Extensive experience in RMAN recovery testing, RAC and standalone database.
-Experience in setting up Oracle ASM storage for Oracle RAC databases.
-Experience in configuring TDE in 12 and 19c database
-Built S3 buckets and managed policies for S3 buckets and used S3 bucket for storage and backup on AWS.
-Work with other teams conform to various requirements including security and compliance of managed servers.
-Experience in migration from oracle database to AWS
-Extensive experience using SQL trace to trace user sessions
-Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
-Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
-Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDM
-Performing monthly and annual performance reports for trend analysis and capacity planning.
-Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
-Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
-Experience in Oracle Data warehouse DBA skills relating to administration and management environments, Oracle OLTP.
-Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
-Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g and 10g/11g environments.
-Implemented proactive monitoring using EXPLAIN PLAN, SQL tuning advisor.
-Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
-Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
-Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
-Refreshed/cloned databases using RMAN utility.
-Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
-Participated in Disaster Recovery Drills (PHYSICAL STANDBY DATAGUARD) and documented database and application validation steps.
-Participated in a 2 node RAC running on ASM cluster for Availability and Scalability.
Pfizer - PeapackNJ.Jan 2017-May 2020
Role: Oracle Database Administrator
Responsibilities:
-Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases
-Worked as a team member for 24x7 support with on-call rotation in all PROD, UAT, PERF, and DEV environments.
-Install and Manage Oracle Server, Oracle Cluster Server (10g, 11g, 12c, and 19c), RAC/Non-RAC Database Instances and configuration as per the Application requirement and Environment Policies.
- Create, maintain and provide information including updates, and reports on current database configurations to application as/and when required.
-Manage Database File System Management, ASM Disk group, User Management, Change Management, Database Commissioning/Decommissioning, and Data Refresh.
- Expert in identifying, operational issues (such as locking, conflict, latch contention, rollback requirements, etc) for database instances and inform the trend captured to application team(s). Monitor the alerts reported by monitoring scripts and OEM related to Database availability, Performance, Network Connections, and database alert logs.
-Great knowledge in finding the root cause of the problem, resolution, prevention, and recording of details.
-Worked with team to migrate on-prem database to AWS RDS for Oracle using DMS and Oracle Data pump. Setup and Managed RDS instances running on Oracle Standard and Enterprise Edition version 19c.
-Perform Application deployments of New Environments, Install and configure Binary and creating database, Upgrade and database Patching.
Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Data pump and Normal) for restoring the specific objects at the database level.
-Building Oracle Standby databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery also referred as BCP clone purposes.
-Applying Rolling PATCHING in the RAC environment to enhance availability.
-Refreshing Dev and Test instances with data from Production on a regular basis.
-Installed Oracle 11g and 19c on Linux platform using ASM.
-RMAN point in time recovery and Instance recovery done on 11g, 12c and 19c.
-Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
-Experience in UNIX/SHELL scripts for providing the reports.
-Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
-Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
-Extensive experience in RMAN recovery testing, RAC and standalone database.
-Experience in setting up Oracle ASM storage for Oracle RAC databases.
-Performed database replication through Golden Gate.
-Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
-Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
-Worked extensively on Performance tuning by partition, indexing, use of Hints and gather Statistics.
-Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDM
-Performing monthly and annual performance reports for trend analysis and capacity planning.
Employment Type: Full-Time
Salary: $ 120.00 Per Year