Candidates About

Brett Matthew Williams

BACKGROUND SUMMARY

Versatile and reliable Sr. Database administrator/ engineer with thirteen years of experience.

DATABASE ENGINEER

Rackspace Hosting (via TEKSystems)

October 2016 - April 2017
Title: Database Scientist/ R&D Product Engineer IV/ Azure SME

Databases: Microsoft Azure, SQL 2018 (Beta), Amazon AWS, SQL 2016

* Microsoft Stack engineer working in conjunction with Rackspace Hosting Research & Development to expand the possibilities of cloud-based technologies.

* Lab-based environment - utilizing Microsoft SQL 2018 (Beta) in conjunction with Linux systems, and Windows 2017 (Hyper V).  This includes creation of engineering rollout plan.

* E2E SQL Database installation/planning directly under Program Manager within Spheres of Support/ Fanatical Support.

* Coordinating release management and deployment procedures.

* SQL - SSRS, SSAS, & SSIS- Deployments, upgrades, networking, & troubleshooting

*MySQL Deployments & Script development (including testing) implemented, administered, migration, and maintenance on MySQL servers within a Linux-based environment

. *Microsoft System Center Failover clustering (both Windows and SQL based)

- Windows 2016 - Hyper V (Disaster Recovery)

Veteran's Affairs (Contractor via KGS)        October 2013 - October 2016
Title: Database Administrator IV/ IT Specialist

Databases: SQL Server 2005, 2008, 2008 R2, SQL Server 2012 & 2012 R2, SQL 2014 & 2016; Mongo DB / Oracle 11g & 12c

* Enterprise level environment with 24/7 on-call support experience

* Primary DBA for multiple projects; responsibilities include overseeing ten other Database Administrators on numerous projects, setting weekly expectations in coordination with project managers and the chief of data operations while maintaining data security in compliance with AITC standards and congressional mandates. Duties include installing/updating SQL patching, trouble-shooting, encryptions, data migration/allocation, and daily routine maintenance.

* Migrating applications from development/test environments to production  - including customization to client specifications in both SQL (NoSQL) and Oracle (GoldenGate 12c)

*Extensive use of SQL Back-Up procedures including to tape, cloud, and NetBackUp.

* Developer of infrastructure architecture with responsibilities including hardware sizing, effort estimation and security oversight.

* Predominate use of VMWare v8.0 through v12.1

* Open-source web application software, such as AMP stack use, including all LAMP (Linus, Apache, MySQL, & Python) used on roughly forty percent of projects.

*Part of team working in conjunction with Microsoft representatives to utilize innovating applications, such as AlwaysOn, to maintain and improve VA Database Servers and best policy practices.

*Daily utilization of SharePoint Server in conjunction with approved venders via shared service applications.

* Active Directory & other LDAP utilization - including rights management, as well as certificate and federation services within a large-scale, ever-evolving enterprise environment.

* Regular utilization of BI - SQL Server Reporting Server (SSRS), SQL Server Analytics Services (SSAS), & SQL Server Analytics Services (SSIS).

* Well versed in United Stated Government standards & practices.

Lyndon Johnson Presidential Library           January 2011 - October 2013

Title: Started as unpaid intern (for school credit) promoted to Database Architect/ Administrator after Internship completed. Current IT volunteer (Spring 2017)

Platforms: Microsoft Windows 7, 8
Databases: SQL Server 2008, R2, & SQL Server 2012 - transitioning to AWS

* Database patches, scripting tables, indexes, constraints, stored procedures, and user-defined functions from production systems to replicate & create database installers for a novice development environment.

* Installation extraordinaire via upgrade from old (SQL 2008) to new system (SQL 2012) following careful migration procedures.

* Supported trending analysis of data gathered during scheduled systems maintenance before finding new ways to evaluate/troubleshoot repeat queries.

* Worked within multiple IDE's - including Microsoft Visual Studio, XCode, & Xojo)                          

* Performed SQL 2008 primary database administrator role maintaining domain structures, user authentication, digital signatures, information security practices, security software packages, and security controls.

* Secondarily responsible for the protection, availability, and integrity of all administered systems data on the in-house network, both domestic and abroad in an OLTP environment. This included extensive back-up/recovery specialization and in-house training.

* Supported the automation & process improvement of functions relative to DFS project databases in production including the introduction of new tools (as needed).

* Worked within multiple IDE's - including Microsoft Visual Studio, Eclipse, and Oracle JDeveloper.

* Project manager of SQL 2012 installation/migration from SQL 2008 system process team.

* Regular use of VMare Workstation v7.0 - 10.0

* Daily performance tuning/ testing administered to optimize network integrity across all platforms. 

* Heavy use of MS Powershell 3.0 - later conversion to Powershell 4.0 in conjunction with Sharepoint Enterprise 2010.

* RMAN back-up specialist (due to extensive work with historical documents/records).

* Daily utilization of SQL 2008 and Windows Server 2008 that included extensive recovery training where I obtained a MCSA Certification.

* MySQL AMP stack used for initial stand-alone database servers.

Harte Hanks/FedEx – Austin Tx                         July 2008 -December 2010

Title: Database Administrator/ IT Specialist/ Data Architect

Platforms: Microsoft Windows Vista, Windows 7
Databases: SQL Server 2005, SQL Server 2008 & 2008r2 / Oracle 10g

* Information security specialist

* Director of Production level support for onsite & offshore teams during development life cycle.

* Co-architect of optimized integral data for international shipping methods for FedEx 2009 using Jscript & VBscript.

* Maintained optimal service levels, recoverability, maintenance, space requirements, and overall database performance and integrity of SQL 2005 system (including weekly performance tuning, upgrades, and back-up).

* Other tasks included creating and maintaining database schemas using stored shipping procedures, views and triggers; providing hypothesis for all root cause analysis with supporting evidence and identifying actions required to restore optimal operating conditions (including configuration changes, patches, etc.)

* Responsible for implementing Enterprise Resource Planning (ERP) into day-to-day projects via a streamlined integration by utilizing MS Sharepoint. 

Database Detectives: Dallas Tx (Contractor for various projects)      

May 2005 -  October 2013

Title: Database Admin/ Architect (depending on contract)

Contract work for companies with a Database Architect/Admin need, but do not possess the funds for a constant DBA presence. Contract positions only.

Platforms: Microsoft Windows ME, 95, 98, 2000, XP, Vista, Windows 7
Databases: SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012

Numerous assignments on a case-by-case and direct hire basis. Freelance database architecture for small businesses who cannot otherwise afford a constant presence; tasks generally include (but are not limited to) system migrations, basic upgrades, multi-systems testing, staging, working within developmental environments, and lots of script writing. Team lead responsible for training junior administrators

* Allowed for numerous networking opportunities that have since served to not only increase exposure to various sizes of database needs; but also provided valuable insight into the evolution of data warehousing from small, to enterprise level scaling.

NBC Universal- USA Network: Los Angeles Ca                

Title: Internship 2007 - 2008 / Paige for Legal Department/ DBA II

Platforms: Microsoft Windows XP, Vista
Databases: SQL Server 2005, SQL Server 2008

* On team responsible for installing, implementation, and configuration of SQL 2008 for entire GE west coast operations upon release.

* Coordinated system upgrades, enhancements, and software updates as directed.

* Met all service level requirements for entire duration of internship, including system monitoring, troubleshooting client connectivity, lock resolution, and performance issues

Other experience with:

·          Data querying and analysis

·          Installing, configuring, and maintaining SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL 2014, SQL 2016, Perl, Oracle, Vader, IDMS, & Mongo DB environments

·          Evaluating and designing a best fit scenarios based on budget and demographics

·          Developing end-customer focused metrics       

·          Facilitating JAD Sessions

·          Managing projects & customer risks

·          Managing multiple schedules

EDUCATION

Master of Arts Degree in General History (with Thesis) from Texas State University  - 2014

Bachelor's Degree in Computer Sciences - 2013

Bachelor's Degree in History from Texas State University - 2012

Teaching Certificate - Social Studies/ History - HS level - Texas State University - 2014 

Master Freemason - Hill City Lodge #456 Texas, A.F. & A.M. Member    2008 - present