STEPHEN P. SZYMANSKI

* ********* **.

Peabody, Massachusetts 01960-5165

ad47w1@r.postjobfree.com

TECHNOLOGY

Software : Oracle 7, 8, 8i, 9i, 10g, 11gR2, 12c, 19c; RAC, ASM, DataGuard, RMAN, AWS, SQL-Loader, OEM,

13c Grid Control, SQL Developer, EMC Timefinder, Data Domain, XTreme I/O, Veritas, Sun Cluster,

ERwin, Tuxedo, BMC Patrol, TOAD, DBArtisan.

Hardware/OS : Oracle Exadata, Oracle Database Appliance (ODA), Oracle Linux, EMC DMX/Symmetrix, NetApp,

Sun/Solaris, HP-UX (Vpar), IBM/AIX RS6000, Dell, HP, MS Windows

Languages : SQL, PL/SQL, SQL*Plus, UNIX Shell scripting, Cron, C, Pro*C, DOS Batch, Visual Basic

EXPERIENCE

5/14 – pres State Street Corp Boston, MA

SSGA – Application Technology Solutions : ORACLE Architect/DBA

· Performance tuning on 19c Exadata environment - Query analysis/rewrites.

· Creation of Audit data warehouse with 7-year retention to replace 3rd party vendor.

Securities Finance Department : ORACLE Architect/DBA

· Database Architect for redesign of entire Agency Lending business (replacing numerous systems).

· Logical/Physical data modeling for deployment on Oracle Exadata architecture.

· Design database schema to support current business functionality as well as enhancements.

· Table/Index creation, ETL, PL/Sql Package coding, Golden Gate config, Performance tuning.

Risk and Regulatory Technology : ORACLE Architect/DBA

· Technical Lead for Exadata migration of 5TB database from existing RAC cluster.

· Performance enhancements on various applications which included table partitioning, query tuning,

schema design, index creation, statistics generation, PL/SQL tuning, table reorgs, table compression.

· Assigned to additional teams to aid in Exadata migrations of existing databases.

TDE Operational Database Team : ORACLE Architect/DBA

· Hired to tune Prod Exadata environment in preparation of increased (3X) data volumes.

· Introduced additional table partitioning designs including automated maintenance PL/SQL package.

· Tuned slow-running queries by rewriting, adding indexes, and utilizing Exadata storage indexes.

2/19 – 5/21 Docupace Technologies Los Angeles, CA (remote)

Infrastructure Team : ORACLE Architect/DBA

· Migrate existing database environment to new Linux Oracle 19c RAC.

- Design, Install, Configure, Test. Migration from Legacy database environment.

· Enhance, Monitor existing environment and Support development teams.

· Schema creation, Partitioning, PL/Sql, DataPump, SQL Tuning

5/13 – 5/14 Turbine Needham, MA

Transactional Data Services : ORACLE Architect/DBA

· Lead architect for Oracle RAC infrastructure to support new gaming environment in North American

region as well as Europe, Russia, and future global sites.

-Installation, design, configuration, and testing of all Production RAC clusters.

· Provided support of Production environment with backup/recovery, performance tuning, schema

design, DataPump refreshes, monitoring and training.

· Supported AWS Cloud databases until migrating to newly-installed Prod RAC environment.

· Installation and setup of 12c Cloud Control monitoring for all Oracle environments.

· Represented database team at all meetings, design sessions, and deployments.

10/11 – 5/13 Commonwealth of Massachusetts - Department of Education Malden, MA

Database Team : ORACLE Architect/DBA

· Participated in initial design & deployment of large-scale Student analysis database on Exadata.

-Schema definition, table layout, partitioning, data compression (HCC), bitmap indexing,

materialized views (w/ query rewrite), query tuning, PL/SQL packages

· Support Enterprise Data Warehouse (EDW) environment – Includes all DDL deployments,

schema design, and ongoing Legacy consolidation projects.

· Migrating all Data Collection database environments to Oracle’s new Database Appliances (ODA).

Project includes 10g-to-11gR2 upgrade, RAC configuration, schema redesign, and data migration.

7/11 – 10/11 Houghton Mifflin Harcourt Boston, MA

Database Team : ORACLE DBA

· Installed a 10gR2 RAC environment on new hardware to replace old environment.

-Duties included Cluster installation, database configuration, and data migration for

14 database environments.

5/11 – 6/11 State Street Corp Westwood, MA

Enterprise Database Team : ORACLE DBA

· Assigned to corporate Data Warehouse (FDR) : Supported 14+ TB 5-node 10gR2 RAC environment.

