27613BR
Achievement & Assessment Inst
Position Overview
Assessment & Technology Solutions (ATS), a unit within the Achievement & Assessment Institute at the University of Kansas, helps public agencies develop high-volume, highly scalable and multi-device-compatible Software as a Service (SaaS) web applications to meet public needs. We are a team of experienced IT professionals with many years of high-volume software product development experience that analyze a client’s technology needs and then design, develop, test, host, and provide post-production support for all web applications that we develop.
ATS is seeking a Database Administrator. Day-to-day activities will involve small to very large and complex Postgres work. The Database Administrator is involved in database design, query optimization, authoring stored procedures, database updates, backups, recovery and troubleshooting of issues.
In addition to a competitive salary, KU offers great benefits to employees with up to 176 hours of paid vacation per year, 8 hours of sick leave earned every month, nine paid holidays plus one discretionary day, a retirement program, medical & dental insurance, life and disability insurance, other benefit plan options and State of Kansas discounts offered by various vendors. KU also offers employees educational and professional development opportunities. KU is a great place to work! KU actively encourages applications from members of underrepresented groups.
KU is not able to provide H1-B sponsorship for this position.
Job Description
75% Operational Support
- Ensure availability and performance of the databases that support online services and business operations (e.g. system monitoring, performance tuning, routine maintenance tasks, etc.)
- Troubleshoot performance, stability and availability issues in a high volume and highly transactional database environment, including creation and review of keys and indexes.
- Work closely with the application development teams to resolve any performance related issues and provide application support.
- Respond to and resolve database access and performance issues.
- Perform database tuning, space management, and instance administration.
- Monitor for deviation in baseline system performance and advise on and execute improvements to slow running queries.
- Review query plans and optimize code as required.
- Measure database performance and troubleshoot complex database issues and I/O bottlenecks.
- Ensure that storage, archiving, backup, and recovery procedures are functioning correctly.
- Develop and maintain efficient programmatic data extracts.
- Run queries to fulfill ad-hoc data requests for customers and internal teams.
- Perform database tuning, performance monitoring, capacity management and automation tasks. Assists in the application of database updates and stand-alone hotfixes to environments, as well as evaluates processes for database management.
- Work closely with IT leaders, software developers, and management.
- Part of on-call rotation to respond to and resolve database issues to ensure production applications are online. This position requires availability outside of standard business hours as part of a rotational on-call schedule
- Coordinate with application team on developing logical database design, reporting and provide ongoing support and administration of databases pertaining to enterprise business applications.
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Implement and oversee database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
- Manage backups, restores and recovery models.
- Configure, manage, and recommend High Availability (HA) and Disaster Recovery (DR) options.
- Stay abreast of trends within the industry as they relate to future innovation of our products and development of new products.
Position Requirements
- This position allows for a hybrid work location for well-qualified candidates.
- This position will require attendance at regularly scheduled meetings onsite.
Required Qualifications
Preferred Qualifications
Additional Candidate Instruction
A complete application consists of:
- Cover Letter
- Resume
- 3 Professional References
Incomplete applications will not be considered.
Review of applications begins April 29 and continues as needed to collect a pool of qualified applicants. For first consideration, please apply by April 29.
Advertised Salary Range
Starting at $85,000; Commensurate with experience
Application Review Begins
29-Apr-2024
Anticipated Start Date
13-May-2024
Primary Campus
University of Kansas Lawrence Campus
FLSA Status
Administrative
Employee Class
U-Unclassified Professional Staff
Work Schedule
Monday-Friday, 8 am-5 pm
Job Family
Information Technology-KUL
Conditions of Employment
Contingent on Funding
Work Location Assignment
Hybrid
Disclaimer
The University of Kansas prohibits discrimination on the basis of race, color, ethnicity, religion, sex, national origin, age, ancestry, disability, status as a veteran, sexual orientation, marital status, parental status, gender identity, gender expression, and genetic information in the university's programs and activities. Retaliation is also prohibited by university policy. The following person has been designated to handle inquiries regarding the nondiscrimination policies and is the Title IX coordinator for all KU and KUMC campuses: Associate Vice Chancellor for Civil Rights and Title IX, [email protected], Room 1082, Dole Human Development Center, 1000 Sunnyside Avenue, Lawrence, KS 66045, 785-864-6414, 711 TTY.
Similar Positions
-
Police Officer, University of Kansas, United States, 29 days ago
Details Posted: 01-Apr-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4916764 University Police Officers perform commissioned law enfo...
-
Academic Advisor, University of Kansas, United States, 1 day ago
Details Posted: 28-Apr-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4930865 University of Kansas Transition to Postsecondary Educati...
-
Assistant Director Student Senate And Leadership Development, University of Kansas, United States, 1 day ago
Details Posted: 28-Apr-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4932116 The University of Kansas' Student Involvement and Leader...
-
Custodian (4pm 12:30am), University of Kansas, United States, 29 days ago
Details Posted: 31-Mar-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4918853 Custodial Services supports KU's mission of learning, sc...
-
Project Coordinator, University of Kansas, United States, 8 days ago
Details Posted: 22-Apr-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4927507 The University of Kansas seeks a highly organized indivi...
-
Administrative Associate Sr, Chancellor's Office, University of Kansas, United States, 8 days ago
Details Posted: 22-Apr-24 Location: Lawrence, Kansas Type: Full-time Salary: Open Categories: Staff/Administrative Internal Number: 4928201 This position serves as the receptionist for the Chancel...