PROFILE:

• Hold over 8 years of Oracle database administration and related experience with extensive knowledge and proficiency in Oracle 10g, 11g and 12c database design, administration and systems analysis within financial, healthcare, logistics and insurance institutions.
• Excellent communication skills and a great team player with a fast learning curve.
• Work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases.
• Possess great attention to detail and the ability to maximize system resources; skills which are beneficial in the following areas:
• Capacity Planning
• New database builds and Refresh.
• DB Creation, Configuration, Upgrade, Patching and Migration.
• RDBMS data loads into Oracle tables using ETL tools
• Oracle Virtual Machine(OVM) for testing.
• Backup and recovery using data pump and RMAN.
• Remote database access using RSA - VPN
• Monitoring and Performance tuning using OEM Grid Control.
• Database integrity and Advanced security implementations.
• Troubleshooting and shell scripting
• Oracle High Availability involving Oracle RAC, Golden Gate and Dataguard exposure.

HARD SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1, Linux Enterprise Server, and Windows

RDBMS: Oracle 10g, 11g and 12c, MS SQL Server, MySQL

Languages: SQL, PL/SQL, Shell Scripting, RStudio

Tools: Toad, Putty, WinSCP, FileZilla, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: Oracle Enterprise Manager (OEM), Real Application Cluster (RAC), ASM, Transportable Tablespaces, RMAN, SQL*Plus, SQL*Loader, Data Pump, Golden Gate, Data Guard, TKPROF, Explain Plan, Statspack, AWR, ADDM.

PROFESSIONAL EXPERIENCE:

Confidential, Plymouth, MN

Oracle Database Administrator

Responsibilities:

• Used Oracle Enterprise Manager (OEM) for database monitoring and performance tuning.
• Installations of Oracle databases on Linux OS and analyzed SQL statements, reorganize database objects and designed indexes.
• Performed day to day database administration tasks like database creation as well as working on projects such as upgrades (from 9i, 10, 11g to 12c) and patching.
• Applied Oracle quarterly patches to non-RAC and RAC configured databases.
• Performed data and metadata migration from legacy servers to newly installed servers using Data Pump, Transportable Tablespaces, RMAN.
• 24x7 remote support and on call Database support using RSA-VPN.
• Ensured standby databases are always in sync with production databases.
• Managed users’ privileges by creating, roles, profiles, schemas, passwords.
• Performed SQL tuning based on reports generated by SQL Trace, ASH, AWR, Explain Plan.
• Monitored and conducted database health checks on daily basis using SQL developer.
• Performed Dataguard switchover as required for maintenance.
• Cloned production databases as needed for testing and development.
• Planned and performed daily Backup and Recovery using RMAN.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Created tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Utilized ADDM and AWR for performance tuning; diagnosing key problems such as expensive SQL statements, I/O performance issues, locking and concurrency issues, excessive parsing, resource bottlenecks (including memory and CPU bottlenecks) and recommending solutions.

Confidential, MN

Oracle Database Administrator

Responsibilities:

• Revised the Backup/Recovery Strategy Manuals/SLAs to implement Block Change Tracking, Parallelism and other RMAN features, significantly reducing Backup and Recovery durations by over 80%
• Performing Online and Offline backups (physical and logical) using RMAN and DataPump
• Drastically improved the performance of SQL Queries by about 90% through the use of appropriate Indexes and Optimization methods
• Proactive Performance Monitoring Reactive Performance Tuning
• Database Cloning/Replication and Refreshes using RMAN, Data Pump and Scripts/SOPs
• Implementing database security and management of users via Roles, Privileges, Profiles and enforcing the Triple A’s
• Encrypting sensitive database tables/columns/tablespaces using TDE
• Linux/Bash Shell Scripting
• Documented protocols for Migration of data/databases
• Occasional simulation of critical files corruption and/or data loss scenarios and how to recover with minimal MTTR
• Application of Oracle Patches (PSU, SPU/CPU, Bundle and Interim Patches) using Opatch Utility
• Installations and Upgrades of Production and Non-Production Databases
• Worked in a cross-functional team that oversaw the Oracle 10g & 11g RAC installation using ClusterWare and ASM
• Installed and configured Data Guard and Broker for High Availability (HA), Disaster Recovery(DR) and seamless Switchover/Failover
• Providing 24/7 (On-call) Production support as needed in both Development and Production databases ranging in sizes from 80GB to 25TB
• Cross-functional team collaboration
• Documentation of activities/procedures and generation of reports as per company policies
• Participated in all phases of the System Development Life Cycle (SDLC) See less

Confidential, White Bear Lake, MN

Oracle Database Administrator

Responsibilities:

• Performed database logical backups using Data pump.
• Oracle installations, upgrades, instance configuration, maintenance and troubleshooting.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Performance tuning and Monitoring using Grid Control database and managing instances using OEM.
• Worked with other IT teams to address issues specific to the database/application interaction to support functionality and maximum performance and to ensure proper backups of all Oracle environments
• Worked with developers on constructing effective PL/SQL programs and packages.
• Cloned, patched and implemented upgrades and migrations,
• Performed Point-in-time recovery as well as cancel based recovery
• Created and administered privileges, roles and profiles.
• Managed database auditing
• Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking
• SQL tuning and database performance tuning using explain plan and SQL tuning advisor.
• Used statistics generated by AWR, ASH, ADDM reports to monitor and tune the database.
• Planned and scheduled backups and restore strategy, performed logical as well as physical backups.
• Established automation of repetitive processes to minimize errors using scripts and OEM.
• Supported application developers in planning, load analysis, and backup and recovery of data.
• Applied quarterly PSU and CPU patches.
• Maintained up-to-date documentation of all Oracle environments.