Beschreibung
Teradata Database Administrator | 14 Months | Vienna, Austria | Great Day Rate
Roles & Responsibilities:
- Creating/maintaining roles and profiles and assigning them to users
- Creating Users, Databases and other objects
- Create/contribute in creating and implementing new concepts
- Assist in Workload Management, PDCR, DBQL and Viewpoint modules
- Assist for implementing retention and archival using TARA for archive and restore also need net-backup knowledge
- Work in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
- Monitor and analyze the database activity, mix of queries/jobs, query/job priority, etc and Managing CPU,I/O, Spool and memory resources
- Exposure to Load utilities like TPUMP, FastLoad, FastExport, MLOAD and TPT Exposure with TDCH
- Manage/Monitor system performance, including workload management and throttling in TASM
- Manage/Monitor Query performance and tuning, physical node behavior, and amp distribution
- Consult on physical database implementations, PPI, skew analysis, join methods, and data access
- Work with Teradata GSC and Managed Services INDIA in resolving RDBMS related incidents.
- Provide weekend/off hour Support as required ( usually 1 weekend per month )
- Linux/Unix operating systems and Oracle Data Integrator
- Experience with RLS or DSA is appreciated
Required Qualifications:
- Teradata experience in an IT department, preferable in the financial services or telecom industry
- Advance Teradata Certification preferably TD14.x or higher
- High knowledge of Teradata Systems and Teradata related products
- Profound knowledge of SQL and Query Tuning
- High level of communication and facilitation skills
- Good knowledge of ITIL is appreciated, but not mandatory
- Fluent English; German is appreciated, but not mandatory
- High-level problem solving and technical experience.
- Extensive experience in administering large databases
- Expert understanding of business application