Sql Server Security Clearance
Resume:
Stephen Chatman
*******.********@*****.***
Las Vegas, Nevada, USA
KEY SKILLS
18+ years of recent and relevant Azure and SQL Server 2008R2 – SQL Server 2022 Database Administration.
Migrations of on-premises Windows Servers and SQL Server to Azure Cloud
Experience in auto-scaling, clustering (Always On Availability Groups), and high-performance transactional databases
IRS MBI Security Clearance
Public Trust Security Clearance
SQL Server upgrades from version 2005 up to 2016 and 2022
Proficiency in scripting languages such as TSQL, PowerShell or Bash for automation tasks
Microsoft AZ-900 Certified
PROFESSIONAL EXPERIENCE
03/2022 – Present
Azure SQL Server DBA
TCS
●Production support guidance, researching, and responding to security vulnerability findings, and working with multiple vendors and teams to leverage existing architecture components.
●Continuously optimize query performance, indexing strategies, and workload distribution.
● Database Administration, with high-level knowledge of MS SQL Server in a medium to large scale solutions to include experience with tasks such as data migration, data modeling, automation, modernization, data replication, backup and recovery, and general DBA tasks
●Supported the business requirements and provide assistance to the team in troubleshooting performance and system errors, including providing data analysis support, discovering and fixing data issues, and communicating with various stakeholders.
●Created Azure Databases using Terraform – Primarily to automate code deployments from Production to QA and Dev environments, but also to satisfy quarterly disaster recovery requirements.
●Built database systems of high availability and quality depending on each end user’s specialized role Datafix management - created, executed, and validated data fixes, manage ongoing and ad-hoc data fix execution.
●Designed and implemented databases in accordance to end users’ information needs and views Manage Azure firewalls. Creating VPNs, establishing remote access to servers, based on different user roles and access requirements.
●Defined users and enabled data distribution to the right user, in appropriate format and in a timely manner.
● Researched and implemented new Azure tools to improve efficiency, performance, and cost-effectiveness.
●Converted SQL databases into Azure bacpacs for Managed environments.
●Reengineered SQL Server 2012 databases to be compliant with SQL Server 2019
●Monitored and reported to management on actual and projected monthly costs of Azure buildouts.
●Utilized Terraform to create and redeploy SQL databases, permissions, and repl objects.
01/2022 – 03/2022
Azure SQL Server DBA
Incept Solutions
●Database release management - deploy and validate DB objects (Stored procedures, functions, reports, DB scripts), DB backups and refreshes Installing servers and hardware in on-premises datacenter.
●Datafix management - create, execute, and validate data fixes, manage ongoing and ad-hoc data fix execution.
●Manage Physical and Azure cloud-based SQL Server 2019 databases.
●Manage Azure firewalls. Creating VPNs, establishing remote access to servers, based on different user roles and access requirements.
●Backups, restorations, and disaster recovery.
●Research and implementation new Azure tools to improve efficiency, performance, and cost-effectiveness.
●Monitor and report to management on actual and projected monthly costs.
12/2020 – 12/2021
Azure Administrator / SQL Server DBA
Microland
●Designed and Implemented SQL Server backup and recovery strategies for on-premises and Cloud.
●Installed and configured multiple AlwaysOn HADr servers Manage Physical and Azure cloud-based SQL Server 2019 databases.
●Work closely with a team of developers to resolve locking and blocking issues on production servers.
●Updated SSL certificates for SQL and IIS Servers
03/2020 – 11/2020
Azure Cloud Engineer / SQL Server DBA
Dept of Energy – Germantown, VA
●Designed and Implemented Azure storage and data strategies
●Installed and configured multiple AlwaysOn HADr servers Manage Physical and Azure cloud-based SQL Server 2019 databases.
●Created Azure Virtual Machines using custom images, configured load balancers with availability sets. Updated SSL certificates for SQL and IIS Servers.
●Design and Creation of Azure PaaS compute and web mobile services.
●Migrated SQL Server 2012R2 - 2019 Clusters from On-premise to Cloud
●Designed Azure VM Disaster Failovers to remote site
04/2019 – 12/2019
Azure Administrator / SQL Server DBA
Whereoware Digital Agency – Chantilly, VA
●Monitored performance on all environments (CPU, disk space, etc.) to ensure smooth running of SQL Server 2012R2 - 2019Created Azure Virtual Machines using custom images, configured load balancers with availability sets. Updated SSL certificates for SQL and IIS Servers.
●Limit downtime on all environments. Migrated SQL Server 2012R2 - 2019 Clusters from On-premise to Cloud
●Implemented different environments for different requirements, including varied setups for development, testing and production environments.
●Managed firewalls, VPNs, and remote access to servers, based on different user roles and access requirements.
●Managed cloud-based FTP and other forms of file sharing.
●Backups, restorations, and disaster recovery SQL Server 2008R2 - 2019
02/2018 – 04/2019
Azure Administrator / SQL Server DBA
Insight Global Consulting – Herndon, VA
●Installing servers and hardware in on-premise datacenter
●Advise and implement different environments for development, testing, and production
●Manage Physical and Azure cloud-based SQL Server 2019 databases.
●Manage Azure firewalls. Creating VPNs, establishing remote access to servers, based on different user roles and access requirements.
●Backups, restorations and disaster recovery.
●Research and implementation new Azure tools to improve efficiency, performance, and cost-effectiveness.
●Monitor and report to management on actual and projected monthly costs.
10/2017 – 02/2018
Azure Administrator / SQL Server DBA
Internal Revenue Service – Lanham, MD
●Connecting On-Premise Windows and SQL Servers into Azure Cloud
●Recreating Virtual Machines and Virtual Disks into Azure
●Working with Development to build new Azure Datawarehouse
●Managing Staging, and Test Data for development and User Acceptance Testing
●Installing servers and hardware in on-premise datacenter
●Protocol configurations of TCP-IP and creating subnets on-premise and in Azure Cloud
●Maintain and repair of routing, IP switching, firewalls, and remote access protocols.
11/2016 – 09/2017
Azure Administrator / SQL Server DBA
Office of the Inspector General – Arlington, Virginia
●Migrations of legacy Sql2005 databases to SQL2016 and to Azure Cloud
●Restores/Refreshes of data between Production, Staging, and Test environments using Powershell
●Installing & Configuring Azure VM’s using Dashboard and Powershell. On-premise to Cloud migrations of SQL Databases via bacpac and bcp
●Administrator for Azure VIP swaps between staging and production to test code upgrades
●Performing disaster healing operations and records backups
●Creating virtual machines in Azure and assigning VM Storage
●Ad hoc searches to determine malicious activity
07/2016 – 10/2016
SQL Server DBA
Scottrade – St Louis, Missouri
●Backup/Restore of Sql2012 databases using TSQL and Powershell. Migrations from SQL
●Support of Development during acquisition/merger to TD Ameritrade brokerage system (Broadridge)
●Patching, Backing up and Monitoring of Azure VM’s – running malware definition to remain current.
●Always On configurations, restorations, and backups
●ServiceNow Ticketing system, Idera and SolarWinds for monitoring
●Excel Vlookups into SQL database via SSIS ETL
●Managed and monitored enterprise database connectivity using Powershell
●Created Dashboards in Splunk to manage stock purchases and user engagements
01/2011 – 05/2016
SQL Server DBA
Accenture - Chicago, Illinois
●SQL Server 2008R2 to SQL Server 2012 Migrations
●Always On configurations, restorations, and backups
●Backup and restores of multi-terabyte databases from production into staging and development environments via Powershell, TSQL, and SSMS.
●Creating and maintaining Reporting Services dashboards.
●Performance monitoring of virtual and physical servers using Idera SQL Diagnostic Manager
●Query plan monitoring to see the causes of blocks and deadlocks
●Adding disks into Azure Virtual Machines to create single volumes and increase max IOPS
●Server-side copy of Azure Blobs between storage accounts.
●Produced search queries and provided near real-time events for Target online retailer for top products per store and per hour during holiday promotions.
●Working with developers during deployments of new code using Azure deployment slots
Current Public Trust Security Clearance
Interim Secret Security Clearance
IRS MBI Security Clearance
Microsoft AZ-900 Certification
EDUCATION
Harper College Associates of Arts Business Administration
Contact this candidate