What are the responsibilities and job description for the Database Administrator position at InsideHigherEd?

Position Overview Assessment & Technology Solutions (ATS), a unit within The Achievement & Assessment Institute (AAI) at the University of Kansas (KU), 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 all groups.

Due to complex state employment laws, the University of Kansas may be unable to hire fully remote workers for this position outside of Kansas. Specifically, we cannot currently offer employment to candidates residing in the following states : California and Delaware. We appreciate your understanding and invite interested individuals from eligible states to apply.

Job Description75% 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.
Design, analyze and tune database replication in symmetric and asymmetric replication environments.
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.
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.

25% Design :

Coordinate with application team on developing logical database design, reporting and provide ongoing support and administration of databases pertaining to enterprise business applications.

Review business requirements for business intelligence, data analysis and forensics and design methods for extracting actionable data.

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 RequirementsThis position allows for a hybrid schedule. Hybrid staff will be required to work on-site at our Lawrence, Kansas office 2-3 days / week. Depending on the center and team needs and the labor laws of the state in which the candidate resides, well qualified candidates may be allowed to work fully remotely. This position will require attendance at regularly scheduled meetings, onsite or through telecommunication platforms.

Required Qualifications

High school / GED and 5 years related experience OR associate’s degree with 3 years related experience OR bachelor’s degree with 1 year of related experience OR master’s degree in field related to discipline.

3 years’ experience troubleshooting performance, replication, stability and availability issues in a high volume and highly transactional database environment.

3 years’ experience designing and building data models and schemas to support application and data analysis requirements.

3 years’ experience creating and maintaining databases, tables, views, stored procedures and other database objects.

2 years’ experience performing database tuning, space management, and database administration.

3 years’ experience in writing Queries, Functions, Procedures and DDL scripts for relational database systems.

3 years’ experience managing PostgreSQL databases, MySQL or Microsoft SQL Server databases.

2 years’ experience managing RDS databases in AWS.

Previous work experience that required organizational, project management, strong analytical and problem-solving skills.

Preferred Qualifications

Previous work experience required the usage of version control tools like Git, as demonstrated in application materials.

Certification in one or more commercial database systems

Previous work experience that required In-depth knowledge of IT standards, concepts, best practices, and procedures, as evidenced in application materials.

Experience working with Linux and Windows servers, as evidenced in application materials.

Excellent communication skills, as evidenced in application materials.

Certification in data analysis and Agile development methods

Additional Candidate InstructionsA complete online application consists of :

Cover Letter

Resume

3 Professional References

Incomplete applications will not be considered.

Application deadline is March 2, 2025.

Contact Information to ApplicantsMark Thompson, mark.thompson@ku.edu

Advertised Salary Range$100,000 - $120,000 / yearWork ScheduleMonday-Friday 8 : 00 am - 4 : 30 pmApplication Review BeginsMonday March 3, 2025Anticipated Start DateMonday March 17, 2025 Apply to Job

Salary : $100,000 - $120,000

Apply for this job

Receive alerts for other Database Administrator job openings

Database Administrator

What are the responsibilities and job description for the Database Administrator position at InsideHigherEd?

What is the career path for a Database Administrator?

Job openings at InsideHigherEd

Not the job you're looking for? Here are some other Database Administrator jobs in the Lawrence, KS area that may be a better fit.

We don't have any other Database Administrator jobs in the Lawrence, KS area right now.

AI Assistant is available now!