Sql Developer Resume Profile
SUMMARY
- 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
- Audit remediation for Oracle E-business 11.5.9 password strength, failed logins, etc.
- 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
SKILLS
- Languages: Korn Shell, SQL, PL/SQL
- Databases: Oracle
- O/S: Red Hat Enterprise Linux 4/5/6/7 32-bit and 64-bit versions , Oracle Enteprise Linux 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 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 in-memory, Oracle Dataguard, Websphere MQ formerly IBM MQSeries , Oracle AQ, Oracle Messaging Gateway, dm-multipath, dm-ioband, Oracle SQL Loader, Oracle DataPump, Oracle Exp/Imp, TSReorg, Oracle Applications Applications Desktop Integration ADI , Oracle Applications Printers, Oracle SQL Net components, Oracle OCFS2 install configure , DRBD, Oracle ASM install configure , Oracle ASMLib, Vormetric Encryption
- Tools: Oracle Enterprise Manager, Docker, Juju, Vagrant, Chef, Puppet, InMon sflow
- Other: Sarbanes-Oxley SOX , HIPAA
- Clearance United States Gov't Confidential level clearance and have been through and cleared SF-85 process for 10-year background check while at USDA, USGS, USEPA and DOI
- TSCI-clearable no issues if necessary.
EXPERIENCE
Confidential
Solution Architect, Oracle Practice
- 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
- Leading transition of all Oracle RAC customers to RHEL6/Linux Multipath/ASM
- Creator of large documentation base at company wiki
- 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
- 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
- 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
- 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
- Fund management company in excess of USD 350 Billion under management Oracle DBA
- 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, Commvault 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 100 travel
- Install and configure Commvault Core Technology Engine
- Install and configure Commvault Oracle backup agent RMAN API
- Install and configure other Commvault 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
- Oracle 9i 10g upgrade with concurrent 32-bit 64-bit migration project LaBarge, Inc.
- Oracle 10gR2 2-node RAC healthcheck and support project City of Charlotte Light Rail System
Environment: Oracle 2-node Linux RAC
Confidential
Senior Oracle DBA Consultant
- 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
- Oracle issue resolution and support for over 200 remote TUSC 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-Contractor
- 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
- 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
- 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
- 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, Commvault Enterprise Backup solution w/RMAN API, OEM Database Control, custom Visual Basic SQL scripted HA solutions.
Confidential
Oracle DBA Consultant
- 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
References Available on Request