SUMMARY

• Over 7 years of experience as an Oracle Database Administrator including 5 years experience with Oracle RAC.
• Expertise in database design, architecture, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning and database security.
• Experience with Oracle RAC, Oracle Enterprise Manager Grid Control, Oracle Fusion Middleware - Weblogic, Data Guard including Active DG and Flashback.
• Experience with replication solutions like Oracle Streams and Goldengate.
• Expertise in database security - database audit, user profiles, security patch updates, connection manager.
• Performed Performance tuning - top activity/SQLs, OS utilities, SQL tuning/profile, AWR global/diff, ADDM, ASH, SQLT.
• Experience with ASM storage, ACFS, HACMP AIX Cluster, Unix/Linux Administration, RAID, SAN storage.
• Experience with My Oracle Support (MOS)/Meta link for Oracle SR, patch download and software delivery cloud.
• Exceptional skills in evaluating Oracle products and state-of-the-art technologies.
• Experience with database administration of SQL server 2008 including stored procedures, backup and recovery, and SQL tuning.
• Experience with AutoSys job scheduler tools
• Experience with HP service Manager’s service desk and on-call tools for problem/incident management and on-call support.

TECHNICAL SKILLS

OS: Oracle SPARC Solaris 10/11, IBM AIX 5.3/5.2, Windows 8/7/Vista, Red Hat Enterprise Linux, Oracle Enterprise Linux, CentOS, SCO Unix, MS-DOS, SUSE Linux

RDBMS/Servers: Oracle 12c/11g/10g, MS Access, SQL Server 2008

Languages: SQL, PL/SQL

Database/ Application Tools: Oracle Enterprise Manager 11g/10g Grid Control, TOAD, RMAN, Oracle Streams and Replication, SQL Optimizer, HP Service Manager, Connection Manager, Spotlight on Oracle RAC, Oracle Transparent Gateway for SQL Server, SQL*Loader, Oracle RAC, Oracle Application Server

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Responsibilities include supporting The Boeing company database systems in a large complex RH LINUX, HP-UX, AIX and Windows environment.
• Providing 24/7 database administration support to production (More than 420 servers with more than 2500 databases), staging and QA databases in 4 data centers.
• Support in the Migration of Oracle 10g Claims database to 11g.
• Installed and configured Golden Gate between Oracle 10g and 11g databases.
• Migrating Oracle 9i, 10g databases on RH LINUX to 11g release 2 on RH LINUX.
• Applied Oracle 11.2.0.4.6 latest patch (both in-place and out-of place patch) and implemented cron jobs for stats, diag destination.
• Cloned Oracle 11g QA database from Development.
• Performed database upgrade from 11.2.0.3 version to 11.2.0.4 version
• Migrated PROD databases from one production box to another production through a CUT-OVER exercise
• Performance tuning - SGA, init.ora and high CPU spikes using nmon, vmstat, iostat, mpstat, explain plans, SQL optimizer, AWR, ADDM, ASH, Splunk reports.
• Configure OEM12c for non-prod/PROD databases and support Golden Gate replication for reporting database.
• Oversaw DR testing operations (as a backup strategy) on numerous Data Guards, physical/logical standby configurations. Resolved archivelog gaps and other related problems. Effected switch over manually and using DMGDRL
• Use AutoSys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
• Database Refreshing / Replication from production to testing using Expdp/Impdp.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
• Managing and creating User accounts, profiles, roles etc
• Perform quarterly home and database PSU patches
• Provided support to application DBA's and SA's.
• Provided team support and handling of team escalation and E-On-calls
• Performed team mentoring and administrative duties, daily, weekly and monthly reporting

Confidential

Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting Confidential Warehouse Inc systems in a very large complex Linux and AIX environment.
• Provided 24/7 database administration support for 4-node Oracle 11g RAC databases (6-8 Terabyte) in production and 2-node RAC in pre-prod, development, test, training and
• Supported Oracle quarterly rolling PSUs for RAC databases and OS patches.
• Built 3 node Oracle 11g RAC (GI/ASM/DB) on RHEL and configured/created application schemas, tablespaces and scripts for export and RMAN backup
• Coordinated, planned and implemented monthly Enterprise Releases.
• Performed performance tuning using explain plans, SQL tuning, SQL profiles, top activity, top SQLs, AWR global/diff, ADDM, ASH, SQLT.
• Performed installation and troubleshooting of physical Data Guard and also configured Active Data Guard.
• Performed partition administration including creating and maintaining partition tables and indexes, and creating local and global indexes.
• Provided on-call support for mission critical Oracle systems.
• Configured RMAN and implemented level 0/1 backup policies.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting Confidential Network systems in a very large complex HP-UX, AIX and Windows environment.
• Handled and supervised a team of 6 Oracle DBAs to support Confidential Network systems.
• Provided 24/7 database administration support for Oracle 11g and 10g databases (10-15 Terabyte) in production, development and test environment.
• Performed migration analysis and database migration for multiple data centers.
• Configured Oracle Security and Oracle Wallet with SSL authentication.
• Performed RAC failover testing and built Linux RAC servers.
• Planned and managed patch cloning process for patch deployments.
• Reviewed and scheduled AutoSys jobs for UNIX and Windows systems.
• Monitored and performed RMAN backups and export data pump jobs.
• Performed Oracle installations, configurations, database refresh/capacity planning.
• Configured OID and LDAP Oracle service names and alias registration.
• Supported Oracle RAC, Clusterware, Data Guard and ASM environment.
• Reviewed and applied Oracle Security Patches, one-off patch and patch sets.
• Monitored and managed Oracle databases using OEM GC, OraTools and TOAD.
• Created and implemented AIX, HP-UX, and Windows shell scripts.

Confidential

Production Support Analyst

Responsibilities:

• Provided 24/7 database administration and development support for GIS (ArcSDE), and Project management system in production, development, test/training environment running on Oracle 10g databases.
• Installed, configured, cloned, supported GIS spatial production, replication, QA databases.
• Developed and performed database backups and recoveries including point-in-time production database recoveries.
• Implemented Oracle 10g database export and import procedures using data pump.
• Developed and modified Crystal Reports based on Business Unit requirements.
• Created SQL scripts, shell scripts, PL/SQL stored procedures, functions and triggers.
• Created SOP documents for Oracle database backup, recovery and maintenance.
• Installed and configured Oracle 11g database and tested new features.
• Developed implementation plan for Oracle 10g (32-bit) upgrade to 11g (64-bit).
• Installed and configured Oracle 10g RAC, Clusterware and ASM on Linux.
• Performed Oracle RAC administration, troubleshooting and backup/recovery.
• Created and refreshed materialized views.
• Implemented and configured Oracle 10g Streams and physical/logical data guard.
• Installed SQL server 2008, created databases, performed backups and recoveries including point-in-time recovery, and performance tuning using SQL profiler.