SUMMARY:

• Experienced in Oracle 18c, 12c, 11g R1, 11g R2 installations, upgrades, migration, configuring logical/physical architecture, SQL, Performance Tuning, database access and Security and auditing
• Highly experienced in Oracle 18c 12c, 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs and OCFS2 file system.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Hand on experience in cloning the non - multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN
• Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.
• Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control

TECHNICAL SKILLS:

HP: UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c, 18c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: OEM, TOAD, SQL DEVELOPER, SQL LOADER, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, Toad, Putty, NX client Windows, WinSCP, UNIX, LINUX, AIX.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, RMAN, Data Pump, Export, Import

WORK EXPERIENCE:

Confidential, Minnesota

Oracle Database Administrator

Responsibilities;

• Installed and configured software for 11g, 12c and 18c on both Windows, Linux & UNIX platforms using Oracle OFA.
• Championed database migration from 10g to 11g & database upgrade from 11g to 12c using the Oracle Data pump & DBUA respectively.
• Improved Performance of queries by 80% - execution time drastically reduced from 20 minutes to 2 minutes using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports, ADDM and explain plan, maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics, and won accolades from managers and executives (Database sizes range 100GB to 22TB)
• Revised & implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Applied block change tracking (BCT) which reduced the backup time from 8hrs down to 45mins.
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events and took appropriate action following the company’s.
• Carried out day to day administration (backup, restore, recovery, troubleshooting), installation, configuration and implantation of Oracle EBS (E-Business Suite 12.2.5) to air ticket, automate business processes and application systems resulting in lower risk high saving long term results with closed lope system.
• Installed and administered Oracle Physical Standby Database for single & multiple instances to achieve high availability & DR solution (DATA GUARD)
• Partnered in the installation and configuration of 11g Real Application Clusters (RAC) / ASM on Red hat Enterprise Linux 7.3
• Worked extensively on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Applied table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using OPatch utility to install, test, and deploy patches to all database instances
• Revised Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables, and Tablespaces. I also implemented the “triple A” (AAA) and database auditing policies as well as data reduction
• Cloned databases using RMAN and DATAPUMP utilities for all database sizes
• Performed database Refreshes from production environments
• Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.
• 24x7 remote and on-call Database support for Database developers & end-users.
• Create standard operational procedures (SOPs) to ease operational support.

Confidential - Maple Grove, Minnesota

Oracle Database Administrator

Responsibilities:

• Daily database administration tasks including scheduling backup, verifying night backups and recovery through RMAN.
• Installation, configuration, maintenance, and tuning of Oracle 11g and 10g on Linux (Red Hat).
• Successfully migrated Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7).
• Worked as a part of a team in Data Center Migration for four months.
• Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development, and implementation.
• Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
• Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security-related tasks including Transparent Data Encryption.
• Used range, hash and composite table partitioning which substantially decreased the DB down time and SQL Execution time. Performed instance tuning by changing init. Ora parameters and managed region parameters such as shared pool size and db cache size with the use of Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM).
• Configured Oracle tools like SQL*Net to access the database across the network
• Configure and manage ASM instances on Oracle 11g.
• Worked in a cross-functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
• Expert in working with PL/SQL including Procedures, Functions, Cursors, and Triggers.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using OPatch utility to install, test, and deploy patches to all database instances
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.
• Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture
• Executed PL/SQL errors fix and modified the applications using PL/SQL
• Performed migrating database objects from development through test and into production environments using Golden Gate.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces, and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.