Teradata DBA

Senior Teradata Database Administrator (DBA)

Rate: Depending on experience

Located in Springfield, IL area is preferred.

Required Qualifications:

• Bachelor’s degree or equivalent work experience

• Proven experience of at least 7+ years as primary/lead on-premises Teradata DBA including:

• 7+ years of experience as a Teradata DBA on Version 15+ and
• 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio and
• 3+ years of experience with Teradata IntelliFlex and
• 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment and
• 3+ years of experience performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans or
• 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates or
• 3+ years of experience identifying and initiating resolutions to customer facing problems and concerns associated with a query or database related business need.

• Data warehouse or equivalent system experience

• Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills

Preferred Qualifications:

• 5+ years logical and physical data modeling experience using ERWIN or other data modeling tool

• 2+ Years of Snowflake Application Database Administration

• 3+ Years of experience as ETL/Informatica Development

• 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

• Experience working with project teams in metadata management, data/IT governance, business continuity plan, data security

• Experience in Application Server Hardware/Software Administration (Windows/Linux)

• Experience with State Medicaid / Medicare / Healthcare applications

• Experience working in matrix organization as an effective team player

• Experience working in agile environment such as Scrum framework and iterative/incremental delivery/release. Experience in tools like DevOps, GitHub will be a plus.

• Experience working in large Design Development and Implementation (DDI) projects

Primary Responsibilities:

• Manage, monitor, and maintain OnPrem Teradata hardware/software including patches,
  replacements, and upgrades with support from Teradata.
  
• Plan and execute tasks required to ensure the Teradata system is operational including
  occasional evening and weekend support for Teradata maintenance.
  
• Provide direction to developers on Operational and Design, Development, and Implementation
  projects to ensure best use of the Teradata system including review/approval of database
  components (such as tables, views, SQL code, stored procedures).
  
• Performing database backup and recovery operations – using the BAR DSA and NetBackup.
  
• Developing of pro-active processes for monitoring capacity and performance tuning.
  
• 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.
  
• Maintaining rules set in the Teradata Active System Management (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,
  and 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 and internal audit including coordinating with Teradata to perform
  
• Teradata system hardening and delivery of Safeguard Computer Security Evaluation Matrix
  (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.
  
• Effectively reporting status, future roadmap, proactive process improvements, automation,
  mitigation strategies, and compensating controls to the management and clients.
  
• Leading database or data related meetings and projects/activities delivering quality deliverables
  with minimal supervision/direction.
  
• Sharing knowledge, coaching/mentoring other members in the team for backups.
  
• Performing additional duties that are normally associated with this position, as assigned.
  
• Responsible for front-end tool (OpenText Bi-Query) and model maintenance and administration.