SUMMARY:

• Over 15 years of experience as an Oracle Database Administrator including 8 years with Oracle RAC and over 3 years of experience as a Developer.
• Holds many certificates and diplomas in Information Technology.
• Expertise in database design, architecture, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning and database security.
• Experience in developing end - to-end Oracle RAC solutions, Single-instance (ASM) builds with Oracle Restart, configuring OEM and Data Guard including Active Data Guard.
• Extensive experience with replication solutions like Oracle Streams, Shareplex, Golden Gate and heterogeneous replication using IBM CDC/IIDR.
• Expertise in database security - SOX compliance, database audit, user profiles, security patch updates and PCI layer 3 migration.
• Experience with Oracle Super Cluster/Exadata, database sizing and capacity planning.
• Performed PL/SQL development, Shell scripting and Performance tuning.
• Experience working with VMware and Oracle Virtual Machine (VM).
• Experience with NetBackup RMAN database backups, ASM storage, ACFS, HACMP, Unix/Linux Admin, RAID, SAN storage.
• Experience with Erwin data modeler,Oracle Designer and knowledge of Toad Data modeler.
• Experience with Oracle 11g warehouse builder and knowledge of ETL.
• Performed data conversion and development across several platforms and contributed in all phases of Confidential Development Life cycle (SDLC).
• Experience with My Oracle Support (MOS)/MetaLink for Oracle SR, patch download and Confidential delivery cloud.
• Exceptional skills in evaluating latest Oracle products and state-of-the-art technologies.
• Experience with database administration of SQL server 2005 and 2008 including stored procedures, backup and recovery, and SQL tuning.
• Experience with Kanban for project workflow, task updates and team collaboration.
• Extensive experience with IBM MAXIMO service desk and on-call tools for problem/incident management and on-call support.

TECHNICAL SKILLS:

Hardware: Oracle SuperCluster T5-8/T4-4, T4/M5000 SPARC, IBM Power P8/P770/780, P630/P520, RS/6000, Compaq ProLiant 3000, Compaq ProLiant 380/385 G3, Dell PowerEdge, HMC, HP SAN, Microsoft CPS

OS: Oracle SPARC Solaris 10/11, IBM AIX 6.0/5.3/5.2/4.3.3/4.3.2, Windows 8/7/Vista/2003/2000/XP/NT/9.x, Red Hat Enterprise Linux 6.0, Oracle Enterprise Linux, CentOS, SCO Unix, MS-DOS, SUSE Linux

RDBMS/Servers: Oracle 12c/11g/10g/9i/8i/7.x, MS Access, SQL Server 2005/2008

Languages: SQL, PL/SQL, C, C++, Pascal, Enterprise Java Beans, Java, JSP, HTML, JavaScript, FoxPro, FoxBASE, VB, Visual C++

Database/ Application Tools: Oracle Exadata, Oracle Enterprise Manager 12c/11g/10g/9i Grid Control, TOAD, RMAN, Oracle Streams and Replication, Golden Gate, SQL Optimizer, Dell Shareplex, Connection Manager, Spotlight on Oracle RAC, Oracle Transparent Gateway for SQL Server, SQL*Loader, SQL Server Management Studio, SQL profiler, IIS, ARCserveIT Backup, NetTerm, Delphix, HUR, Oracle Warehouse Builder, Oracle RAC, Oracle Application Server, WebLogic server, Putty, Xming, Xmanager, MobaXTerm, VNC, CA ManageIT, SQL station, Unicenter TNG, Quest SQLab Vision, BMC Patrol, Developer 2000, ERwin, Oracle Designer, Crystal Reports, WinRunner, MS Vision and Project, VMware vCenter & vSphere, Oracle VM, Virtual Box, IBM CDC/IIDR, Excel, PowerShell, OpenStack, Puppet, GIT, Eclipse, NoSQL - MongoDB, Couchbase

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix AZ

Senior Oracle Database Administrator

Responsibilities:

• Responsibilities include building and supporting B2B and B2C database systems for highly visible ATLAS Billing and Revenue (BRM) project in AIX, Linux and Windows (Cloud Platform System - CPS) environment.
• Built 2-node RAC, Single instance (ASM) databases for ATLAS phase-I at Alpharetta Data Center and DR (Active Data Guard) systems at Dallas Data Center.
• POC for ATLAS 30+ database VMs - Production, Staging, Development, UAT,QA, Parallel Run, Migration, DR.
• Configure new builds into OEM 12c and set up monitoring alerts.
• Perform day-to-day database administration tasks - tablespace management, user password management, ASM space/disk addition, privileges and grants etc.
• Coordinate DBA tasks and Developer's requests with APPs DBA team (size 6 DBAs).
• Implemented RMAN database and archive log TAPE backups using NetBackup.
• Plan Oracle PSU patching and apply patches to Prod and non-prod databases.
• Performance tuning - SGA, init parameters, slow database response, re-size redo logs,
• Planning and working on database migrations using data pump and data guard from AIX/Windows (CPS) to Linux (BlueBird).
• Built DR systems using Active Data Guard. Implemented different configurations - 2-node RAC (Primary) to Single-instance (Standby), Single-instance (ASM/Primary) to Single-instance (ASM/Standby), Single-instance (non-ASM/Primary) to Single-instance (non-ASM/Standby), one primary (PROD) to more than one standby (Reporting and DR).
• Developed scripts for database status, standby log apply, sync check and latency detection.
• Supported go-live of ATLAS B2B and B2C apps - BRM, AIA, OSM, SIEBEL, OCDM.

Confidential, Lawrenceville, GA

Senior Oracle D atabase Administrator

Responsibilities:

• Responsibilities included developing and supporting end-to-end Oracle RAC and data guard solutions in VMware and Linux environment.
• POC for Oracle requirements and support issues.
• Developed end-to-end Oracle EE RAC 11g and 12c solutions using PowerShell and RPMs.
• Updated RMAN backup/restore RPMs and tested in Geo and non-Geo architecture.
• Configured data guard for CMC database and supported HA.
• Assisted technical leaders in supporting production/development/test/lab environment.
• Worked with developers/testers to troubleshoot day-to-day issues like tablespace management, user creation, JDBC/application database connectivity, and ORA- errors.
• Attended NoSQL Couchbase presentations and deployed VMs for MongoDB and MySQL.
• Created NoSQL MongoDB database for device management.
• Performance tuning - SGA, init parameters, slow database response, AWR, ADDM.
• Researched and provided information on Oracle 12c multi-tenant architecture, licensing for diagnostic and tuning pack, and security patches.

Confidential, Alpharetta, GA

Senior Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting Confidential systems in a large complex AIX environment.
• Provided 24/7 database administration support to production (3-4 TB), staging and QA databases in three data centers.
• Installed, configured and supported Golden Gate between Oracle 10g and 11g databases.
• Migrated Oracle 9i and 10g databases on IBM P770 to 11g release 2 on IBM P780.
• Applied Oracle 11.2.0.4.3 patch and implemented cron jobs for stats, diagnostic log cleanup
• Coordinated PROD migration from P770 to P780 using Hitachi Universal replication(HUR)
• Performance tuning - SGA, init parameters and high CPU spikes using nmon, vmstat, iostat, mpstat, explain plans, SQL optimizer, AWR, ADDM, ASH, Splunk reports.
• Migrated data warehouse database - Oracle 9i/P770 to Oracle 11g/P780.

Confidential, Alpharetta, GA

