Job Details

Enterprise Database Specialist
Go to our website »

Position Number: 5139959
Location: El Paso, TX
Position Type: Computer and Information Technology

Enterprise Database Specialist

Job ID: 11710
Location: El Paso, TX
Full/Part Time: Full Time
Regular/Temporary: $RegTemp

About UTEP

UTEP is a comprehensive public research university that is increasing access to excellent higher education. We advance discovery of public value and positively impact the health, culture, education, and economy of the community we serve.

The University of Texas at El Paso is America's leading Hispanic-serving university. Located at the westernmost tip of Texas, where three states and two countries converge along the Rio Grande, 84% of our 24,000 students are Hispanic, and more than half are the first in their families to go to college. UTEP offers 172 bachelor's, master's and doctoral degree programs at the only open-access, top-tier research university in America.

Position Information

Hiring Department: Information Technology, Enterprise Computing

Posting End Date: Open until filled

Hours: 40 hours per week, standard Monday- Friday 8:00am- 5:00pm; the work schedule for this position requires on-call availability, and at times work will be performed on weekends or occasional holidays. Occasional travel may be required.

FLSA status: Exempt

Earliest Start Date: As soon as possible

Salary: $70,149 annually

Required Application Materials:

Resume
Cover Letter

Optional Application Materials:

List of three references

The primary accountabilities are intended to describe the general content of and requirements of this position and are not intended to be an exhaustive statement of duties. Incumbents may perform all or some of the primary accountabilities listed. Specific tasks or responsibilities will be documented in the incumbents' performance objectives as outlined by the incumbents' immediate supervisor or manager. This position is security-sensitive and subject to Texas Education Code 51.215, which authorizes the employer to obtain criminal history record information. A valid driver's license issued by the State where the applicant resides and insurability as defined in UTS 157 may be required to perform the position's essential functions.

Purpose of Position

Under close supervision but with latitude for the use of independent judgment, designs, implements, and assists to maintain critical University-wide computer servers and databases; codes, tests, and implements physical databases using relational database management system (Microsoft SQL Server).

Essential Functions

Responsible for critical databases that affect University-wide deployments such as University web pages, student information system, and datamarts.

Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access methods.

Creates advanced database objects such as tables, views, functions, and stored procedures using standard database languages such as Structured Query Language (SQL) as well as vendor-specific procedural database languages such as T-SQL or PL/SQL.

Calculates optimum values for database parameters such as amount of computer memory and processor requirements.

Designs database security based upon requirements and existing University policies.

Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.

Establishes and maintains database installation configurations.

Modifies database schema and stored procedures to increase processing performance, referred to as performance tuning.

Tests and corrects errors, and refines changes to databases and database objects.

Creates and maintains documentation for new projects.

Must be available on an on-call basis, weekends, and holidays as needed.

Assists with special projects, as needed.

Knowledge of all Microsoft Office software and able to learn and use institutional software and systems.

Complies with all State and University policies.

Other duties may be assigned.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Required Qualifications:

Education: Bachelor's degree from four-year college or university within area of assigned responsibility

and

Experience: Three (3) years of experience related to the statement of duties and responsibilities; OR equivalent combination of education and experience.

Qualified Applicants Should Demonstrate:

Working knowledge of operating systems such as Microsoft Windows, Linux, or Unix.

Working knowledge of Microsoft SQL Server Engine and Microsoft SQL Server Agent operations.

Working knowledge of Microsoft SQL Server management with Powershell.

Occasional travel may be required.

Additional Information

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee must frequently stand and walk. The employee must regularly sit; use hands to feel; reach with hands and arms; and talk or hear. The employee must lift and move up to 25 pounds. The work schedule for this position requires on-call availability, and at times work will be performed on weekends or occasional holidays.

The noise level for this work environment is usually moderate.

In keeping with its access, excellence and impact mission, The University of Texas at El Paso is committed to an open, diverse, and inclusive learning and working environment that honors the talents, respects the differences, and nurtures the growth and development of all. We seek to attract faculty and staff who share our commitment.

The University of Texas at El Paso is an Equal Opportunity / Affirmative Action Employer. The University does not discriminate on the basis of race, color, national origin, sex, religion, age, disability, genetic information, veteran status, or sexual orientation and gender in employment or the provision of services in accordance with state and federal law. Discrimination on the basis of sex includes an employee's or prospective employee's right to be free from sexual harassment under Title IX of the Higher Education Amendments of 1972.

For accommodation information for employees and applicants with disabilities, please contact UTEP's Equal Opportunity Office at eoaa@utep.edu.

To apply, visit https://zahr-prd-candidate-ada.utshare.utsystem.edu/psp/ZAHRPRDADA/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=2&JobOpeningId=11710&PostingSeq=1