Teradata DBA

3 years of Teradata DBA experience & Experience with Netezza is a plus
Contract Corp-To-Corp, Contract Independent, Contract W2, C2H W2, Part Time, 18 Months
Depends On Experience
Telecommuting not available Travel not required

Job Description

 

 * GC, CITIZEN, EAD's and candidates who're authorized to work in the United States are encouraged to apply*

 

Job Title: Teradata DBA

Location: Columbus, OH

Duration: 18 months

 

Job Description:

This team provides database administration support for developers and infrastructure engineers.  Candidate should have at least  3 years of Teradata DBA experience. Experience with Netezza is a plus.  Start date would be as soon as possible.

 

Teradata Application DBA Responsibilities 

Administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases.  

Review data models and database designs, data access and table maintenance codes. 

Resolve database performance issues, database capacity issues, replication, and other distributed data issues.  

Support production DBA in daily or emergency procedures to resolve issues.  

Support the data loads into the databases.  

Ensure that the application and any enhancements, interact efficiently with the database developers.  

Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities.  

Create/Implement database maintenance plan to ensure data integrity.  

Manage the backup and recovery process.  

  

Day to day activities 

Performance tuning – strong knowledge of sql, joins, stats concepts 

Move data from one server to another – nparc, tara/netbackup 

Compression – Nexus 

Review ddl – solid understanding of best practices (can suggest changes to make) 

Run DML for developers for QA and prod boxes (SQL assistant) 

Linux and shell scripting as needed 

Service now – assigning, completing, closing out task/incident tickets 

Grant access using existing procedures – Galaxy request for existing prod dbs/data stores, Service now requests for developer access on DEV.  Complete developer access requests with Service Now. 

Troubleshoot and resolve user and database issues to ensure the data warehouse meets service level requirements. 

Provide guidance to less experienced team members 

Review IIQ requests for access removal/changes 

  

Release Activities 

Plan/coordinate several tasks to ensure all are completed when needed 

Report completion of activities to the team. 

Schedule time with developers if there are questions/issues regarding release work. 

Review scripts to lessen issues on execution day. 

  

On Call duties 

Use Viewpoint to monitor systems.  Check into poorly running queries that are affecting system performance. 

Respond to emails to the Teradata DBA team. 

Actively monitor and respond to service now tickets. 

Monitor load id release requests and check system to make sure load ids can be released. 

Review incoming tickets – if fix ids could be use, promote them.   

Ensure backups are running over the weekend, escalate any issues to the system dbas. 

Complete Emergency or Urgent RFC ddl/dml/restore activity. 

Use Teradata Administrator to move space to avoid capacity issues 

 

Dice Id : 10106782
Position Id : 705706
Have a Job? Post it

Similar Positions

Business Analyst (Data Privacy)
  • iSpace, Inc
  • Marysville, OH
Retail Business Analyst
  • TOP Consulting
  • Dublin, OH
Business Analyst
  • Principle Solutions Group
  • Columbus, OH
Program Manager
  • Halcyon Solutions, Inc.
  • Columbus, OH
Business Anlayst BA3
  • Digitek Software, Inc.
  • Columbus, OH
Business Analyst
  • Caresoft
  • Columbus, OH
Scrum Master
  • Infinity Consulting Solutions
  • Columbus, OH
Operational Support Engineer
  • Capricorn Systems, Inc.
  • Minneapolis, MN
Data Privacy Analyst
  • Calance US
  • Marysville, OH
Business Systems Analyst
  • V.L.S. Systems, Inc
  • Columbus, OH
Project Coordinator
  • The Judge Group
  • Dublin, OH
As400 BPCS Consultant -- AS400 based ERP application
  • Technology Resource Group
  • Dublin, OH
Business Analyst
  • Fast Switch, Ltd.
  • Columbus, OH