Yancy Johnson

Yancy Johnson Email and Phone Number

Database Administrator at Satcom Direct @ Satcom Direct
Yancy Johnson's Location
Orlando, Florida, United States, United States
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.

Yancy Johnson's Current Company Details
Satcom Direct

Satcom Direct

View
Database Administrator at Satcom Direct
Yancy Johnson Work Experience Details
  • Satcom Direct
    Database Administrator
    Satcom Direct 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.
  • Aaa
    Database Administrator
    Aaa 2016 - 2018
    Us
    · Provided database performance tuning support.· Assisted in the database support of the Connect Suite development team.· Implemented SQL Server log shipping.· Supported database developments and deployment scripts.· Performed Oracle to SQL Server database conversions.· Contributed database assistance to the Club Support technical assistance team.· Review opportunities to implement cloud based technologies.· Migrate databases to AWS.
  • Nci, Inc.
    Data Architect
    Nci, Inc. Mar 2015 - 2016
    Reston, Va, Us
    · Cleared for Secret/Top Secret Information in support of database design and architecture for NCI in support of the United States Army.· Developed enterprise focused data designs for NCI in support of the United States Army.· Reviewed and reverse engineered MS-SQL database architectures to validate for security, performance and scale.· Regularly performed design reviews and presentations to senior staff.· Research Hadoop and other big data solutions for inclusion in the NCI environment.
  • Incharge Institute Of America Inc.
    Senior Database Administrator
    Incharge Institute Of America Inc. Apr 2012 - Mar 2015
    · Administered, designed and supported MS-SQL databases. · MS-SQL Reporting Services administrator.· Evaluated, designed and developed process and design standards.· Architected and implemented data encryption routes.· Performed T-SQL performance tuning.· Implemented and supported SQL Server Cluster. · Researched, architected, developed and implemented enterprise business intelligence environment.· Developed new disaster recovery procedures.
  • Florida Virtual School
    Database Administrator
    Florida Virtual School Jul 2011 - Apr 2012
    Orlando, Florida, Us
    · Administered, designed and supported MS-SQL databases. · Responsible for administering Crystal Reports and Reporting Services.· Developed process and design standards.· Managed and implemented replication processes.· Performed T-SQL performance tuning.· Implemented and maintained SQL Cluster
  • Farm Bureau Insurance Of Michigan
    Database Administrator
    Farm Bureau Insurance Of Michigan Apr 2006 - Jun 2011
    • Administered over 100 SQL Server instances, designed and supported MS-SQL Server environment consisting of SQL Server 2000 -2008 R2.• Implemented and maintain data replication across multiple SQL Server instances.• Lead ETL developer, reviewed and maintained complex DTS and SSIS packages.• Responsible for creating reports using Crystal Reports and Reporting Services.• Tuned SQL Server performance through index optimization, database configuration, query tuning and table partitioning.• Participated in Disaster Recovery practices.• On Call 24x7 for production support.• Evaluated, selected and assisted in the implementation of vendor solutions such as Control-M, Idera Diagnostic Manager, SQL Server 2008, NetApp, Pivotal CRM and Reporting Services. • Developed T-SQL, SSIS design standards and peer review processes.• Worked in and lead project teams to implement an operational data store and planning for a data warehouse.• Developed web services to access mainframe data.• Taught developers how to perform T-SQL development including teaching a 5 day class.
  • Alta Resources
    Data Analyst
    Alta Resources Jan 2005 - Jan 2006
    Neenah, Wi, Us
    • Maintained 4 SQL Server instances. • Supported PeopleSoft CRM and provided custom solutions.• Maintained and supported legacy applications.• Cleansed, loaded and extracted customer lists.• Created and maintained Crystal Reports as well as provided customer specific data analysis and reporting.• Developed process monitoring utilizing Stored Procedures.• Developed and maintained DTS packages.• SQL Job scheduling and custom reporting solutions• Provided customer consultation.• Managed and created process documentation.

Yancy Johnson Education Details

  • Michigan State University - Eli Broad College Of Business
    Michigan State University - Eli Broad College Of Business
    General
  • Michigan State University
    Michigan State University
    Computer Engineering

Frequently Asked Questions about Yancy Johnson

What company does Yancy Johnson work for?

Yancy Johnson works for Satcom Direct

What is Yancy Johnson's role at the current company?

Yancy Johnson's current role is Database Administrator at Satcom Direct.

What schools did Yancy Johnson attend?

Yancy Johnson attended Michigan State University - Eli Broad College Of Business, Michigan State University.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.