Database Administrator III

ONEOK, Inc.; United States; On-site; USD 122,000 - 182,000; Full time

Job summary

ONEOK, Inc. is seeking an experienced database administrator to design, implement, and maintain Oracle database systems.

The role focuses on performance tuning, data integrity, security, and backup/recovery operations, collaborating with development and IT teams to meet business needs. The ideal candidate has extensive Oracle database experience in a corporate environment, strong SQL skills, and familiarity with management tools like Enterprise Manager.

Qualifications

• Bachelor's Degree in computer sciences or related field with relevant coursework and experience.
• Experience administering Oracle databases in a corporate environment.
• Proficiency with Oracle RDMBS design, tuning, and management tools.

Responsibilities

• Monitor and maintain databases for optimal performance and data integrity.
• Ensure data security and implement backups and recovery procedures.
• Design complex database schemas and coordinate with development teams on requirements.
• Prepare reports on system security, performance, and disk utilization.
• Modify stored procedures and manage multiple Oracle instances.

Skills

Database administration

Oracle databases

SQL performance tuning

Data security

Backup and recovery

Enterprise Manager

Education

Bachelor's Degree in Computer Sciences

Tools

Oracle RDBMS

Enterprise Manager

SQL*

Job description

#WeAreONEOK – Fortune 500 company. 100+ years in business. Leading midstream service provider. Safety first. Sustainable operations. Environmentally responsible. Employee focused.

JOB SUMMARY

This position is eligible for remote work in one of the following states: Arkansas, Colorado, Georgia, Illinois, Iowa, Kansas, Louisiana, Minnesota, Missouri, Montana, Nebraska, New Mexico, North Dakota, Oklahoma, South Dakota, Texas, Wisconsin, or Wyoming. This position will require some travel for office meetings, as needed, to our corporate office in Tulsa, OK.

Job Profile Summary

Provides advanced level database services including design, creation, and maintenance of database systems.

Essential Functions and Responsibilities

Monitor and maintain databases including but not limited to:

• Optimal database performance by tuning database parameters and settings
• Data integrity and reliability
• Data security
• Capacity planning
• Troubleshooting of performing SQL issues
• Ensures databases are properly backed up
• Design complex database schema and table structures for new development. Install and configure database packages
• Coordinate with development personnel and end users to resolve data conflicts and complicated performance problems
• Coordinate with technical and development personnel to identify requirements for new database design

Compile, calculate, analyze, and prepare information and reports related to databases including but not limited to:

• System security and event logs
• Performance monitoring reports
• Disk utilization reports
• Backup/recovery logs

Education

• Bachelor's Degree in computer sciences or other related field with previous experience or equivalent formal education to include a combination of such courses as programming languages (Visual Basic, C, C++, Java, PL/SQL, etc.) computers and society; computer organization; data structures and algorithm analysis; numerical analysis, file processing, database processing, and operating systems plus the following job-related experience:

Work Experience

Experience with all areas of administration of applicable database systems. Experience supporting Oracle databases in a corporate environment

Experience and/or training in use and function of database systems such as:

Designing and working with multiple instances of Oracle RDMBS

Utilizing Enterprise Manager and other management tools to maintain and tune Oracle databases

Modifying stored procedures in a database server environment

Experience in reading and interpreting company correspondence, reports, cost analyses, contracts, manuals, and computer printouts, and legal documents

Experience in regards to research, compose, and prepare reports, studies, recommendations, and correspondence applicable to position

Experience interacting and communicating effectively

Experience developing and presenting information to individuals and groups

Knowledge, Skills and Abilities

Knowledge of: relational database design including table structures, indexes, and primary/foreign key fields. Experience with problem resolution and technical troubleshooting skills

Ability to: apply math, algebra, and statistical and volumetric methods

Ability to: lead, train, coach, delegate and review work activities

Ability to: communicate and/or exchange written and verbal information and instructions

Licenses and Certifications

• None required

Strength Factor Rating - Physical Demands/Requirements

• Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time, but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Strength Factor Description - Physical Demands/Requirements

Standing: Remaining on one's feet in an upright position at a work station without moving about (Occasionally)

Walking: Moving about on foot (Frequently)

Sitting: Remaining in a seated position (Constantly)

Lifting: Raising or lowering an object from one level to another (includes upward pulling) (Occasionally)

Carrying: Transporting an object, usually holding it in the hands or arms, or on the shoulder (Occasionally)

Pushing: Exerting force upon an object so that the object moves away from the force (Occasionally)

Pulling: Exerting force upon an object so that the object moves toward the force (includes jerking) (Occasionally)

Climbing: Ladders, Stairs (Occasionally)

Balancing: Maintaining body equilibrium to prevent falling (Occasionally)

Stooping: Bending the body downward and forward by bending the spine at the waist (Occasionally)

Kneeling: Bending the legs at the knees to come to rest on the knee or knees (Occasionally)

Crouching: Bending the body downward and forward by bending the legs and spine (Occasionally)

Crawling: Moving about on the hands and arms in any direction (Occasionally)

Reaching: Extending hands and arms in any direction (Constantly)

Handling: Seizing, holding, grasping, turning or otherwise working with the hand or hands (Manual Dexterity) (Constantly)

Fingering: Picking, pinching or otherwise working with the fingers primarily (Finger Dexterity) (Constantly)

Feeling: Perceiving such attributes of objects/materials as size, shape, temperature, texture, movement or pulsation by receptors in the skin, particularly those of the finger tips (Constantly)

Talking: Expressing or exchanging ideas/information by means of the spoken word (Frequently)

Hearing: Perceiving the nature of sound by the ear (Frequently)

Tasting/Smelling: (Occasionally)

Near Vision: Clarity of vision at 20 inches or less (Constantly)

Far Vision: Clarity of vision at 20 feet for more (Frequently)

Depth Perception: Three-dimensional vision; ability to judge distances and spatial relationships so as to see objects where and as they actually are (Frequently)

Vision: Color - The ability to identify and distinguish colors (Constantly)

Working Conditions/Environment

• Employee is subject to inside environmental conditions

Working Conditions

Well lighted, climate controlled areas (Constantly)

Frequent repetitive motion (Constantly)

CRT (Computer Monitor(s)) (Constantly)

Travel

• Travel in and around office facilities system wide.

Driving

• Based on assigned tasks, employee may be assigned a company vehicle requiring the applicable driver's license

ONEOK is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, sex, pregnancy, sexual orientation, age, religion, creed, national origin, gender identity, disability, military/veteran status, genetic information or any other categories protected by applicable law.

The job description is not intended to be a complete list of all responsibilities, duties or skills required for the job and is subject to review and change at any time, with or without notice, in accordance with the needs of ONEOK.

ONEOK is committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to participate in the application and hiring process. To request an accommodation email [e-mail] or call 1-855-663-6547. #LI-Remote

Expected Salary Range

$122,000.00 - $182,000.00

At ONEOK (NYSE: OKE), we deliver energy products and services vital to an advancing world. We are a leading midstream operator that provides gathering, processing, fractionation, transportation, storage and marine export services. Through our approximately 60,000-mile pipeline network, we transport the natural gas, natural gas liquids (NGLs), refined products and crude oil that help meet domestic and international energy demand, contribute to energy security and provide safe, reliable and responsible energy solutions needed today and into the future. As one of the largest integrated energy infrastructure companies in North America, ONEOK is delivering energy that makes a difference in the lives of people in the U.S. and around the world.