Michael Shoblock Email & Phone Number

Roxbury Township, Nj, Us

Roxbury Township, Nj, Us

Hoboken, Nj, Us

CTO &FounderOracle DBA and Developer

London, Gb

Lead Oracle developer on system to gather product and price data from multiple ERP systems; publish standard model using via Composite Virtualization; update Cameleon CPQ by sending data in JSON format via RESTful webservice. Implemented standard framework for ETL processing. Created webservice to provide standardized data extracts in XML and JSON formats. Configured Oracle Embedded Gateways for data extracts from Sybase to Oracle.Built dynamic ETL processes, including XML extraction routines using Oracle’s XDB. Developed web-enabled mod_plsql routines and APEX screens. DBA responsibilities include Oracle installations and performance tuning.

Converted Access/FoxPro application to Oracle/PLSQL/APEX, implementing PCI compliance standards, Transparent Data Encryption, and Virtual Private Database.Performed PCI DSS Assessment.On-going system enhancements, new features, and dba support.

London, Gb

Responsible for tuning existing SQL and PL/SQL code, defining new indexes to improve performance of applications on Oracle 9i database. Documented existing ETL processes, and created mappings to assist in rewrite of processes. Modified existing content load routines for error handling and performance.

Senior DBA responsible for installation, configuration, upgrade and support of multiple Oracle database, Application Server, Collaboration Suite, Portal and Forms/Reports installations for various clients, including Oracle 10g R2 Real Application Clusters, Physical Standby Databases, and EM Grid Control 10g. Performed services for clients, including gathering and documenting requirements, design, tuning SQL applications, backup and recovery, upgrade/patch evaluations, recommendations and installs. Created scripts to perform hot and cold database backups and maintain old redo logs.Worked with developers to write sql using Oracles XML built-in functions to generate formatted web output from relational data, and to store XML data as CLOBs. Installed Oracle Discoverer, created and maintained End User Layers, worked with developers to create views to facilitate complex reports.

DBA and Developer on multiple Oracle projects.DBA and Lead Developer on SFA/PDMA Compliance system implemented in Oracle 8i on NT. Managed ETL routines to provide State License and DEA data. Implemented screens with Developer 6i and WebDB/Portal.Oracle DBA One of two DBA’s responsible for installations, upgrades, tuning and monitoring of over ninety Oracle databases. Wrote database packages and custom screens in Forms 5.0 to allow easier remote monitoring of databases. Standard DBA responsibilities, including backup and recovery, security, and space management.Detached Database ServerDeveloped Detached Database Server to support a high-volume transaction processing application on Open VMS. The Server was implemented in Oracle 7 using Pro*C, PL/SQL, VMS Mailboxes and ASTs to provide a flexible architecture. The server handles approx. 100,000 requests daily, as many as 37 per second (recorded), reducing average daily CPU by half and bringing total Elapsed Time for all batch jobs to 1/3 its previous amount. Internal Training - Oracle Tuning SessionsWrote and presented multiple in-house Oracle training sessions, covering topics such as Oracle Access Paths, Optimization Modes, TKPROF, EXPLAIN, Join Orders, Access Methods, and Hints.Applications Support /Y2K Upgrades

Mount Arlington, Nj, Us

Technical Lead on State License Data Warehouse system. Data from State Medical boards and the DEA is normalized and warehoused in Oracle to allow on-line and bulk matching and validation of practitioner licenses via web access. Designed and implemented underlying database, ETL methodology, internal processing and matching routines, and data access routines for web system.

Mclean, Virginia, Us

Technical Lead on Oracle 9i project to interface with Manugistic applications on Unix and NT. Developed transfer routines for legacy systems using Webconnect, MQSeries, ESQL and DataJunction. Developed stored PL/SQL routines to process legacy data.Technical Lead and project DBA of sales forecasting data warehouse system interfacing with I2 Rhythm Demand Planner/Analyzer and legacy systems for multiple business units of Mars Inc. Data warehouse implemented under Oracle V7, on a DEC Alpha running Open VMS V7. Code base included SQL*Forms 3.0, SQL, PL/SQL and DCL. As project DBA implemented Logical Partitions, Database Triggers, and PL/SQL Libraries, defined Oracle Roles, tuned Init.Ora parameters. Oversaw small group of developers.

New York, Ny, Us

DBA responsible for migrating existing database system from Oracle V5 to Oracle V7.1. Tasks included developing migration plan; installing Oracle V7.1; creating instance with new tablespace, table and index definitions with new storage parameters, and constraints; importing existing database into Oracle V7; upgrading application code and setting up end-user accounts. Code upgrade included converting HLI (OCI), Pro*C and Passport applications to V7 compatibility, testing and performance tuning.

New York, Ny, Us

Developer to complete an Invoicing system, using Oracle 7 under VAX/VMS with SQL*Forms V3 front end. Maintained database design using ERWIN/ERX, developing stored PL/SQL, some Cobol code.

New York, Ny, Us

Developer on Investment Analysis System, using Oracle 7 on a DEC Alpha with SQL*Forms V4.5 front end interfaces. Responsible for enhancing and implementing database design using Oracle CASE V5.1; development of PL/SQL packages and database triggers; implementing database constraints.

Mclean, Virginia, Us

Oracle DBA responsible for over 90 databases nationwide, on DEC VAX and Alphas. Responsible for Oracle installs, upgrades from V6 on VAX/VMS to V7 on Alphas, archiving, backup and recovery, database monitoring and tuning. Wrote automated programs to perform on-line defragmentation, and monitor space usage of remote databases. Optimized Oracle applications.

New York, New York, Us

Developer on Sales Reporting System using Oracle V6. Implemented PL/SQL scripts, SQL*Forms V3 and SQL*Reportwriter to compute, maintain and report sales quota, bonus and commission data.

Switzerland 🇨🇭 , Ch

Team leader responsible for the development of the Detail Design Phase of Order Management System - inventory tracking and order fulfillment - using Oracle 6.0.3.3 on an RISC 6000 under AIX/X-Windows. Responsible for the design of SQL*Forms applications and SQL*Plus reports and logical and physical database modeling.

Mclean, Virginia, Us

Developed an OLTP manufacturing tracking and reporting system, using Oracle 6.0.3.3 on VAX/VMS, SQL*Forms V3, SQL*Menu, Pro*C, SQL*Loader, SQL*Plus, Reflection and DCL command procedures. Feature include batch uploading of data from PC files to Oracle on the VAX, and updates to remote databases using SQL*Net. Coordinated rollout, including software installation and data conversion from prototype system.

New York, Ny, Us

Designed and implemented financial applications as part of Moody’s Analytical Information Database Systems (MAIDS), using Oracle V6 on VAX/VMS. Upgraded existing SQL*Forms applications from version 2.3 to 3.0. Optimized Oracle applications for publishing system.

Gb

Functions included performance tuning, SQL optimization, code reviews, and application and database design. Developed SQL*Forms V2 Screens, User Exits and Pro*C modules for an on-line Oracle V5 distributed client-server system to manage personnel, client, contract and billing information for all firm activities. System was implemented in over 80 sites. Implemented SQL*net transfers, via a two-phase commit using Pro*C.

Developed a GUI Oracle V5 DBA tool, using PASSPORT and C to provide a simple interface to perform all DBA functions, including monitoring and maintaining tables, indexes, users, space and security.

Worked with sales dept. to promote PASSPORT, an alternative to SQL*Forms V2. Fielded technical question, gave demos of PASSPORT to potential clients, and reviewed and updated technical manuals and user guides.