Database Administrator III

Remote

Full time

R8526

#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

• Disk space management

• 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

• Database dump scripts

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

• Utilizing SQL, Linux administrative skills

• 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 View email address on click.appcast.io or call View phone number on click.appcast.io?. #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.