Sammy Samuels Email & Phone Number

Saint Louis, Mo, Us

• Development of PowerShell Scripts for Automated Processes • Automation of SQL Server and Windows Patching for the whole Infrastructure Estate via Ansible• Automation of SQL Server Installation via Ansible through Configuration files as Baseline.• ServiceNow Ticket Creation Via Critical alert threshold by set metadata• Vaulting of Credentials to CyberArk Vault via automated process• Support Commercial and Federal Servers• Configuration Management tools such as Ansible, Puppet, Salt for Installation, Patching of SQL and Windows Servers.• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.• Supervise all aspects of the assigned team including day-to-day supervision, performance evaluation, and assignment to IT Projects and/or Production Support functions. • Ensuring definition and development of database documentation and standards• Ensuring Database performance monitoring and tuning is regularly accomplished• Designing backup and restore strategies and Disaster Recovery solutions• Implement security policy design for current and new applications.• Coordinate team meetings with groups for any new design/strategies.• Creating database design for new projects support.• Managing, leading, and administering project resources and monitoring project activities and resources to mitigate risk• Respecting confidentiality in discussing consumer/participant, staff, volunteer and organizational matters; also maintaining confidentiality of organization, project, fiscal and personnel related information.• Identifying, updating, developing, implementing and managing ITIL management best practice processes.• Ensuring compliance with all software licensing agreements. Managing and safeguarding software media and associated licenses. Tracking software versions and maintaining centralized software use log.

Woodland Hills, California, Us

• Working with Department of Defense, Veteran-Affairs Customers on Government deliverable Projects • Ensuring Right privileges and permissions in Production, QA, Test & Dev Environment. Including NIST & Non-Nist Boundaries/ DIACAP & Non-DIACAP. • Migrating Databases from Sql 2000 to Sql 2008R2 • Migrating Databases from SQL 2005 to SQL 2014. • Migrating User logins with/without Password from Old Instance of Sql 2000 to Sql 2008R2, 2005 to 2014. • Working with the Application Team to determine if their applications work with the new compatibility mode. • Updating Statistics, Rebuilding Indexes on New Server (Index-Optimize). • Performance Monitoring, Tuning. • Deployment of OEM Monitoring Tools(Oracle) for Sql-Server • Migrated Microsoft Access Database to Sql-Server • Resolved Cluster Related errors on Windows Server 2003 & Legacy versions of SQL-Server. • Created a Monitoring Dashboard for Monitoring the Enterprise by creating an effective alerting system which prompts when SQL-Server restarted with the downtime, and active node if applicable. • Ensuring CPU Load-Balancing after Maintenance Window for Server Patching. Resources are being failed over to secondary nodes during server patching, and prior to Production Hours, I verify that all resources are running on their primarily assigned nodes. • Updating SQL Server Instance patching with the latest Service packs & OR Cumulative Updates.

Gogarburn, Gb

• Extensive experience on both SQL Server Administration and T-SQL Application Development • Knowledge of Normalization/ Denormalization techniques for OLTP and OLAP environments. • Used SQL Indexes for improving query performance, lower storage and maintenance cost. • Experience in optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) • Windows Performance Monitor for monitoring and tuning MS SQL Server performance. • Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances. • Good experience in user management for DBs, maintaining of databases, and providing SQL • Server security by assigning logins, server and database roles and server permissions. • Participated in Disaster prevention and Recovery Strategies and supported High availability features like Snapshot Replication, Clustering (Active/Passive) and Database Mirroring. • Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans. • Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server. • Proficient in developing business application logic using SQL Stored Procedures, Functions and • T-SQL queries and maintained code repository in Visual Source Safe (VSS) for deployments. • Created and maintained SQL objects like Tables, Constraints, User defined Functions, Indexes, • Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications. • Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL • Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail. • Developed Tabular Reports, Matrix Report, and Charts using SSRS and deployed to Report Server. • Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility

Reading, England, Gb

• Creating of Databases, Database Instances • Performance Tuning and Monitoring • Assigning users required rights and privileges to databases and sql instances • Generating Backup Report daily, and re-running backups before Production goes live • Capacity Planning and Database Growth Tracker(Monthly basis) • Training on New Versions and Features of Sql Server

It Systems Analysis & Design

Master'S Degree, International Relations And National Security Studies