Azure Administrator / SQL Server DBA Resume Chantilly, VA - Hire IT People

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Azure Administrator / SQL Server DBA

Confidential - Chantilly, VA

Responsibilities:

Monitor performance on all environments (CPU, disk space, etc.) to ensure smooth running of all environments.
Limit downtime on all environments.
Advise on, and implement, different environments for different requirements
Different setups for development, testing and production environments.
Very intensive data processing environments.
Environments that require high guaranteed uptime.
Environments that can automatically scale depending upon processing requirements.
All aspects of cloud security.
Manage firewalls, VPNs, and remote access to servers, based on different user roles and access requirements.
Manage cloud - based FTP and other forms of file sharing.
Backups, restorations and disaster recovery.

Azure Administrator / SQL Server DBA

Confidential - Herndon, VA

Responsibilities:

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.

Azure Administrator / SQL Server DBA

Confidential - Lanham, MD

Responsibilities:

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.

Azure Administrator / SQL Server DBA

Confidential - Arlington, Virginia

Responsibilities:

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

SQL Server DBA

Confidential - St Louis, Missouri

Responsibilities:

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

SQL Server DBA

Confidential - Chicago, Illinois

Responsibilities:

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