-Duties included schema analysis, DB environment management, StandBy readiness, code deployments, DR Failover planning/implementation, and RAC node-additions.

4/11 – 5/11 SavingStar Waltham, MA

· Deployed a new 11gR2 Data Guard environment to replace existing standalone Production database.

· Configured Data Broker and documented Switchover/Failover procedures for staff.

12/10 – 3/11 Epsilon Wakefield, MA

DBA Team: ORACLE DBA

· Assigned to client with problematic 4-node 10gR2 RAC environment. Made numerous

recommendations concerning node interconnect (RAC), TNS connectivity, PGA/SGA tuning,

table partitioning, index addition, schema design, data migration, and PL/SQL tuning.

· Initiated the design of an incremental nightly load process to eliminate the existing “truncate/reload”

method. Extract times, as well as Load times, were drastically reduced due to the smaller datasets.

· Performed core DBA functions : Automated Stats gathering, index rebuilds, schema migrations,

SQL tuning, Explain plans, RMAN config, and DataPump export/imports.

8/10 – 12/10 Outcome Sciences Cambridge, MA

Production Services: ORACLE DBA

· Analyzed existing 10g and 11g RAC database environments; Designed and deployed enhancements

in each system including Tablespace layouts, Redo Log duplexing, spfile tuning, SGA/SQL tuning,

automated Statistics generation, Index additions/rebuilds, RMAN backups, and EMC SAN config.

· Designed/Deployed range-partitioning scheme for large tables (500 – 900 million rows) utilizing

block compression to reduce tablespace size by 50+%. Implemented Read-Only tablespaces for

all historical data partitions (reducing RMAN backup cycles).

· Created all new 11g R1/R2 RAC database environments; Consolidated existing systems into new

databases. The older 10g databases were migrated to the new 11gR2 environment.

· Reviewed scalability concerns with IT Management, leading to architecture enhancements.

8/09 – 8/10 Humedica Brighton, MA

IS Department: ORACLE DBA / Architect

· Tasked to stabilize current multi-terabyte database environment; Recreated all existing databases on

11gR2 RAC and configured new environments as needed. Both the Production and Staging

databases were 11gR2 RAC with ASM.

· Advised development team on data loading strategies; Provided SQL tuning, Explain Plans,

PL/SQL programming, and additional schema structures to facilitate ETL processing.

· Addressed scalability issues with management; Introduced table partitioning, index tuning,

Materialized Views, PL/SQL coding, SAN Backup/Recovery methods, & data migration via db links.

· Worked with clients to extract & transform their historical data for upload into Humedica’s databases.

Designed views and PL/SQL package to perform the extract.

3/09 – 6/09 PartyLite Gifts, Inc Plymouth, MA

Database Team : ORACLE DBA

· Analyzed existing 10g database environments and deployed recommendations for improvement.

-New tablespace layout, index rebuilds, table partitioning, bitmap indexes, compression,

SQL tuning, materialized views, incremental data loading, parallel processing, backup/recovery.

12/06 – 2/09 Massachusetts Institute of Technology Cambridge, MA

Database Services : ORACLE

DBA / Architect

· Migrated existing Enterprise Data Warehouse to new Sun Solaris / Oracle 10G / EMC DMX

environment.

-Represented Database team in all Design sessions prior to performing the physical cutover.

· Enhanced the Data Warehouse with new tablespace layout, parameter modifications, nightly load

tuning, query optimization, table partitioning, and statistics gathering procedures.

5/06 – 12/06 First Marblehead Corp Boston, MA

Enterprise Data Warehousing : ORACLE DBA / Architect

· Acted as Lead Database Architect in structural redesign of corporate Data Warehouse.

-Duties included schema design / deployment, table partitioning, impact analysis, Informatica maplet processing, index / view / procedure creation, SGA specification, & query tuning.

9/05 – 5/06 Arbella Insurance Group Quincy, MA

Database Engineering Group (Development) : ORACLE DBA / Architect

· Served as Lead Database Architect on an Enterprise-wide 3-tier development effort.

-Duties included schema design & deployment, DB environment management, DBA team liaison, initial database creation, data load design, query tuning, & application support.

· Represented Database team at various Architecture and Design meetings.

· Worked within DBA team structure to migrate all database environments into High-Available cluster.

12/04 – 9/05 JP Morgan Investments Boston, MA

Data Management Group (Development) : ORACLE DBA / Architect

· Provided DBA support for evolving Data Warehouse environment

