Principal Database Administrator
Purpose of Position: Provide lead responsibility in all UT Data Warehouse(IQ)related database administration, architecture, operational maintenance and functional application support. Establish best practices and scalable/sustainable infrastructure to enhance data warehouse services to meet the University business needs.
Essential Functions: Primary technical responsibility in the installation and upgrade of IQ specific Oracle products and applications software, monitoring and tuning database performance, defining new/modified database tables, and device configuration. Provide design and support services for establishing, upgrading, and maintaining the Oracle software environments, including, but not limited to Operational Data Store (ODS), Enterprise Data Warehouse (EDW), other reporting and analytics products such as Cognos and OBIEE as well as other vendor-supplied and locally developed systems. In conjunction with functional and other infrastructure teams, assists in establishing and managing user access and design and implement security and DR architecture. In conjunction with IQ and other ETL developers and business analysts, define new objects or modifications to existing objects. Create, maintain and refresh required Oracle instances/databases for development, test and production environments. Assist in resolving application or transactional level errors, security breaches, user activity and resource utilization and ongoing capacity planning of production environment. Monitor system resources of database servers to assure production systems meet performance _ availability requirements and hardware enhancements are scheduled in a timely fashion. Provide after hours on-call support for critical database issues. Assists and performs scheduling and monitoring daily refreshes and loads from other source of records (such as mainframe or other databases). Understand and maintain documentation of dependencies between versions of application vendor software, databases, OS and storage. Work with project teams, IQ, and IT governance bodies to determine needs, set priorities, and create project plans. Lead and participate in a larger IT team to architect, implement and enhance a new generation of relational database infrastructure and standards as applicable to the ERP and other business units on campus.
Marginal/Incidental functions: Other related functions as assigned.
Required qualifications: 8 years of experience in DB design/architecture, data modeling, security, performance, scalability, and tuning for ERP, web, and scientific research databases across heterogeneous DB platforms. Demonstrated experience leading efficiency improvements and implementation of DB policies and procedures for data security and integrity across heterogeneous DB platforms. Proven experience in disaster recovery and business continuity design and implementation across heterogeneous DB platforms. Demonstrated experience of successful partnerships with software application development groups to provide DB setup, optimization, and modification support. Experience in identification, design and implementation of process automation with scripting tools. Proven record of successful design and implementation of High Availability Configurations and Clustering, Replication, Mirroring and Log Shipping - across heterogeneous DB platforms. Experienced with systematic performance tuning (i.e., DB server performance tuning, DB-related component tuning, and product-specific DB request tuning) across heterogeneous database platforms. Bachelor's degree. Excellent customer focus and interpersonal skills. Equivalent combination of relevant education and experience may be substituted as appropriate.
Preferred Qualifications: Project management skills and ability to lead large, complex technical projects. Record of developing project charters, timelines, technical deliverable, resource allocation, and task delegation. Record of timely completion of project milestones. Graduate degree in computer science or related field. Experience leading and composing communications for database events and procedures. Experience with Oracle Exadata implementation and administration.
Working conditions: May work around standard office conditions Repetitive use of a keyboard at a workstation Climbing of stairs Work performed on concurrent multiple projects under pressure of rigid deadlines and/or time limitations. May require occasional extended work hours or on-call obligation.
Must be authorized to work in the United States on a full-time basis for any employer.
Please apply online at: https://utdirect.utexas.edu/apps/hr/jobs/nlogon/120320019329