Project Lead - TERADATA DBA

Location: Hoffman Estates , IL

skills and responsibilities:

knowledge of Teradata database concepts and physical database design plus
database administration support for very large databases in a Teradata
environment. Design,
creation, maintenance, and support of database objects based on architectural
guidelines and standards. Combined
experience with application support, performance tuning, user & security
administration, optimization of BTEQ/SQL
& Teradata procedure language. Understanding
of Bteq, Multiload, fastload, fastexport, Tpump,TPT , TD explain utility,
TSET,TD Index Wizard, TD Static Wizard, Viewpoint Periodic
backups of the database and operating system. Coordinate
and assist with support incidents reported by users of the EDW environment. Support
and implement audit requirements 2-4
years’ experience in Teradata administration Experience
in Linux/Unix platform, and shell scripting Additional Good to have skills Monitoring
and administration of Teradata
Databases. Install,
Setup and configure Teradata Database.
Database Patching and Upgrade. Administration,
Backup and retention policy implementation. Creating and Setting up of New
backup and Restore jobs Database
backup, restoration and recovery. Contact
to Teradata Support to resolve issues
like performance and product support. Following up with vendor on the
Teradata Hardware Alerts. Setup
and configure Replication, Mirroring, DR on the Servers. Scripting
for automation of tasks. Managing
Database Jobs, parameter tuning Troubleshooting
database related issues SQL
Query Optimization, Rebuilding of Indexes Analyzing/Validating
Database segments Housekeeping
activities, Health, Performance monitoring. Support
development team, Test team, fixing daily development backup job issues, Client
Installation support on Users Desktops. Provide
24*7 Hours Support for Production Server including Fixing Weekend Production
backup and Restore jobs issues. Application
Outages Handling. DR
Setup and Testing. Create
user, Grant permission, role and privileges. Setup
and follow-up of Site scope/Insight alerts. Co-ordinating
with Control M to schedule new jobs or
to change existing schedules Create
User Database, Create Tables/views, Procedure/and macros. Teradata
object migration, Migration of code from Development/QA/Test/Production Preparing
Ticket History and Metrics.