Database Administrator - Hybrid
XPO Logistics, Inc.
Rock Hill, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Rock Hill, United States of America
Tech stack
Software Applications
Databases
Continuous Integration
Linux
IT Management
Oracle
Oracle Applications
Oracle SQL Developer
Performance Tuning
Application Data
Shell Script
PL-SQL
SQL Databases
Database Performance
Sql Tuning
Job description
- 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
Requirements
- Bachelor's degree
- 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
Preferred qualifications:
- 4+ years of experience with database administration within Oracle
- Deep knowledge/experience in the following: SQL, PL/SQL and Oracle DBA tasks
- Able to stay current with emerging trends and database technologies
- Able to quickly learn and achieve proficiency in new software applications and maintain a thorough knowledge of internal company software applications applicable to the position/business unit
- Oracle Database Certification
- Oracle Advanced Queues knowledge
- Data modeling skills and use of Entity-Relation (ER)
Benefits & conditions
Pulled from the full job description Health insurance 401(k) matching Paid time off Disability insurance Paid holidays, * Competitive compensation package
- Full health insurance benefits are available on day one
- Life and disability insurance
- Earn up to 15 days of PTO over your first year
- 9 paid company holidays
- 401(k) option with company match
- Education assistance
- Opportunity to participate in a company incentive plan
About the company
XPO is a top ten global provider of transportation services, with a highly integrated network of people, technology and physical assets. At XPO, we look for employees who like a challenge and can communicate effectively in all situations. We want to leverage your skills and years of experience to drive positive results while ensuring a bright future for yourself and XPO. If you're looking for a growth opportunity, join us at XPO.