SUMMARY

• Enterprise DBA support utilizing around 7 years of Experience in Oracle Database Administrator, providing 24X7 productions and development support 11g R2 RAC, 10gR2 RAC, 9i databases on different platforms like HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control.
• Worked on 12c Cloud 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 Red-Hat Linux and Sun Solaris.
• Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
• Strong SQL skills to perform the data base operations.
• Intermediate PL/SQL skills.
• Very familiar with Oracle Dictionary Views.
• 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).
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Physical database design, Logical database design, normalization, de-normalization
• Set up Oracle GoldenGate uni-directional and Bi-directional setup.
• Familiar with Database security and auditing.
• Setup procedure for Database statistics gathering
• Worked on Upgrade and Migration Project.
• Collections of performance data for specific time range using STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, and SQL Trace.
• Analysis of Database Wait Events.
• Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
• Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.
• Setup Data Guard.
• Excellent problem solving skills in Data Guard environment.

TECHNICAL SKILLS

• Primary Skills - Oracle Admin
• Database Installation
• Configuration
• Support and Maintenance
• Database Backup and Recovery (RMAN and User managed)
• OEM
• TOAD
• TKPROF
• STATSPACK
• SQL*Loader
• Storage and Space management
• Performance Tuning (Memory management
• SQL Tuning
• Lock etc.)
• Shell Scripting
• User
• Role
• Profile management
• SQL
• PL/SQL Programming
• Project: Upgrade & Migration
• Index Rebuilding and monitoring Usage
• Oracle Net
• TCP/IP
• Oracle GoldenGate Replication
• Additional skills
• Operating Systems
• Windows2008/2012
• RHEL
• AIX
• Oracle Solaris
• HPUX
• Languages
• C
• C++
• Oracle 9i to 12c
• Microsoft SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Oracle DBA

Responsibilities:

• Supported different clients with multi-terabyte databases.
• Installed Standalone and RAC Database Servers
• Completely build RAC from scratch including OS and RAID configuration.
• Build Data Guard
• Worked and resolving gaps.
• Responsible for new 11g database installation
• Upgraded and patched existing Oracle homes.
• Build 2-node 11g R2 cluster from scratch on Linux.
• Build Data Guard.
• Designed roles and assigned permissions
• Responsible to improve the performance by using the Hints, Index, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Automating the backup processes using shell scripts.
• Build RAC clusters and added nodes.
• Table space management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump
• Used exp/imp, data pump and dblinks to move the data
• Worked on standard and enterprise edition of the Oracle RDBMS.
• Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
• Worked on schema Reorganizations for better space management
• Performed Database Refreshes and Database Copies for Development, Test and Production databases
• Installed, Migrated, configured and tested Oracle 9i databases in various environments
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility. applications on varied platforms like Solaris, Windows and Linux Servers
• Migration of system and applications from Oracle 9i to 10g.
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
• Worked with Oracle in troubleshooting issues.
• Worked with Development team in deployments.

Environment: Oracle 10g, 11g R2, RAC, Oracle Data Guard, Oracle GoldenGate

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

• Build database servers.
• Performed Silent installs.
• Ran scripts
• Install database with dbca, scripts and silent install.
• Worked with Sr. DBAs and shadowing them.
• Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
• Helped deploying RAC
• Helped deploying Data Guard.
• Installed Oracle clients on application servers.
• Worked on a faced pace working environment.
• Developed and implemented backup and recovery strategies.
• Developed policies and procedures for system operations to better serve clients.
• Setup Alerts via Grid Control.
• Load Data using SQL Loader from flat files
• Supported developers in running scripts
• Used TOAD to manage databases.
• Worked on SQL Server 2005 and 2008 instances.
• Schedule daily and weekly maintenance jobs in SQL server
• Setup the log shipping to create standby database in DR data center.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Supported multiple accounts on versions 9i to 11g
• Silent Installation of Oracle 11g on CentOS
• Create and maintain users, roles and privileges.
• Installed and configured Oracle Grid control.
• Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Environment: 10g, 11g, 11g Grid Control, RHEL