Information Technology Careers | SQL Server Database Administrator

SQL Server Database Administrator

Career Area: Information Technology

Occupation Group: Database Specialists

Salary

Percentile wages tell how much a certain percentage of an overall population in a geographic area or within a given industry or field makes. The percentile wage estimate is the value of a wage below which a certain percent of workers fall.

An example would be the 25th percentile, 25 percent of workers employed in that occupation earn less and 75 percent earn more than the estimated wage value. At the 75th percentile, 75 percent of workers employed in that occupation earn less and 25 percent earn more than the estimated wage value.

A typical SQL Server Database Administrator earns the following wages (national and state):

State

The average salary in North Carolina for those pursuing this career is $94,422

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

National

The average salary in the United States for those pursuing this career is $95,773

*The salaries depicted here are representative of the range of salaries posted in job listings over the past year. Living wage in North Carolina is $30,000.

What Does a Professional in this Career Do?

Administers SQL Server data systems and structures. Uses software applications and structured query language (SQL) procedures to store and organize data, such as an organization's records or financial information. Ensures that users can easily access the information they need and that data are protected from unauthorized access.

Employment Trends

The job demand and job growth statistics shown here were derived from job posts over the past year. Expected job growth projections are extrapolated from year-over-year job post listing history.

Job demand and job growth is expected at the following rates:

LocationGrowth
North Carolina38+16%
Nationwide1341+11.5%

Skills

A professional in this position typically utilizes the following skills in the course of everyday work in this exciting and challenging field:

Baseline Skills

The following are baseline skills every SQL Server Database Administrator is expected to have in order to experience success in this field:

  • Troubleshooting: Troubleshooting or dpanneuring is a form of problem solving, often applied to repair failed products or processes on a machine or a system.
  • Communication Skills: The ability to convey information to another effectively and efficiently.
  • Planning: Working experience with the process of thinking about and organizing the activities required to achieve desired goals.
  • Problem Solving: Problem solving consists of using generic or ad hoc methods, in an orderly manner, for finding solutions to problems.
  • Writing: Experience expressing business messages effectively in written form. This may include planning drafting and revising as necessary.

Specialized Skills

These skills are specific to working in this career:

  • SQL: SQL ( ESS-kew-EL or SEE-kwl, Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
  • SQL Server: Microsoft SQL Server is a relational database management system developed by Microsoft.
  • Database Administration: Database administration is the function of managing and maintaining database management systems (DBMS) software.
  • Teradata DBA: Working experience of Teradata DBA. Teradata offers three main services to its customers: cloud and hardware-based data warehousing, business analytics, and consulting services. In September 2016, the company launched Teradata Everywhere, which allows users to submit queries against public and private databases. The service uses massively parallel processing across both its physical data warehouse and cloud storage, including managed environments such as Amazon Web Services, Microsoft Azure, VMware, and Teradata's Managed Cloud and IntelliFlex.
  • Performance tuning: Working experience of Performance tuning, which is the improvement of system performance. Typically in computer systems, the motivation for such activity is called a performance problem, which can be either real or anticipated. Most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load is called scalability, and modifying a system to handle a higher load is synonymous to performance tuning.

Distinguishing Skills

Any SQL Server Database Administrator that possesses the following skills will stand out against the competition:

  • Database Architecture: Database architecture focuses on the design, development, implementation and maintenance of computer programs that store and organize information for businesses, agencies and institutions.
  • Oracle PL/SQL: PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.
  • PostgreSQL: PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.
  • Database mirroring: Working experience of Database mirroring, which is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially compromised.
  • Data Warehouse Processing: Working experience of Data Warehouse Processing, which involves extracting, transforming and loading data from source systems and placing it into a data warehouse.

Salary Boosting Skills

A professional who wishes to excel in this career path may consider developing the following highly valued skills:

  • Database Architecture: Database architecture focuses on the design, development, implementation and maintenance of computer programs that store and organize information for businesses, agencies and institutions.
  • Database Cloning: Working experience of Database Cloning. A database clone is a complete and separate copy of a database system that includes the business data, the DBMS software and any other application tiers that make up the environment. Cloning is a different kind of operation to replication and backups in that the cloned environment is both fully functional and separate in its own right. Additionally the cloned environment may be modified at its inception due to configuration changes or data subsetting.

Experience

This position typically requires the following level of experience. The numbers presented in the pie charts below were derived from actual job posts over the past year. Not all job postings list experience requirements.

Experience Required%
0 to 2 years6%
3 to 5 years47%
6 to 8 years29%

Many of the programs offered through NC State are designed for working professionals who need additional credentials to enhance existing work experience.

Students who do not have the expected level of experience may wish to look into internship and employment opportunities.

Common Job Titles

It is possible to find work in this field in positions commonly listed as the following job titles:

  • Sql Server Database Administrator
  • Senior Sql Server Database Administrator
  • Sql Server
  • Microsoft Sql Server Database Administrator
  • Sql Server Database Administrator/Developer

Similar Occupations

If you are interested in exploring similar occupations, you may want to research the following job titles: