Oracle Architect/dba Resume
Boston, MA
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.