SQL Server Team Resume

Summary of Qualifications:

  • 24x7 Database Support Experience
  • 300+ Years of SQL Server Experience
  • Average 12 Years of Experience as SQL DBA
  • Support Over 300 Remote DBA Clients
  • Manage 10s of 1000s of Database Daily
  • Support Thousands 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

Work Experience

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.

Basic Administration Skills

  • 7 x 24 x 365 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
  • 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
  • Health Checks/Assessments

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
  • 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
  • Cloud Support
  • Physical to Virtual Machine
  • In-Memory OLTP
  • Cloud Support for Amazon, Azure, and Azure SQL

Technical Skills

SQL Server Versions
SQL Server 6.0, 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 Partitioning, Data Compression, SQL Auditing, Transparent Database Encryption, Extensible Key Management, Role-based Security, Sliding Window Partitioning, AlwaysOn Availability Groups, Contained Databases, Master Data Services, Data Quality Services, Encryption
Applications
Microsoft SSAS, SSIS, IIS, Reporting Services, Report Manager, Data Mining, Spatial

References

“We have been with RDX for just over two months now. Within the past 4 days, on 3 different occasions, alerts set up by RDX have saved us a ton of time and potential data loss by alerting us to issues before they became huge problems. Proactive monitoring and alerts are definitely something we gained from this service that we did not previously have. I feel that our valuable data sources are finally getting some much needed management and attention."

-Healthcare Client

“Thanks to each of you for being part of a great virtual team to execute a significant upgrade in performance for us. Appreciate your thoughtful planning and skilled execution. Thanks for helping deliver a big step in value to our Team Leaders.”

-Retail Client

“I wanted to pass along my thanks to your team for a job well done. They have been very responsive to our requests and perform their jobs with the utmost professionalism. They have also been working with additional members of our technical team and have re- ceived ‘good press’ here as well. We value the work your group does for us and consider them an extended key part of our team.”

-Manufacturing Client

“The service has been excellent. I cannot thank you enough for being so proactive in supporting our SQL Server.”

-Business Services Client

“Remote DBA Experts has several times taken action to fix and streamline the process of documenting, sharing knowledge and updating procedures. They treat us fairly, listen to our concerns and attempt to rectify any of the problems that we bring to their attention. We get great value for having them on board and get 24 x 7 coverage at a very reasonable price: we would never be able to afford 4 to 5 DBAs on staff.”

-Transportation Services Client

“We are very pleased with Remote DBA Experts. Not only are they very technically pro- ficient when handling our database issues, but they are extremely well-organized and proactive. They are completely self-sufficient and low maintenance and we feel like our systems are in good hands thanks to their excellent service. Highly recommended!”

-Non-profit Client

Select Clients

  • ak steel
  • first american bank
  • gnc
  • pbs
  • save the children
  • sbarro
 
image description
All Customers Receive
timely service 24x7 Support from DBA Experts
united states support 100% Onshore DBA Solutions
team of resources Dedicated DBA Resources
database service Customized
SLAs