SUMMARY:

• Oracle 12c GNS RAC ASM Flex Clusters on cloud providers in LXC containers (Orabuntu - LXC)
• Next-generation Pre-/Post-Sales all-flash high-performance low-latency storage for Oracle RDBMS
• Next-generation deployment of Oracle 12c GNS FLEX ASM RAC clusters on LXC Linux Containers
• Day-to-Day Oracle support of hi-volume interbank-FX, and retail-FX currency trading platforms
• Lead Consultant, design/Install 64-bit Oracle RAC production T-bill trading platform
• Confidential lead engineer Oracle on Amazon EC2, created cloud custom images. Amazon partner
• Currenex State Street Bank RAC OCFS2-to-ASM SOW for conversions of production to ASM
• 17 years supporting Oracle 7.x,8i,9i,10g,11g production RDBMS fortune 50 companies
• Latest ASM RHEL6 RAC storage techniques (Linux Multipath, 12-dm-permissions.rules)
• Lead DBA design/build full-responsiblity DBA 24/7 HA system $100M USEPA Times Beach Project
• Install/Configure/Administer Linux RedHat, CentOS, Oracle Enterprise Linux, Ubuntu
• Install and configure virtualized n-node RAC on LXC, KVM, Vmware, Xen, VirtualBox
• Building Oracle on Flash Storage Arrays, specialized techniques and considerations
• Created standby databases for both Standard Edn (manual) and Enterprise Edn (dataguard) clients
• Proven ability to meet tight deadlines and deliver systems ontime despite technical obstacles
• Designed, built, supported 2-node Oracle RAC on Windows for NYCT Subways
• 365/24/7 support of large multi-platform computing environments for largest fortune 50 companies

SKILL:

Languages: Korn Scripts, Bash Scripts, SQL, PL/SQL

Databases: Oracle, MSSQL, MySQL, PostgreSQL

O/S: Red Hat Enterprise Linux 4/5/6/7 (32-bit and 64-bit versions), Oracle Enteprise Linux kernels (UEK 2 & 3), CentOS Linux (32-bit and 64-bit versions), SUSE Linux (SLES 9, 10), Ubuntu Linux 8.04/9.04/9.10/10/11/12/13/14/15 Server and Desktop versions (32-bit and 64-bit)

Software: LXC, KVM, Xen, VMWare, Virtualbox, Oracle RDBMS (Enterprise Edition and Standard Edition) 7.x, 8i, 9i, 10g, 11g, 12c, RMAN, Oracle Dataguard, Oracle Utilities, TSReorg, Oracle Applications Oracle ASM (install & configure), Oracle ASMLib

EXPERIENCE:

Confidential

Senior Director Database Administration

Responsibilities:

• Management responsibility for all Oracle-related systems and projects, 1.5 million customers
• Hands-on Oracle DBA working with storage, server, and database layers.
• Manage team of consultants, contractors, and FTE resources
• Travel as required to remote IT office locations
• Work with 3 rd party vendors to develop solutions
• Drive DR (Disaster Recovery) process and system improvements
• Drive Security improvements.

Confidential

Sales Engineer / SA, Oracle Practice

Responsibilities:

• Field Engineering, Sales Org, pre-/post-sales, Oracle on flash sales. Over $4M 2014
• Wrote shell scripts for array san-level snapshot copies of Oracle databases
• Migrated databases from spinning disk to 4K format flash disk
• Built Oracle 12c 2-node ASM GNS RAC databases in Linux Containers
• Assist Marketing Department with product events such as Collaborate 2014
• Write white papers on zero-downtime storage migrations 512-->4K, snapshots
• Write custom scripts for customers to create Oracle DB from SAN LUN snapshots
• Personally closed over $4M in deals successfully, tier-1 customers.

Confidential

Sr. Engineer, Oracle

Responsibilities:

• Leading transition of all Oracle RAC customers to RHEL6/Linux Multipath/ASM
• Lead engineer Oracle on Amazon EC2, built custom images, put standby DB on EC2
• Upgrade/Migration from 10gR2 → 11gR2 RAC
• Oracle HAIP, bonding, and VLAN assignments for Oracle RAC
• Re-ip (move) of Oracle RAC databases to new IP subnets
• Leading high-profile deployments including 4-node RAC for national-level project.
• Implementation of Vormetric Encryption for HIX HIPAA databases
• Various shell-scripting projects
• Oracle on EMC VNX Storage support

Environment: 11gR2 RAC on RHEL5 and RHEL6 with ASM using Linux Multipath for storage persistence (we are phasing out ASMLib due to non-support for RHEL6) with Dataguard and Manual standby deployments. We have 1 Oracle on Windows deployment, but 99% of our customers run Oracle on RHEL.

Confidential

Database Group Manager

Responsibilities:

• Manager 5 Oracle and SQL Server DBA's
• Support production and development projects, including OneCarolina SunGard Banner
• Introduce EPM Live Work Engine and Project Portfolio Time Management
• Implemented change-management systems for database changes

