We provide IT Staff Augmentation Services!

Senior Data Warehouse Dba Resume

Fremont, CA

SUMMARY:

Over 37 years of experience in driving mission critical systems involving data driven OLTP solutions. The last 15 years have been focused on designing Data Warehouse designed with Confidential OLAP. Managing agile work teams to build Business Analytics solutions from multi - dimensional data models. These projects required the ability to forge technical solutions and develop flexible implementation plans in a team environment.

TECHNICAL SKILLS:

  • CA ERWIN Data Modeler
  • Embarcardero ER/Studio Data Architect 9.0
  • Visible Analysts 7.6.5
  • Red Gate SQL Compare
  • Embarcardero DBArtisan
  • Netezza (Striper,Twinfin /Mustangs)
  • Microsoft SQL Server 2012/2008/2005/2000/7.0/6.5
  • Microsoft SSAS, SSIS, SSRS, DTS, & OLAP
  • MYSQL
  • Microsoft ACCESS
  • SYBASE
  • ORACLE 8i
  • DB2 UDB, DB2/MVS
  • Linux
  • Microsoft NT 2008, NT 2003, NT XP, NT2000, Windows NT 4, Windows 98/95
  • IBM OS2, OS2 LAN Server
  • IBM AIX, MVS, VM, TSO, CICS

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Senior Data Warehouse DBA

  • Senior Architect/DBA of MYSql & MS SQL server hosted in AWS, server farm & client server sites.
  • Multiple complex database to support:
  • NASCAR motorsport
  • Major League Baseball
  • College football player & ball tracking system
  • Broadcast graphic rendering systems
  • World cup of hockey tracking system.
  • Re-architect system to create a production quality system from a unstable “production” system.
  • Extensive use of data replication with a mix of MYSql, MSSQL & SymmetricDS replication.

Confidential, San Francisco, CA

Senior BI/Data Warehouse Architect/DBA

  • Senior Architect/DBA overseeing the entire Netezza server environment.
  • Provide 24 x 7 support for server and DBA with 7 Netezza consultants.
  • Lead integration plan for production and change control for Netezza environment.
  • Design with IBM the creation of Netezza replication with PTS servers for real-time replication. This is part of the corporate disaster recovery between two new data centers.

Confidential, San Francisco, CA

Senior BI Architect/Developer

  • Enterprise Data Architect for integration of all cloud bases business systems to support enterprise wide data analytics and data mining.
  • Principle Data architect for bring Microsoft SQL server 2012 Business Intelligence for implementing Data warehouse with BI in 10 months for exception ROI.
  • Implemented source cross system information from across the company with SSIS.
  • Created SSAS cubes from the data warehouse for all departments to get a single multiple dimensional analyses and reporting.
  • Designed corporate Data Warehouse model to support multi-dimensional data analytics and data mining.

Confidential, San Francisco, CA

Senior Database Architect

  • Enterprise Data Architect of Global BASES (800 million in annual revenue).
  • Leader Data architect for Re-engineering Flowshare project on Netezza.
  • Enterprise Data Modeling in ErWin

Senior Database Administrator

  • Managing over 40+ Netezza servers with over 1300 TB of data.
  • Managing and tuning over 2000+ SQL servers with more than 100 terabytes for OTLP, .NET, OLAP, data warehousing, datamarts, and data mining with SSIS,SSAS & SSRS.
  • Automated HP monitoring for SQL servers.
  • DBA support for the full developmental life cycle of multiple projects.

Confidential, Foster City, CA

Senior DBA/Architect

  • Developed Data Warehouse architecture for a start-up in Visual Analyst with data dictionary and ERWin.
  • Managing and tuning over 15 servers for OTLP, .NET, OLAP, data warehousing, datamarts, and data mining with SSIS,SSAS & SSRS.
  • Developed strategies to monitor and proactively minimize recurrent errors in a 24 x 7 support environment.

Confidential, Oakland, CA

Consultant

  • Managing and tuning over 150 server for OTLP, .NET, OLAP, data warehousing, datamarts, data mining, and data replication using MS SQL server and Oracle.
  • Developed strategies to monitor and proactively minimize recurrent errors in a 24 x 7 support environment.
  • DBA support for the full developmental life cycle of multiple projects.
  • Logical and physical database design of the Enterprise Data warehouse on Oracle.
  • Design and automation of disaster recovery procedures.

Confidential

Consultant

  • Design paper less imaging medical charts system using MS Access, Acrobat, MS Word, and MS SQL Server.
  • Turn key backup, recovery, and disaster recovery procedures.
  • Developed HIPAA compliance access and security.

Confidential, New York, NY

Senior Consultant

  • Managing and tuning production MS SQL server.
  • Built a clustered SQL Server 2000 server to support a corporate wide intranet business portal.
  • Migration of SAP and application systems from Oracle to MS SQL Server.
  • Designed data model to assure successful implementation.
  • Analyzed data for integrity and coherence with Data Transformation Services (DTS) & OLAP Services.
  • Executed data migration via an iterative process; refining and validating the conversion of the data.

Confidential, New York, NY

Project Manager

  • Implemented web-based technology to gather and review corporate tax returns for all subsidiaries.
  • Created the first universal web-based reporting portal at Metropolitan Life.
  • Designed and implemented data warehouse to monitor corporate compliance.

Relational Database Administrator

  • Administered financial reporting database, critical to hundreds of business analysts, which incorporated Cognos multi-dimensional cubes and Actuate reports.
  • Designed, built, and configured clustered MS SQL server 7.0 on Windows NT 4.0 Cluster Server.
  • Database design and performance tuning for various projects.
  • Converted financial reporting system from an MS SQL Server to IBM UDB EEE database.
  • Database Architecture, Design, and implementation of a 40 terabyte compliance database on IBM UDB EEE.

Distributed Technology Administrator

  • Assessed IBM DDCS/2 and IBM Data Propagator Relational.
  • Database and system administration of Sybase.
  • Developed procedures for installation and performance tuning of Micro Decisionware Gateways on OS2 and Windows NT.

Confidential, New York, NY

Relational Database Administrator

  • Implemented a datamart of the global management system for decision support.
  • Migrated critical data from legacy mainframe databases to SQL Server.
  • Implemented the integration of Bachman DB2 DBA and Analyst.

Confidential, New York, NY

System Administrator, DB2

  • Developed backup and recovery procedures for the DB2 subsystem and end-users.
  • Developed the disaster recovery plan for off-site storage and restoration.

Confidential, New York, NY

Database Administrator, DB2

  • Installed Systest and Production DB2 environment and coordinated the migration of applications.

Confidential, New York, NY

Systems Engineer

Technical sales support specializing in DB2, QMF, SQL/DS, and CSP.

Senior Systems Programmer

Developed the SQL/DS database product.

Hire Now