OBJECTIVE:

To seek a strong technical management position in Oracle domain with emphasis on cutting edge technologies like High Availability, Disaster Recovery, Backup/Recovery, Database Security, Audit/Database Vault, Replication performance tuning that meets or exceeds company's long term IT goals and contributes to superior KPIs.

CORE COMPETANCIES:

Technical:

A highly qualified Oracle12c/11g/10g/9i Professional with 20 years of hands-on DBA expertise on cutting edge Oracle server technology stack: Oracle Data warehousing, core DBA, performance tuning, backup and recovery, RMAN, High Availability RAC,MAA , Dataguard, Replication, Cloud Control, GoldenGate, OID, Partitioning, AQ Oracle Streams on a variety of hardware OS platforms.

Tools/Software Profeciency:

RMAN, Oracle DataPump SQL Plus SQL Loader Dataguard Broker Shell scripting Networker, VeritasVCFS SFRAC4.1/5.1 VxFS VxVM Veritas NetBackup7.6.0.2 EMC TimeFinder Snaps Clones NetApp Filer Snapdrive/Snapmirror/Snaps SRDF Technology SqlBacktrack, TSM Tivoli Bocada, Storage Essentials, Oracle12c Cloud Control/OEM SQL Developer CronJobs, DBArtisan, SQL Navigator, TOAD PL/SQL Developer I3/Precise Erwin Oracle Designer Suite PL/SQL, AWR, StatsPack, Explain plan, tkprof Solaris8,9 System Administration LogLogic, Nagios Remedy , ITG Mercury for IT Governance FootPrints Altiris,Microsoft Project,I3/Precise, Qpasa, MQ, Performance Center, Content Manager, Websphere Portal, Process Server, BuildForge, ClearQuest, ClearCase, Requisition Pro, Infosphere, Cognos.

IT Methodologies: ODI ITIL SOA CMMi AGILE RUP PCI SOX SDLC

Business Systems/Solutions: TIBCO, Innotas, BI, BO, MAXIMO, LAWSON, EPIC, CLARITY, REMEDY,TECSYS, KRONOS, Siebel Analytics, Oracle e-Business Suite, Oracle Workflow OBIEE, PeopleSoft.

Database Technologies: Oracle 12c/11g/10g/9i RAC, OracleApps11i/12c, 11g Dataguard Logical/Physical , 11g Streams, GoldenGate, RMAN, SQL Server7, MS Access.

Shared File Systems: OCFS2 Oracle GPFS AIX VCS/SFRAC4.1/5.1, ASM.

Shared Storage: HP 3Par, NetApp Filer EMC DMX SANs NAS HP SAN ASM Oracle , Raw Volumes.

Operating Systems: Sun Solaris11, AIX5L, RHEL6.5/5/4, Oracle UEK Linux6, HP-UX, Windows98/2000/2003/XP/Vista servers.

Hardware: HP Blade Infrastructure, Cisco FlexPod, SUN SPARCV880, HP-UX 11.0, SUN E15K, M9000, M4000, M5000, V490s, V890s, E2900s.

Network: Cisco Nexus Storage Switches, Infiniband, iSCSi,10GigE/Fiber Channel high speed interconnect.

Project Management:

• A results-driven, successful IT Project Manager with over 15 years of project management experience, PMP certification and proven track record in completing projects on time raising productivity, quality and customer satisfaction.
• Experienced DBA Manager, successfully leading VLDBs and Oracle ERP/Oracle Applications projects from requirements gathering through production.
• Leadership supervisory experience in leading multiple projects/teams simultaneously.
• Results-oriented professional with proven excellence at delivering projects, collaborating project teams, client interactions and deploying technology to build successful solutions.
• Creative thinker analytical problem-solver with demonstrated ability to manage large cap projects from planning through closure under high pressure time-sensitive environments.
• Exceptional organizational interpersonal, verbal and written communication effective customer relationship and team building skills.
• Decisive, energetic, focused team leader who leads high performing teams through changes.

Functional: Energy/Utilities, HealthCare, Telecom, Defense, Aeronautics, Retail, Pharmaceutical, Pharmacy Claims, Manufacturing, Healthcare IT , Advertising, Banking, Government Administration.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Oracle DBA Consultant Confidential

