SQL Server DBA / MS Azure SQL Server DBA/ Data Migration Administrator Resume

SUMMARY:

A highly accomplished Database Technology Professional with over 20 years industry experience leveraging Database technologies and cloud platforms in the design, development and implementation of large - scale technology solutions.

WORK EXPERIENCE:

Confidential

SQL Server DBA / MS Azure SQL Server DBA/ Data Migration Administrator

Responsibilities:

Administration for very large and complex databases in SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, 2008
Implemented Always-On Availability Groups (AAG) and HA/DR Troubleshooting
Administration on Production Servers with server configuration, performance tuning and maintenance
Implementation of SQL Server High Availability and Disaster Recovery strategies.
Implemented data transformation services for Bulk Loads with SSIS and BULK INSERT ETL operations.
Implemented SQL Server 2017 mechanisms like data compression, online indexing, Container Databases
Performance tuning using DMV and dynamic management functions for Queries and DB Operations.
SQL Server 2008, 2012, 2014, 2016 database migration / upgrades to SQL Server 2019.
Support for Very Large databases (VLDB) and troubleshooting the problems.
Responsible for monitoring and making recommendations for performance improvement.
Rebuilding / Monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Creation of power shell scripts to support automation and simplification of administrative task
Manage backup and recovery functions for reporting data warehouse environment
Setup alerting mechanism for SQL Server databases and supporting environment to ensure system health and maximum availability
Developed strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud
Implement cloud technology policies, and procedures for disaster recovery and archiving
Development of the DR workload migration plan in conjunction with application owners and other technical resources
Created SQL Server consolidation plan to upgrade older SQL Servers onto newer platforms
Developed support plan for MS SQL Server databases including performance tuning & high availability
Implement user access and security procedures in accordance with SOX requirements

Confidential, New York City / Philadelphia

SQL Server DBA / SQL Data Migration Administrator

Responsibilities:

Performance tuning exercises within MS SQL Server 2008/2008 R2/ database and application parameters
MS SQL Server Performance tuning
MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;
MS SQL Server Multiple TempDB Database Files; PolyBase; Query Store; Row Level Security;
MS SQL Server R Comes to SQL Server; Stretch Database utilization; Temporal Table utilization
150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases - Consolidation/Data Migration
Backups, Performance Tuning, Parameter/Configuration Optimization, Partitioning, Query Optimization,
Log Shipping, Database Restore, Database Refreshes, Monitoring
Meta Data Management, Log Management, IN-Memory Optimization, Database Cluster Tuning
SQL Profiler, Indexing Optimization, Parallel Query Optimization, Storage Optimization (Data Files, Logs)
900+ MS SQL Server Database Instances - Designed DB Consolidation / Data Migration Plans
Performance tuning exercises utilizing SQL Server Indexing strategies (Utilizing SQL Profiler primarily)
Performance tuning on queries that were poorly performing to identify ways to improve response time and through put (Utilizing SQL Profiler - MS SQL Server)
Database Performance Tuning (MS SQL Server)
Performed typical database and server maintenance and backup procedures
Database Backup and Recovery and Disaster Recovery Design and Implementation
Large data loads and updates from production into development environment
Review of the database architecture as a whole to determine areas of improvement
Make recommendations to include table level partitioning where it would improve performance
Best Practices model for disk level database data file improvements for performance gain (MS SQL Server)
Always-on availability group for read-only secondary replica
Recommended backup and recovery strategies for data protection and disaster recovery per the SLA’s
Deployment of windows Service Packs through windows update process and MS downloads.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship