Demo

Database Administrator II

Paycom
Oklahoma, OK Full Time
POSTED ON 1/10/2025
AVAILABLE BEFORE 4/9/2025

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. Provide guidance and mentoring to junior database professionals.

RESPONSIBILITIES

  • Troubleshoot database server service outages as they occur, including after-hours and weekends.
  • Build, maintain, and validate deployment packages for database change scripts
  • Document changes to the database environment.
  • Review new database code to ensure it meets standards for reliability and performance.
  • Coordinate and communicate activities related to service disruption in all environments.
  • Document database standards and provide training to ensure compliance.
  • Produce and maintain documentation as required. This includes process maps, data models, training materials, user manuals and other system documentation.
  • Provide support for enterprise systems.
  • Provide on-call support for our environments after hours and on weekends as required.
  • Review database administration processes, technologies, software, and tools and recommend improvements.
  • Participate in ticket resolution activities for database environments and systems.
  • Provide critical problem resolution for live environments.
  • Perform other duties as assigned.

Qualifications

Education / Certification :

  • Bachelor Degree.
  • Experience :

  • 2 years' experience with database analysis or database development.
  • 2 years' experience configuring and troubleshooting applications and databases in a networked environment.
  • 2 years' experience troubleshooting various database issues (locking, replication, logging, connectivity, etc.)
  • 2 years' experience with performance tuning and query optimization a plus.
  • 2 years' experience administering backups, restores, recovery models, clustering, mirroring, and replication.
  • General understanding of database concepts.
  • Ability to perform well under minimal supervision from Team Lead and Supervisor of Database.
  • Can provide coaching and mentoring to junior team members.
  • Ability to write and troubleshoot SQL code and design (stored procedures, indexes, triggers, constraints, etc.)
  • Experience in designing database architecture as part of a software design process.
  • Deep knowledge of indexes, integrity checks, server configuration and patching methods.
  • Skills / Abilities :

  • Must have the willingness to learn new systems and transition to a MYSQL / Windows environment.
  • Must have the ability to learn business processes and system relationships.
  • Must have superb troubleshooting skills and the ability to be analytical and decisive.
  • Must have the ability to write clear instructions for end users and other members of the database team.
  • Must be willing to work a flexible schedule as needed.
  • Ability to communicate effectively is critical.
  • Maintain effective working relationships in a team-focused environment.
  • Paycom is an equal opportunity employer and prohibits discrimination and harassment of any kind. Paycom makes employment decisions on the basis of business needs, job requirements, individual qualifications and merit. Paycom wants to have the best available people in every job. Therefore, Paycom does not permit its employees to harass, discriminate or retaliate against other employees or applicants because of race, color, religion, sex, sexual orientation, gender identity, pregnancy, national origin, military and veteran status, age, physical or mental disability, genetic characteristic, reproductive health decisions, family or parental status or any other consideration made unlawful by applicable laws. Equal employment opportunity will be extended to all persons in all aspects of the employer-employee relationship. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation benefits, and separation of employment. The Human Resources Department has overall responsibility for this policy and maintains reporting and monitoring procedures. Any questions or concerns should be referred to the Human Resources Department.

  • To learn more about Paycom's affirmative action policy, equal employment opportunity, or to request an accommodation - Click on the link to find more information : paycom.com / careers / eeoc
  • LI-Hybrid

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Database Administrator II?

    Sign up to receive alerts about other jobs on the Database Administrator II career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $130,034 - $179,473
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099

    Sign up to receive alerts about other jobs with skills like those required for the Database Administrator II.

    Click the checkbox next to the jobs that you are interested in.

    • Backup/Recovery Skill

      • Income Estimation: $85,059 - $120,527
      • Income Estimation: $101,597 - $131,824
    • Change Data Capture Skill

      • Income Estimation: $96,598 - $126,350
      • Income Estimation: $115,719 - $153,093
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Paycom

    Paycom
    Hired Organization Address Oklahoma, OK Full Time
    Job Details Level Experienced Job Location OKC Outside Sales Office - Oklahoma City, OK Position Type Full Time Educatio...
    Paycom
    Hired Organization Address Atlanta, GA Full Time
    Job Details Level Experienced Job Location Atlanta Buckhead Office - Atlanta, GA Position Type Full Time Education Level...
    Paycom
    Hired Organization Address Charlotte, NC Full Time
    Job Details Level Experienced Job Location Charlotte Office - Charlotte, NC Position Type Full Time Education Level Bach...
    Paycom
    Hired Organization Address Providence, RI Full Time
    Job Details Level Experienced Job Location Providence - Providence, RI Position Type Full Time Education Level Bachelor'...

    Not the job you're looking for? Here are some other Database Administrator II jobs in the Oklahoma, OK area that may be a better fit.

    Database Administrator II

    Love's, Oklahoma, OK

    Database Administrator II

    Love's Travel Stops, Oklahoma, OK

    AI Assistant is available now!

    Feel free to start your new journey!