• Actively working on a large upgrade and migration project involving HP-UX PA RISC to HP-Itanium servers for the middle tier CIS application stack and HP-Itanium to Oracle Enterprise Linux. Databases are also upgrading from 10g to 11g.
• Deployed, maintained managed Oracle Change Management Pack, Audit Vault Database Firewall, as well as Database Vault for ten RAC databases in development production.
• Deployed, maintained and managed a three node Oracle11gR2 RAC MAA environment with two RAC physical standbys Dataguard : Setup LinuxRHEL6.5 servers on HP Blade infrastructure with ASM as volume manager shared file system, HP 3Par s storage sub-system , 10GigE/Fiber Channel hi-speed interconnect via virtual connect to Cisco Nexus switches.
• Built an OEM Cloud Control 12c Grid Infrastructure Solution with dataguard on Oracle Linux 64 bit platform for managing and monitoring enterprise databases, middle tiers, backups other applications.
• Managed 45 l non RAC environments for Development and UAT.
• Used RMAN for backing up RAC and Dataguard databases to disk and then to tape via Netbackup.

Confidential

DBA Lead Database Operations

• Maintained and managed a three node Oracle10g R2 RAC MAA setup with three RAC physical standbys Dataguard in production environment on Windows 2003 cluster with 5 TeraByte ASM storage, Oracle Clusterware and NetApp storage.
• Designed, deployed and managed a three node Oracle11.2.0.3 RAC MAA setup with RAC physical standbys Dataguard on OEL RHEL6Linux cluster with 5 TeraByte ASM storage, Oracle Clusterware and NetApp storage on FelxPod Cisco hardware.
• Designed, developed and deployed two highly available OEM Cloud Control 12c Grid Infrastructure Solutions with dataguard on Oracle Unbreakable Linux 64 bit platform for managing and monitoring Production and Development environments.
• Actively involved in detailed schema and application tier client upgrades of client environments PROD, DEV, and UAT . The upgrades were for application code, patch and enhancements.
• Managed several non RAC environments for Development and UAT 50
• Used RMAN for backing up RAC and Dataguard databases to disk and then to tape via Netbackup4.3. Managed the entire Netbackup to tape tier.
• Used TOAD, OEM shell scripts to monitor databases.
• Prepared implemented and upgraded all 30 production databases from 10.2.0.3RAC cluster on Windows to Oracle11g release 2 RAC cluster on Linux platform. The databases ranged from 500GB to 3.5 TB size.
• Used Oracle GoldenGate to migrate and replicate data between 10g and 11g systems.
• Actively engaged in advanced level performance management for tuning apps, database design, OS, Storage and Oracle Instances on both Windows and Linux cluster databases. Used DBA HIST tables, shell scripts, toad and OEM Grid Control for tuning.

Confidential

Sr. Oracle DBA Systems

• Engaged with developing and managing a brand new Oracle11g Release2 RAC setup with Dataguard physical and logical standby databases in production, test, beta, dev and stress environments on Linux RHEL5/6 VM clusters with ACFS, ASM, Oracle clusterware and NetApp storage.
• Managed Oracle infrastructure with 4 different environments, each 1 TB size with the following technology stack: 3 node Oracle11g release2 RAC clusters, Physical RAC Standbys, Logical RAC Standbys and Cascaded Standbys on 64bit Linux RHEL5/6 platform with ACFS, ASM, Oracle Clusterware RAC Nodes over 12 Clusters.
• Used RMAN for backing up RAC and Dataguard databases to disk and then to tape via netbackup.
• Created and installed a new Oracle11g Release1 OEM Grid Infrastructure to manage and monitor enterprise databases on Oracle11g Release2 RAC cluster on 64 bit Linux RHEL5 2 node cluster with ASM, ACFS, Oracle clusterware and NetApp storage.
• Used TOAD, shell and Perl scripts to monitor databases.
• Actively maintained the disaster recovery site for the primary database, also on a 3 node RAC cluster on RHEL5 Linux with ASM, ACFS, Oracle Clusterware and NetApp NAS storage.
• Prepared upgrade path for all the databases from 10.2.0.4 to Oracle11g release 2.
• Heavily engaged in advanced level performance management project focused exclusively on tuning apps, database design, OS, Storage and Oracle Instances.
• This involved using Oracle analytical tools, DBA HIST tables, shells, toad and OEM Grid Control.
• Actively used YUM commands for Oracle Linux and Oracle VM OS package management.

Confidential

Sr. Oracle DBA Contractor