-Duties included analyzing current Informatica workflow, data analysis, SGA tuning, table partitioning, Statistics generation, index rebuilds, & object reorgs.

· Enhance/Design database schema to provide for addition Compliance customer tracking requirements.

· Served as Development DBA resource for additional projects leading to Production deployment.

9/03 – 12/04 Fidelity Investments Boston, MA

Global Equity Trading Technology : ORACLE DBA / Architect

· Provided DBA support for Production & 25+ Test environments for a large-scale, distributed Financial

application. Responsibilities include Production database monitoring, Queue configuration, data

migration, schema enhancement, partition maintenance, data pruning, and backup/recovery.

· Worked within team of DBAs on various projects: DataGuard implementations, Database reorgs,

Data Warehouse design/configuration, Materialized View replication, Sun-to-IBM migration

· Served as DBA resource for various Development efforts leading to Production deployment.

6/03 – 9/03 Inficon Cambridge, MA

Database Engineering : ORACLE DBA / Architect

· Provided initial consultation on database structures and physical layout, redesigning where needed.

· Developed PL/SQL packages to perform various data-cleansing operations.

· Designed strategy to migrate client databases from 8.1.6 to 9i taking advantage of new features

where advantageous.

1/03 – 6/03 Fleet Capital Leasing Providence, RI

Information Technology Department : ORACLE DBA

· Performed complete database evaluation resulting in a list of recommendations : Table / Index reorgs,

EMC disk array configuration, index additions, SQL query optimization, init.ora parameter changes,

memory tuning, Export parameter changes, obsolete table reduction, and “hot backup” improvments.

· Redesigned “monthly load process” PL/SQL package to both eliminate row-chaining and simplify logic.

· Designed automated process to “refresh” development/QA databases from Production environment

via shell scripts, PL/SQL packages (schema extraction) and Export / Import utilities (data migration).

7/02 – 12/02 EwayDirect Norwalk, CT

IS Department : ORACLE DBA / Architect

· Performed initial evaluation of Production database environment due to various response-time problems

identified by Client. Discussed recommendations with Client and planned implementation.

Tasks included database structure changes, Table / Index reorgs, index additions, parameter changes,

memory tuning, SQL coding changes, data purging procedures, and PL/SQL development.

· Designed strategy to migrate Production 8.1.5 database instance to newly-created 8.1.7.4 instance.

· Coded numerous PL/SQL packages in order to streamline data manipulation processes.

· Tuned slow-running queries : SQL Explain Plans, index addition/modification(s), PL/SQL

· Advised Client on various architectural matters.

5/02 - 6/02 Rockland Trust Company Plymouth, MA

Technology Center : ORACLE DBA

· Performed initial installation of Oracle RDBMS software on new server. Created database and all

schema objects to be utilized by 3rd party software application.

· Migrated data from non-relational source system to newly-created Oracle database. This process

involved extraction from legacy system, loading to Oracle via SQL-Loader, and PL/SQL data cleansing.

· Created backup/recovery process for nightly cycle.

8/01 - 4/02 Agencourt Bioscience Corporation Beverly, MA

IS Group : ORACLE Applications DBA / Architect

· Participated in implementation of Oracle 11i Applications.

-Duties included DBA support, Patch application, TAR resolution, database tuning, & Sun/Solaris configuration and monitoring.

· Automated nightly/weekly maintenance cycles via Crontab shell scripts

-Jobs included table analyze/reorgs, online index rebuilds, Archive Log purges, tablespace coalesce, data migration (export/import), & object recompiles .

· Supported LIMS (Lab Information Management System) design & deployment. Created database

tables and PL/SQL packages in order to store & process Clinical Lab data.

· Advised Senior Management on various archtectual matters.

3/01 - 7/01 JP Morgan Chase – ArrakisPlanet.com Cambridge, MA

Database Group : ORACLE DBA / Architect

· Acted as lead database architect for a Sybase-to-Oracle conversion of a large-scale financial

application. Duties included existing-system analysis, database design, data migration,

Oracle mentoring, Hardware architecture (Sun/Solaris) and PL/SQL coding.

· Designed PL/SQL coding architecture utilizing packages, procedures, and functions to interface with

Java application layer; Coded various system components within this architecture.

· Developed migration procedure utilizing Sybase Bulk Copy and Oracle SQL-Loader.

11/99 - 3/01 EMC Corporation Hopkinton, MA

Internet Solutions Group : ORACLE DBA

· Supported numerous external client databases in a “showcase” hosting environment implementing

EMC’s “best practice” solutions.

