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:
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