|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/8/2008 4:25:22 PM
Posts: 1,
Visits: 1
|
|
We are currently searching for a technically strong and highly motivated Teradata Data Warehouse DBA for one of our largest retail client’s Enterprise Data Warehousing initiatives. The successful candidate will be responsible for implementing and maintaining the Teradata database of a multi-terabyte production data warehouse.
Location: Union, NJ
Responsibilities include:
• Developing the overall data warehouse architecture and physical implementation standards.
• 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 leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• 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, 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
Required Skills: The candidate must be a senior level Teradata DBA and must be proficient in Teradatada tools Teradata WinDDI, Teradata Manager, Teradata Query Manager, and Teradata's Priority Scheduler, BTEQ etc. Knowledge of database recovery and restart procedures is desirable.
Must have a minimum 5 years DBA experience with 3 years as a Teradata DBA in a senior capacity performing development, administration, implementation and support in a production Data Warehousing environment. Experience in a large-scale, retail data warehouse is a plus.
Teradata Certification(s) highly desirable.
If interested, please send a current resume to rbaker@galentechsolutions.com or call 212-500-6985 for more information
|
|
|
|