Senior PostgreSQL DBA — On-Prem, Performance & Automation

O'Reilly Auto Parts; Springfield (MO); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Stock Purchase Plan

401k with Employer Contributions

Medical Insurance

Dental Insurance

Vision Insurance

Paid Time Off

Tuition Assistance

Career Growth

Job summary

O’Reilly Auto Parts is seeking a Database Administrator III to design, implement, and support databases, data warehouses, and data marts. Mentoring junior DBAs and ensuring security, backups, and performance are key responsibilities.

The role focuses on PostgreSQL in on-premises Linux environments with emphasis on optimization, automation, and governance, while aligning with organizational standards and DR plans.

Qualifications

• Bachelor’s degree in CS/IT or equivalent practical experience.
• 5+ years hands-on database administration in production environments.
• Strong PostgreSQL expertise in on-premises Linux environments.

Responsibilities

• Tune database performance and optimize SQL based on tests and user feedback.
• Drive standardization and automation for maintenance, deployments, and monitoring.
• Coordinate change management and ensure data integrity and standards.
• Implement security controls (RBAC, ACLs) and monitor logs for anomalies.
• Ensure backup, recovery, and DR procedures meet SLAs and test DR drills.
• Design database resource distribution and physical modeling for scalability.
• Gather requirements across teams to drive database improvements.
• Create runbooks and architecture diagrams; maintain documentation.
• Mentor junior DBAs and collaborate with cross-functional teams.
• Stay updated on database tech and compliance policies.

Skills

PostgreSQL administration

Database architecture

Performance tuning

Automation & scripting

HA & DR

Change management

Data analysis

Documentation

Mentoring

5+ years DBA experience

Education

Bachelor’s Degree in Computer Science or Information Technology

Tools

MySQL

Oracle

Microsoft SQL Server

Job description

O’Reilly Auto Parts is seeking a Database Administrator III to design, implement, and support databases, data warehouses, and data marts. Mentoring junior DBAs and ensuring security, backups, and performance are key responsibilities.

The role focuses on PostgreSQL in on-premises Linux environments with emphasis on optimization, automation, and governance, while aligning with organizational standards and DR plans.