Database designer vs data administrator

The differences between database designers and data administrators can be seen in a few details. Each job has different responsibilities and duties. It typically takes 2-4 years to become both a database designer and a data administrator. Additionally, a database designer has an average salary of $87,051, which is higher than the $80,072 average annual salary of a data administrator.

The top three skills for a database designer include database design, data management and javascript. The most important skills for a data administrator are data management, java, and profiling.

Database designer vs data administrator overview

	Database Designer	Data Administrator
Yearly salary	$87,051	$80,072
Hourly rate	$41.85	$38.50
Growth rate	9%	9%
Number of jobs	68,992	124,537
Job satisfaction	-	-
Most common degree	Bachelor's Degree, 68%	Bachelor's Degree, 58%
Average age	46	46
Years of experience	4	4

Database designer vs data administrator salary

Database designers and data administrators have different pay scales, as shown below.

	Database Designer	Data Administrator
Average salary	$87,051	$80,072
Salary range	Between $64,000 And $117,000	Between $53,000 And $119,000
Highest paying City	San Jose, CA	Richmond, CA
Highest paying state	New Jersey	Louisiana
Best paying company	State Street	Southern California Edison
Best paying industry	Finance	Finance

Differences between database designer and data administrator education

There are a few differences between a database designer and a data administrator in terms of educational background:

	Database Designer	Data Administrator
Most common degree	Bachelor's Degree, 68%	Bachelor's Degree, 58%
Most common major	Computer Science	Business
Most common college	Massachusetts Institute of Technology	Stanford University

Database designer vs data administrator demographics

Here are the differences between database designers' and data administrators' demographics:

	Database Designer	Data Administrator
Average age	46	46
Gender ratio	Male, 67.2% Female, 32.8%	Male, 41.9% Female, 58.1%
Race ratio	Black or African American, 6.7% Unknown, 5.1% Hispanic or Latino, 8.4% Asian, 27.5% White, 51.7% American Indian and Alaska Native, 0.5%	Black or African American, 8.0% Unknown, 5.2% Hispanic or Latino, 9.2% Asian, 17.7% White, 59.4% American Indian and Alaska Native, 0.5%
LGBT Percentage	6%	6%

Differences between database designer and data administrator duties and responsibilities

Database designer example responsibilities.

Devise and manage recommended changes to SalesForce for better business processing practices.
Create and modify tables, views and indexes, PL/SQL store procedures, functions and triggers according to business requirement.
Perform and troubleshoot data extract into SAS datasets.
Translate ETL of data to graphs used to drive business decisions.
Enhance existing database screens with useful metric reporting functions using VBA.
Apply updates and financial transactions receive from customers, in XML format.

Data administrator example responsibilities.

Manage the LDAP requests for user provision.
Manage replication & distribution servers, versioning dev & production servers.
Design and lead team efforts to reduce batch windows through application on new features.
Manage access to file shares, DFS shares, IIS servers and terminal services.
Integrate LDAP and setup security at multiple levels to achieve data security and object level security.
Install and set up the VMWare environment, managing the closing/building and allocation of all virtual servers.

Database designer vs data administrator skills

Common database designer skills

Database Design, 14%
Data Management, 10%
JavaScript, 10%
PL/SQL, 9%
SAS, 5%
Microsoft SQL Server, 4%

Common data administrator skills

Data Management, 12%
Java, 11%
Profiling, 10%
DB2, 7%
Unix, 7%
Sybase, 6%