Edtech.com's Summary

Purdue University is hiring a Database Administrator. The role involves creating, supporting, and administering MySQL, Postgres, Oracle, and SQL Server databases while collaborating on standards and procedures. The position focuses primarily on MySQL administration including installation, configuration, performance tuning, backup, and recovery.

Highlights

Manage MySQL database installation, configuration, upgrades, and security roles.
Optimize SQL queries and analyze execution plans for performance improvement.
Implement automated backup strategies and perform point-in-time recovery to ensure disaster readiness.
Perform performance tuning, including slow query analysis and index optimization.
Administer Linux/Unix systems with shell scripting and monitor system metrics.
Collaborate with developers, sysadmins, and data teams; document technical processes.
Required skills: MySQL, Postgres, Oracle, Linux, Windows OS familiarity, Microsoft SQL, PowerShell, TSQL, SQL Server Management Studio, SecureCRT.
Qualifications: Bachelor’s degree in Computer Science, Engineering, or related field; minimum two years of database administration experience.
Annual salary range: $70,320 to $74,712, commensurate with experience and education.
Background check required; Purdue University does not sponsor employment authorization for this role.

Database Administrator Full Description

Job Summary

The Database Administrator is a fully competent and productive professional contributor who will be responsible for the creation, support, and administration of MySQL, Postgres, Oracle and SQL Server databases on both UNIX and ‎Windows platforms while under general supervision. This position is primarily for MySQL however the DBA will still collaborate with other staff to establish standards, policies, and procedures for all database construction and use, as well as programing and application administration.

1. MySQL Administration

Installing, configuring, and upgrading MySQL
Managing roles, permissions, and security
Monitoring performance and system health

2. SQL Proficiency

Optimizing queries for performance
Understanding execution plans

3. Backup & Recovery

Setting up automated backup strategies
Performing PITR (Point-in-Time Recovery)
Ensuring disaster recovery readiness

4. Performance Tuning

Analyzing and improving slow queries
Index optimization (B-tree, GIN, GiST, etc.)

7. Linux/Unix System Administration

Shell scripting for automation
Familiarity with system-level performance metrics
Working with systemd, crontab, etc.
Setting up alerts for disk space, replication lag, query spikes, etc.

8. Soft Skills

Problem-solving: Debugging complex issues under pressure
Communication: Explaining technical decisions clearly to peers/stakeholders
Documentation: Writing runbooks, SOPs, and change logs

Teamwork: Collaborating with developers, sysadmins, and data teams

This is a remote position.

What We're Looking For

Education and Experience Required:

Bachelor’s degree in Computer Science, Engineering or related field
Two (2) years of experience in database administration
- or a combination of education and experience including at least one-year technical experience with Postgres, mySQL or Oracle

Skills Required:

MySQL, Postgres, Oracle, Linux, Familiarity with Windows OS, Microsoft SQL, MySQL, Oracle, PostGreSQL, MS Office, PowerShell, TSQL, SQL Server Management Studio, SecureCRT

Additional Information:

Purdue University will not sponsor employment authorization for this position
A background check will be required for employment in this position
FLSA: Exempt (Not Eligible for Overtime)
Retirement Eligibility: Defined Contribution Waiting Period
Benefit Statement: Purdue University offers a substantial Benefit Package including medical, dental, and vision insurance as well as a generous paid time off package for sick and vacation days

Career Stream

Professional 2

Pay Band S070
Job Code #20002038

Career path maker: https://www.purdue.edu/hr/careerpathmaker/

The anticipated annual salary for this position is between $70,320 to $74,712 commensurate with the candidate’s education and experience. The final salary offer will be determined based on a variety of factors, including equity, available budget, educational background, and relevant experience.

Who We Are

Purdue is a community built on collaboration, with global perspectives, Boilermaker pride and endless opportunity to live, learn and grow. Join us and contribute to our culture.

Equal Opportunity Employer

Purdue University is an EOE employer.

Original Job Description