Dennis Spera Email & Phone Number

New York City Metropolitan Area

Support Of the MongoDB platform for high security applications

Garden City, N.Y.

• Systems Engineer utilizing software engineering tools to support a premier global credit card processing platform. Kubernetes, Docker and Python data science modules and libraries. Jenkins, Jira, Git, Visual Code.
• MasterCard® and Visa® TC57/IPM/CTF file structure analysis and troubleshooting
• Designed and Implemented Perl System Architecture
• Developed modern Perl OO infrastructure to interface with Fidelity’s FIS Software
• Multi-currency POS, ATM, e-commerce and VISA® emerging market compliance
• Escalating system issues to NOC and relevant hardware/software support

Hauppauge N.Y.

• Created and Maintained Schema objects like table spaces, tables, indexes, constraints,...views, materialized views, synonyms, DB links, sequences and triggers.
• Experience with replication and migration using oracle data migration utilities..including SQL*Loader, Export/Import, DATAPUMP.
• Expertise with Database Administrative tools like Oracle Enterprise manager (OEM),..SQL*PLUS, TOAD, SQL Developer.
• Experience in all phases of Software Development Life Cycle (SDLC)
• Experience in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks.

Bethpage, N.Y.

• Development of backend packages, procedures, functions, triggers and other underlying objects used within the KOMS backend operational data store which ultimately populate the fact tables.
• Understanding business Metrics populated within KOMS ® front end (MicroStrategy) application. Knowledge of the flow of metrics from detailed report, summary reports up to the executive dashboard, Allowing Cablevision.
• Intimate knowledge of Application source tables, Dimension tables and fact tables and their inter-relationship to each other.

60 Wall St., N.Y., N.Y. 10001

* As a application DBA some of my duties (although not exhaustive) included schema design, objectpartitioning and object fine tuning.* Analysis of indexing requirements and examining index Clustering Factors and B-tree level height to ensurethe CBO is using them properly.* Other responsibilities include, PL/SQL development supporting the iCRES ®, risk.

New York, NY

* Data Warehouse Project: * Built the warehouse prototype in a distributed environment residing on Sun Microsystems ES6000(s) + ES4000(s), This project allowed us to be in a ‘go’ state when we received Chase Manhattan Bank’s first of many ES10000 multi-domain servers.* Upon receipt of the server, developed the strategy for exploiting the ES10000 including.

235 Pinelawn Rd, Melville, NY 11747

* Administered the replicated environments and deployed to new replication sites.* Involved in the Year 200 projects to assure the applications are Y2K compliant.* Participated in the database upgrade from Oracle 7 to Oracle 8, and provided support for Oracle upgrade, application installation and operation, and database implementation at the Post.*.

United States

Served Aboard USS John F. Kennedy making 2 deployments to Europe and Asia Injured in the Line of Duty

B. Sci., Computer Science

Education record

Oracle Performance tuning Oracle Backup and recovery Oracle Real Application Clusters Oracle Data management and storage internals Oracle.