Yancy Johnson

About Yancy Johnson

Experienced Data Architect skilled in Performance Tuning, SQL Server Reporting Services (SSRS), Stored Procedures, Extract, Transform, Load (ETL), and Databases. Strong business development professional with a MBA - Class of 2012, Business Administration focused in Business Administration and Management, General from Michigan State University - The Eli Broad Graduate School of Management.

Experience

1. Database Administrator

   Satcom Direct

   Jan 2018 — Present · Melbourne, FL, US

   Provide guidance to a team of senior data professionals through aligning company tasks, prioritizing assignments, reviewing work and focusing on best practices.· Manage a highly available data environment utilizing a combination of Always On Availability Groups, replication, SSIS, linked servers, Azure SQL Managed Instances, Azure SQL Databases, Power BI and PowerShell.· Identify, plan, schedule and implement data migrations to on-premises and Cloud architectures.· Fully manage SQL Server migrations, including determining outcomes, implementation dates, documentation, migration scripts, installation, communication, validation and coordination with other teams.· Monitor, implement and manage database replications. This includes replication on Always On Availability Groups.· Provide guide and implement methods to improve database performance tuning and optimization.· Assist in the application of database upgrade and deployment scripts.· Review, recommend and implementation Microsoft Azure Cloud technologies.· Design, implement and monitor database backup strategies.· Architect, implement, document and monitor disaster recovery solutions.· Review, modify, apply and evolve data security best practices. This includes implement transparent data encryption throughout the environment.· Lead the enterprise-wide data classification initialize.

Education

• Michigan State University

  Bachelor of Science, Computer Engineering

  1995 — 2002

• Michigan State University - Eli Broad College of Business

  MBA - Class of 2012, Business Administration, Business Administration and Management, General

  2010 — 2012

Skills

• Stored Procedures
• Database Administration
• Access
• C#
• Disaster Recovery
• Performance Tuning
• Replication
• Databases
• Business Analysis
• T-Sql
• Web Services
• Data Analysis
• Database Design
• Sql Server
• Sql
• Visio
• Dts
• Business Intelligence
• Ssrs
• Microsoft Sql Server
• Etl
• Crystal Reports
• Ssis