Job ResponsibilityAs Teradata developer, responsible for maintaining all DBA functions (development, test, production) in operation 24x7.
Experience / ready to work on L2/ L3 support also extended hours
Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
Moved databases between machines.
Installed patch sets and upgraded Teradata.
Automated data warehousing and datamart refreshes using Transportable table space option.
Worked on creating and managing the partitions.
Performed database health checks and tuned the databases using Teradata Manager.
Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
Installed Teradata drivers for the teradata utilities.
Refreshed the data by using fastexport and fastload utilities.
Job RequirementsJob Benifits