Environment: Oracle 11gR2 (11.2.0.2.0 ) on Linux (Red Hat 5), Oracle Weblogic server, Oracle Enterprise Manager Cloud 12c, Oracle Fusion Middleware

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Hyperion EPM installation, configuration and production support
• Oracle Financials 11.5.x and 12 support

Environment: Oracle Virtual Machine (OVM), Linux.

Confidential

Database Group Manager Consultant

Responsibilities:

• Oracle RAC build, support, troubleshooting
• SQL Code development
• Teach RAC training course to customer (NYCT) staff

Environment: 10gR2 RAC on Windows 2003 server.

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Platform migration (HP-UX → Linux) and simultaneous (9i → 11gR2) upgrade using DataPump
• Support OCILIB (Instantclient deployment, “ make ” ocilib, advise on compilation ocilib issues)
• Support Oracle Messaging Gateway asynchronous messaging upgrade project
• JMS1.1 compliant messaging technologies review (ActiveMQ, mule ESB, Oracle Service Bus)

Environment: RMAN, Confidential Simpana 8/9, Oracle Streams AQ, Oracle Messaging Gateway, Oracle Applications 11i, Oracle 11gR2, Oracle 9i, Linux/Unix shell scripting, Oracle Grid Control 11g.

Confidential

Oracle Implementation Engineer

Responsibilities:

• Install and configure Confidential Core Technology Engine
• Install and configure Confidential Oracle backup agent (RMAN API)
• Install and configure other Confidential backup agents

Environment: This was a 100% travel position working at a new client each week. Therefore, this environment encompassed a wide range of operating systems, including desupported versions, and less common operating systems such as Gentoo Linux.

Confidential

Sr. Oracle DBA Consultant

Responsibilities:

• Oracle 9i → 10g upgrade with concurrent 32-bit → 64-bit migration project
• Oracle 10gR2 2-node RAC healthcheck and support project

Environment: Oracle 2-node Linux RAC

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• PROD and DEV database support for existing FXcurrency trading platforms
• Oracle Architect, RAC database on IBM Blade Servers and DS3400 storage
• Lead DBA Design/Install 64-bit Oracle RAC Production worldwide T-bill trading platform
• Lead consultant, reporting to management, on the Enterprise Backup Catalog Project, RMAN
• Lead consultant Oracle e-Business high-availability project (Oracle Financials replication project)
• Member of production performance issues and maintenance window resolution team
• Create documentation of systems for management
• Oracle Real Applications Clusters (RAC) on Vmware and Xen Virtual platforms
• Advise management, systems engineering, and other internal teams on Oracle best practice
• Creation and cloning/migration of Oracle production and development databases.
• Oracle SEC and SOX Internal Audit Oracle financials 11i remediation team coordination
• Oracle 64-bit 2-node Linux RAC support and installation (CRS,ASM,DB)
• SAN/dm-multipath design consultant including device capacity design/planning
• Xen virtual machine prototyping including Oracle Financials 11.5.10.2 and Oracle RAC 10g/11g
• Linux/UNIX operating system install/admin/config, including udev, dm-multipath, dm and dm-ioband.
• ProjectOpen project management software initiative project management
• Custom Linux/Unix shell scripting projects and entire range of day-to-day DBA tasks
• Weekly docket of controlled change management maintenance-window tickets/tasks.

Environment: FX Currency Trading high-volume systems, Oracle 2-node Linux 64-bit RAC, Oracle Financials 11i, Oracle security, Audit compliance, HP Storage Arrays

Confidential

Senior Consultant

Responsibilities:

• Oracle issue resolution and support for over 200 remote Confidential Managed Services customers.
• Support 200+ clients 24/7 remotely using various VPN's & monitoring/ticketing system,skytel pager
• Support multi-node RAC systems including 6-node CBOE options trading platform
• Support ASM-based RAC 10g and 11g systems.
• Support Dataguard managed standby and manual standby databases and Oracle Streams.
• Physical database maintenance, e.g. adding datafiles, create indexes/tables/objects etc.
• Oracle ERP support, e.g. restarting workflow services, troubleshoot concurrent managers, etc.
• Build RAC 2-node virtualized systems on Linux using Vmware, Xen Hypervisor, VirtualBox
• Administration of DB objects such as tables, indexes, functions, packages, procedures, triggers

Environment: Unix ALL, RedHat Linux, Oracle Enterprise Linux, Windows ALL, VAX/VMS, IBM OS/390, Oracle RDBMS 6.x-11gR1, Oracle e-Business 10.x-12i, Korn/C/Bash shells, Perl, VPN All types (cisco, sonicwall, juniper, etc.), SOA, Oracle Forms, Oracle Enterprise Manager (9i/GC). Oracle Dataguard.

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Deploy Oracle 10gR3 Dataguard production physical Flashback DB, read/write standby, savepoints
• Build 32-bit Oracle RAC on Red Hat Enterprise Linux 4.
• RMAN administration (Configure, Acquire Backups, use for creating Standby Databases)
• Deploy Transparent Application Failover (TAF)
• Prepare Best Practices and Environment Documentation
• Configure Oracle Dataguard HA solution with flashback R/W standby for PROD systems

Environment: RedHat Linux 4, Oracle RDBMS 10gR4 Enterprise Edition, Oracle Dataguard 10gR3, Oracle APEX, RMAN

