Michael Smith Email & Phone Number

Sterling, Va, Us

Fairfax, Va

Administer clustered SQL 2012 instances hosting over 100 databases supporting both OLTP applications and a data warehouse in build, test, and production environments. Manage instance level and database level security while ensuring compliance with DISA Security Technical Implementation Guides (STIGs).Implement and monitor SQL Auditing to detect and deter violations of security policies and procedures.Implemented and manage TDE (transparent data encryption) for all databases containing Personally Identifiable Information (PII) to protect data at rest. Monitor performance of SSIS packages and OLTP application queries using SQL Profiler, Extended Events, and SQL DMVs.Monitor SQL performance to identify resource bottlenecks.Add, remove and modify indexes to ensure maximum performance for data processing, transaction processing, and reporting.Implemented SQL resource governor to ensure consistent application performance.Assist analysts and developers with writing queries and stored procedures.Design and implement database schemas to support the Retention Management Software (RMS) and compliance reporting needs with an emphasis on performance and data integrity.Create and manage SSIS packages and SQL Agent jobs to perform maintenance tasks and ETL tasks. Synchronize environment schemas using Powershell and DACPACs

Herndon, Va

Design and implement database schemas to support order entry (Online Transaction Processing – OLTP) and compliance reporting needs with an emphasis on performance and data integrity.Created SSIS packages and SQL Agent jobs to perform maintenance tasks as well as data import and export functions. Designed and managed the implementation of components for the .Net 4.0-Sql 2008 R2 based Annuity Maintenance and AnnuityNet3 platforms.Utilized MS Project to plan, estimate, schedule and track development projects.Assigned tasks to local and offshore developers using MS Team Foundation Server (TFS).Worked closely with technologically and geographically diverse customers as well as our Quality Assurance (QA) and Client Integration Services departments to ensure timely delivery of functionality to the customers.Facilitated phone and online (WebEx) meetings to coordinate remote and local development effort.Assisted Junior Developers with resolution of critical issues.Wrote functional specifications for new projects targeting the VB 6 and C++ based legacy platform.Estimated implementation and support costs for client's statement of work. Participated in the research, evaluation and acquisition of hardware and software products including storage, servers, workstations, component libraries and monitoring applications.Wrote and delivered accurate project status reports for senior management and present new functionality to internal and external stakeholders.

Master Of Science (Ms), Management

Bachelor Of Science (Bs), Computer And Information Sciences And Support Services