O

O'Reilly Auto Parts

Automotive parts retailer with nationwide stores

Database Administrator 3 - PostgreSQL

Database AdministrationConfirmed live in the last 24 hours
Full-timeSpringfield, MO, USA

About the Job

Requirements

  • Strong hands-on administration, configuration, maintenance, and performance tuning experience in PostgreSQL within enterprise on-premises and Linux-based environments.
  • Proven track record managing physical database design, index optimization, query tuning, and storage allocation in mission-critical production environments.
  • Demonstrated ability to build automation scripts and workflows to streamline routine database administration tasks and deployments.
  • Deep working knowledge of backup and restore strategies, replication, clustering, failover mechanisms, and service-level-agreement-driven recovery procedures.
  • Strong understanding of change management frameworks, system protocols, and data governance standards.
  • Ability to analyze operational trends from database telemetry, monitoring systems, and reporting tools to drive informed capacity planning and infrastructure decisions.
  • Ability to manage complex technical issues with minimal supervision and maintain composure under pressure.
  • Bachelor’s degree in Computer Science, Information Technology, or equivalent practical experience.
  • Five or more years of hands-on database administration experience managing enterprise production environments.

Responsibilities

  • Design, implement, and support databases, data warehouses, and data marts.
  • Perform physical database design, performance tuning and optimization, data dictionary management, backup and disaster recovery execution, routine queries and updates, and security enforcement.
  • Support critical interfaces between core business applications and back-end database systems.
  • Perform database and SQL tuning based on application software tests and user feedback; monitor, diagnose, and resolve performance bottlenecks and system faults to ensure optimal uptime.
  • Drive standardization across database environments and develop and implement automation for routine maintenance tasks, deployments, and database monitoring.
  • Align database work with organizational change management processes and established protocols; contribute to the review and approval of database specifications to preserve data integrity, architecture standards, and compliance.
  • Implement and maintain security controls, including role-based access control, access control lists, and audit logging; monitor access and performance logs to detect anomalies and escalate security issues.
  • Ensure databases are recoverable in compliance with established service-level agreements; monitor and test backup and recovery procedures, and participate in disaster recovery exercises.
  • Design the distribution of database resources and provide physical modeling and design services to tune database applications for performance and scalability.
  • Gather technical and business requirements across cross-functional teams and translate user goals into database enhancements; research emerging database technologies and best practices to improve infrastructure reliability.
  • Create and maintain technical runbooks, architecture diagrams, and operational documentation in alignment with organizational standards.
  • Mentor junior database administrators and collaborate across engineering teams and with internal stakeholders.
  • Maintain knowledge of database technologies, security regulations, and organizational codes of conduct; ensure alignment with compliance policies.

Desired Qualifications

  • Experience supporting other enterprise relational database systems, specifically MySQL, Oracle, and Microsoft SQL Server.
  • Relevant professional accreditations or cloud database certifications, such as AWS RDS/Aurora, Google Cloud SQL, or Azure SQL.

About the Company

O'Reilly Auto Parts

Automotive parts retailer with nationwide stores

O'Reilly Auto Parts runs a large network of auto parts retail stores and distribution centers, selling automotive parts and supplies to retail customers and professional installers. It stocks a wide range of parts and related items and helps customers choose the right parts with knowledgeable staff and efficient service. The company differentiates itself through its nationwide store footprint, emphasis on customer service, and a culture focused on growth and development, aiming to be the dominant supplier in its markets by offering the best price, quality, and service. Its goal is to become the leading auto parts supplier in its market areas by delivering strong prices, quality parts, and high levels of service.

Company size
10,001+
Company stage
IPO
Headquarters
Springfield, IL
Founded
1957

Recently Posted Jobs

Explore more opportunities at O'Reilly Auto Parts

See more jobs