• Engaged in the build out of a new datacenter in Austin TX. There were 3 datacenters total.
• Engaged in managing existing RAC, Dataguard physical and logical standby and a sleuth of very large oracle databases in 3 datacenters on SUN, Veritas, EMC stack.
• Managed a multi-terabyte Oracle infrastructure having 10 different environments, each one 3 TB size with the following technology stack: 3 node Oracle10g RAC clusters, Physical RAC Standbys, Logical RAC Standbys and Cascaded Standbys on Solaris10 platform with Veritas VxFs, VxVM, SFRAC5.1. 32 RAC Nodes over 12 Clusters.
• Prepared designed the migration plan from existing datacenter to the new datacenter.
• Used EMC TimeFinder Clones and Snaps for backing up very large databases ranging 3TB to disk and then to tape via netbackup. Largest DB generated 100G redo/day.
• Actively engaged in all the cycles of code deployment: DEV, TEST, UAT, POC, LaST, PRODFIX, TRAINING and PRODUCTION. 24 Standbys supporting 15 Primaries.
• Used Oracle10g Grid Control, I3/Precise, and shell scripts to monitor enterprise databases.
• DBA for management maintenance of a core 10TB company database on a 4 node Oracle10.2.0.4 RAC cluster on Suse Linux with ASM and NetApp Filer NAS storage.
• Actively maintained the disaster recovery site for the primary database, also on a 4 node RAC cluster on Suse Linux with ASM and NetApp Filer NAS storage.
• Prepared upgrade path for the 10TB database from 10.2.0.4 to Oracle11g release 2.
• Regularly engaged in advanced level performance management projects focused exclusively on tuning apps, database design, OS, Storage and Oracle Instances. This involved using Oracle analytical tools, DBA HIST tables, shells, toad and pl/sql developer.
• Used Netapp Snapdrive and Snapmirror technologies as the backup solution for the core database.
• Using Oracle10g Grid Control, TOAD, custom shell scripts to tune SQL and monitor DB.

Confidential

Lead Oracle DBA, Enterprise Data Architecture

• Primary DBA for an Oracle10.2.0.4 Dataguard Primary database on AIX5.3 platform with one local in data center logical standby and two remote logical standby databases in maximum availability mode. Used RMAN to backup the database to TSM Tivoli Tape.
• Actively used Dataguard broker for role transitions, configuration management, redo managementlog apply transport services, data protection mode changes, disabling/removing/enabling databases, changing database properties managing observer of the dataguard stack.
• Primary DBA for Oracle Advanced Payables project, supporting eBuisness Suite, with Oralce10g, 2-node 20TB RAC database on 64 bit AIX5L with ASM on EMC SAN.
• Successfully migrated a twenty terabyte Oracle AP eBusiness single instance database on Sun Platform to AIX platform on a 2-node RAC db using RMAN and then upgraded the database to 10.2.0.4. Routinely exported/imported data used RMAN to disk backups.
• Tuned SQL queries, database instance and Oracle AP modules PA, PO, GL and others as the database migrated from Oracle10g single instance on Sun Solaris9 to a 2 node RAC cluster on AIX platform. Used unix crons, shells grid control as monitoring tools.
• Successfully migrated a single instance 2TB Oracle database on Linux platform with ASM to a 2-node RAC cluster on AIX5L 64 bit platform using RMAN.
• Tuned several queries of a 2.8TB merchant database that improved site access and data processing on their portals from 2 minute response time to under 5 second response time.

Confidential

Oracle DBA Manager, Database Services, MISD

• Lead a group of seven DBAs supporting over 150 Oracle databases ranging from Oracle8i to Oracle11.1.0.7. The stack included 10g RAC, OID Dataguard solutions.
• Deployed a new HA Grid Control solution to monitor, manage and backup all servers and database targets. The configuration was a highly available Oracle11g as OMR, Oracle10.2.0.4 repository and OMS.
• Built from scratch, a 1TB 2-node10g RAC AIX5.3 64bit cluster on ASM, Clusterware and EMC SAN storage and scheduled RMAN backups to tape via TSM Tivoli software.
• Actively managed two cluster applications internal MAXIMO ticketing and TIBCO interface engine on Oracle10g RAC with ASM storage on IBM AIX5.3 64bit,
• Oracle clusterware and EMC SAN storage. These two databases are 2.5 terabytes each.
• Actively managed a physical Oracle10g dataguard solution for Lawson HR Apps
• Completed a site to site DR exercise of a 1TB database from St. Louis to Philly.
• Revamped the entire oracle RMAN tape backup strategy to use Tivoli TSM software.
• Progressively tuned a 3 TB data warehouse with a process based approach.
• Helped developers with logical physical data modeling for enterprise wide data-access.
• Maintained one multi-terabyte Oracle data warehouse supporting Business Intelligence, Business Reports and ETL processes AppWorx .
• Reduced backup time from 27 hrs to 6 hrs. Supported OLAP /BI-BO workloads in multi-TB environment.
• Established policies and procedures pertaining to database management, backups, data access, security, maintenance, capacity planning and utilization.

