Cycle3 IT Staffing is seeking a Teradata DBA
In this role you will be developing the overall data warehouse architecture and physical implementation standards.
Will be participating in analysis and creation of logical data Models.
Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models.
Maintain the referential integrity of the database.
Assisting developers in tuning SQL and maintains appropriate Priority Scheduler Profiles.
Working with ETL Team to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
The ideal candidate will be providing ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup, and performance monitoring.
Experience Using Teradata Manager to monitor and manage Teradata RDBMS resource utilization, and create alert policies for monitoring database space and average disk use.
Expert level SQL skills, understanding of Data Warehouse Metadata Concepts, tools and repositories.
Runtime Optimization, capacity management and planning, security, configuration, scheduling and execution of Maintenance utilities.
Drive planning and execution of hardware/software upgrades and expansion.
Shell scripting, system tuning and troubleshooting on UNIX.
The ideal candidate must be a senior level Teradata DBA and must be proficient in Teradata toolsTeradata Administrator, Teradata manager, Teradata Query manager, TASM and Teradata*s Priority Scheduler and BTEQ.
The ideal candidate should possess knowledge of database recovery and restart procedure is desirable.
Experience with Teradata 12 or higher.
Knowledge of viewpoint (Preferred).
Preferable if the candidate also has hands-on Teradata ETL experience.
Must have a minimum five Years of Teradata DBA experience in a senior capacity performing development, administration, implementation and support in a production Data Warehousing environment.
Experience in a large-scale and retail data warehousing is a plus.
Teradata Master Certification is highly desirable.
To apply for this job email your details to email@example.com