Yancy Johnson Email & Phone Number

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.

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.

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.

· 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.

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

• 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.

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.

Mba - Class Of 2012, Business Administration, Business Administration And Management, General

Bachelor Of Science, Computer Engineering