Senior Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting Confidential systems in a very large complex Solaris, AIX and Linux environment.
• POC for CIDB - mission critical application and Team Lead of 5 DBAs.
• Provided 24/7 database administration support for 4-node Oracle 11g RAC databases (8-10 TB) in production and 2-node RAC in pre-prod, development, test, training and integration environment in three data centers.
• Planned and rolled out Phase-I SOX database security compliance across the enterprise.
• Supported IBM IIDR/CDC heterogeneous data replication - implementation, upgrades, support between Oracle and DB2/Mainframe.
• Built 3-node Oracle 11g RAC on RHEL and configured/created application schemas, tablespaces and scripts for export and RMAN backup
• Participated in Oracle SuperCluster/Exadata architecture, database consolidation
• Performed capacity planning for non-prod and PROD Oracle SuperCluster/Exadata systems.
• Provided AWR miner reports and database sizing information along with instance caging requirement for SuperCluster/Exadata databases to Oracle.
• Coordinated with Oracle and System Administrators to configure Exadata.
• Developed SuperCluster/Exadata database consolidation plan for non-prod databases.
• Configured IBM IIDR/CDC heterogeneous (DB2-Oracle) replication on Exadata.
• Attended hands-on Oracle workshops/training on SuperCluster/Exadata and Golden Gate.
• Configured unidirectional Oracle Golden Gate and supported Shareplex 3-way replication between Oracle databases in 3 data centers.
• Presented IBM IIDR/CDC data replication and OEM 12c Change Management.
• Tested OEM12c Change Management to compare plans, generate code and push the code to sync development/test databases after Enterprise releases.
• Performed performance tuning using explain plans, SQL tuning, SQL profiles, top activity, top SQLs, AWR global/diff, ADDM, ASH, SQLT.
• Performed partition administration including creating and maintaining partition tables and indexes, and creating local and global indexes.
• Implemented CA's dSeries job automation for non-prod and prod Application related jobs.
• Configured RMAN and implemented level 0/1 backup policies and VTL/TSM backups.
• Received Certificate of Appreciation from Confidential management.

Confidential, Bellevue, WA

Senior Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting Boeing systems in a very large complex HP-UX, AIX and Windows environment.
• Team Lead of 8 Oracle DBAs and POC for Oracle requirements and support issues.
• Provided 24/7 database administration support for Oracle 11g and 10g databases (15-20 TB) in production, development and test environment.
• Configured Oracle Security and Oracle Wallet with SSL authentication.
• 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.
• Supported Oracle RAC, Clusterware, Data Guard and ASM environment.

Confidential, Baltimore, MD

Senior Oracle Database Administrator

Responsibilities:

• Provided 24/7 database administration and development support for Oracle 10g, 9i, 8i database systems in production, development, test/training environment.
• Installed, configured, cloned, supported GIS spatial production, replication, QA databases.
• 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.
• Developed logical data models and physical data models using Erwin data modeler.
• Generated SQL scripts, DDLs, ER models and reverse engineer Maximo database structure.
• Installed SQL server 2008, created databases, performed backups and recoveries including point-in-time recovery, and performance tuning using SQL profiler.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Responsibilities included supporting NAVIS Express/SPARCS Oracle OLTP database systems in a large complex AIX, RHEL and Windows environment.
• Provided 24/7 database administration support for Oracle 10g, 9i, 8i databases in production, development, QA, and test environment.
• Performed database upgrades; Implemented data replication using Oracle streams.
• Implemented Oracle security using database audit, audit trail review, user account management, connection manager, and Oracle security patch updates.
• Developed and performed database backups and production database recoveries.
• Assisted developers and testers in troubleshooting SQL and PL/SQL, and supported HA.
• Generated and analyzed AWR and ADDM reports; Worked on SQL trace, Explain plan, SQL hints, rewriting SQL queries and TKPROF for SQL tuning.
• Evaluated and recommended BMC, CA, Quest database monitoring tools.
• Prepared and presented OEM concepts/architecture and Oracle Streams architecture.
• Received a commendation letter from the customer.

Developer

Confidential,NC

Responsibilities:

• Designed, developed and performed data conversion using tools and templates.
• Developed Generic stored PL/SQL procedure/functions and SQL scripts for building schema, loading data tables, indexes, triggers and constraints.

Confidential

DBA/Developer

Responsibilities:

• Performed system analysis, data modeling and development for Mutual Fund application.
• Provided database administration, data conversion, application support and user training.
• Performed and managed application development for Mutual Fund plans.