Teradata Database Administrator DBA

Eversoft Technologies LLC

Sacramento, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Amazon Web Services JIRA Microsoft Azure Cloud Computing Databases Extract Transform Load (ETL) Data Warehousing Disaster Recovery Monitoring of Systems Python (Programming Language) Parsing Query Optimization

+5 more

SQL Databases Teradata SQL Scripting System Availability Servicenow

Job description

· Install, configure, and maintain Teradata databases and related infrastructure · Monitor system performance, query optimization, and workload management (TASM/TIWM) · Manage space, user access, roles, and security profiles · Support backup, restore, and disaster recovery operations (ARC/BAR) · Collaborate with developers and data teams to tune SQL and data models · Handle database upgrades, patching, and migrations · Troubleshoot production issues and ensure high availability

Requirements

· Strong expertise in Teradata SQL, BTEQ, FastLoad, MultiLoad, TPT · Experience with Teradata utilities: ViewPoint, Teradata Studio, TDCH · Knowledge of Teradata architecture (nodes, AMPs, PEs, parsing engines) · Familiarity with Unix/Linux and scripting (Shell/Python) · Understanding of ETL pipelines and data warehousing concepts Good to Have: · Teradata Vantage experience · Cloud platforms (AWS, Azure) with Teradata on cloud · ITIL / ticketing tools (ServiceNow, Jira) · Medicaid knowledge