Database Administrator - ATG

Company: TKC Holdings
Location: West Des Moines
Posted on: January 13, 2022

Job Description:

Overview:Are you looking for a career with premium benefits and the potential for growth?
At Advanced Technologies Group, a TKC Holdings Company, we've created something special, a better place to work and grow. Many employees start just expecting a paycheck but end up with a rewarding career. We provide exceptional training and a clear career path.About This Position:The Database Administrator assists with managing large mission critical databases hosting data for ATG software while supporting ATG developers as they create and update the offender Management Suite of programs; this would include optimizing queries and performing tasks needed to update databases to support new versions of the applications.
Essential functions include, but are not limited to the following:

• Tracking performance metrics of every database administered by the ATG team; includes reviewing processor, memory and hard disk usage, etc.
• Assisting in identifying queries that need to be optimized, and help optimizing the same
• Assisting management in proactively managing tables and index fragmentation
• Responding to notification (email/pages) from utilities monitoring key metrics of database servers while working towards being able to handle these issues independently
• Completing projects within time estimates with minimal returned work and keep supervisor informed on progress of all projects
• Seeking information to update technical skills and business knowledgeWhat You'll Need:
  • Bachelor's degree (B. A.) from four-year college or university; or three years progressive work experience in the field; or equivalent combination of education and experience
  • Working knowledge of relational database structure concepts - table normalization, type and use of indexes, and record/page locking, etc.
  • Ability to independently design queries that can select, insert, update and delete records using SQL
  • Ability to independently confirm successful completion of scripts that automate routine database maintenance tasks such as backups, index and table rebuilds, etc.
  • Under guidance of management, ability to perform script maintenance and complete required database updates to support the update of new versions of ATG applications
  • Working knowledge of how metrics of the server's key components (processor, memory and disk) affect database performance and identify potential bottlenecks
  • Working knowledge of Shell Scripting - PowerShell
  • Ability to successfully pass pre-employment (post offer) Company or Facility background check and drug screeningBenefits:Advanced Technologies Group (ATG), a TKC Holdings Company, offers comprehensive benefits to all regular-full time employees. ATG offers a variety of medical plans with:
    • Prescription coverage
    • Vision
    • Dental
    • Life Insurance
    • Short Term and Long Term Disability
    • Many more benefits that can be selected to create the right package for youATG also understands the importance of work life balance and planning for the future. To help with both of these, employees are eligible for paid time off and a Company Match for the 401(k) Retirement Savings Plan.EEO Statement:We are proud to be an EEO/AA employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

Keywords: TKC Holdings, West Des Moines , Database Administrator - ATG, IT / Software / Systems , West Des Moines, Iowa