MSSQL Database Administrator

#WeAreONEOK – Fortune 500 company. 100+ years in business. Leading midstream service provider. Safety first. Sustainable operations. Environmentally responsible. Employee focused.JOB SUMMARYSenior SQL Server Database AdministratorOur SQL Server environment is large and runs on servers throughout the organization. Bachelor’s Degree in Computer Science, MIS, or related field or Relevant work experience. 7+ years of hands-on experience with MS SQL Server Expertise in database design, implementation, optimization, replication, and security Familiarity with Active Directory using Groups and Service Accounts Strong understanding of T-SQL, SSRS, SSIS, stored procedures and linked servers Proficiency in troubleshooting and resolving database issues Performance Tuning of processes and applications Backup and Recovery Upgrading versions and applying CU’s and Service Pack as necessary Strong communication and interpersonal skills MSSQL versions 2012 -2022 Some Oracle experience is a bonus HA Clustering knowledge, Always On Experience Auditing database configuration and security configurations. Powershell scripting On Call Support The ability to work in a large database environment with many customers and applications Familiarity with SQL Licensing Ability to multi-task and prioritize workloads Strong attention to detail and accuracy Ability to work independently or in a team environment Proficient with SQL Management Studio, Enterprise Manager, Query Analyser, rescheduling jobs with SQL Server Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checksThis position is eligible for remote work in one of the following states: Arkansas, Colorado, Illinois, Indiana, Iowa, Kansas, Kentucky, Minnesota, Missouri, Montana, Nebraska, New Mexico, North Dakota, Oklahoma, South Dakota, Tennessee, Texas, Virginia, Wisconsin, or Wyoming. This position will require some travel for office meetings, as needed, to our corporate office in Tulsa, OK.Job Profile SummaryProvides 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 and/or Microsoft SQL Server database 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 and/or MS SQL Server

Utilizing Enterprise Manager and other management tools to maintain and tune both Oracle and/or MS SQL Server databases

Modifying stored procedures in a database server environment

Utilizing SQL, Windows Server and/or Unix 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 HRSolutions@ONEOK.com or call 1-855-663-6547​.Expected Salary Range$115,000.00 - $173,000.00ONEOK is a leading midstream service provider and owns one of the nation’s premier natural gas liquids systems, connecting NGL supply in the Mid-Continent, Permian and Rocky Mountain regions with key market centers and an extensive network of natural gas gathering, processing, storage and transportation assets.