Candidates About

 

Douglas e. Brown

INTRODUCTION

A highly accomplished Database Technology Professional with over 20 years industry experience leveraging Database technologies and cloud platforms in the design, development and implementation of large scale technology solutions.

 

EDUCATION & TRAINING

 

Education

Temple University

Bachelor of Arts Physiology May 1985

 

Formal Training / Skills

Training Mongodb 2013

Training MS Cluster and HA 2006

Training LINUX 2006

Training SQL Server DBA 2003

Training Oracle DBA 2003

Cloudera Hadoop Administrator  May 2016

Awards
Full Athletic Scholarship Temple University / Men’s Gymnastics Team
1981 NCAA Championships
1983 United States Men’s Gymnastics Eastern Regional Team
1987 United States Junior Olympic Gymnastics Judges Association
Temple University Athletic Announcer 1986 - 1998
Federal Executive Board silver medal for excellence in performance and dedication, 1997
Federal Executive Board bronze medal for excellence in performance and dedication, 1995
Certificate of recognition for exceeding performance requirements, 1995
Certificate of recognition for support in meeting station objectives, 1993, 1994, 1996

 

Professional Associations

Professional Association of SQL Server (PASS)

SQL Server Central

SQL Server Worldwide Users Group (SSWUG)

PHLOUG - Philadelphia Oracle Users Group

IOUG – Independent Oracle Users Group

BDPA Houston Chapter

 

 

 

BACKGROUND SUMMARY:

 

Senior Database Architect/Engineer/Administrator (Total Experience – 12+ years)

Develop database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.  Maintain database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.  Prepare users by conducting training.

 

Senior Performance Tuning Consultant (Total Experience – 12+ years) 

Responsible for performance tuning and optimization of relational databases management systems, deployment of RDBMS running on Linux, Windows, Open VMS and UNIX platforms.  Provide consulting on performance tuning and troubleshooting, application workload testing, integration, data migration and general problem solving.  Architect and implement backup and disaster recovery solutions including native back tools deployed with the RDBMS. 

 

Technical Project Management / Technical Lead (Total Experience – 6+ years) 

Responsible for establishing and managing the scope of remediation activities for the various data warehouse performance tuning technical tasks; Responsible for creating and maintaining a plan for execution of the data warehouse performance tuning activities; Work closely with department heads as portions of the technical issues were shared  inter-departmentally.  In addition to building a close relationship I also defined the accountability resolutions to help long term problem solving pertaining to shared technical responsibilities.  Focal point for all planning and execution activities for the technical environments involved.   Accountable for the following tasks: Initial project planning, Development of project scope, Defining project guidelines, Resource coordination (internal and contracted), Testing coordination.  Manage project plans and project resource requirements and budget.

 

 

Senior Database Administrator (Total Experience – 12+ years)

Responsible for administering, performance tuning and optimization Oracle databases, deployment of Oracle databases; Oracle RAC & Grid Control; SQL Server databases; Sybase; MySQL databases; The concurrent user count ranges from 100 to 10,000 users & web users (con-current).  The systems infrastructure that these databases operate on range from stand-alone systems to clustered systems.

 

BIG DATA Solutions Provider & Administrator (Total Experience –4+ years) 

Business Intelligence (BI)/Online Analytical Processing (OLAP); interactively analyze multidimensional data roll-up, drill-down, data slicing; Cluster Analysis; Data Mining; Network analysis; NoSQL Database; Hadoop; Hadoop Cluster Administration; MongoDB DBA; Big Data Strategies - Performance Management (non-transactional, US Census data), Data Exploration, Social Analytics (non-transactional, click stream data).

 

Overall Technical Expertise (Total Experience – 25+ years) 

Industry Experience Includes - Healthcare, Telecommunication, Technology, Banking & Financial Services, Manufacturing

 

 

 

 

 

 

 

 

 

TECHNICAL SKILLS & QUALIFICATION SUMMARY:

 

