Every day we create an estimated 2.5 quintillion bytes of data and this amount is accelerating at an exponential rate. More data has been collected in the past two years than in the entire human history.

So where does all of this data go? One of the foundational locations is a database. Without the database and the ability to query it, it would be nearly impossible to analyse any of that data in a meaningful way. With that being said, administrators are needed for all of this information.

Database Administration consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today’s organisations via their IT systems.

White-on-White Microsoft SQL Server Symbol with Drop Shadow

Microsoft SQL Server

Setup database systems, ensure those systems operate efficiently and regularly store, back up, and secure data from unauthorized access with the industry-leading database management platform from Microsoft.

Important decisions have to be made at the planning stage though as areas such as how to optimise the Windows server or servers SQL will run on, whether to implement availability groups or not and selecting RAID levels for storage for example need to be considered ahead of time.

Post-installation tasks can include configuring Database Mail and SQL Server Agent Alerts in order to receive critical errors as and when they occur, implementing backup strategies, performance tuning and configuring regular maintenance tasks.

Data Access and Auditing

Implement Cell-Level Encryption
Implement Always Encrypted
Implement Backup Encryption
Configure Transparent Data Encryption
Configure Encryption for Connections
Manage Database Object Permissions
Create and Maintain Users
Create and Maintain Custom Roles
Configure Row-Level Security
Configure Dynamic Data Masking
Configure and Manage SQL Server Audits
Query SQL Server Audit Logs

Backup and Restore

Back Up Very Large Databases
Back Up Databases to Azure
Manage Transaction Log Backups
Configure Database Recovery Models
Configure Backup Automation
Perform Piecemeal Restores
Perform Page Recovery
Perform Point-in-Time Recovery
Restore File Groups
Implement Database Consistency Checks
Identify and Recover From Database Corruption

Manage and Monitor Instances

Monitor Current Sessions
Identify Causes of Blocking Activity
Identify Sessions That Consume TempDB Resources
Identify Available Space on Data Volumes
Identify the Cause of Performance Degradation
Configure the Data Collector
Manage Query Stores
Configure Extended Events and Trace Events
Identify Problematic Execution Plans
Troubleshoot Server Health Using Extended Events
Maintain Indexes
Update Statistics
Create and Manage Operators
Create and Manage SQL Agent Alerts
Define Custom Alert Actions
Configure Database Mail
Configure Policy-Based Management

High Availability and Disaster Recovery

Configure and Monitor Log Shipping
Configure Windows Clustering
Create Availability Groups
Create Distributed Availability Groups
Configure Read-Only Routing
Manage Failover
Manage Shared Disks

Databases and Instances

Create Databases
Configure Database Performance Settings
Configure Database Scopes
Configure Operators and Alerts
Manage Files and File Groups
Manage System and User Database Files
Configure TempDB
Management Studio Installation

Storage

Manage SMB File Shares
Review Wait Statistics
Manage Storage Pools
Recover From Failed Storage
Monitor Dynamic Management Views (DMVs)
Automate Maintenance Tasks
Verify Database Integrity

If you are interested in discussing Database Administration options, then please feel free to get in touch for a no-obligation conversation by using any of the methods below:

contact@invisibleit.co.uk
+44 7956 986183
205 Latitude Court
3 Albert Basin Way
Royal Docks
London
E16 2QP
United Kingdom