Michael Shoblock Email & Phone Number

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..

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.

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.

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.

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.

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.

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.

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..

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.