Database Administrator I

A Database Administrator I, is responsible for the performance, integrity and security of the databases to support the computing environment. Under direct supervision, a Database Administrator I will work through day-to-day operational tasks related to the database systems.    

ESSENTIAL JOB FUNCTIONS

• Administer, support, and optimize on-premise PostgreSQL databases (version 9 and above).

• Manage high availability configurations, backups, installations, and upgrades.

• Write and debug complex SQL queries and scripts; develop rollback and contingency plans.

• Work with connection poolers such as PgBouncer and Pgpool to improve application-database efficiency.

• Respond to and resolve production issues during scheduled on-call shifts.

• Perform maintenance activities and support code deployments during off-hours (nights/weekends as needed).

• Track and manage tasks using a formal ticketing system.

• Maintain database code, scripts, and configuration in a version control system (e.g., Git, Bitbucket).

• Learn and support other RDBMS platforms as needed (MySQL, Oracle, MS SQL).

• Collaborate and communicate effectively with team members and stakeholders.

• Support a culture of continuous improvement and uphold company values in all interactions.

Required Qualifications:

• Hands-on experience with PostgreSQL in on-prem environments (v9+).

• Strong SQL skills and proficiency in troubleshooting, tuning, and rollback planning.

• Experience with high availability setups and disaster recovery strategies.

• Familiarity with database connection poolers (e.g., PgBouncer, Pgpool).

• Comfortable working independently and capable of managing frequent context switching.

• Experience working with ticketing systems for task tracking and prioritization.

• Proficiency in version control systems (Git, Bitbucket, etc.).

• Availability for weekly rotating on-call duty and off-hours maintenance support.

• Strong teamwork orientation and willingness to support peers.

SKILLS/EDUCATION/KNOWLEDGE/EXPERIENCE/ABILITIES

Required:

College degree or equivalent experience

3-5 years system administration experience, or application development experience

0-2 years database administration experience

Exceptional problem-solving skills

Above average oral and written communications skills

Willingness to work flexible schedule including nights/weekends

Must work well in a team environment

Must be able to learn independently

O’Reilly Auto Parts has a proven track record of growth and stability. O’Reilly is full of successful career stories and believes in a strong promote-from-within philosophy, encouraging you to grow your career along with the organization. 

Total Compensation Package:

• Competitive Wages & Paid Time Off

• Stock Purchase Plan & 401k with Employer Contributions Starting Day One

• Medical, Dental, & Vision Insurance with Optional Flexible Spending Account (FSA)

• Team Member Health/Wellbeing Programs

• Tuition Educational Assistance Programs

• Opportunities for Career Growth

O’Reilly Auto Parts is an equal opportunity employer. The Company does not discriminate on the basis of race, religion, color, national origin or ancestry (including immigration status or citizenship), sex, sexual orientation, gender identity, pregnancy (including childbirth, lactation, and related medical conditions,) age (40 and over), veteran status, uniformed service member status, physical or mental disability, genetic information (including testing or characteristics) or another protected status as defined by local, state, or federal law, as applicable.

Qualified individuals with a disability may be entitled to reasonable accommodation under the Americans with Disabilities Act. If you require a reasonable accommodation during the application or employment process, please send an email to: rar@oreillyauto.com or call 417-862-2674, ext. 68901, and provide your requested accommodation, and position details.