SUMMARY

• Over 10 plus years in Oracle Database Administration including 10g, 11g,12c,18c and 19c. Created and configured Oracle RAC 19c databases on two node clusters.
• Experience maintaining Exadata.
• Managed databases on Linux, Solaris, Windows, AIX and HPUX.
• Build RAC Clusters.
• Build Disaster Recovery sites using Oracle Data Guard. Recently migrated 11g and 12c database to another data center using Oracle Data Guard feature with a minimal downtime.
• Installed and configured databases using silent install, OMF and via scripts.
• Has extensive knowledge in dynamic views and dictionary tables.
• Applied CPU and PSU patches.
• Extensive experience in OS space and table space management.
• Worked on database security and Fine Grain Auditing.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Extensive experience in backup and restores using RMAN
• Managed databases on Exadata and Golden Gate.
• Cloned databases using RMAN duplicate and used Data Pump for object level refreshes.
• Excellent Experience in installing and maintaining Oracle Data Guard to implement physical Standby Database for Disaster Recovery in 10g, 11g, 12c,18c,19cand Providing Critical Solutions with DR options
• Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader
• Managed databases using Exadata.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Build 4 - node RAC cluster on RHEL, OEL
• Setup DR using Oracle Data Guard.
• Extensive experience in Oracle Partitioning.
• Extensive experience in Oracle ASM and ACFS
• Worked on 12c Cloud Control
• Worked on 11g Grid Control
• Applied CPU, PSU and one off patches.
• Analyze application activity, tuning the particular data caused for poor performance
• Installation of Oracle Databases on Standalone and RAC cluster.
• Data Guard setup with Primary and Standby Databases.
• Strong Oracle RAC Installation, Configuration and Tuning Skills on RAC and Solaris
• Clone databases using RMAN duplicate database
• Extensive experience in RMAN restore and recoveries.
• Good replicating experience using Materialize Views.
• Worked on setting up Data replication using Oracle GoldenGate
• Strong SQL skills to perform the data base operations
• Very familiar with Oracle Dictionary Views.
• Experience with configuring/administering Exadata environments.
• Implementing, configuring, and hands-on support on Oracle Exadata
• Worked on many export import and Data Pump tasks.
• Used Shell scripts to automate jobs.
• Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
• Experience with configuring/administering Exadata environments.
• Implementing, configuring, and hands-on support on Oracle Exadata
• Disk space monitoring and Database availability.
• Physical database design, Logical database design, normalization, de-normalization
• Set up Oracle GoldenGate unit-directional and Bi-directional setup.
• Familiar with Database security and auditing.
• Setup procedure for Database statistics gathering
• Worked on Upgrade and Migration Project.
• Monitored databases using cronjobs and OEM.
• Written shell scripts to automate tasks.
• Worked with offshore DBA
• Provided on-call support on rotational basis.

TECHNICAL SKILLS

• Oracle Admin
• Database Installation
• Linux Shell Scripting
• Data Guard
• Oracle Exadata
• Storage and Space management
• Performance Tuning
• RMAN 11g 12c 18c 19c
• User
• Role
• Profile management
• SQL / SQL Developer / TOAD
• Patching
• AWS
• Oracle Golden Gate
• Oracle Net
• TCP/IP
• 12c Cloud Control
• Cloud
• RAC Installation
• 12c Cloud Control
• SQL Loader
• Rman
• Performance Tuning
• ASH
• AWR and ADDM
• Stats pack tkprof
• Data guard
• Linux
• OEL
• RHEL and Fedora
• Microsoft Windows 2012
• AIX
• HPUX
• Solaris
• Datapump

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Build 4-node RAC Cluster
• Build and supported Disaster Recovery Site using Oracle Data Guard
• Supported different clients with multi-terabyte databases.
• Installed Standalone and RAC Database Servers
• Migrated databases from non-ASM to ASM Responsibilities include maintaining databases, monitor daily database activity, implement customer requirements, coordination, performance tuning.
• Proficient in maintaining 10g, 11g, 12c, 18c, and 19c databases
• Installed 2 node and 4 node clusters on Exadata
• Migrated databases
• Build Unidirectional and bi directional GoldenGate replication
• Worked closely with offshore DBAs
• Worked closely with Storage Admins to space build ASM database servers
• Designed and Implemented database security using Oracle roles and privileges.
• Maintenance of the RMAN repository database and configuration of backup policies.
• Installed and administered RAC databases.
• Setup monitoring using 11g grid control and12c cloud control.
• Implemented Data Guard for DR purpose
• Implemented Incident rule creation, Mail Server registration, Email subscription from OEM
• Converted the single instance dbs. to RAC clusters
• Worked on instance and SQL tuning
• Written shell scripts
• Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers
• Managed databases on Exadata X5 and X7.
• Good Understanding of Exadata Architecture.
• Proficient in writing UNIX Shell scripts to automate business processes and daily backup.
• Managed databases on the AWS cloud.
• Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation, and different type of storage structure (SAN/NAS)
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Worked and resolved Gaps in standby environment.
• Configuration, troubleshooting Golden Gate issues.
• Setup Uni-directional Golden Gate setup.
• Setup and managed replication using Oracle Golden Gate.
• Setup and Oracle Golden Gate uni-directional and Bi-directional replication
• Applied CPU/PSU patches.
• Worked on Migration project where a data center is moved.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies.
• Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN.
• Monitoring the scheduled backup procedures for daily basis using crontab.
• Build Disaster Recovery sites using Oracle Data Guard. Recently migrated 11g and 12c database to another data center using Oracle Data Guard feature with a minimal downtime.
• Install Oracle 11g RAC with 4 nodes on RHEL platform with ASM.
• Configured & designed and developed the Backup and Archiving, Disaster Recovery in AWS Cloud.
• Monitor database performance using OEM Cloud Control and run ADDM, ASH, AWR reports.
• Experience with Unix Shell scripting, SQL, PL/SQL and upload data using SQL*Loader.
• Migrate Database across different servers and platforms using and Data Pump Export/Import and perform database Refresh and RMAN Cloning.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Data Guard
• Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Stats pack for best performance.
• Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.
• Managed databases on Exadata
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Migration of system from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the OEM in 11g for Performance and maintenance.
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db. console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and
• Used SQL SQL Tuning Advisor and SQL Monitoring.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Build Grid control for Monitoring 400+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies using Data Pump.
• Applied PSU patches.
• Resolves cluster related issues.
• Implemented basic replication through Materialized Views.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Configured Data Guard to provide high availability
• Used RMAN duplicate feature to move/clone databases on Linux, AIX and UNIX.
• Cluster Installation and Configuration, Administering databases in RAC
• Installation, Configure, setup of 11g RAC on Linux.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 11g to 12C and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions.
• Database migration from 9i to 10g to 11g. Then from 11g to 12C R2.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Recovered and clone database using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures specifically in regard to change management.
• Proficient in communicating directly with internal resources on a daily basis,
• Able to work effectively with multiple teams at once.
• Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Monitored database space requirements and adjusted for future needs.