Database Administrator Frequently Asked Questions

Database Administration is an IT function that manages relational and non-relational databases. The main goals of the Database Administration are to ensure that databases are available and perform well, and that the data is secure. This includes but not limited to installation and patching of the database software, security configuration, automation, performance tuning and monitoring, performing databases backup and recovery tasks, ensuring databases availability, etc.

SQL Server Database Administrators primary responsibilities depend on a DBA level (junior, intermediate, senior) or company size. Junior DBAs or members of the larger organizations/teams usually have a smaller scope of the duties.

Here are some common responsibilities of the SQL Server Database Administrators:

– Installing, upgrading and patching Database Software
– Provisioning databases
– Configuring database instances and databases
– Performance tuning and monitoring
– Granting users access to database servers and databases, setting up permissions to the database objects, etc.
– Protecting data by setting up network and data encryption
– Auditing users’ access for compliance reporting
– Ensuring data availability and integrity
– Automating DBA processes and data movement related tasks
– Creating databases backups and recovery strategies
– Building and maintaining documentation
– Planning for future capacity
– Troubleshooting database related applications issues
– Writing and optimizing T-SQL scripts for miscellaneous DBA tasks, database development, etc.

Depending on a DBA’s level, they may be involvement in broader tasks such as database server architecture, perform analytical tasks, DBA mentoring, training, etc.

Most often Database Administration tasks are performed by a dedicated Database Professional titled a DBA (Database Administrator.  DBAs have extensive experience and training dedicated to the database platforms they manage.

Database Administration can also be performed by an IT Specialist who has multiple responsibilities.  For example, in smaller companies Systems Administrators sometimes can be responsible for the Database Administration as well. Also, in some cases there might be people in a business department that might be responsible for specific databases or manage database servers for a specific application. Some IT Service providers provide DBA services as well.

SQL Server Database Administrators usually work in an IT Department.  DBAs can work within different teams depending on the organization size and the IT department structure. In larger organizations there might be a dedicated DBA team or a department.  SQL Server Database Administrators can be part of the IT Operations/Infrastructure Team or Application Support Team.  In some cases, there could be a dedicated SQL Server Database Administrator in an Application Development Team. These teams might be responsible for their own development and administration.  Read this tip about Building a SQL Server DBA Department.

Regardless of the department or team that SQL Server Database Administrators work in, the DBAs usually interact with all other IT teams and often with business departments as well.

SQL Server Database Administrators work with:

– System Administrators – when there are Operating Systems issues, Active Directory related questions or when SQL Servers are patched or upgraded
– Network Administrators – during network communication or firewall related issues, for example
– Developers – when T-SQL code needs tuning or the new indexes potentially have to be created
– Application Support Team – on troubleshooting application issues that might be related to a database performance, for example
– Business Department – when business is responsible for an application support or needs SQL -Server Database Administrator expertise in software upgrades planning, etc.
– Third-party vendors – this could be Software (Applications) vendors/providers, service providers, etc. You will need to coordinate with the vendors upgrades, integrations etc.
– Microsoft – if SQL Server support is required or SQL Server bug encountered.

Depending on the company you work for, on projects you involved in and on your responsibilities, you will be using some or all of the following technologies/software on a day-to-day or occasional basis:

SQL Server Management Studio (SSMS) – is a free tool to administer, configure and manage SQL Servers, to develop T-SQL or other code (for example MDX), etc.

Copilot – it’s integrated now with SSMS and can improve DBA productivity. Read this tip for more information

SQL Server Agent – to automate DBA tasks and other database processes (to schedule and review SQL Server Agent Jobs, create alerts, etc.)

T-SQL to create database administrative scripts or develop stored procedures, create tables and other database objects, etc.

Operating System – to review event logs, run performance monitor, install SQL Server software, configure folders and files permissions, etc. It could be Windows or Linux.

Windows Active Directory – to check Windows logins status, Windows Groups membership, review SPNs, etc.

Networking – for client connectivity troubleshooting, SQL Servers configurations (ports, IP addressed, DNS names, etc.)

Security related technologies – for example, to provision and use SSL certificates (to encrypt network traffic), configure SQL Server Transparent Data Encryption; setup Kerberos for Windows Authenticated logins

Remote server connections (for example, VMware, Microsoft Virtual Servers) – to perform administration tasks that can only be performed by logging in locally to the server
PowerShell scripting – not mandatory, but you can perform and automate many DBA tasks with it

Visual Studio – some DBAs may write code or create SSRS reports, SSIS packages, etc.

Source Control tools which used to be one of the main developers’ tools is now a must for the SQL Server Database Administrators. Microsoft lately integrates more DBA related source control tools/templates into SSMS and Visual Studio

ETL (Extract/Transform/Load) and other data movement tools. For example, SSIS, bcp, Export/Import Wizard, etc.

Depending on your responsibilities you may use other than Database Engine SQL Server features such as SSRS, SSIS, and SSAS

Email or other communication tools (including virtual meetings software, chats, etc.)

Last, but not least – knowledge of one or more cloud technologies, including understanding a difference between SaaS, PaaS and Azure SQL Database.

Soft skills are as important as the “hard” skills for the successful DBA career. SQL Server Database Administrators usually collaborate with multiple teams on their day-to-day job and need to have great communication skills and ability to work with multiple teams (Network, Application Support, Development, Business Departments).

DBAs need to have great analytical and problem-solving skills and be detail oriented.

A person that works with databases and data must have integrity and be honest. These are the most valuable qualities required for protecting and securing sensitive data.

SQL Server Database Administrators need to be able to learn quickly and adapt to rapidly changing technologies, be proactive to prevent potential issues and failures.

Last, but not least – the Database professionals must be able to work under pressure (for example, to response efficiently to critical systems downtime issues) and ability to make timely decisions.

Read this tip about the key qualities for a SQL Server Database Administrator.

You can have a formal SQL Server training or obtain/learn new skills on job. For example, when you perform occasional DBA tasks as part of your other IT role. You can also have a Junior DBA role as part of the bigger DBA team and learn from senior DBAs, from online resources, User Groups etc.

To be a successful DBA you need to have a good understanding of related technologies, such as Active Directory, Cloud Platforms (Azure, AWS, etc.); have basic networking knowledge. One of the main skills is writing T-SQL scripts.

Some resources for the training are:
– Free Microsoft Learn training
– Online learning web sites. For example: Datacamp or Coursera.

To find training providers (for instructor-led training or Microsoft partner training centers, for example) you can use Microsoft’s search here.

The great way to have a hands-on experience is to search for “GitHub Labs SQL Server” and complete the Labs’ exercises. Here is one of the examples of the GitHub SQL Server Workshops.

Here are some courses you can start with from Microsoft Learn:
– Query and modify data with Transact-SQL – Training | Microsoft Learn
DP-900: Microsoft Azure Data Fundamentals – YouTube
– Course DP-300T00-A: Implement scalable database solutions using Azure SQL – Training | Microsoft Learn

Read these tips that have more references about the Database Administrator training:
– Starting your SQL Server career path
– Professional skills development articles

SQL Server Database Administrator Certifications could be obtained by passing Microsoft certification exams. The latest certifications don’t focus only on SQL Server these days. Most Microsoft Certifications require Azure technologies/products knowledge these days. For the Database Administration certification, the skills check is for a combination of SQL Server and Azure SQL Server products (for example, Azure SQL Database, Azure SQL Managed Instance).

Here are some of the SQL Server Database Administrator certifications:
– The entry level certification is a “Fundamentals” certification – Microsoft Certified: Azure Data Fundamentals.
– The next level of the certification (“Role-Based”) for the Database Administration is Microsoft Certified: Azure Database Administrator Associate.

Here are tips that will help you to prepare for the exams for these certifications:
– DP-900 Microsoft Azure Data Fundamentals Exam Study Guide
– Exam DP-300 Administering Microsoft Azure SQL Solutions Study Guide

Microsoft certifications achievements could be shared online on LinkedIn site and help your future employers to review your credentials.

Some of the Certifications could be renewed without extra costs if you renew it on time. More information about renewal and eligibility could be found on Microsoft Learn site: Microsoft Certification Renewal.

Read more about advantages and disadvantages of the certifications here.

Microsoft provides a poster (“Become Microsoft Certified”) that has more details about other role-based certifications.

Read more about “SQL Certifications Program from Microsoft” here.

Some people may feel challenged by tasks that other people enjoy. Pretty much the same is in the technology world. If you have more experience and education in one area you may find related task easy and find another task more challenging.

There are many discussions about DBAs challenges online. Here are some of the most common ones:
– Performance related challenges (queries tuning, finding performance bottlenecks and finding a solution that is supported by a vendor)
– Balancing applications compatibility issues with SQL Servers supportability and lifecycle-
– Capacity management and planning
– Keeping up with the new technologies
– Effective Security management to address increasing threats and compliance requirements
– Creating robust Disaster Recover plans that fit complex RTO/RPO objectives
– After-hours support.

Depending on industry and clients’ requirements SQL Server Database Administrators can have minimal after-hours (night and weekend) work or have a very demanding on-call schedule.

Some applications are used only during regular business hours. In these cases, SQL Server Database Administrators might have minimal work during non-business hours to patch the database systems, for example or perform the upgrades.

Other applications, for example online banking, require 24/7 availability and DBAs are usually have rotating on-call schedule. Exact hours and frequency depend on a company, and you need to check with IT management how much after-hours work is expected and what is the compensation model for it.

Note, that there are also emergency responses requirements for the SQL Server Database Administrators. It means that if any critical application’s database becomes unavailable you need to work on remediation as soon as possible.

Experienced DBAs with 5 or more years of experience are on demand. But if you just started looking for you first SQL Server Database Administrator job it might take some time and a few interviews. As any other entry level IT job, it might be not so easy to find your very first DBA job.

Check this article about the job market for DBAs in the United States, for example.

Your chances are higher if you have additional skills and willing to take alternative job offers. You can start, for example, as a data analyst, report writer or junior DBA. You can start in a smaller company, but this in most cases will require to perform other than DBA tasks as well. Think about beyond SQL Server Database Administrator additional skills, for example, cloud technologies, DevOps, ETL.

If you are taking university or college program, then you might start as a summer student or a Co-op worker. This will give you an opportunity to obtain experience before finding your first job.

One of the proven methods for finding a job is networking. Attend users’ groups and vendors’ presentations. Meet with other SQL Server Database Administrators.
Read more about finding SQL Server Database Administrator job here. This MSSQLTips category has multiple tips about the job search.