SUMMARY:

• Database Farms Physical Infrastructure Builds
• Database Server Builds (9i, 10g and 11gR2)
• Database Cluster Builds (RAC)
• Database DR Solution
• Database Backup & Recovery (RMAN)
• Database protection using Data Guard
• Database Storage Management (ASM)
• Database Replication
• Database Migrations
• Database Upgrade
• Database Monitoring (Grid Control)
• Database Cross platform Data Movement (Transportable Tablespaces)
• Administration skills in RHEL
• Proficient in Performance Tuning / Instance Tuning
• Proficient in ASH, AWR and ADDM reports
• Proficient in AIX, Solaris, HPUX, Other flavors on Linux
• Proficient in SQL Server Database Administration
• Proficient in UNIX Shell scripting
• Proficient in TOAD and SQL Developer
• Sound experience in managing Oracle Databases all release up to Oracle 12c, Proficient in RAC, Data Guard, RMAN Administration.
• 24/7 On - call support
• Worked with the many 11g R2 new features including but not limited to the following:
• SQL Access Advisor
• SQL Performance Analyzer
• SQL Plan Manager
• Table compression enhancement
• Active Data Guard
• SCAN Listener
• Upgraded from 10 to 11g R2
• Query Result Caching
• Invisible Indexes.
• Database Replay.
• Automatic Memory Management.
• Automatic SQL Tuning

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, Arkansas

Oracle DBA

Environment: Oracle 11g R2 RAC, RHEL, 12c Cloud Control

Responsibilities:

• Configured Data Guard to provide high availability by implementing 11g R2 Physical Standby database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate for Oracle using 11g R2
• Database migration from 10g to 11g.
• 24x7x365 production support.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• 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.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Evaluate and implement latest database technology and new Oracle12c features
• Experienced with RMAN, replication, RAC, Data Guard, Goldengate and Oracle12c.
• Create and maintain users, roles and privileges
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Part of On-call rotation to support 24/7 every few weeks.

Environment: Oracle 10g / 11g Databases, 11g (Active) Data Guard, 10g/11g RAC

Confidential, Chicago, IL

Oracle DBA

Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, Data Guard

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line.

Confidential, IL

Jr. Windows Admin and Jr. SQL Server Jr. DBA

Environment: Windows 2000, SQL Server 2005

Responsibilities:

• Support various prod and non-prod SQL server 2000 databases
• Configure Log shipping
• Worked on Windows Server Installation.
• Worked on SQL Server Installation.
• Configured SQL Server Backup
• Restore databases
• Migrate Databases
• Restore Windows Servers.
• Writing batch scripts.

Environment: Windows 2000, SQL Server 2000, LAN / WAN