Microsoft Sql Resumes

Experience in supporting thousands of SQL Server databases running on all versions (from 6.0 to 2016) for hundreds of organizations on a 24×7 basis. Expertise in SQL Server on both Linux and Windows operating systems. Very strong in administration, installation & configuration, development, version upgrades, data migration, backup and recovery, clustering, replication, disaster recovery, performance monitoring & tuning, DTS,T-SQL, index optimization, database development, writing stored procedures & triggers. Perform a variety of SQL Server tasks related to problem resolution and monitoring, administration, availability, performance, security and corporate strategy.

Summary of Qualifications:

  • 24 x 7 Database Support Experience
  • 300+ Years of SQL Server Experience
  • Support Over 500 Remote DBA Clients
  • Manage Tens of 1000s of Databases Daily
  • Support Over 50000 Servers
  • Performed Over 2000 Database Upgrades
  • Microsoft Certified Data Platform Partner
  • Support 1000s of Replicated Databases
  • Hundreds of AlwaysOn Availability Groups Supported
  • Support 1000s of SQL Server Clusters
  • Support 1000s of Log Shipped Databases

Basic Administration Skills:

  • 7x24x365 Database Support
  • SQL Server Maintenance Plans (Backups, Indexes, Statistics,Consistency Checks)
  • Ad hoc Index Maintenance, Statistics Maintenance and Consistency Checks
  • Emergency Recoveries
  • Ensuring Recoverability of Databases
  • Health Checks/Assessments
  • SQL Server Installation, Configuration, Migration, Upgrades and Patches
  • Restores and Refreshes
  • Space Management and Capacity Planning
  • Object Creation and Management
  • Change Management
  • Blocking/Deadlocking Resolution
  • Security Administration and Maintenance
  • Effective and Efficient Critical Response

High Availability Skills

  • SQL Server and Windows Clustering
  • AlwaysOn Availability Groups
  • Mirroring
  • Log Shipping

Development Support Skills:

  • T-SQL Development and Code Tuning
  • Formal or Informal Code Reviews
  • Data Modeling

Strategic Skills:

  • TDE, Certificate and Key Encryptions
  • Database Related Hardware Design
  • Replication
  • Index Assessments
  • Partitioning Strategies including Sliding Windows Partitioning
  • Change Data Capture
  • Utilize Performance Analysis of Logs (PAL) Reports to Assist in Database Optimization
  • Archiving Strategies
  • Database-specific and Enterprise Disaster Recovery Plans
  • Compression
  • Full Text Search
  • Conversions to/from Other DBMS
  • Strategies for Automation including Refresh Jobs
  • Removing Sensitive Data
  • Consolidation Recommendations
  • Physical to Virtual Machine
  • In-Memory OLTP
  • Cloud Support for Amazon, Azure, and Azure SQL

Technical Skills

SQL Server Versions SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016
Database Features Database Mirroring, Log Shipping, Clustering, Backup Compression, Database Snapshots, Replication (Merge, Transactional, Snapshot, Heterogeneous Subscribers, Peer to Peer), Change Data Capture(CDC), Table/Index Partitioning, Data Compression, SQL Auditing, Transparent Database Encryption, Always Encrypted, Column-Level Encryption, Role-based Security, Sliding Window Partitioning, Always-On Availability Groups, Contained Databases, Master Data Services, Data Quality Services, In-Memory Tables and Indexes, Temporal Tables, Stretch Databases
Applications Microsoft SSAS, SSIS, IIS, Reporting Manager with SSRS