Azure cloud administration

Stephen E. Chatman

***** ******** *******, *******, ******** 20147 312-***-****

Email: *******.********@*****.***

KEY SKILLS

15+ years of recent and relevant SQL Database Administration.

Migrations of Windows Servers and SQL Server 2005/2008/2012/2014

NOC administration and monitoring

On-premises to Azure Cloud migrations

Microsoft Azure installation and administration

Datacenter reconfiguration of Storage and Raid configurations

Splunk dashboard creation

Active Public Trust Security Clearance

PROFESSIONAL EXPERIENCE

02/18 – Present

Azure Administrator / SQL Server DBA

Peraton Corp – Herndon, VA

Monitor performance on all environments (CPU, disk space, etc.) to ensure smooth running of all environments. Proactive network systems monitoring primarily using Splunk

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 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/17 – 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/16 – 09/17

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/16 – 10/16

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/11 – 05/16

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

10/10 – 12/10

SQL Server DBA

Chase Bank - USCIS, Chicago, Illinois

SQL Server – 24x7 Production Support Operations

Working with developers to design and implement scripting for Microsoft ETL implementations.

Altering and monitoring Tivoli, Onbase, USCIS, E-flow and TMS

Troubleshooting SQL Server database issues to meet government deadlines to get immigration papers processed effectively.

Executing Profiler traces to discover applications problems, performance tuning, and identifying slow running queries

SQL Server performance monitor using SolarWinds – primarily to discover and resolve locking and blocking

06/10 - 09/10

SQL Server DBA

Nalco Chemicals, Naperville, Illinois

Deploying Analysis Services and SSIS development projects.

Optimizing and redesigning Analysis Services aggregations using sampling frequencies and queries.

Data scrubbing and transformations using SSIS to prepare data for migration from staging into data warehouse.

Designing Finance Measure groups and dimensions in Analysis Services.

03/10 - 04/10

SQL Server DBA

Peak6 Investments, Chicago, Illinois

Interfaced extensively with business analysts and developers to install software, approve and execute scripts, and deploy SSIS packages into staging and production.

Profiler traces to discover performance issues.

02/10 - 03/10

SQL Server DBA

Wisconsin Physicians Services, Madison, Wisconsin

Migrations from SQL2005 to SQL2008. Installation and Configurations of SSIS, and Reporting Services (SSRS).

Resolving Active Directory, Kerberos, and IIS 6.0 issues related to recent Reporting Services deployments.

Lead for SSIS ETL project to convert databases from DB2 and VSAM into SQL Server 2008.

10/2007-12/2009

SQL Server DBA

CEC, Hoffman Estates, Illinois

Production SQL DBA projects. Backups, restores, disaster recovery projects. Migrating SQL2005 to SQL2008

Working with developers to implement Microsoft ETL implementations.

Converting DTS packages to SSIS. Developing, configuring and deploying SSAS.

04/07-10/07

SQL Server DBA

Apex Systems Inc., Chicago, Illinois

Migrating SQL2000 server to SQL2005. Installing LightSpeed for backups and restores. Creating instances.

Converting legacy DTS packages to SSIS. Deploying SSIS to servers.

Creating package configuration for SSIS solutions. Resolving issues related to SSIS solution deployment.

03/07-04/07

SQL Server DBA

Bayview Financial, Miami, Florida

DTS to SSIS Migration Project

Converted and migrated SQL 2000 DTS to SQL2005 SSIS.

Implemented checkpoints, created precedence constraints, some debugging and handling of errors.

Added SSIS package security, created SQL Server Agent Jobs to execute SSIS packages, performed end-of-project development of SSIS packages.

12/06-01/07

Harley-Davidson, Carson City, Nevada

SQL Server Administrator (Short term project)

Moved log files to separate disk subsystem from other databases and server activity to reduce disk contention and outstanding I/O bottlenecks. Moved Tempdb to separate disk allowing the faster creation of indexing on some of the larger tables.

Removed unused indexes and identified overly large indexes robbing Insert and Update performance. Created covering indexes to reduce Bookmark Lookups. Created two hash indices and packaged them inside of a stored procedure which eliminated some very wide indexes on large tables which were degrading performance.

Performed RAID calculations to identify system disk bottlenecks and recommended adding physical disks to provide for future growth. Used Performance Monitor to identify instances of excessive paging and drafted Change Management to add an additional drive to the array and to use a different version of RAID

9/06- 11/06

SQL Server DBA

CXI, Deerfield, FL

SQL Server Administrator (Fill in until perm employee returns)

Troubleshooting stored procedures, reverse engineering for cleaning up and fixing code that was previously written in SQL versions 2000 to comply with SQL Server 2005.

A great part of the production support was maintaining the existing replication servers.

Creating and editing DTS packages and conversions from DTS to SQL Server 2005 SSIS packages.

Moving files from Oracle database to SQL database, through DTS.

07/06- 09/06

SQL Server DBA

Rewards Network, Miami, FL

SQL Server Administrator (Short term project)

Lead the DBA area on database design, tuning, backup/recovery architecture, administration and maintenance of relational databases.

Advised development staff on efficient SQL statement generation.

Participated in data modeling using ERwin and design planning with development team.

Participated in team projects and offered insight on technologies and procedures.

Worked within a team environment and became a point of contact for daily database problem resolution.

Minimally involved in maintaining the replication servers.

Created TSQL queries with Groovy java compiler to retrieve datasets from legacy systems.

Developed DTS packages to perform joins between AS400 and SQL Server 2000 and 2005 for sales reporting purposes.

Guardian-First Commonwealth Chicago, IL

12/98 to 07/2005

SQL Server Database Administration (2 month contract that ended up converting perm)

Migrated from SQL Server 7 and SQL Server 2000 to SQL Server 2005.

Worked with the System Engineers to install the SQL Server and carried out all upgrades to new three-terabyte capacity, applying service packs to correct server bugs and trouble-shoot SQL Server problems reported by the users.

Configured the Server according to application needs and Server hardware, set-up and maintained replication, as and when required.

Backed up terabyte databases and performed restores and ran consistency checks from SQL standby servers prior to making changes in production.

Performed and monitored daily database operations and set-up backup schedules.

ABN-AMRO LaSalle Banks, Chicago, IL

02/97 to 11/98

SQL Database Administrator

Worked with the development team to set standards and assisted team members with performance issues.

Managed user accounts and implemented database security to include knowledge of roles, profiles, and system and object level privileges in accordance with security policies.

Resolved performance and blocking issues, applied software patches, troubleshooting and problem resolution and disaster recovery.

Scheduled backups; managed clustered servers and corrected problems with Transactional Replication.

Current Public Trust Security Clearance

Inactive Secret Security Clearance

EDUCATION

Harper College

Contact this candidate