We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

4.00/5 (Submit Your Rating)

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

We'd love your feedback!