Confidential

Oracle DBA Consultant

Responsibilities:

• Upgrade Banner 7.x product modules (7.4 upgrade)
• Upgrade Oracle Application Server 10.1.2.0.2 to 10.1.2.2.0
• Solve cutover issues from Jinit 1.3.1.26 to Sun JVM 1.5.0 10 for Windows Vista clients
• Prepare draft security guideline document for Oracle database installs
• Implement developed changes using change management system Merant and Serena
• Clone Oracle PROD db to TEST and DEV systems.
• Wrote Oracle security SOP

Environment: Oracle RDBMS 9i/10g Enterprise Edition, Sungard Higher Education Banner 7.x application, Oracle Application Server, Oracle Forms, Oracle Jinitiator/Sun JVM, Windows Vista, RMAN

Confidential

Oracle DBA-Developer

Responsibilities:

• Support Sungard SCT Banner products (ODS, EDW, Banner, Workflow)
• Created materialized views off of PROD to support Remedy nightly feed
• Recoded 6 views in the ODS product to use new, faster more efficient functions
• Upgrade Oracle Application Server 10.1.2.0.2 to 10.1.2.2.0 and upgraded Banner modules
• Clone Oracle PROD db to TEST and DEV systems.
• Support Sungard SCT Banner products (ODS, EDW, Banner, Workflow)
• Created fully-automated Oracle database cloning shell-scripted solution for fully automated cloning
• Created daily and weekly automated backup verification email reports for all databases
• Diagnosed data problem for external department (using pragma autonomous transaction trigger)
• Implemented standards for DB admin, auditing/user authent, maint., disk utilization, and datafiles.
• Oracle expert on team for design/tech/tool selection criteria and recommendations.
• Banner ODS and data warehouse support; recoding of poorly perfoming views after DW upgrade.

Environment: Oracle RDBMS 9i Enterprise Edition, Sun Solaris Global File System (GFS), Veritas Cluster, Sungard Higher Education Banner 7.x application, Oracle Application Server, Oracle Forms, Oracle Jinitiator/Sun JVM, Windows Vista, RMAN

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• On-demand, as-needed Oracle DBA break-fix and project-support (side-job)
• Build “manual standby” for this Oracle Standard Edition shop using vbs scripting and SQL scripts.
• Address capacity planning issues and respond to various capacity alerts, 24x7 off hours support.
• Issue troubleshooting, resolution documents, and escalation with business and dev teams.

Environment: Windows 2003 Server, Oracle RDBMS 9.2.0.8.0 and 10gR4 Standard Edition on Windows Server, Confidential Enterprise Backup solution w/RMAN API, OEM Database Control, custom Visual Basic & SQL scripted HA solutions.

Confidential

Oracle DBA Consultant

Responsibilities:

• All aspects Oracle database support, heterogeneous environment, versions 7.x, 8.x, 9.x and 10g
• All aspects MSSQL Server support
• Redesigned and restructured the workflow of Remedy tickets for improved manageability
• Enforced Sarbanes-Oxley (SOX) and 21CFR11 regulations and implemented company data policies
• Recovered critical project SAP 1 Tb database which SAP Basis Admin could not recover
• Supported Waters HPLC research Oracle database projects
• Manage DB performance, users, reports, security, etc. using OEM, Toad, scripts, and 3rd party tools.
• Support developers activity to create new Oracle schemas and database objects.
• Performance tune the database, using database tuning as well as tuning of SQL code.
• Oracle database security administration, including auditing, user administration and user creation.
• Work with team on db standards, DR strategies and OS Oracle-related kernel parameter blueprints.
• Address and resolve escalated tickets with enterprise teams.

Environment: Oracle RDBMS 7.x-10gRx Enterprise Edition, Windows/Linux platforms, MSSQL server 2005, Waters HPLC applications, Food and Drug Administration (FDA) 21CFR11 validated servers, SAP

Confidential

Oracle DBA

Responsibilities:

• Automated menu-driven refresh system
• Server monitoring system
• Java Runtime Environment silent repackaging
• Recoding of Benefit Time Differential report as server side stored procedure
• Disaster Recovery documentation and turnover
• Address and resolve escalated tickets with enterprise teams.

Environment: Oracle RDBMS 9i Enterprise Edition, IBM AIX, Netbackup, Korn shell scripts, Kronos Timekeeper.

Confidential

Oracle DBA Consultant

Responsibilities:

• Engineer Oracle (production and development) database(s) according to client specs using ERWIN.
• Adjust table and index storage parameters based on design specs and performance considerations.
• Create Oracle database logical and physical structures per client requirements and system specs.
• Advocate control regs consistent with FDA/CFR guidelines and accepted professional standards.
• Specify design parameters to home office developer and debug released versions at client site.
• Act as technical advisor to developer on Oracle requirements for custom coded VB application.
• Write project documentation package and transfer knowledge of system operation to in-house team.
• Track all time by project according to client and consulting company requirements.
• Provide any other as-needed project services as directed by project manager.

Environment: Oracle RDBMS 9i Enterprise Edition, VAX VMS legacy