Confidential

Infrastructure Project Manager, Infrastructure Services

• Independently managed six full life cycle client facing IT infrastructure projects with high visibility budgets between five and ten million dollars.
• Was a subject matter expert in projects with domain areas that included Oracle10g RAC, Dataguard, storage, backup, maintenance and support, network monitoring, Datacenter build and multi-terra byte platform migrations between HP-UX, VMS, AIX, Windows Linux platforms.
• Managed project teams ranging from ten to thirty professionals.
• Certified oracle10g RAC and Dataguard on Linux platform with load, application, performance, failover, TAF, crash and storage tests along with benchmarking.
• Routinely analyzed risks, client satisfaction data and recommended areas of improvement to top management. Coached and trained other associates in the role.
• Developed proposals around major issues impacting scope, cost and schedule to executive team and implemented process and quality improvements to projects.

Confidential

Sr. Principal Consultant

• Senior principal responsible for delivering high availability disaster recovery solutions at clients using Oracle HA stack: RAC, Dataguard Oracle10g Streams on Linux, HP-UX, AIX and Windows platforms.
• Performed Oracle Applications installs and integration and developed roadmaps for Oracle Architecture infrastructure strategies upgrades, migrations, disaster recovery, backups, restores, db design, data access .
• Provided project guidance to client DBA teams scoped, planned, executed and controlled long term database implementation projects HA, DR and replication
• Successfully delivered several RAC/non-RAC performance-tuning assignments for clients that experienced poor overall system performance.
• Prepared project plans for database implementations, large cross platform migrations, upgrades, refreshes name changes. Engaged in tuning advanced troubleshooting of VLDBs data warehouses for clients.

Confidential

Sr. Database Consultant

• Managed databases ranging from Oracle8i to Oracle10g with sizes ranging from 500GB to 2.8 Terabytes SAP database . Also served as SQL Server DBA for fifty SQL servers.
• Developed managed company wide Architecture infrastructure strategies upgrades, migrations, disaster recovery, backups, restores, db design for AIX,Sun Solaris,HP-UX Windows servers.
• Implemented Oracle9i RAC and shared server configuration on ten 9i databases for an eCommerce application using multiple listeners for load balancing dispatchers. Also implemented Oracle Names for distributed networking environment across the enterprise.
• Lead a project to efficiently integrate company's clinical trials drug development data warehouse into a cohesive whole by implementing 9i OEM across several distributed databases in three continents.
• Successfully lead the Oracle Migration project, involving forty five databases from various prior releases to Oracle9.2.0.5 on SUN-Solaris, Linux Windows platforms to success, thus saving company two million dollars per annum in maintenance and support.
• Lead for the disaster recovery project involving Oracle9i Release2 Dataguard Deployment of ten single instance databases on Sun-Solaris and Linux platforms.
• Lead the project for conversion of ten single instance databases into Oracle9i RAC.

Confidential

Solutions Architect

• Lead a group of six Technical Architects in a data warehouse environment managed 4 projects with a goal of keeping all applications and data available to the business users 24/7 with 99.99 MTTR.
• Worked on 15 9i databases with 11TB data on 4 Sun Solaris5.8 servers EMC storage.
• Completed Oracle9iRAC cluster project for a critical 1TB-pharmacy database which helped company make 1.9 million dollars in revenues for the 1st quarter of 2004.

Confidential

Sr. Oracle DBA

• Primary DBA for seventy VLDBs mix of Oracle 9i, 8i and 8.0.X Databases with Oracle9i high availability dataguard environment on a 24/7 basis.
• Performed overall design, development, implementation, administration maintenance, Backup configuration, Restore Recovery, performance tuning, troubleshooting and monitoring of databases on sixty five Sun Sparc Solaris servers two AIX servers.
• Earned 5 sprint values excellence awards including one for Oracle9iRAC implementation three months ahead of schedule, saving client three million dollars.
• Ensured inclusion of appropriate backup recovery strategies for each Database design.
• Ensured optimum performance of databases by reviewing and specifying hardware and capacity planning requirements across operating systems.

Confidential

Oracle DBA at Oracle Corp., Wellington, New-Zealand, SONY Singapore, MBNS Malaysia.