Database Specialist

Job Level
Entry-level position
Job Category
Specialist / Associate
Sector
  • Systems / Operations
Job Status
Areas of Responsibility
  • Data / Database

Title

Database Specialist

Department

Office of the Registrar (8101)

Location

Main Campus

Position Summary

The database specialist will work under the supervision of the Database Specialist Sr. This position is responsible for database support for multiple divisions within the Office of the Registrar. Strong communication skills are vital. Exceptional attention to detail, sensitivity in maintaining confidential information, and the ability to effectively assess and respond to team member’s data needs is essential. The Office of the Registrar requires an individual who is multi-talented, who works well under pressure and genuinely enjoys working with people.

Outstanding UA benefits include health, dental, and vision insurance plans; life insurance and disability programs; paid vacation, sick leave, and holidays; UA/ASU/NAU tuition reduction for the employee and qualified family members; state retirement plan; access to UA recreation and cultural activities; and more!

The University of Arizona has been recognized for our innovative work-life programs. For more information about working at the University of Arizona and relocations services, please click here.

The University of Arizona is in the process of creating a new classification and compensation architecture. This University Career Architecture Project (UCAP) will revolutionize the way we think about professions and manage compensation at the UA. It is a two year initiative that will replace the current classified staff and appointed professional categories of employment with market-based job functions and families. As an applicant, UCAP will create clearer career paths and opportunities and will help you make more informed pay decisions. To learn more about this project, please visit ucap.arizona.edu.

Duties & Responsibilities

  • Compiles and submits data for National Student Clearinghouse reporting.

  • Runs the grade change work flow process.

  • Works multiple report processes related to grading.

  • Runs reports to ensure integrity of data between information academic departments are entering in relation to the Course Catalog. 

  • Creates future semesters and roll course section information from one semester to the next. 

  • Runs reports in Ad Astra to ensure data integrity between UAccess and Ad Astra.

  • Monitors database system availability and overall functionality. Creates and implements programming scripts and procedures to maintain consistent and accurate data, 

  • Communicates with users to troubleshoot problems and identify database needs. Analyzes requested database changes for impact on existing computer systems. 

  • Trains and informs users directly or through user interfaces. Instructs users on data extraction techniques. Imports, exports and retrieves data for users. 

  • Creates technical and non-technical database documentation. 

  • Participates in the analysis, design and development of automated databases.

Knowledge, Skills, & Abilities

  • Knowledge of logging into remote environments.

  • Knowledgeable about computer security and the safe practices regarding sensitive data. 

  • Skill in analytical and creative problem solving.

  • Skill in communicating technical information to technical and non-technical users.

  • Skill in working independently and as part of a team.

  • Ability to communicate effectively, verbally and in writing.

Minimum Qualifications

  • Experienced in the development, maintenance and querying of relational database management systems including Microsoft Access.

  • Comprehensive knowledge of Microsoft Office Products.

  • Comprehensive knowledge of navigating within a local area network.

Arizona Board of Regents Minimum Qualifications

Three years of experience installing, monitoring and maintaining relational database software and related hardware; OR, an Associate’s degree in Management Information Systems, Computer Information Technology or related field AND two years of experience installing, monitoring and maintaining relational database software and related hardware; OR, Any equivalent combination of experience, training and/or education.

Preferred Qualifications

  • Experienced in PeopleSoft’s’ Records and Enrollment, Enrollment Reporting, Reporting tools including Query Manager and Communication Generation.

  • Ability to build queries in PeopleSoft Query Manager using SQL.

  • Knowledge of building Analysis and Dashboards in Oracle Business Intelligence Enterprise Edition (UAccess Analytics).

  • Experienced in SQL query development using Microsoft Access and SQL Developer.

Full Time/Part Time

Full Time

Number of Hours Worked per Week

40

Job Category

Computer, Engineering and Technical

Benefits Eligible

Yes - Full Benefits

FLSA

Exempt

Posted Rate of Pay

$29,441 - $40,361 Annually (DOE)

Type of criminal background check required:

Name-based criminal background check (non-security sensitive)

Posting Detail Information

 

Posting Number

S27444

Number of Vacancies

One

Desired Start Date

08/12/2019

Position End Date (if temporary)

 

Limited to Current UA Employees

No

Contact Information for Candidates

Denise Lewis
dlewis9@email.arizona.edu

Open Date

07/12/2019

Review Start Date

07/22/2019

Close Date

 

Open Until Filled

Yes

Special Instructions to Applicant

Please note: You will be required to provide contact information for a minimum of three professional references within your application. Should you be selected as a finalist for this position, for your convenience, your references may receive an automatic email. This email will ask your references to complete a brief questionnaire in regard to your suitability for the position as well as request the attachment of a letter of recommendation. These letters of recommendation must be uploaded directly via the UACareers.com website by your reference provider. UACareers.com is not compatible with any “dossier aggregate” system (e.g., Interfolio, Intellimedia).

Quick Link for Internal Postings

http://uacareers.com/postings/39822

Diversity Statement

At the University of Arizona, we value our inclusive climate because we know that diversity in experiences and perspectives is vital to advancing innovation, critical thinking, solving complex problems, and creating an inclusive academic community. As an Hispanic-serving institution, we translate these values into action by seeking individuals who have experience and expertise working with diverse students, colleagues, and constituencies. Because we seek a workforce with a wide range of perspectives and experiences, we provide equal employment opportunities to applicants and employees without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or genetic information. As an Employer of National Service, we also welcome alumni of AmeriCorps, Peace Corps, and other national service programs and others who will help us advance our Inclusive Excellence initiative aimed at creating a university that values student, staff and faculty engagement in addressing issues of diversity and inclusiveness.