Skip to main content

SQL Server Team Resume

Experience in supporting thousands of SQL Server databases running on all versions (from 6.0 to 2016) for hundreds of organizations on a 24x7 basis. Very strong in administration, installation & configuration, development, version upgrades, data migration, backup and recovery, clustering, replication, disaster recovery, performance monitoring & tuning, DTS, SSIS, SSAS, SSRS, 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
  • Average 12 Years of Experience as SQL DBA
  • Support Over 300 Remote DBA Clients
  • Manage Tens of 1000s of Databases Daily
  • Support 1000s of Servers
  • Performed Over 2000 Database Upgrades
  • 15 Microsoft SQL Server Certifications
  • Dozens of Cubes Supported
  • Support Over 3000 SSIS Packages
  • Support Over 1000 Replicated Databases
  • Dozens of AlwaysOn Availability Groups Supported
  • Support 1000s of SQL Server Clusters
  • Support 100s of Log Shipping Instances

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
  • Regulatory Compliance Support

High Availability Skills:

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

Development Support Skills:

  • Development Support Skills
  • T-SQL Development and Code Tuning
  • Formal or Informal Code Reviews
  • Data ModelingT-SQL Development and Code Tuning
  • Creation and Tuning of SSRS Reports
  • Creation and Tuning of SSIS Packages
  • Creation and Tuning of SSAS Cubes

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), Change Data Capture(CDC), Table/Index Paritioning, Data Compression, SQL Auditing, Transparent Database Encryption, Extensible Key Management, Role-based Security, Sliding Window Partitioning, Always-On Availability Groups, Contained Databases, Master Data Services, Data Quality Services, Encryption
Applications Microsoft SSAS, SSIS, IIS, Reporting Services, Report Manager, Data Mining, Spatial
close button

Resources

*Required