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.
-
Database AdministratorSatcom Direct 2018 - PresentMelbourne, 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. -
Database AdministratorAaa 2016 - 2018Us· 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. -
Data ArchitectNci, Inc. Mar 2015 - 2016Reston, 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. -
Senior Database AdministratorIncharge 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.
-
Database AdministratorFlorida Virtual School Jul 2011 - Apr 2012Orlando, 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 -
Database AdministratorFarm 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.
-
Data AnalystAlta Resources Jan 2005 - Jan 2006Neenah, 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 BusinessGeneral -
Michigan State UniversityComputer 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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial