Job Location: Iowa City, IA
This position is eligible to participate in remote work. Remote work must be performed at a location within the state of Iowa. Successful candidates who participate in remote work must comply with requirements of the remote work program and related policies.
Position Summary:
The University of Iowa Hospitals and Clinics department of Health Care Information Systems is seeking a Lead Database Administrator to plan, coordinate, deploy and manage complex database management systems, processes, and related technologies in support of data warehouse and analytics initiatives. Primary duties include providing operational support for multi-terabyte database management systems and solutions built on them to ensure performance, capacity, service, and security level expectations are met. This position is responsible for provisioning database system resources, continual monitoring and alert follow-up, database backup, disaster mitigation and recovery. Involvement in root cause analysis of adverse performance events and subsequent resolution by utilizing tracing, query and database optimization is expected. Research of new and upgrades to existing database system technologies, review of business value with stakeholders and implementation of new technology is part of this role.
Position Responsibilities:
- Collaborates with development staff, customers, and other DBAs to translate project goals into database models.
- Review of business value with stakeholders
- Serves as an expert consultant for both applications and other systems support staff on questions and problems with database design, usage, tuning and troubleshooting.
- Installs, administers, and fine-tunes database engine.
- Provisioning database system resources
- Continual monitoring and alert follow-up
- Involvement in root cause analysis of adverse performance events and subsequent resolution by utilizing tracing, query, and database optimization
- Manages data access and administers database security.
- Develops and implements change management procedures including version control.
- Develops database backup, disaster mitigation and recovery.
- Research of new and upgrades to existing database system technologies
- Prepares reports for management on database growth and performance as needed.
- Provides technical information, guidance, and training to junior staff members, as assigned.
Health Care Information Systems (HCIS) provides and supports information and communication systems and technology that facilitate quality patient care, progressive medical education, and innovative research.
HCIS services University of Iowa Health Care by providing comprehensive, high level support for patient care delivery, internal and external communication, technology innovation, medical education, and research. Creating and maintaining a positive, productive, and rewarding environment for information technology and communication staff
Pay Grade: https://hr.uiowa.edu/pay/pay-plans/professional-and-scientific-pay-structure-b
Salary: $75,000 to commensurate (Paygrade 5B)
The University of Iowa offers a generous benefits package, including 24 days paid vacation per year to start and paid sick leave. Complete information regarding the full benefits package may be viewed at https://hr.uiowa.edu/benefits
Percent of Time: 100%
Location: 3281 Ridgeway Drive, Coralville, IA
Staff Type: Professional & Scientific
Type of Position: Regular
Position Qualifications:
Education Required
Bachelor’s in Computer Science, Engineering or MIS or an equivalent combination of education and experience.
Required Qualifications:
- MS SQL Server 2014/2016/2019 database management system administration experience (typically 5-7 years) in an enterprise environment
- MS SQL database index, index management and database statistics proficiency
- MS Windows Server 2012 R2/2016/2019 clustering implementation experience
- Microsoft Business Intelligence (MSBI) stack concepts and usage experience
- MS SQL Server Integration Services (SSIS) administration experience
- Working experience organizing and managing projects and documentation
- Excellent written and verbal communication skills
Desired Qualifications
- MS SQL Server Analysis Services (SSAS) administration experience
- MS SQL database, query, and SSIS package performance tuning and optimization proficiency
- MS SQL database replication concepts, architecture and implementation
- SAN connected MS SQL server architecture and implementation
- Active Directory and Kerberos authentication for MS SQL Implementation
- ETL and data quality tool administration and usage
- PowerShell scripting proficiency
- MS SQL Server certification
In order to be considered, applicants must upload a resume (under submission relevant materials) that clearly addresses how they meet the listed required and desired qualifications of this position. A cover letter is desired as part of the application process. Job openings are posted for a minimum of 14 calendar days. This job may be removed from posting and filled any time after the minimum posting period has ended.
Successful candidates will be subject to a criminal background and credential check. This position is not eligible for University sponsorship for employment authorization.
For additional questions contact John Thiede john-thiede@uiowa.edu
Submit CV To All Data Science Job Consultants Across United States For Free