Download PDF

Portfolio items

Data Visualizations

Objective

Actively seeking a position in a small company with a compelling and impactful mission.

My dream scenario is a  long-term position contributing to a highly proficient and collaborative team.  I enjoy working in a team setting and working directly with customers.

Work experience

Nov 2014Present

Database Development Engineer

Tableau Software
  • Built ETL using Talend Open Studio to move build data from operational data store to data warehouse.  Cultivated a set of logging and error-handling best practices for ETL with Talend.
    • Performance-tuned Tableau viz on a large customer data set revealing a bug in the product that produced overly complex query plan.  My investigation helped quantify the cost of the added complexity, which prioritized it's resolution.
    • Collaborated with counterparts in build and architecture team to create scripting and a DB to record builds to changelists associations.
    • Created a method to generate anonymized data from real customer data to perform load testing against a real-world data set.
    Sep 2014Dec 2014

    Database Programming Instructor

    Bellevue College Continuing Education

    Instruction for the following courses:

    • Database Design : Introduction to relational theory, normal forms and utilizing database features to implement business rules.
    • Advanced T-SQL Programming: SQL Server programming concepts including stored procedures, functions, triggers, transactions and error-handling.
    Nov 2013Nov 2014

    Development IT Database Administrator

    Tableau Software
    • Created standard production server environment.  Standardized backups, monitoring, capacity planning, documentation and security for production databases.
    • Implemented, upon request, performance tuning and debugging to 
    • Conceived & implemented reporting infrastructure utilizing SQL Server transactional replication.
    • Curated and implemented several new test data sources for the development team to work with, including Amazon Redshift and SAP HANA (AWS and appliance).
    • Created patching scripts to update database servers on Windows VM hosts.
    Aug 2010Sep 2013

    Senior Database Engineer

    Microsoft (XBox)

    Technologies: SQL Server 2005/2008/2008 R2/2012, Powershell, Windows 2008, 2008 R2, 2012.

    Performance Tuning & Optimization:

    • Researched, authored and tuned methodology for business requirement to alter table structure to a federated database table with 1.5B rows. No customer impact was incurred.
    • Diagnosed, quantified and resolved several live-site performance related bugs. Techniques included query analysis with execution plans, index fragmentation analysis, blocking and concurrency analysis.

    Capacity Planning

    • Developed, refined database growth metrics collection and analysis at the data file and table/index-level to project hardware requirements.
    • Developed SSRS reports displaying growth trends in a concise, attractive format.

    High Availability

    • Developed and refined infrastructure (SQL jobs, Powershell cmdlets and database objects) to monitor and alert on SQL Server transactional replication latency.
    • Architected, monitored, deployed and supported several SQL instances utilizing SQL 2012 Always-on groups, SQL Database Mirroring, log-shipping and replication.

    Security

    • Authored, implemented a high-security database utilizing table encryption, auditing and limited security configuration. Work included defining symmetric and asymmetric keys, a secured escrow certificate, and code to encrypt and decrypt the sensitive data.
    • Implemented Active directory role/resource group separation in order to grant least-required client-to-server privileges.

    Leadership in operational excellence

    • Developed deployment protocols to efficiently test, validate and rollback partitioned database deployments.
    • Scripted automated database patching to simplify and consistently and thoroughly patch database servers.
    • Defined and led a project to store infrastructure source control and deployment strategy for database infrastructure code. 
    • Set up code review process to for internally developed database monitoring and administrative code.
    Sep 2007Aug 2010

    Database Developer

    Microsoft (IT)

    Technologies: T-SQL, SSIS, SSRS, MSBuild

    • Defined requirements, designed, developed and reviewed database back-end for a custom build tracking system.
    • Independently developed and deployed a light-weight disk space monitoring solution bridging needed functionality until the team was able to onboard SCOM.
    • Implemented TFS daily build and validation automation.
    Dec 2005Sep 2007

    Senior Database Administrator

    Microsoft (IT)

    Technologies: SSMS (2005), T-SQL, VBScript

    • Owned the domain password change enhancement process, reducing the effort from 72 work-hours to 4. Work included problem analysis, definition and scope, solution development, testing and implementation.
    • Planned, documented, tested and implemented SQL 2000 to SQL2005 upgrade for the Compass/Clarify datastore.  Zero-downtime incurred.
    Feb 2003Dec 2005

    Systems Engineer

    Microsoft (microsoft.com)

    Technologies: SQL2005, SQL2000, T-SQL

    • Collaborated with Windows Update feature team in planning, deploying, upgrading and supporting the data-tier infrastructure for Windows Update.
    • Debugged and refined dev and test environments to properly simulate production for PENS (Personalized Electronic Newsletter Service)
    Apr 2002Feb 2003

    DBA Manager

    T-Mobile (Voicestream Wireless)

    • Assign, monitor, and reallocate team resources, as needed to current and future SQL production projects. 
    • Serve as a liaison between Production Support and internal customer groups in charting the progression and procedures required to move SQL Server database applications from dev/test to production. 
    • Provide a sounding board and direction to new ideas for staff DBA's.
    Jan 2001Apr 2002

    SQL Server DBA

    T-Mobile (Voicestream Wireless)

    • Developed/documented Voicestream SQL Server hardware and software installation standards. 
    • Indexing and query-tuning analysis for several mission critical systems. Tools included SQL Profiler, Index Tuning Wizard, Query Analyzer, Windows 2000 Performance Monitor & Quest Spotlight on SQL Server. 
    • Diagnosed and remedied day-to-day SQL-related problems. 
    • Developed and implemented disaster recovery plan. Leveraged log-shipping for SQL 7.0 to remote site. 
    • Developed and implemented database capacity planning and forecasting. The system utilized SQL Agent Jobs, stored procedures and transactional replication to track database and database table growth on several servers to be used to provide a historical basis to predict growth trends and patterns.

    Skills

    Database Performance Tuning
    (SQL Server, all versions) Index, statistics analysis Query plan analysis Index health/maintenance development
    Database Security

    Server, Database, object-level security Utilizing server, database, application roles Best practice implementation (SQL injection, authentication modes, integration with Active Directory) Encryption (symmetric, asymmetric keys) SQL Server Audit (SQL2008, 2008R2)    

    T-SQL Development

    Relational database development, including most T-SQL constructs; views, stored procedures, inline and table valued functions, CTE's.

    Scripting

    Various administrative tasks utilizing Python 3.5, Powershell versions 2.0, 3.0. Cmdlet and script samples available upon request.

    ETL

    Talend Open Studio

    SSIS

    Tableau

    Created various Tableau server data sources and workbooks to help see and understand data.  Samples available upon request.

    Capacity Planning

    SQL Server ( versions 2005, 2008, 2008R2, 2012)   Tools: Data collection Perfmon Profiler

    High Availability

    Database Mirroring (SQL 2008, 2008 R2) SQL Always-On Groups (SQL 2012) Log-shipping (SQL 2005, 2008, 2008R2) Transactional Replication (SQL 2005, 2008, 2008R2, 2012) Backup/Recovery (All versions)  

    References

    Dave Smolin

    • Development manager (customer)
    • 4/16-Present

    Jeesh Murali

    • Developer peer at Microsoft
    • 10/2011-11/2013

    Nicole DesRosiers

    • Developer peer at Microsoft
    • 9/10-7/2012

    Jason Bell

    Manager:

    • IEB (XBox)
    • 9/2010-7/2012

    OLTP database optimization

    Education

    Sep 1995Jul 1997

    B.A. Computer Science

    University of Maryland University College
    Sep 1992Sep 1995

    University of Maryland