·         Database Design, Data Maintenance, Database Security, Database Management, Requirements Analysis, Teamwork, Technical Zeal, Project Management, Presenting Technical Information, Training , Operating Systems   ·         On-Line Transaction Processing (Mission critical applications - Transactions); OLTP; Database Management System; MS Cluster Services; SQL Profiler; SQL Server Reporting Services; SQL Server  Replication; Network Operating System; Adhoc Reporting Services;              Alwayson Failover Cluster; AlwaysOn              Availability Groups; Q&A Product Life Cycle               Management; Project Management; Crystal               Reports   ·         Database Design and Administration - Oracle  v8, v8i, v9i, v10g, v11g,  SQL Server  v6, v7, 2000, 2005, 2008, 2008r2, 2012, 2014, 2016; MySQL, Access ,PostgreSQL v9.4, v9.6   ·         Oracle DBA – Oracle v10g, v11g, 12c; DBA, Sun Solaris, IBM AIX, HP HPUX, Linux and Windows installation and scripting.   ·         SQL Server SSRS, SSAS & SSIS, Database Clustering (Log Shipping, Data Mirroring, Replication), SAN Storage Technologies.   ·         SQL Server DBA – v6, v7, v2000, v2005, v2008, v2008r2, v2012; v2014; v2016; Windows designs, implementations and performance tuning; Microsoft SQL Server Migration Assistant (SSMA); Microsoft Power BI   ·         SQL Server DBA – v2008r2, v2012; Cluster implementations, HA, Log shipping, Always-on availability, Mirroring     ·         VMWare, Hyper-V and AWS cloud Administration, Azure Cloud, ADMS (Azure Data Migration Service); Azure SQL DW   ·         MySQL DBA – v4, v5, v6, v7 windows, Linux  designs, implementations and performance tuning, clustering, replication and data migration   ·         Big Data Technology –Hadoop Distributed File System; Replication; Amazon Web Services; Map Reduce;  YARN; MongoDB v2.4 -2.6; Amazon Web Services; Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization; Azure Cloud Services

Project Management – Project Managed via software manager, Team Lead, Technical Lead, Resource Management and Project Development   ·         Peoplesoft – v5, v6.x, v7.x, v8.x, v9.x, HRMS, CRM, Implementations, deployments and performance tuning.  Ptools v8.14-8.5x, Upgrade Assistant and new Upgrade Manager (9.2x)   ·         Microsoft Dynamics SL 7/2011; SharePoint 2010; SAS; Chesapeake IDM TRECS; IBM Cognos; Bassetes; Rapport Leasing; Crystal Reports Server   ·         Clinical Applications – MOM Reporting and Monitoring System;  Eclipsys Clinical Application, MS SQL Server DB   ·         Staff and Budget Management – Management of Technical Resources up to 50 on-shore & off-shore in all.  Departmental Budget and Project Budget Management for hardware and staffing requirements.  Resource Management and Cost Analysis.       Data Warehouse – Star Schema, Snowflake, Business Objects, Extract Transform and Load, data migration and performance tuning, Azure SQL DW   Big Data Strategies - Performance Management (non-transactional, social data), Data Exploration, Social Analytics (non-transactional, social data), Decision Science; Designing and developing scalable software architectures; Manipulate massive-scale datasets, Architectures for big data capture, representation, information extraction and fusion.

 

 

 

 

 

 

WORK EXPERIENCE SUMMARY

 

 

 

McBee Associates                                                                                                                      09/16 – Present

Wayne PA

 

DBA Lead / Postgresql DBA /MS Azure DR Architect / MS SQL Server Database Architect & Administrator

 

• Worked with systems administrators to implement cloud architectures that utilize industry best practices
• Implement cloud technology policies, and procedures for disaster recovery and archiving to ensure effective protection and integrity of storage appliances and stored data assets
• Development of the DR workload migration plan in conjunction with application owners and other technical resources
• Establish appropriate end-user access control levels for stored data
• Review and deploy cloud system releases and vendor-supplied patches according to best practices
• Managed MS Azure accounts utilized for disaster recovery/storage/Big Data Platform
• Designed and Developed data migration strategy between on premise and Azure environments
• Administration of PostgreSQL multi node clustered and replicated environments
• Monitoring of system performance utilizing PgAdmin, Splunk, Debeaver and command line tools
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra.
• Defined data elements that were required for initial Big Data Platform

 

• Follow change control, incident response, and testing processes for modifications to cloud technologies and software
• Creation of power shell scripts to support automation and simplification  of administrative task
• Maintained cloud systems support and architecture documentation
• Utilize Jira for time and project tracking
• Team designed and trained to follow Kanban or Scrum based on project or user story.
• Establish and document the PostgreSQL/EnterpriseDB technology stack including standard operating procedures including startup/shutdown, backup/recovery, disaster recovery, fail over
• Provision production database enterprise manager server, replication server and replicated standby for disaster recovery
• Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments
• Manage backup and recovery functions for a PostgreSQL reporting data warehouse environment
• Setup alerting mechanism for both PostgreSQL database and supporting environment to ensure system health and maximum availability

• Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud
• Created monitoring solution for  production databases with PowerShell, Solar Winds & SQL Server Mgmt Studio

·         Database Consolidation from MySQL, DB2 & SQL Server into PostgreSQL Database (Data Warehouse Reporting)

·         GG replication for changes from SQL Server, DB2 and MySQL to PostgreSQL

• Created & Documented high level SQL Server consolidation plan to upgrade older SQL Servers onto newer platforms
• Developed support plan for MS SQL Server databases including performance tuning & high availability requirements
• Documented plan to migrate SQL Server 2000 database into SQL Server 2012 instances with very little complication

·         POC: SQL Server 2012 to 2016 upgrades

·         POC: SQL Server 2016 application testing

·         SQL Server 2012 to 2016 upgrade on DEV Database

·         SQL Server 2016 upgrade on TST Databases.

·         SQL Server data migration from 2005 & 2008 to 2016

• Implement user access and security procedures in accordance with SOX requirements

 

 

 

Sleep Innovations (Innocor)                                                                                                   02/15 – 08/16

West Long Branch NJ

 

Technical Team Lead / MS SQL Server/MySQL DBA/JD Edwards Database Administrator/ Big Data Architect / Big Data Administrator /AWS Technical Lead / MongoDB DBA

 

 

·         Organized and facilitated Agile and Scrum meetings

·         Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.

·         Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance

·         Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project

·         Provided daily communications, scrum notes, sprint reviews reports, and project retrospectives

·         Provided regular snapshots of project velocity and budget burn rate.

·         Big Data Strategy – Developed Initial Approach and Selected Initial Technology Stack

·         Big Data Strategy – performance management, data exploration, social analytics, data science

·         Design and model database within the NoSQL area to accommodate data solutions with Hadoop and In-Memory DB

·         Architect & Administrator Hadoop, MongoDB, MySQL,Hadoop Cluster

·         Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig

·         Design/Plan/Architect data ingestion strategy from 2000+ data sources into (HDP) Hadoop Data Lake

·         Design/Plan/Architect ETL strategies for real time data pipeline ingestion to (HDP/HDF) Hadoop Data Lake

·         Architect & Administrator Hadoop Horton works, Hadoop Yarn, Talend Analytics

·         Oracle Golden Gate / Oracle Data Integrator / Hive / NoSQL Data integration design & configuration

·         Architect & Administrator (AWS) GenGireXD, PostgresSQL, Greenplum, Hawq & Kafka environments; GoLANG Program

·         Architect & Administrator (Azure) Hadoop Horton works, Hadoop Yarn, Hadoop Spark w/Mongo Cassandra & CouchDB

·         Architect & Administrator (Azure) Hortonworks, Hadoop Yarn, Storm, Nifi w/Mongo, Cassandra & CouchDB

·         Identify and improve data elements within existing data lakes and new data lakes still in design phase.

·         Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra

·         Oracle12C Enterprise Metadata Management installation and deployment

·         Oracle Enterprise Metadata Management - Impact Analysis, Annotation and Tagging functions, Reporting Source Lineage

·         R & Python with comprehensive proficiency; Scala – Architecture & Collection Library, REPL, Scaladoc, Refection, Macros

·         Talend Data Integration- Reading an input file, Transforming data, Combining columns, Joining data sources

·         Talend Data Integration- Creating metadata, Joining data sources, Capturing rejects, Filtering data

·         Talend Data Integration- Filtering output data, Using multiple filters, Using context variables, Error handling

·         Talend Data Integration- Setting up sales data files, Creating customer metadata, Creating product metadata

·         Talend Data Integration- Creating database metadata, Joining data, Creating master Jobs

·         Talend Data Integration- Master Data Management model design, deployment and configuration

·         Replication of Data from JDE database into MS SQL and MySQL databases Platforms for reporting.

·         MySQL Database administration and support and performance tuning. 

·         I setup MySQL monitoring scripts and index rebuild scripys for the purpose of negating possible performance degrading activities.

·         Provision MySQL instances, both in clustered and non-clustered configurations

·         Administer database instances in AWS

·         Ensure performance, security, and availability of databases

·          

·         Perl Scripting modifications and new script development.

·         Backup and Recovery setup via scripts and 3^rd party tools for the MySQL, Oracle and SQL Server Databases.

• Performance tuning exercises within MS SQL Server 2012/2014 database and application parameters
• MS SQL Server Performance tuning exercises within MS SQL Server 2014 database and application parameters

·         MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;

