A Database Administrator II is responsible for the performance, integrity, and security of PostgreSQL databases to support the organization’s computing environment. Under direct supervision, the Database Administrator II will work through project-related activities as well as day-to-day operational tasks related to PostgreSQL systems in on-prem, cloud, and hybrid environments.

Essential Job Functions

Install, configure, patch, and upgrade PostgreSQL databases (version 11 and above) in on-prem and cloud environments (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).

Monitor and optimize database performance; write, debug, and tune complex SQL and PL/pgSQL queries.

Manage and test backup and disaster recovery strategies using native PostgreSQL tools (pg_dump, pg_basebackup, WAL archiving, etc.) and cloud-native services.

Configure and support high availability and replication solutions (e.g., streaming replication, logical replication, Patroni, pgPool-II).

Participate in weekly rotating on-call shifts and respond to alerts, incidents, and outages in real time.

Perform after-hours maintenance activities and support application code deployments during nights and weekends as needed.

Use a ticketing system (e.g., Jira, ServiceNow) to manage and prioritize tasks.

Use version control systems (e.g., Git, Bitbucket) to maintain and deploy database code, schemas, and scripts.

Collaborate with development, operations, and infrastructure teams to provide database expertise and ensure system stability.

Be open to learning and supporting additional RDBMS platforms (e.g., MySQL, Oracle, SQL Server) as needed.

Required Qualifications:

Proven experience as a DBA supporting PostgreSQL (11 and above) in enterprise environments.

Strong SQL and PL/pgSQL skills with experience debugging, tuning, and planning rollbacks.

Experience with PostgreSQL backup and recovery, replication, and high availability architectures.

Familiarity with connection pooling and resource management (e.g., pgBouncer, pgPool-II).

Ability to handle multiple tasks simultaneously and efficiently context switch in a fast-paced setting.

Comfortable working independently and proactively engaging in team activities.

Willingness to work on-call and during off-hours for critical support and maintenance windows.

Experience using ticketing and version control systems.

Skills/Education/Knowledge/Experience/Abilities

Required:

College degree or equivalent experience

5+ years of database administration experience with PostgreSQL

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.