Sql Server Data

Mario Scott

Kennesaw, GA 908-***-****

*************@*****.*** www.linkedin.com/in/scottmario

Database Administration Disaster Recovery Strategies Operations Management

Microsoft Certified Solution Associate(MCSA) offering over 4 years of exceptional technical computer service. Innovative, energetic Information Technology Professional with noted successes in the areas of database administration, SQL Server, and technical implementations. Analytical leader recognized for the ability to develop creative solutions and methodologies to effectively manage data for organizations. Collaborative communicator skilled in driving cross-functional projects from inception to completion pertaining to system upgrades, data migrations, and performance tuning.

Personal Skills

Strong leadership, communication, and collaboration skills

Flexible and able to adapt to a changing environment.

Excellent listening skills and willing to take time out to listen to a clients’ problems.

Areas of Expertise

Database Administration

High Availability

Data Migrations

Capacity Planning

Team Foundation Services(TFS)

SSIS/SSRS

Data Management

Data Analysis

Project Management

Monitoring

Database Maintenance

Technical Authoring

Database design

Performance Enhancement

Development

SQL

PROFESSIONAL EXPERIENCE

FIELD NATION Norcross, Georgia 7/2017 – Present

Database Administrator (Contractor)

Execute performance tuning of applications and participate in the maintenance of service availability, performance, integrity, capacity planning, and security. Install, administer, maintain, and troubleshoot various SQL Servers Instances on standalone, virtual and clusters, upgrading, patching, and keeping SQL servers current with the latest service packs (SP).

Key Achievements:

Completed 20+ projects and drove business requirements analysis to solutions delivery and support.

Oversaw over 20 servers to effectively support terabytes of data with various monitoring tools.

Directed the migration 50+ Microsoft SQL Server 2008 and 2012 to Microsoft SQL Server 2014 for various environments.

CAREERBUILDER Norcross, Georgia 1/2016 – 2/2017

Database Administrator (DBA)

Collaborated with users through email and phone to gain insight on issues and participated in Web-ex sessions to troubleshoot and resolve issues. Installed, configured, and maintained SQL Servers with the latest service packs (SP) and hot fixes. Helped develop databases for business requirements in a collaborative effort with the Development team. Created and configured systems including log shipping, database mirroring, replication, and Always on Availability groups.

Key Achievements:

Developed and managed SSIS packages to migrate data from source systems into staging and data warehouse.

Validated, extracted, transformed, and loaded data into data warehouse and data marts with the assistance of SSIS to create ETL packages.

Standardized disaster recovery strategies and executed database backup, recovery, and restore.

DYNAMICS GLOBAL IT SOLUTIONS Norcross, Georgia 5/2015 – 11/2015

Database Administrator

Used monitoring and alerts to ensure systems were fully functional and maintained performance statistics. Applied industry best knowledge to troubleshoot and resolve user-reported system performance issues. Improved performance for clients through the development of tables, index and data compression, and partition of system databases. Conveyed updates and contacted the support team to reconcile issues within agreed SLA after addressing routed critical tickets. Determined need and forecasted future resources through the execution of trend analysis.

Key Achievements:

Utilized monitoring tools to monitor systems and performance issues including locking, deadlocking, and fragmentations.

Applied knowledge of Database Tuning Advisor to help resolve performance issues after the evaluation of database performance of index tuning.

Optimized and migrated objects in the database and moved and synchronized data records, procedures, and SQL Agent jobs.

UNITED STATES ARMY Fort Bragg, NC 6/2007 – 1/2015

Operation Manager, (1/2008 – 1/2015)

Performed technical inspections and spearheaded troubleshooting and diagnostics procedures. Executed management, repairs, and quality control functions for $25M+ in equipment and vehicles with zero (0) losses and damages. Utilized leadership acumen to train and mentor eight (8) staff members that compiled and maintained material, merchandise, and supply records. Ensured compliance with safety and risk management practices with zero (0) violations, significant injury, nor loss.

Key Achievements:

Developed a Brigade Maintenance Operations Plan while deployed in Afghanistan to serve as the catalyst for being awarded the Bronze Star.

Increased vehicle preparation from 70% to 95% by leading maintenance for 5K+ of diesel mechanical equipment.

Sustained 100% accountability of equipment and zero maintenance related issues in the midst of combat operations.

EDUCATION, CERTIFICATIONS, AND TRAINING

Master of Business Administration

Grantham University

Bachelor of Science, Applied Management and Computer Technology

Franklin University

Certifications

CompTIA A+ Microsoft Certified Professional Microsoft Technology Associate (Windows Server Administration Fundamentals, Networking Fundamentals, Database Fundamentals) Querying Microsoft SQL Server 2012/2014 Administering Microsoft SQL Server 2012/2014 Databases

Professional Development

Scrum Master MTA Database MTA Networking CompTIA + Linus-010 MTA Windows Server

CompTIA Server Plus Linux

TECHNICAL PROFICIENCIES

Windows Servers, SQL Server, Linux, MySQL, Visual Studios, ApexSQL, SQL Doctor, Visual Studios

Contact this candidate