Post job

Contractor-database administration vs database analyst

The differences between contractor-database administrations and database analysts can be seen in a few details. Each job has different responsibilities and duties. It typically takes 2-4 years to become both a contractor-database administration and a database analyst. Additionally, a contractor-database administration has an average salary of $107,794, which is higher than the $85,660 average annual salary of a database analyst.

The top three skills for a contractor-database administration include microsoft sql server, PL/SQL and DBA. The most important skills for a database analyst are database management, database design, and data analysis.

Contractor-database administration vs database analyst overview

Contractor-Database AdministrationDatabase Analyst
Yearly salary$107,794$85,660
Hourly rate$51.82$41.18
Growth rate9%9%
Number of jobs23,45877,072
Job satisfaction--
Most common degreeBachelor's Degree, 63%Bachelor's Degree, 69%
Average age4646
Years of experience44

Contractor-database administration vs database analyst salary

Contractor-database administrations and database analysts have different pay scales, as shown below.

Contractor-Database AdministrationDatabase Analyst
Average salary$107,794$85,660
Salary rangeBetween $69,000 And $168,000Between $63,000 And $116,000
Highest paying City-San Francisco, CA
Highest paying state-Washington
Best paying company-Mayo Clinic
Best paying industry-Manufacturing

Differences between contractor-database administration and database analyst education

There are a few differences between a contractor-database administration and a database analyst in terms of educational background:

Contractor-Database AdministrationDatabase Analyst
Most common degreeBachelor's Degree, 63%Bachelor's Degree, 69%
Most common majorBusinessBusiness
Most common collegeStanford UniversityStanford University

Contractor-database administration vs database analyst demographics

Here are the differences between contractor-database administrations' and database analysts' demographics:

Contractor-Database AdministrationDatabase Analyst
Average age4646
Gender ratioMale, 63.4% Female, 36.6%Male, 62.3% Female, 37.7%
Race ratioBlack or African American, 8.0% Unknown, 5.2% Hispanic or Latino, 9.2% Asian, 17.7% White, 59.3% American Indian and Alaska Native, 0.5%Black or African American, 8.3% Unknown, 5.2% Hispanic or Latino, 9.4% Asian, 19.3% White, 57.3% American Indian and Alaska Native, 0.5%
LGBT Percentage6%6%

Differences between contractor-database administration and database analyst duties and responsibilities

Contractor-database administration example responsibilities.

  • Fix grid control alerts on the database and monitor the database using grid control including managing of templates.
  • Analyze database performance, tune queries, and write PL/SQL store procedures, triggers, functions and packages.
  • Develop and implement backup and recovery procedures and create a corporate disaster recovery procedure for DB2.
  • Maintain scripts, procedures and SSIS solutions.
  • Create and performance tune T-SQL Scripts/SSIS packages.
  • Assist developers with T-SQL code development for more efficient execution.
  • Show more

Database analyst example responsibilities.

  • Develop PL/SQL packages and procedures in order to automate financial reports on a monthly, quarterly and annual basis.
  • Used T-SQL skills including creation of user define functions, complex store procedures, query optimization to write automate reporting.
  • Implement and automate existing manual process, to create CRF by creating new database objects in SQL and macro in excel.
  • Develop employee web portal using PHP, JavaScript, CSS, and MySQL.
  • Design and schedule SSIS packages to load data from OLTP to OLAP system for data analysis and generating KPI reports.
  • Perform analysis, design, programming, and unit testing of PL/SQL code and UNIX shell scripts.
  • Show more

Contractor-database administration vs database analyst skills

Common contractor-database administration skills
  • Microsoft SQL Server, 10%
  • PL/SQL, 9%
  • DBA, 6%
  • Database Systems, 5%
  • Windows, 5%
  • Linux, 4%
Common database analyst skills
  • Database Management, 8%
  • Database Design, 8%
  • Data Analysis, 6%
  • Backup Recovery, 5%
  • ETL, 4%
  • Data Warehouse, 4%

Browse computer and mathematical jobs