Database Developer

Scott Tyree

719-***-**** – *********@*****.*** – LinkedIn.com/in/ScottTyree

Database Developer Administrator

Data Architecture – SQL Database Management and Development

Key Skills

Data modeling

Complex stored procedures

Custom functions & triggers

Script development & debug

Overall system performance tuning

BI using SSRS & ad-hoc sql

ETL using SSIS, SPs & custom tools

Table design & architecture

System management & maint

Disaster mitigation, testing & recovery

Data, user & access security

Analytical, highly engaged Database Design Leader with 15+ years of extensive experience driving data innovation, development and deployment aimed at creating database solutions and optimization.

Skilled in analyzing client operations, applications and programing, and implementing long-term resolutions aligned with end-user needs and growth.

Track record of success in designing, testing, improving, and maintaining new and existing databases that can be integrated with multiple applications.

Excels in SQL, AWS, AZURE, Cloud, NoSQL, Graph, web and mobile platforms.

Expert communicator skilled in translating business needs into technical solutions and building relationships across functions to drive cohesive, strategic operations.

Experienced team builder who has grown, managed and mentored teams of varying sizes and skillsets.

CAREER ACCOMPLISHMENTS

Developed an automated system to identify and track errors in Transaction Monitoring System and customer-facing Service Interrupting Events.

Identified and corrected design errors in SQL process, resulting in the optimization of existing SQL code for performance and reliability improvements.

Developed data warehouse and associated reporting tools in order to improve business visibility and reduce load on engineering team.

Worked with multiple teams in varied locations to gain access to data in order to develop a centralized dashboard showing an overall view of Customer Satisfaction with new product release.

Designed a system to centralize and transform disparate application email processes into one data-driven system.

Managed numerous migrations and upgrades for both server hardware and SQL instances.

PROFESSIONAL EXPERIENCE

FORMATION BRANDS/PMI WORLDWIDE San Francisco, CA 6/2016 - 9/2017

SQL Migration Consultant/Developer

Principal data strategist in the migration from SQL to Oracle, building a suite of data extracts and updates to the primary SQL infrastructure. Produce data extracts for Data Cleansing Team and data update processes to re-load cleansed data, including error checking and record logging. Integral participant in cross-functional troubleshooting of complex systems, applications and programs; deliver recommendations for solutions and improvement.

Developed layout and stored procedures for a very complex product catalog using SSRS that allows for use of multiple dynamic parameters. The output had to be sharable with clients in near real-time.

Performed code cleanup and optimization of majority of existing scripts, SP’s and views.

Managed data cleansing process by creating and executing extract and reload scripts as part of the pre-migration to Oracle project.

Developed suite of reports using SSRS for Sales and Marketing teams.

CPA.com San Jose, CA 2/2012 – 2/2016

Principal DBA/Database Developer

Held accountability for portfolio of database resources and provided significant support to several teams including, Engineering, Operations, Customer Support, Product Management, Sales and Marketing. Designed, generated and managed data warehouse for SSRS reporting. Conducted regular code review with the Engineering Team and created an approval process for object and account creation for Change Control.

Designed, built and managed data warehouse utilizing SSIS for ETL and SSRS for delivery.

Identified and solved longstanding issue with table design behind online store that created performance issues across the site. Primary orders table was indexed improperly.

Successfully achieved “one version of the truth” by building a central data collection and storage system.

Developed process utilizing SSIS and transactional replication to pull data from California, New York, New Jersey and North Carolina locations to facilitate single sign-on across all four web properties.

MICROSOFT (COLLABERA) Issaquah, WA 12/2010 – 12/2011

SQL DBA/Developer/Data SME

Provided support for Microsoft’s cloud offerings as part of the MSS Quality Team. Identified and acquired data needed to create a system that supported the team and numerous internal business partners. The company was rolling out Office365 and used the team’s analysis to provide a smooth migration experience to customers.

Designed, built and managed data warehouse, data mart and the SSRS environment.

Built SSIS packages to pull data from systems used to capture CSAT.

Provided ad-hoc data to team of analysts based off ever changing and evolving needs.

Established and strengthened relationships with resources outside of the team, while collaborating with other data teams throughout the company.

DATA TIER CONSULTING Addison, TX 2/2008 – 12/2010

Senior SQL DBA/Database Developer

Directed concurrent database projects, including global corporate relocation, nationwide health insurance provider, financial services and municipal government in line with aggressive timeline, quality and client requirements.

Formed and implemented a strategic plan to avoid future disaster scenarios by increasing security measures and enhancing backup and maintenance plans.

Designed and built solution for automated contract generation using SSRS which eliminated old manual process and shaved several days off the overall contracting process.

Effectively trained Reporting Team on appropriate T-SQL coding standards and best practices, which increased productivity, efficiency and accuracy.

Identified and resolved several inaccuracies and inefficiencies in the existing CRM, ERP and Leads systems.

Increased SQL performance by 70% through better use of indexing, code optimization and SP rewrites.

CREDIT SOLUTIONS OF AMERICA Addison, TX 3/2006 – 2/2008

Data Services Director/Data Architect

Hired, trained and led the Data Management and Reporting Teams to support the company’s growth. Assembled the entire Data Services Group comprised of Database Administration, Database Development, Data Integrity, CRM Administration and Corporate Reporting Teams.

Developed stored procedures that were used by the Application and Web Development Team for internal and external projects.

Fulfilled mission critical goal of building an extremely complex system that processed third party data into CRM.

Managed software patches and upgrades as well as user access utilizing Roles and Active Directory.

CROSSMARK Plano, TX 8/2004 – 3/2006

UIX Developer/SQL Developer

Created and managed reporting for Crossmark’s Retail Operations and Business Unit. Built ETL’s and reporting tables using DTS and SQL 2000, respectively.

Designed and implemented a system that connected proprietary SalesTrak data, which housed over 2 billion records across 75 tables, to Nielsen data

Developed suite of ETL processes to distribute data to various reporting systems.

Held several roles and responsibilities including user interface developer, reporting portal developer and manager, and reporting services report developer and administrator.

Additional Work History

Global Site Analyst/SQL DBA, Hewlett-Packard, Plano, Texas 4/2003 – 8/2004

SQL DBA/Development Lead, MCI Worldcom, Plano, Texas 9/2000 – 4/2003

Web Applications Developer, Financial Industry Computer Systems, Addison, Texas 9/1999 – 8/2000

On-Air Graphics Designer/Web Developer, Belo Crop/WFAA-TV Dallas, Texas & KOTV Tulsa, Oklahoma 8/1993 – 8/1999

TECHNICAL PROFICIENCIES

SQL MySQL SSRS ETL T-SQL Neo4j AWS AZURE RDMS

SSIS Microsoft Office Suite Adobe Suite NoSQL Active Directory

EDUCATION

OKLAHOMA STATE UNIVERSITY, Stillwater, Oklahoma

OKLAHOMA BAPTIST UNIVERSITY, Shawnee, Oklahoma

Professional Development:

MongoDB for DBA, New Horizons Training Center Dallas, Texas, 2014

Graph Data Modelling, GraphAcademy, San Francisco, California, 2014

Neo4j Fundamentals, GraphAademy, Palo Alto, California, 2013

Contact this candidate