Yancy Johnson

Database Administrator @Satcom Direct

Orlando, FL, US
EMAILS
y•••••••@satcomdirect.com
MOBILE NUMBERS
+15•••••••50

Signup · Get unlimited contacts

WORK HISTORY

Jan 2018 — Present

Database Administrator @Satcom Direct

View department →

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

1995 — 2002

Michigan State University

Bachelor of Science, Computer Engineering

2010 — 2012

Michigan State University - Eli Broad College of Business

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

SKILLS

Stored ProceduresDatabase AdministrationAccessC#Disaster RecoveryPerformance TuningReplicationDatabasesBusiness AnalysisT-SqlWeb ServicesData AnalysisDatabase DesignSql ServerSqlVisioDtsBusiness IntelligenceSsrsMicrosoft Sql ServerEtlCrystal ReportsSsis

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.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.