-Duties included software installation, database creation, monitor configuration, sizing/tuning, backup/recovery, site design, customer advisement, & ongoing maintenance.

· Designed the Oracle components for a database backup/recovery methodology utilizing shell scripts,

EMC’s Timefinder software and Oracle’s “hot-backup” capabilities.

· Redesigned layout for Oracle 11i Apps configuration.

-Enhancements included optimal disk utilization, tablespace relocations, table/index resizing, App file layout (on disk stripsets), & nightly maintenance cycle via Cron.

· Acted as Oracle database liazon to EMC’s Ireland facility; Facilitated knowledge-transfer

sessions with staff, recreated existing database environments, participated in new site buildouts,

and provided remote DBA support as needed.

5/99 - 11/99 Planning Systems Inc Portsmouth, NH

Database Systems : ORACLE DBA / Architect

· Acted as lead database architect for legacy-to-Client/Server military (U.S. Navy) application.

· Facilitated database design sessions to transform requirements into a logical/physical models.

· Configured database environments for Development & QA to contain the new schemas.

This included initial database creations, table/index scripting, sizing/tuning, data migration,

ongoing database support, and knowledge transfer to both in-house staff and those at client site.

2/99 - 5/99 Boston Communications Group Woburn, MA

Information Systems Division : ORACLE DBA

· Configured 300+ Gigabyte Oracle 8 database environment for new corporate Data Warehouse.

Initial installation, hardware striping requirements, table/index sizing, schema scripting,

design recommendations, table partitioning, performance tuning, and final deployment.

· Supported staff with various DBA tasks including Production OPS support, development

& QA database creation, new schema design, data maintenance and SQL scripting.

· Acted as resource for migration of Production Oracle 7 OPS environment to new Oracle 8

database; Implemented partitioning strategy for large tables.

4/97 - 1/99 UNIFI Communications Lowell, MA

Research & Development : ORACLE DBA

· Managed multi-Gigabyte database environments in the corporate SQA lab.

Responsibilities include schema deployment, release management, data migration,

database creation, shell & SQL scripting, performance tuning, and code installation.

· Designed & Implemented OLTP database utilizing Oracle 8 Parallel Server. Tasks

include hardware layout, database creation, schema design, table/index partitioning,

SQL Package tuning, multi-node load testing, and partition maintenance automation.

· Served as database resource to R&D department for project release management,

product configurations, and technology planning for new SQA lab environment.

4/95 - 4/97 Fidelity Investments Boston, MA

Vantage 20/20 Database Services : ORACLE DBA

· Provided DBA support for Production & 150+ Test environments for a large-scale,

distributed Financial application. Responsibilities include Production database

monitoring, schema creation/incrementals, data migration, performance tuning, index

creation, backup/recovery, shell scripting, and object reorgs.

· Represented department at meetings involving Production installs, System integration,

Test methodologies, Risk assessment, and Database environment strategies.

8/92 - 4/95 Bank of Boston Boston, MA

Corporate Center Systems : Sr. Database Systems Specialist (MS SQL Server)

· Acted as Database Administrator with duties including software installation, database

script creation, Stored Procedure & Trigger coding, index creation, performance tuning,

load process design/implementation, user account management, & production support.

· Performed data modeling & logical/physical database design for numerous Financial

Client/Server database systems.

· Designed/coded Graphic User Interfaces (GUIs) to access data on remote database servers.

7/89 - 8/92 John Hancock Financial Services Boston, MA

CASS (Client Accounting & Statistical System) : Programmer/Analyst (Sybase)

· Assigned to design team responsible for requirements accumulation, functional interaction,

Data Model creation, & overall system definition.

· Designed various system components including online transaction processes, batch

procedures, global subroutines, referential integrity constraints, & reports.

· Coded application software within a structured architecture utilizing Stored Procedures

and Triggers.

12/87 - 7/89 GTE Government Systems Billerica, MA

Network Engineering Department : Software Engineer - Secret Clearance

· Participated in the design, development, and implementation of Object-Oriented software

components within a large-scale military information system.

· Analyzed data to produce Entity-Relationship models utilizing in-house CASE technology.

· Assigned to core research team responsible for Information Engineering on a military

deployment system; Attended various seminars for training in this discipline.

EDUCATION

Wentworth Institute of Technology Boston, MA

Bachelor of Science Degree in Computer Science, September 1987

AFFILIATIONS

WHO'S WHO among Students in American Universities & Colleges, 1987

Vice President of Wentworth Student Government, 1986 - 1987

Contact this candidate