Oracle DB Administrator | Hybrid | Performance & Automation

XPO; Portland (OR); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health insurance

PTO 15 days first year

9 company holidays

401(k) with company match

Education assistance

Incentive plan

Job summary

XPO is seeking a Database Administrator to manage Oracle databases, optimize SQL performance, and implement PL/SQL automation in a Unix/Linux environment. You will collaborate with infrastructure and development teams, deploying new schemas and maintaining database objects while upholding best practices.

Ideal candidates have strong Oracle SQL/PL/SQL skills, Linux scripting ability, and familiarity with CI/CD concepts.

Qualifications

• Bachelor's degree required.
• 2 years of database administration experience with Oracle Server.
• Expertise in Oracle technologies, OCI, Exadata experience, Familiarity with monitoring tools like OEM.
• Strong proficiency with SQL, Oracle partitioning, and knowledge of Oracle PL/SQL (2+ years).
• Experience with Linux and shell scripting.
• Experience with monitoring SQL performance and tuning (plan, baselines, profiles).
• Experience developing PL/SQL Procedures/Packages and automation.
• Experience managing the deployment of DDL/DMLs to the database.
• Experience with CICD concepts.
• Ability to assist application developers with SQL review.

Responsibilities

• Work extensively with Oracle databases.
• Focus on SQL queries, plan review, and database administration.
• Be responsible for daily monitoring of SQLs performance, up-time and drive resolution to technical issues.
• Support database performance in the context of applications by working with the infrastructure and application teams
• Act as a liaison between the project management, technical teams and IT leadership; assure best practices are defined and followed; drive consistency across applications and projects wherever possible
• Support deployment of new databases, new schemas and new database objects and ongoing maintenance of the same
• Contribute to defining application database standards by creating application data models

Skills

Oracle SQL

PL/SQL

Linux

Shell scripting

SQL tuning

CI/CD concepts

SQL review support

Education

Bachelor's degree

Tools

OEM

OCI

Exadata

Job description

XPO is seeking a Database Administrator to manage Oracle databases, optimize SQL performance, and implement PL/SQL automation in a Unix/Linux environment. You will collaborate with infrastructure and development teams, deploying new schemas and maintaining database objects while upholding best practices.

Ideal candidates have strong Oracle SQL/PL/SQL skills, Linux scripting ability, and familiarity with CI/CD concepts.