Work in Iowa Manufacturing Jobs

Job Information

TKC Holdings Senior Database Administrator - ATG in WEST DES MOINES, Iowa

Are you looking for a career with premium benefits and the potential for growth? ​

At Advances Technologies Group, 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. ​

The Senior Database Administrator independently manages large mission critical databases hosting data for ATG software. Additionally, this role supports 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. This positions works directly with customers under the guidance of team leadership to determine necessary database servers configuration changes.

Tasks may include, but are not limited to the following:

  • Track performance metrics of every database administered by ATG team; includes reviewing processor, memory and hard disk usage, etc.

  • For issues identified, present corrective action plan to team management

  • Independently identify and optimize queries that are either consuming more resources than expected

  • Proactively manage tables and index fragmentation

  • Respond to notification (email/pages) from utilities monitoring key metrics of database servers. Be able to independently handle issues

  • Complete projects within time estimates with minimal returned work

  • Keep supervisor informed on progress of projects

  • Seek information to update technical skills and business knowledge

  • Assist developers and other DBAs to troubleshoot complex queries and store procedures

  • Write and troubleshoot scripts that automate routine database maintenance tasks such as backups, index and table rebuild, etc.

  • Independently maintain and execute scripts that implement required database updates to support the update of new versions of ATG applications

  • Bachelor's degree from four-year college or university plus five to ten years of progressive work experience in the field; or equivalent combination of education and experience

  • Deep knowledge of relational database structure concepts -- table normalization, type and use of indexes, and record/page locking, etc.

  • Expertise in using server's key components (processor, memory, and disk) metrics to identity bottlenecks and improve database performance

  • Analyze database engine statistics to identify potential bottlenecks, then make database change recommendations to resolve database inefficiency

  • Working knowledge of Shell Scripting - PowerShell

  • Ability to successfully pass pre-employment (post offer) Company or Facility background check and drug screening

Advanced Technologies Group (ATG), 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 you

ATG 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.

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.

Requisition ID: 2021-5026

Company: Advanced Technologies Group, LLC - 894IZ

External Company Name: TKC Holdings

External Company URL: https://www.tkcholdings.com/

Street: 1601 48TH ST., SUITE 220

Telecommute: No

DirectEmployers