TECHNICAL SKILLS:

Software: Oracle 7, 8, 8i, 9i, 10g, 11gR2; RAC, ASM, DataGuard, RMAN, AWS, SQL - Loader, ODI, OEM12c Grid Control, SQL Developer, EMC Timefinder, Advanced Queues, Veritas, Sun ClusterSQL Developer, ERwin, Tuxedo, BMC Patrol, TOAD, DBArtisan.

Hardware/OS: Oracle Exadata, Red Hat Linux, ODA, EMC DMX/Symmetrix, NetApp, Sun/Solaris, HP-UX (Vpar)IBM/AIX RS6000, Dell, HP, Windows NT thru XP, VAX 8550 thru 6220, IBM Mainframe 3090.

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

EXPERIENCE:

Confidential, Boston, MA

ORACLE Architect/DBA

Responsibilities:

• Technical Lead for Exadata migration of 5TB database from existing RAC cluster.
• Performance enhancements on various applications which included table partitioning, query tuningschema design, index creation, statistics generation, PL/SQL tuning, table reorgs, table compression.
• Assigned to additional teams to aid in Exadata migrations of existing databases.

Confidential, Quincy, MA

ORACLE Architect/DBA

Responsibilities:

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

Confidential, Needham, MA

ORACLE Architect/DBA

Responsibilities:

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

Confidential, Malden, MA

ORACLE Architect/DBA

Responsibilities:

• 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 deploymentsschema 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

Confidential, Boston, MA

ORACLE DBA

Responsibilities:

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

Confidential, Westwood, MA

ORACLE DBA

Responsibilities:

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

Confidential, Waltham, MA

Responsibilities:

• Deployed a new 11gR2 Data Guard environment to replace existing standalone Production database.
• Configured Data Broker and documented Switchover/Failover procedures for staff.

Confidential, Wakefield, MA

ORACLE DBA

Responsibilities:

• Assigned to client with problematic 4 - node 10gR2 RAC environment. Made numerous recommendations concerning node interconnect (RAC), TNS connectivity, PGA/SGA tuningtable 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 migrationsSQL tuning, Explain plans, RMAN config, and DataPump export/imports.

Confidential, Cambridge, MA

ORACLE DBA

Responsibilities:

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

Confidential, Brighton, MA

ORACLE DBA / Architect

Responsibilities:

• 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 PlansPL/SQL programming, and additional schema structures to facilitate ETL processing.
• Addressed scalability issues with management; Introduced table partitioning, index tuningMaterialized 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 Confidential s databases.
• Designed views and PL/SQL package to perform the extract.

Confidential, Plymouth, MA

ORACLE DBA

Responsibilities:

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

Confidential, Cambridge, MA

ORACLE DBA / Architect

Responsibilities:

• Migrated existing Enterprise Data Warehouse to new Sun Solaris / Oracle 10G / EMC DMX
• 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.

Confidential, Boston, MA

ORACLE DBA / Architect

Responsibilities:

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

Confidential, Quincy, MA

ORACLE DBA / Architect

Responsibilities:

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

Confidential, Boston, MA

ORACLE DBA / Architect

Responsibilities:

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

Confidential, Boston, MA

ORACLE DBA / Architect

Responsibilities:

• 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 reorgsData Warehouse design/configuration, Materialized View replication, Sun-to-IBM migration
• Served as DBA resource for various Development efforts leading to Production deployment.

Confidential, Cambridge, MA

ORACLE DBA / Architect

Responsibilities:

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

Confidential, Providence, RI

ORACLE DBA

Responsibilities:

• Performed complete database evaluation resulting in a list of recommendations: Table / Index reorgsEMC disk array configuration, index additions, SQL query optimization, init.ora parameter changesmemory 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).

Confidential, Norwalk, CT

ORACLE DBA / Architect

Responsibilities:

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