SUMMARY

• Over 15 years of IT experience and over 6 years of experience working on DBA/Architecture, Production 24*7 support, Implementation, Configuration, Upgrades, Replication, User/Security Administration, Backup/Recovery, Database Migration, ASM and Data Guard, RAC, Grid Control, Exadata, ZFS storage appliance, super clusters.
• Experience in Upgrading databases from 11.2.0.3 to 11.2.0.4.
• Experience in Database Space Management, troubleshooting.
• Experience in attaining Performance tuning for Oracle database using utilities like AWR, ADDM.
• Experienced in all the phases of Software Development Life Cycle (SDLC)
• Experienced in implementing scripts using bash, k - shell, and writing scripts for backup and refresh purposes
• Experienced in handling multiple tasks simultaneously and extended 24 X 7 database support to developers and end users.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g.
• Install and configure OEM Grid Control 12c and Real Application Clusters (RAC) 11gR2 on multiple nodes
• Strong analytical and problem solving skills with ability to work within a team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team and coordinate team meetings.

TECHNICAL 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.1RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10

RDBMS: Oracle 9i/10g&11g /12c

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL SQL Developer, MS Office, JSON Data, Tableau, Power BI Desktop

Tuning Tools: TKPROF, STATSPACK, AWR, and ADDM.

Languages: SQL, UNIX Shell Scripting, Python

Others: Remedy, ConnectWise, HP manager, clear quest, clear case

PROFESSIONAL EXPERIENCE

Confidential, Sacramento CA

Oracle Database Administrator

Responsibilities:

• Lead database activities in Launching the new Confidential Educational Center Application.
• Used Real Application Testing (RAT) to test for performance issues
• Analyzed software patch product for management decision making.
• Coordinator and lead 11.2.0.4 upgrade implementation across enterprise.
• Installed Oracle GRID Infrastructure on servers
• Performed oracle database patching using opatch utility
• Assist in coordinating and implementing clusterware and database upgrades
• Couching junior specialists.
• Perform database migrations using RMAN duplication.
• Performed adhoc backup and recovery operations to support Genesys systems testing.
• Monitor, Log and Research ORACLE ERRORS.
• Manage ticket queues and tasks amongst team.
• Fulfill user access requests for PeopleSoft and MY| Confidential systems.
• Apply change requests for both development and production environments.
• Co-ordinate and Apply Exadata patching.
• Exadata clusterware patching and upgrade from 11.2.0.3 to 11.2.0.4.
• Apply emergency ghost patching.
• Create database links on multiple systems.
• Perform flashbacks for training and call center database systems.
• Database creation for PeopleSoft and PSR systems, manually and as well as using DBCA.
• Monitor and perform archive log spaces and tablespace management.
• Perform, monitor and manage backup operations for all systems. While troubleshooting backup errors.
• Performing planned and adhoc hot and cold backups, and monitoring back up reports.
• Configuration of ZFS backups and RMAN duplication.
• Performing imports and exports using DATAPUMP utilities.
• Using OEM 12 c GRID, for monitoring, and other daily activities.
• Manage different schemas and application support.
• Performing active and time based refreshes.
• Perform Database upgrades .o-patch utility or DBUA.
• Help coordinate PeopleSoft Application upgrade to 9.2 project.
• Install oracle client software.
• Monitor and configure memory structures such as huge pages and SGA; tablespaces; and Redo logs using round robin technique.
• Assist client with application analyses and tuning.
• Assist with project coordination, and led security project

Confidential, Sacramento, CA

Oracle Database Administrator

Responsibilities:

• Writing shell scripts to automate various processes
• Supported database platform are Solaris 11.1
• Migrated oracle 11g databases on Linux and Solaris for development, integration and production environment
• Monitor and manage databases using OEM Grid Control 12c
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Creation and configuration of Oracle database of various sizes in Dev, Test, Model and Production environments.
• Worked on Auditing and security with Oracle databases.
• Design flowcharts for DBCRs, DCRs, SCRs, and SIRs using MS Visio
• Design all Dev, Test and Production environment using MS Visio
• Monitor and Configured Oracle 11g databases using OEM.
• Created and Managed user, tablespaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Communicate and coordinate with Oracle using My Oracle for major database issues/ problems
• Applied client patches and other patches as required (Releases participation).
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Assist with coordinating team meetings in C-IV project

Environment: Oracle 11.2.0.3, Adobe LiveCycle Management, IBM AIX V6.1, ASM, Exadata, ZFS storage appliance, Data guard, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM

Confidential, Bethesda, MD

Oracle Database Administrator

Responsibilities:

• Production support database on 9i, 10g and 11g versions with standalone and RAC environment.
• Supported database platform are Solaris 10 and AIX 5.3.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment
• Install and configure OEM Grid Control 12c
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Upgraded databases from 9i to 10g, 10g to different 11g versions.
• Worked on Auditing and security with Oracle databases.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Flash Recovery Area.
• Created and Managed user, table spaces, data files and archive log
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Communicate and coordinate with Oracle using My Oracle for major database issues/ problems
• Worked on oracle Public and Private Database Link.
• Applied client patches and other patches as required.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Configure and install Real Application Clusters (RAC) on multiple instances/nodes
• Assist with coordinating team meetings.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, ASM, Data guard, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM

Confidential, NY

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3)
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies ( Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.

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

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• Install oracle database software 9.2.0.1, 10.2.0.1 and 11.1.0.6.0 using oracle universal installer on development, test and production server for their claim, policy and online applications in IBM AIX 5.3 environment.
• Install OEM grid control that includes oracle agent, management repository and management service on VMware Red Hat Linux virtual machine. Install agents on various AIX database servers.
• Upgrade software and databases from 9.2.0.1 to 9.2.0.6, 10.2.0.1 to 10.2.0.3, 9.2.0.6 to 10.2.0.3 and 10.2.0.3 to 11.1.0.6.0 on development; test and production databases on AIX database servers. Apply patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.
• Migration of full 9.2.0.6 databases, schemas those are on Linux environment into AIX, 10.2.0.3 database environment using export/import and data pump utility.
• Create development, test and production databases using database configuration assistant- DBCA, manual scripts and sqlplus using Automatic storage management- ASM.
• Database performance tuning using AWR, ADDM, ASH, sql tuning advisor, explain plan, statistics, blocking sessions, STATSPACK, TKPROF, sql query restructure and sql trace.
• Schedule cronjob for daily night hot/online backup of production databases on tape using RMAN scripts.
• Refresh or restore development, test and reporting databases from production database backup using RMAN scripts or export/ Import and data pump utility.
• Schedule a cronjob and create lots of shell script in Unix environment like backup and restore of databases, update statistics, export and import of tables, log file maintenance, cleanup archive logs, startup and shutdown databases, email logs and alert to users, mount point space check, tablespace size check and business related activity like automatic bill payment, check generation, bill generation and many more.
• Created physical standby database on remote server to provide high availability.

Environment: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle 9i/10g, AIX 5.1, 5.2, 5.3