* 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
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
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