Senior Database Administrator
Core
Senior Database Administrator managing cloud database infrastructure and automating processes for the UT Data Hub to improve university outcomes.
Role type
Senior Database Administrator (Cloud/PostgreSQL/Oracle)
Builds
Cloud database infrastructure, automated database processes, high availability solutions, and disaster recovery strategies for the UT data ecosystem.
Domain
Higher Education / Cloud Data Infrastructure
Deliverable
production ML models | infrastructure
Required skills
PostgreSQL administration, SQL scripting, database tuning, Oracle administration, AWS services (RDS, S3, EC2, IAM, VPC), Databricks workspace administration, Infrastructure as Code (AWS CDK, Terraform), backup and disaster recovery strategies, high availability solutions, system administration (Windows/Linux), dbt
Preferred skills
Cloud-based workload automation, cloud data warehouse experience, high availability database implementations, SDLC support, Quality Assurance processes, Agile methodologies, issue tracking systems, AWS/Databricks certifications
Technologies
PostgreSQL, Oracle, Databricks, AWS, Cognos, Tableau, dbt, AWS CDK, Terraform, CloudWatch, JIRA
Responsibilities
Contribute to day-to-day operations of PostgreSQL databases in a 24x7 production environment; Define database architectures to meet application performance and security requirements; Implement tuning improvements and advise developers on SQL tuning options; Develop and implement backup and disaster recovery strategies; Perform PostgreSQL server updates, upgrades and installations; Configure and maintain legacy Oracle database instances; Hands-on administration of AWS services supporting database workloads; Databricks workspace administration including cluster management and Unity Catalog; Participate in on-call rotation; Provide Windows and Linux system administration as needed for database applications.
Seniority
Senior, hands-on IC