SUMMARY

• I have over 7 years of experience as an Oracle Database Administrator. I have worked on Oracle 19c,18c,12c,11g, and 10g versions. My duties include project and production support, installation, configuration, upgrades and patches, performance tuning, cloning, space management, migration, backup and recovery, and database security.
• Excellent experience in managing large - scale OLTP databases and OLAP databases in HA and DR setup.
• Solid experience in oracle database cloning, migration, upgrades, applying patch sets, code reviews, database release and deployments and data centre consolidation activities.
• Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
• Highly experienced in performance monitoring/tuning /troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
• Experience in using transportable tablespace, materialized view, RMAN incremental backup and bitmap indexes in data warehouse environment.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases and Grid Infrastructure.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in configuring, managing, and monitoring both Physical standby and Logical standby database using Data Guard and Have hands on experience on Active Dataguard.
• Extensively implemented Datapump, conventional Export/Import (Oracle 19c,12,11g and 10g) for migration and logical backup of database.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 12c) allowing users to quickly move a user Tablespace across Oracle databases.
• Experience in Oracle Golden Gate 10.x/11.x installation, configuration, and troubleshooting Golden Gate issues.
• Zero downtime migration using oracle datapump and Golden Gate between Oracle 10g,11g,12c and 19c with Linux, Solaris, and Windows platforms.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
• Experience in configuring Golden Gate replication between OLTP to OLTP, and OLTP to data warehousing environments.
• Installed Oracle 11g,12c, and 19c with ASM and OCFS2 File systems.
• Experience in installing and patching Oracle RAC with ASM on AIX, Solaris, and Linux platforms.
• Supported 400+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases and upgraded from 10g to 11g.
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
• Performed conversion of Single Node Instance to multi node RAC with ASM and adding instance to existing RAC.
• Installed and configured 2 node oracle 19c RAC for production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Experience in installation of Oracle RAC with ASM and manage RAC instance using Crsctl and Svrctl utility.
• Involved in migrating production databases single instance to RAC environment.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
• Experience in Upgrading databases, applying patches.
• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
• Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performance Tuning of Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database.
• Experienced in using 10g features like 10g,11g RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Checking and resolving Database corruptions using DBVERIFY utility.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• UNIX Systems Administration - Database and application integration efforts.
• Heavy UNIX shell scripting, CRON jobs

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Linux and window environments.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL)
• Installed and configured 2 node server-side load balancing Oracle RAC 12c, 19c databases on Linux with ASM and Data Guard.
• Production support database on 10g, 11g and 12c versions with standalone and RAC environment.
• Set up user profiles and roles as per the access level of user for the data and application security.
• Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment
• Installation and configuration of Oracle Golden gate.
• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
• Configured deployed and administered 3 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 6.0, using ASM and Raw Devices on Oracle 11gR2.
• Table created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 11g and 19c RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 12.1.0.2.0 to 18.0.0.0.0. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge data centres.
• Installed Oracle 19c on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, AWR, ADDM, ASH, SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 11.2.0.2 to 12.2.0.2 and applying patches whenever required.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases
• 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.
• Worked on both VMS and UNIX environments.
• 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.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Confidential, Washington DC

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, 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 Datapump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Backup/Recovery - Write Rman Backup script as required. Recover corrupted Blocks from Rman backup. Restore backup of 10g on 11g. Involved in Corporate DR exercise. Implement Flashback features. Used backup-based duplication method for 11R2 databases.
• Apply in-place/out-of-place PSU Patch in 11R2. Install bug fix patch.
• Tuning Database using AWR/ADDM/SQL trace. Hands on Various Tuning Advisors. Migrate SQL plans & statistics from QA to PROD. Schedule stats Job using DBMS SCHEDULER. Used AWRSQL/SQL tuning package. Tune various SQL's. Provide Primary investigation on Performance issue to application team in minimal time. Troubleshoot/mitigate various wait events in DB. Tuning of RAC instances and Database.
• 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.
• Performed Database upgrade from Oracle 10.2.0.1 to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Detect corrupted blocks by using DBVERIFY utility.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Implemented table partitioning to improve performance and data management.
• Implemented Security through Virtual Private Database and Fine grained Auditing.
• Developed RMAN scripts for database backup and recovery.
• Designed and implemented the database servers for two new data centres.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Migrated from oracle to PostgresSQL and SQL server databases
• Installed ASM environment and migrated databases from NON-ASM to ASM.