Job Description :

Senior Teradata Database Administrator

Location: Springfield, IL (Hybrid/Remote)

Job Description

This role requires regular onsite presence in Springfield, Illinois to perform backup/restore and support onsite maintenance by Teradata (and its subcontractors). The candidate must be willing to relocate to the Springfield Illinois area.

Must-Haves:

  1. Proven experience of at least 7+ years as primary/lead Teradata DBA
  2. 7+ years of experience as a Teradata DBA on Version 15+
  3. 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio
  4. 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment

Job Requirements:

  • Bachelor's degree or equivalent work experience
  • Proven experience of at least 7+ years as primary/lead Teradata DBA
  • 7+ years of experience as a Teradata DBA on Version 15+
  • Previous experience leading Teradata major upgrade/floor sweep
  • 3+ years of experience with Teradata 6800/1800 system or IntelliFlex
  • 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio
  • 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment
  • 3+ years of experience performance tuning in a large database (?5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
  • 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates
  • 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 Location required is Springfield, IL area

Preferred Skills:

  • Teradata Vantage Certified Master
  • Experience upgrading to Teradata Intelliflex
  • 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
  • 3+ years maintaining and creating models using OpenText BI-Query
  • 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.

Required Skills : *Must-Haves: Proven experience of at least 7+ years as primary/lead Teradata DBA 7+ years of experience as a Teradata DBA on Version 15+ 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment
Basic Qualification :
Additional Skills : Location: 100% Remote but local to Springfield, IL (Candidate must be willing to travel onsite as needed within a 2-hour notice
Background Check :Yes
Drug Screen :Yes
Notes :*Must-Haves: 1. local/near Springfield IL (2 hours away, no travel cost would be covered). Regular onsite customer meetings, supports software/hardware maintenance on site 2. Standard DBA + system DBA and application DBA (queries, primary communication) make sure runs efficiently 3. Communication - will be speaking and writing to the customer directly, very important, where previous gaps have lied.
Selling points for candidate : Location: 100% Remote but local to Springfield, IL (Candidate must be willing to travel onsite as needed within a 2-hour notice
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship :Yes
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Misc: Technical
Branch Code :Chicago