Skip to main content

SQL Server DBA Services Datasheet

Optimize the performance of your critical SQL Server databases by leveraging specialized talent, proven processes and a robust range of services and expertise from the nation’s #1 onshore remote DBA services provider. RDX’s SQL Server Service Delivery Team has unparalleled expertise in all SQL Server versions (6.0 to 2016) running on all releases of the Windows Operating System. From day-to-day operations to strategic decision-making, our SQL Server experts are with you every step of the way—managing your solutions, empowering your success and ensuring full maximization of your SQL Server investment.

How we help you succeed:

24x7

Get around-the-clock coverage for your critical systems from dedicated, 100% onshore SQL DBA monitoring and admin experts.

exploit

Fully exploit the power of your SQL Server database technologies to receive maximum benefit from your investment.

exp

Leverage the SQL DBA expertise and skills you need without the costs and headaches of hiring in-house.

Attain Fast

Attain fast, effective resolutions to database issues with RDX's industry-leading tools and SLAs.

Innovation

Focus on innovation, not support. RDX helps you leverage SQL Server's advanced features while freeing internal resources.

Reduce

Reduce operational risk by leveraging RDX’s deep expertise, proven processes, and PCI-backed security infrastructure

Services:

  • 24X7 SQL Server Support
  • Proactive Monitoring and Problem Resolution 
  • SQL Server Database Installation, Configuration & Setup
  • Database Development
  • Upgrades and Migrations
  • Space Management & Capacity Planning
  • Disaster Recovery Analysis and Testing
  • Backup and Restores
  • High Availability Options—Clustering, Mirroring, Replication, Log Shipping
  • SQL Performance Monitoring & Tuning
  • Security Administration and Maintenance
  • T-SQL Index Optimization
  • Object Creation and Management
  • Writing Stored Procedures and Triggers

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 450 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
  • 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:

  • 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

Select SQL Clients

close button

Resources

*Required