Job Type



10 days ago


Springfield, IL


Senior Teradata Database Administrator

Springfield, IL

Direct Hire


Primary Responsibilities:

  • Creating, maintaining, and supporting Teradata architectural environment
  • Working with creation of databases, tables, views, users, and granting them access
  • Working with the development teams with design, implementation, and performance tuning of new and existing applications
  • Performing database backup and recovery operations
  • Developing of pro-active processes for monitoring capacity and performance tuning
  • Supporting the application development teams for database needs and guidance
  • Providing day to day support for the EDW users problems like job hands, slowdowns, inconsistent rows, re-validating headers for tables with RI constraints, PPIs and configuration
  • Supporting Teradata patch and upgrades collaborating with Teradata team and interfacing with the application sub vendors
  • Supporting backup and restore/retrieval process – using the BAR DSA and NetBackup. Create, implement, and maintain BAR strategy for the Teradata (TD) application and system databases
  • Maintaining rules set in TASM and supporting workload management. Maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels
  • Supporting the database system and application server support for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance as needed
  • Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools and application servers and make preventive or corrective actions as needed
  • Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage, security administration etc.
  • Coordinating with the team and customers in supporting database needs and make necessary changes to meet the business, contractual, security, performance, and reporting needs
  • Supporting internal or external audit process and address vulnerabilities or risk proactively. Prepare and support IRS audit
  • Coordinating with Teradata to perform Teradata system hardening and delivery SCSEM Reports as needed addressing issues in the hardening and vulnerability scan report
  • Generating and maintaining capacity management, Space, and CPU reports on analyzing the Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance and growth requirements
  • Reviewing and resolving Teradata alerts and communicate any risk / issues or impact to the management, team, and business users through appropriate communication strategy
  • Creating Teradata incident on issues, tracking using TAYS, setting appropriate priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
  • Performing additional duties that are normally associated with this position, as assigned


Required Qualifications:

  • Bachelor’s degree or equivalent work experience
  • 5+ years of experience as a Teradata DBA on Version 14+
  • 5+ years of SQL experience
  • 3+ years ETL using Teradata Utilities in a Unix/Linux environment
  • 3+ years performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
  • 3+ years analyzing project requirements and developing detailed database specifications
  • 3+ years identifying and initiating resolutions to customer problems and concerns associated with a
  • Data Warehouse or equivalent system


Preferred Qualifications:

  • 3+ years identifying and initiating resolutions to customer problems and concerns associated with a Data Warehouse or equivalent system
  • 5+ years logical and physical data modeling experience
  • 5+ years with Erwin or other data modeling software
  • 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs
  • 3+ years working with technical developers to strategize solutions to align with business requirements
  • 3+ years defining standards and best practices and conducting code reviews
  • Experience in Application Server Hardware/Software Administration (Windows/Linux)
  • Experience with State Medicaid / Medicare / Healthcare applications
  • Experience in SharePoint
  • Knowledge in ETL process, Unix, and Windows Scripting /
  • Knowledge/Experience in Agile
  • Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills
  • Ability to proactively learn and support overall system administration, support hardware/software maintenance, and leading data management activities
  • Training developers in how best to design queries for a specific database
  • Working with lead / management, business users, SMEs/BA, developers, application administrators, architect/modelers, and coordinating with hardware / software sub vendors
  • Installing, configuring and administering Microsoft SQL Server on Windows Server
  • Performing application servers backups and recovery using Veritas Backup Exec 2012/above
  • Analyzing IBM Tivoli logs and responds to alerts and errors
  • Monitoring of SAN storage with the knowledge and ability to react to alerts and errors
  • Configuring and managing HP MSA Storage arrays
  • Installing, configuring and administering Windows Server 2008 R2 or higher platforms on HP DLT
  • Servers