·         MS SQL Server Multiple TempDB Database Files; PolyBase; Query Store; Row Level Security;

·         MS SQL Server R Comes to SQL Server; Stretch Database utilization; Temporal Table utilization

• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication

• GG replication for changes from Oracle, SQL Server, DB2 and MySQL to PostgreSQL

·         150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases – Consolidation/Data Migration

·         300+ Oracle Servers housing over 2200 oracle databases – Consolidation/Data Migration

·         150+ Sybase ASE Database – Consolidation/Data Migration

·         100+ MySQL Database – Consolidation/Data Migration

·         120_ DB2 Database Servers housing over 300 DB2 databases – Consolidation/Data Migration

·         DBA 12c (450+ PRD DB’s); SQL Server DBA 2012/2014/2016 (425+ PRD DB’s); DB2 DBA 9/10 (75 PRD DB’s)

·         SQL DBA – Oracle 11i, 12c, 12c R2, OEM 13c; SQL Server 2012, 2014, 2016; DB2 11.1, 10.5, 10.1, 9.8, 9.7;

·         SQL DBA – Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,

·         SQL DBA – High Availability (RAC, Always On, Data Guard, HADR) Replication (Golden Gate, Native Replication)

·         SQL DBA - Log Shipping, Database Restore, Database Refreshes, Monitoring

·         SQL DBA – Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning 

·         SQL DBA – SQL Profiler, Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)

·         DB2/UDB DBA –11.1, 10.5, 10.1, 9.8, 9.7;

·         DB2/UDB DBA – Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,

·         DB2/UDB DBA – High Availability (HADR) Replication (Golden Gate, Native Replication)

·         DB2/UDB DBA - Log Shipping, Database Restore, Database Refreshes, Monitoring

·         DB2/UDB DBA – Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning 

·         DB2/UDB DBA – Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)

·         150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases – Consolidation/Data Migration

·         300+ Oracle Servers housing over 2200 oracle databases – Consolidation/Data Migration

·         100+ MySQL Database – Consolidation/Data Migration

·         120_ DB2 Database Servers housing over 300 DB2 databases – Consolidation/Data Migration

·          

·         Lead technical team responsible for performing the Oracle JD Edwards Enterprise One, Financials and Supply Chain Management.

• Production Support / PY / QA Support / Development Support

• Performance tuning exercises within SQL Server 2012 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler –MS SQL Server)

• Database Performance Tuning (MS SQL Server)
• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment
• Database Consolidation from Oracle, MySQL, DB2 & SQL Server into PostgreSQL Database (Data Warehouse Reporting)

• Review of the database architecture as a whole to determine areas of improvement
• Performed database refreshes from production to py/dev/qa environments
• Performance Tune JD Edwards environments
• Performance tuning exercises within MS SQL Server database and application parameters
• Performance tuning exercises including index strategies database (MS SQL Server)
• Make recommendations to include table level partitioning where it would improve performance
• Best Practices model for disk level database data file improvements for performance gain (MS SQL Server)
• Always-on availability group for read-only secondary replica
• Recommended backup and recovery strategies for data protection and disaster recovery per the SLA’s
• Deployment of windows Service Packs through windows update process and MS downloads.

·         Support high volumes of production and development service requests

·         Routine daily maintenance (watches space, backup, export, etc.)

• Management of Database Basics (Creating databases, managing transaction logs, sizing database and managing disk space usage and compacting database.
• Manipulating database objects (tables, indexes, table data, creating table triggers, stored procedures)
• Data Transformation Services (Create packages, replication, transformations)
• Install SQL 2016 evaluation in test environment
• POC: SQL Server 2012 to 2016 upgrades
• POC: SQL Server 2016 application testing
• Configure off-site backups in Microsoft Azure cloud storage
• DR Database Deployment with Log shipping utilizing Azure VM with SQL Server 2014

 

 

 

 

 

 

 

Independence Blue Cross                                                                             02/14 – 02/15

Philadelphia PA.

 

Technical Team Lead / MS SQL Server Database Administrator/ Big Data Administrator / Hadoop Administrator / Hadoop Technical Lead

 

• Lead technical team responsible for performing the performance tuning of the ERRECA Clinical Application and the databases associated with the applications for which the databases were essential for.

• Performed ERRECA Clinical Application performance tuning (Query tuning, table resizing, data file group reorganizations)

• Production Support / Test Support / QA Support / Development Support
• Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler primarily)
• Reviewed Windows 2008, VMware and EMC SAN for areas of improvements.  Made recommendations in these areas that would benefit