Senior Database Administrator

Job Posting Title:

Senior Database Administrator

----

Hiring Department:

Enterprise Technology - Data to Insights (D2I)

----

Position Open To:

All Applicants

----

Weekly Scheduled Hours:

40

----

FLSA Status:

Exempt from FLSA

----

Earliest Start Date:

Immediately

----

Position Duration:

Expected to Continue

----

Location:

Texas

----

Job Details:

General Notes

Flexible work arrangements are available for this position, including the ability to work 100% remotely. Remote work for individuals who reside outside Texas but within the United States and its territories will be considered and requires Central Office approval.

This position provides life/work balance with typically a 40-hour work week and travel limited to training (e.g., conferences/courses).

Enterprise Technology is dedicated to supporting the mission of the University of Texas at Austin of unlocking potential and preparing future leaders of the state.

Your skills will make a difference.

You’ll be working for a university that is internationally recognized for research and the work you do will make a difference in the lives of our students, faculty and staff. If you’re the type of person that wants to know your work has meaning and impact, you’ll like working for our campus.

The University of Texas at Austin and Enterprise Technology provide an outstanding benefits package to our staff. Those benefits include:

• Competitive health benefits (Employee premiums covered at 100%; family premiums at 50%) 

• Vision, dental, life, and disability insurance options 

• Paid vacation, sick leave, and holidays 

• Teachers Retirement System of Texas (a defined benefit retirement plan) 

• Additional voluntary retirement programs: tax sheltered annuity 403(b) and a deferred compensation program 457(b) 

• Flexible spending account options for medical and childcare expenses 

• Training and conference opportunities 

• Tuition assistance 

• Athletic ticket discounts 

• Access to UT Austin's libraries and museums 

• Free rides on all UT Shuttle and Capital Metro buses with staff ID card 

For more details, please see: https://hr.utexas.edu/prospective/benefits and https://hr.utexas.edu/current/services/my-total-rewards 

Must be authorized to work in the United States on a full-time basis for any employer without sponsorship.

This position requires you to maintain internet service and a mobile phone with voice and data plans to be used when required for work.

Purpose

The Senior Database Administrator for the UT Data Hub improves university outcomes and advances the UT mission to transform lives for the benefit of society by increasing the usability and value of institutional data. The position builds and maintains cloud database infrastructure and automates database processes for the UT data ecosystem. It covers database and system administration across Oracle, PostgreSQL, and Databricks, and devises optimal database configurations to meet university needs for high-performance data systems and ensures compliance with UT information security requirements. The role requires strong troubleshooting skills and the ability to build effective working relationships across technical and non-technical teams. Main tech stacks include: Databricks, AWS, Cognos, Oracle, PostgreSQL, and Tableau.
 

Responsibilities

Cloud Database Administration:

• Contribute to all day-to-day operations of PostgreSQL databases in a 24x7 production environment. 
• Demonstrate progressive troubleshooting and analytical skills through timely problem resolution. 
• Define database architectures to meet application performance and security requirements. 
• Implement tuning improvements and advise developers on SQL tuning options. 
• Provide technical guidance on integration, design and testing on production system databases. 
• Develop process for Performance Monitoring of database servers and individual databases. 
• Develop, implement and improve backup and disaster recovery strategies. 
• Develop and implement high availability solutions.
• Perform PostgreSQL server updates, upgrades and installations.
• Demonstrate an ability to write SQL scripts and stored procedures.