Data Engineering

Name: Brett Reed Phone: 817-***-**** Email: **********@*****.***

Objective

To automate existing implementations and increase overall performance, by performing Server and database audits, standardizing database maintenance plans, and optimizing applications.

Management Experience

Professional Highlights

Results oriented leader for MSSQL and MongoDB DBA’s to instill confidence and ownership within team

Implementation Innovator around design standards for encryption, automation, auditing, and monitoring

Cost containment analysis on hardware resources to support increased budget requests and server consolidations

Conduct Interviews for onshore and off shore candidate’s

Perform quarterly performance reviews

Big Data Solutions Architect for rolling out MongoDB for almost 60 instances using 30TB’s of storage for on premise and AWS EC2 instances covering both Linux and Windows. Responsible for creating implementation scripts/procedures and documenting standards covering installation, encryption, security, user access, backup procedures, disaster recovery plans, auditing, automation, and system reporting. Established training for team of over 30 team members to earn Mongo University Certificates.

Database Architect for 1TB Windows Server resource utilization warehouse.

Implemented databases for SiteCore, Siebel, Thunderhead, CRM,’s and portal authentication for millions of users

Performance Lead for 5,100 MSSQL databases across 165 production instances using 635TB of storage

Senior Lead for MSSQL/windows platform in Standardizing global best practices/standards/procedures covering installations, encryption, security, auditing, reporting, and maintenance plans,

Senior Lead Project management for implementing MSSQL Server Consolidations and MSSQL upgrades.

Database Administration

Docker Containers, MongoDB in AWS/Linux/Windows 2012 R2, Sharding, Replication, Encryption, LDAP, Kerbose integration, Ops Manger installation and configuration, consisting of EBS(io1/gp2), S3, and Glacier.

Deployed MSSQL SQL Auditing across all Regions including Custom ETL Warehouse for Reporting

Innovative Lead Problem solver for Design standards, network communication, SQL Tuning

Deployed system wide Windows Registry reporting and configuration changes using PowerShell

Created multiple custom alerting repositories for database/server resource monitoring utilizing DMV’s/PowerShell

MSSQL 6.5,7,2000,2005,2008,2012,2014,2016 including Multi Node Multi Site Clustering, always on, Always Encrypted, Database Mirroring, Replication, Log shipping, DTS, SSIS, SSRS, DMV’s

Hands on OLTP experience (Siebel and website portals) and data warehouses

UDB DB2 version 7, 8, DB2 for z/OS 7,8 Data warehouse and Siebel

Oracle Client setup/configuration connectivity tnsnames, OID

Supported Sybase 12.5.3.1 including conversions to MSSQL

Created system Disaster Recover procedures and participated in multiple successful DR tests

Data Center Migrations

Physical move/migration of both Windows and Unix Database Servers due to a core business unit sale

Windows/Linux Server reconfiguration, domain migration, network troubleshooting, application firewalls

Server and database migration while moving from one physical datacenter to another

SQL Server upgrades from 6.5 thru 2016

HP-UX Sybase conversion to MSSQL 2008 R

Server Consolidations

Conversion and upgrading of unsupported databases and operating systems

Reduction of server footprints to reduce annual hosting costs

Responsible for engineering Hardware/software for procurement

Database installation including system admin and database configuration

Engineered VM requirements for Wintel/Linux

Standardized Docker Linux Containers deployments to ensure identical systems and data integrity

Employment History

SR DBA LEAD

Mercer, Norwood, MA/Dallas TX 2006-present

SR Data Warehouse Developer

Putnam Investments, Franklin, MA

2004-2006

QA Tester - data warehouse

Putnam Investments, Norwood, MA

2001-2004

QA Tester – web/applications

Integrated Planning, Newton, MA

2000-2001

QA Tester – web/applications

Putnam Investments, Quincy, MA

2000

Data Analyst

Federated Investors, Rockland, MA

1998-2000

Education Bachelor of Science Rochester Institute of Technology Rochester, NY

Contact this candidate