BIS Database Administrator

Roan Resources, Inc. Oklahoma City , OK 73113

Posted 5 months ago

Overview

The Database Administrator is responsible for the design, implementation, efficiency and security of the company's database systems

Responsibilities

  • Serve as subject matter expert on SQL Server database technology and market trends.

  • Install and maintain DBMS software including patches, fixes, and version upgrades.

  • Responsible for daily monitoring and maintaining maximum performance of databases and identify poorly performing queries.

  • Responsible for maintaining and troubleshooting daily/nightly database backups and SQL Agent jobs

  • Make recommendations for improvements to security, scalability, and overall performance of SQL Server databases.

  • Document, plan and test Disaster Recovery procedures.

  • Implement data backup and recovery procedures to prevent data loss from any potential failure.

Qualifications


Required Education and

Qualifications:
  • High School diploma or G.E.D required. Bachelor's Degree in Management/Computer Information Systems, or similar field preferred.

  • Minimum of 2+ years of experience in Microsoft SQL Server DBMS & Windows operating systems

  • Minimum of 1 year of experience writing SQL Programing & hands on experience with database query, stored procedure and SQL performance tuning.

  • Experience with Microsoft SQL Server High Availability and Always On.

Knowledge, Skills and Abilities:

  • Propensity toward identifying and implementing on-going process improvement

  • Strong desire to learn new technologies.

  • Ability to manage and deploy application database modifications.

  • Ability to provide 24x7 on call support and work independently as needed.

  • Strong desire to learn new technologies.

  • Experience with Microsoft SQL Server Integration Services and SQL Server Reporting Services.

  • Experience with Audits of Microsoft SQL Server database environments

  • Experience setting up standards and guidelines for self-managed development teams

  • Experience supporting 24x7 production database systems

  • Experience with Idera/Redgate tools

  • Experience with Powershell is a plus

Benefits and Perks:

  • 100% company paid individual medical, dental, & vision insurance coverage

  • 401k + company match

  • Competitive total compensation package

  • Generous vacation policy

  • 11 company paid holidays

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Administration Analyst
New!

Two95 International Inc.

Posted Today

VIEW JOBS 10/16/2019 12:00:00 AM 2020-01-14T00:00 <p><strong>Title – </strong><strong>Database Administration Analyst</strong></p><p></p> <p></p> <p><strong>Position – (Full Time)</strong></p> <p><strong>Location –</strong> <strong>Oklahoma City OK</strong></p> <p><strong>Salary –($Open) </strong></p><p><strong>Requirements</strong></p><p>Provide database support and implementation for enterprise applications running in a MYSQL/Windows Server environment. Collaborate with QA and Development teams in design, testing and implementation of database changes. Track and resolve database related incidents related to performance, capacity limitations, and replication. Maintain policies and procedures to ensure security and integrity of the database. Maintain documentation describing processes, procedures, and database models.</p> <p></p> <p><strong>RESPONSIBILITIES:</strong></p> <p>§ Troubleshoot database server service outages as they occur, including after-hours and weekends.</p> <p>§ Build, maintain, and validate deployment packages for database change scripts</p> <p>§ Document changes to the database environment.</p> <p>§ Review new database code to ensure it meets standards for reliability and performance.</p> <p>§ Coordinate and communicate activities related to service disruption in all environments.</p> <p>§ Document database standards and provide training to ensure compliance.</p> <p>§ Produce and maintain documentation as required. This includes process maps, data models, training materials, user manuals and other system documentation.</p> <p>§ Provide support for enterprise systems.</p> <p>§ Provide on-call support for our environments after hours and on weekends as required.</p> <p>§ Participate in ticket resolution activities for database environments and systems.</p> <p>§ Perform other duties as assigned.</p> <p>Qualifications</p> <p>§ Bachelor Degree in technical field or another field with 2 years related work experience.</p> <p>§ Experience as database analyst or database development.</p> <p>§ Experience configuring and troubleshooting applications and databases in a networked environment.</p> <p>§ Experience with Windows Server OS is a plus.</p> <p>§ Experience in performance tuning and query optimization a plus.</p> <p>§ Ability to write and troubleshoot SQL code and design (stored procedures, indexes, triggers, constraints, etc.)</p> <p>§ Experience in designing database architecture as part of a software design process.</p> <p>§ Working knowledge of indexes, integrity checks, server configuration and patching methods.</p> <p><strong>SKILLS AND ABILITIES:</strong></p> <p>§ Must have the willingness to learn new systems and transition to a MYSQL/Windows environment.</p> <p>§ Must have the ability to learn business processes and system relationships.</p> <p>§ Must have superb troubleshooting skills and the ability to be analytical and decisive.</p> <p>§ Must have the ability to write clear instructions for end users and other members of the database team.</p> <p>§ Must be willing to work a flexible schedule as needed</p> <p>§ Ability to communicate effectively is critical.</p> <p>§ Maintain effective working relationships in a team-focused environment.</p><p><strong>Benefits</strong></p><p><strong>Note:</strong> If interested please send your updated resume to <strong><a href="mailto:Santhosh.sampath@two95intl.com" rel="nofollow noreferrer noopener" class="external">Santhosh.sampath@two95intl.com</a></strong> and include your rate requirement along with your contact details with a suitable time when we can reach you. If you know of anyone in your sphere of contacts, who would be a perfect match for this job then, we would appreciate if you can forward this posting to them with a copy to us.</p><p>We look forward to hearing from you at the earliest!</p> Two95 International Inc. Oklahoma City OK

BIS Database Administrator

Roan Resources, Inc.