Sql Server Microsoft
Resume:
PROFESSIONAL SUMMARY
Technical Professional with many years of experience architecting, managing, designing, installing, upgrading, maintaining and administering databases and supporting systems that support various Financial, HR, Educational, Healthcare, and other applications. Responsibilities including creating stored procedures, views, triggers, generating reports, architecting solutions, design, implementation, installation, and mentoring others. Excellent communication skills.
Loving data and protecting it.
TECHNICAL SKILLS
Microsoft SQL Server (7, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019), Azure DB, AWS RDS, Snowflake, Redis, Firebase, DBT, AirFlow, FiveTran, PowerBI, Cosmos DB, SSRS, DTS, SSIS, Hadoop, HDinsight, MongoDB, JSon, Windows Server 2008 / 2003 / XP / 9x / 2000 / NT, Crystal Reports, MySql, Oracle, Sybase, Informix, Interbase, Paradox, Sybase SQL Anywhere, Access, DBIsam, PHP, ASP, HTML, XML, Javascript, JScript, Delphi, Pascal, C/C++, Powerbuilder, Visual Basic, DOS, UNIX, Linux, Novell Netware
EXPERIENCE
Nerd United Jun 2023 - Present
Director of Data
Lead and manage a team of Data Professionals (Data Engineers, Data Analysts, Report Designers).
Design and maintain the overall data architecture of the organization(s).
Interact with, mentor, and review data needs with CTOs, Dev Managers, Developers, IT staff, DevOps staff, Product owners, across many company groupings.
Proof of Concept and ownership various data related solutions, with the goal of loving our data.
Lead the development and implementation of data integration strategies to ensure that data is flowing smoothly between different systems and departments, across various RDBMS’s, disparate data storage systems, and data warehouse systems.
Implement and progress Data Governance across the organizations.
Create Documentation for furthering the processes and procedures involving our data landscape.
Environment: Microsoft SQL Server 2019, AWS RDS SQL DB, Mongo DB, Redis, Firebase, DBT, AirFlow, Snowflake, FiveTran, OFAC
Nerd United Jan 2022 – June 2023
Senior Data Architect
Design and maintain the overall data architecture of the organization(s).
Analyze business requirements and determine the most appropriate data architecture.
Interact with, mentor, and review data needs with CTOs, Dev Managers, Product owners, across several brands.
Create and maintain standards for database design and database development.
Proof of Concept various solutions, with the goal of loving our data, data processes, and data folk
Review proposed changes to database schemas
Developing and implementing data integration strategies to ensure that data is flowing smoothly between different systems and departments, across various RDBMS’s, disparate data storage systems, and data warehouse systems.
Implement and progress Data Governance across the organizations.
Environment: Microsoft SQL Server 2019, AWS RDS SQL DB, Mongodb, Redis, Firebase, Snowflake
Health Equity April 2019 – Jan 2022
Senior Data Architect
Interact with, mentor, and review data needs of teams of Data Professionals.
Create and maintain standards for database design and database development
Train Engineering team on standards and processes for database design and database development
Review all proposed changes to database schema
Research and create proof-of-concepts to improve performance, scalability, security, and maintainability
Proof of Concept various solutions, with the goal of loving our data, data processes, and data folk
Environment: Microsoft SQL Server 2012, 2014, 2016, 2019, Azure SQL DB, Windows Server 2016
Nature’s Sunshine Jan 2016 - April 2019
Manager of Database Administrator
Manage team of Data Professionals.
Responsible for 28 database server systems housing 900+ databases.
Implementing best practices for maintenance and performance tuning of database systems.
Institute graceful change management to database systems.
Create inventory of systems and document processes within database systems.
Project management experience.
Environment: Microsoft SQL Server 2008R2, 2012, 2014, 2016, Azure SQL DB, Azure Managed Instance, Native replication, Windows Server 2008, Windows Server Core
Imagine Learning Dec 2010 – Dec 2015
Senior Database Administrator
Responsible for monitoring, troubleshooting, applying change to and improving processes necessary to maintain database systems Production, Staging and Development environments.
Instrumental in creating policies and processes for Production as well as other systems.
Implement SQL Server best practices and policies from ground up.
Responsible for interfacing between Development, QA, and various Operations teams.
Involved in aspects of release management, including database, as well as other. Instrumental in creating release plans as well as either implementing said plans to successfully manage releases thru multiple environments and replication topologies. Perform Production alterations with accepted policies and procedures.
Implement and create team wide best practices and policies for entire IT group.
Responsible for the continual monitoring and performance analysis of various databases in a variety of environments.
Project management experience.
Replication experience with SQL Server Native replication.
Cloud architecture experience with BI emphasis and NOSql solutions.
Environment: Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014, Native replication, Windows Server 2008, Virtual Server
Visa / Cybersource / Authorize.net May 2008 – Dec 2010
Senior Database Administrator
Responsible for monitoring and troubleshooting highly transactional Production environment.
Instrumental in creating Infrastructure Engineering policies and processes for Production systems.
Responsible for interfacing between Product Development and Production Operations teams involving all aspects of release management. Create release plans and Implement plan to successfully manage releases thru multiple environments and replication topologies. Perform Production alterations with accepted policies and procedures.
Responsible for monitoring, troubleshooting and improving processes necessary to maintain Service Delivery of database systems.
Implement SQL Server best practices and policies.
Responsible for the continual monitoring and performance analysis of various databases.
Project management experience.
Disaster Recovery system architecture experience.
Replication experience in a mixed topology with Native replication and GoldenGate replication.
Environment: Microsoft SQL Server 2000, 2005 & 2008, GoldenGate & Native replication, Windows Server 2003, Virtual Server, Windows XP, DTS
ACS October 2005 – May 2008
Database Administrator
Responsible for monitoring and troubleshooting Production environments for 16 clients with multiple database instances both local and remote, including 50+ Database Servers, Reporting Server and Monitoring Server.
Analyze and optimize SQL to increase system functionality and throughput.
Perform production alterations with accepted policies and procedures.
Responsible for monitoring and troubleshooting all aspects of User Acceptance Testing environments including Database Servers, Web Servers, Reporting Server and File Servers.
Instrumental in developing Sarbanes-Oxley compliant policies and procedures for database and web based application operations.
Mentor and Trainer in SQL Server best practices and policies.
Architect for relational databases to support Production / UAT / Development database needs.
Responsible for the continual monitoring and performance analysis of various databases.
Project management experience.
Disaster Recovery system architecture experience.
Environment: Microsoft SQL Server 2000 & 2005, IIS, HTML, VBScript, Windows Server 2003, Virtual Server, Windows XP, Sarbanes-Oxley, Reporting Services, SSIS, DTS
RHI August 2005 – October 2005
Database Engineer Contractor
Responsible for existing and new functionality to be implemented in ARGIS Database on a Microsoft SQL Server 2000/2005 platform.
Modified highly visible reports for enhancements and additional functionality to increase business productivity.
Created new stored procedures for client team needs.
Investigated bug reports, testing for bug, modifying database objects to remedy bugs
Optimized and enhanced various technical processes in ARGIS application to increase efficiency.
Environment: Microsoft SQL Server 2000, Microsoft SQL Server 2005, Windows XP
ACS October 2004 – August 2005
Database Administrator
Responsible for monitoring and troubleshooting all aspects of production, reporting, staging and backup MS SQL Server 2000 databases along with production, staging and backup web servers.
Responsible for the operations of Front End Payroll System (FEPS); internationally used by employees for logging time worked for payroll purposes.
Instrumental in developing Sarbanes-Oxley compliant policies and procedures for database and web based application operations.
Instrumental in developing reporting solutions for internal and external users.
Architect for relational databases to support production database needs.
System Administrator and Technical Resource for operations of FEPS system.
Functioned as the primary resource for database knowledge to application developers.
Responsible for the continual monitoring and performance analysis of various databases.
Environment: Microsoft SQL Server 2000, IIS, HTML, ASP, ASP.net, VBScript, Windows XP, Event Sentry, Sitescope, Web Funnel, Sarbanes-Oxley
ACS October 2002 – October 2004
Senior Software Engineer / Database Administrator
Responsible for the system requirements, analysis design, development, testing, and implementation of applications / systems used in high volume image-based capture environments.
Designed, implemented and administered multiple relational MS SQL Server 2000 databases.
Instrumental in coordinating development efforts remotely for multiple projects.
Develop applications / systems in existing framework, while adding to this framework for custom user needs.
Functioned as technical resource for database knowledge to other application developers.
Environment: Microsoft SQL Server 2000, Delphi, Pascal, HTML, XML, ASP, VB, VBScript, Windows XP
BROOKLINE October 2000 – October 2002
SQL Server Database Administrator / Developer
Database Administrator / Developer / Architect instrumental in mentoring other developers in data access, along with implementing procedures and standards.
Maintain integrity of our database structure across multiple client s databases and platforms while continuing development and new structures with a scripting upgrade system.
Implemented better coding standards, visual standards, and SQL standards, to produce a better application and databases for our users.
Main resource for data manipulation, queries, stored procedures, reports, tuning and problem solving for all database related issues.
Devised creative ways of extracting data from the database increase productivity and system utilization.
Functioned as the Lead Developer instrumental in mentoring other junior developers on process, methodology and technical development experience.
Instrumental in data reporting, including creation and maintenance of Stored Procedures, Triggers, and Queries, reporting with many reporting tools including Crystal Reports.
Maximized capabilities of the databases for use with applications, beyond what current usage.
Environment: Microsoft SQL Server 7 and 2000, Oracle, Informix, Interbase, DBIsam, Delphi, Pascal, HTML, XML, ASP, JScript, Windows 9x/2000/NT, Crystal Reports, ER Studio
SOFTWISE, INC. October 1995 – October 2000
SQL Server Database Developer
Instrumental in entire software process from planning and organizing, through development, application deployment and customer support.
Implemented database replication schemes with paradox, flash filer and later SQL Server Replication.
Created a user friendly front end interface that increase application usage and functionality.
Instrumental in data manipulation (import and export), including creation and manipulation of Stored Procedures, Triggers, and Queries, along with reporting with many reporting tools
Improved all aspects of the software process to create a more efficient means of delivering software
Created methods that empower customers to reach solutions with their own learned abilities
Environment: Microsoft SQL Server 7, SQL anywhere, Flashfiler, Delphi, Pascal, Paradox, HTML, Windows 9x/2000/NT
ERUDITE SOFTWARE August 1994 - October 1995
Software Developer
Learned cooperation and compromise by being a member of a development team that worked together to create the best possible product
Participated in an organized development process cycle, learning each aspect s place and necessity
Worked with a team to create solutions for software enhancements and bugs
Learned the power of working on teams with user s goals in mind
Environment: Powerbuilder, C/C++, Sybase, Netware, Unix, Windows 9x
EDUCATION
Brigham Young University - 1994
Studied Computer Science at Brigham Young University
OTHER
Acquired leadership and communication skills serving a Spanish speaking mission in Argentina for The
Church of Jesus Christ of Latter-day Saints
Learned responsibility, diligence and tenacity while earning my Eagle Scout Award in the Boy Scouts of
America
INDUSTRY & COMMUNITY VOLUNTEERING
Initial Chapter Leader ‘Utah County SQL Server User Group’
Presenter for SSWUG, UCSSUG, ISSUG, Microsoft Corporation, PASS SQLSaturday
Member and volunteer Professional Association of SQL Server (PASS)
Committee member ‘Chapter Committee’ PASS
Regional Mentor PASS
Special Interest Group ‘Auditing & Compliance’ leader PASS
SQL Blogging, SQL community involvement
SQL Server MVP from Microsoft 2014-2016
Friend of RedGate
Contact this candidate