Edtech.com's Summary

Purdue University is hiring a Database Administrator responsible for creating, supporting, and administering MySQL, Postgres, Oracle, and SQL Server databases on UNIX and Windows platforms. The role involves managing database performance, security, backup and recovery, and collaborating with a team to establish database standards.

Highlights

Administer MySQL databases including installation, configuration, and upgrades.
Manage database security through roles, permissions, and access controls.
Monitor and optimize SQL queries and database performance metrics.
Design and maintain automated backup and disaster recovery strategies including Point-in-Time Recovery.
Perform Linux/Unix system administration and automate tasks using shell scripting.
Use tools such as systemd, crontab, and configure real-time alerts for system metrics.
Communicate technical decisions clearly and document procedures for team use.
Collaborate across teams including developers, sysadmins, and data professionals.
Required skills include MySQL, Postgres, Oracle, Linux, Windows OS familiarity, Microsoft SQL, PowerShell, TSQL, and SQL Server Management Studio.
Requires a Bachelor's degree with at least two years of experience; salary range $80,880 to $85,935 yearly.

Database Administrator Full Description

Database Administrator, Senior
Purdue University

Join Purdue University as a Senior Database Administrator—an integral role responsible for the creation, support, and administration of MySQL, Postgres, Oracle, and SQL Server databases across both UNIX and Windows platforms. While this position primarily focuses on MySQL, you'll collaborate with a dedicated team to set standards and drive excellence in database use, programming, and application administration.

Key Responsibilities

MySQL Administration
Install, configure, and upgrade MySQL databases.
Manage security: roles, permissions, and access controls.
Monitor database performance and system health, proactively troubleshooting issues.

SQL Proficiency

Optimize SQL queries for maximum performance and efficiency.
Interpret and utilize execution plans to refine resource usage.

Backup & Recovery

Design and maintain automated backup strategies.
Perform and validate Point-in-Time Recovery (PITR).
Ensure disaster recovery plans are up-to-date and thoroughly tested.

Performance Tuning

Diagnose and resolve slow SQL queries.
Optimize data structures using advanced indexing (B-tree, GIN, GiST, etc.).
Linux/Unix System Administration
Automate system tasks with shell scripting.
Monitor system-level metrics and proactively identify bottlenecks.
Utilize systemd, crontab, and configure real-time alerts for key metrics (disk space, replication, query spikes).

Soft Skills

Problem-Solving: Debug complex technical issues effectively under pressure.

Communication: Articulate technical decisions and strategies clearly to peers and stakeholders.

Documentation: Write thorough runbooks, SOPs, and maintain change logs that enable team success.

Teamwork: Collaborate cross-functionally with developers, sysadmins, and data professionals.

Why Purdue?
At Purdue, experience a culture defined by unrivaled pride, unlimited potential, and a trusted community. Our employer value proposition ensures:

Community: Work among colleagues devoted to your growth and success.

Opportunity: Tackle innovative database challenges with global impact, empowered to learn and contribute.

Boilermaker Pride: Be part of a legacy dedicated to excellence and distinction.

Support: Enjoy professional development and an environment where every contribution matters.

Join us to make a lasting impact—supporting campus initiatives and technological advancement as part of a team that celebrates collaboration and innovation.

The anticipated annual salary range for this position is $80,880 to $85,935 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.

This is a remote position.

About Us

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.

What We're Looking For

Education and Experience Required:

Bachelor’s Degree
Two (2) years experience
An equivalent combination of education and experience may be considered

Skills Needed:

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 #20002039

Career pathmaker: https://www.purdue.edu/hr/careerpathmaker/

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

Database Administrator, Senior
Purdue University

Key Responsibilities

MySQL Administration
Install, configure, and upgrade MySQL databases.
Manage security: roles, permissions, and access controls.
Monitor database performance and system health, proactively troubleshooting issues.

SQL Proficiency

Optimize SQL queries for maximum performance and efficiency.
Interpret and utilize execution plans to refine resource usage.

Backup & Recovery

Design and maintain automated backup strategies.
Perform and validate Point-in-Time Recovery (PITR).
Ensure disaster recovery plans are up-to-date and thoroughly tested.

Performance Tuning

Diagnose and resolve slow SQL queries.
Optimize data structures using advanced indexing (B-tree, GIN, GiST, etc.).
Linux/Unix System Administration
Automate system tasks with shell scripting.
Monitor system-level metrics and proactively identify bottlenecks.
Utilize systemd, crontab, and configure real-time alerts for key metrics (disk space, replication, query spikes).