.teradata dbajob description job description:
- work as part of teradata database administration team to maintain teradata dev, uat, prod, cob environments.
- monitor and maintain all teradata infrastructure including backup servers, tape libraries and datadomain servers.
- coordinate with vendors on issues with software, hardware, etc.
- conduct capacity planning and performance analysis of teradata database & netbackup.
- work on projects to upgrade existing infrastructure or deploy new systems to increase performance or capacity.
- improve teradata system performance by performing query performance tuning and implementing appropriate workload rules.
- designing and implementing custom disaster recovery solutions to replicate the data from production to disaster recovery system.
- respond and resolve complex customer-related issues.
- in-depth knowledge of teradata, netbackup, emc datadomain and scripting skills to optimize the teradata environments.
- work on security administration like full disk, network, media encryption and hardening.
- pdcr (performance data collection and reporting) installation, migration, configuration, troubleshooting and reporting.
- vewpoint, datalab, querygrid, datamover, bar setup and configuration.
technical skills required:
- +2 years of experience in teradata core and application dba.
- extensive hands-on experience in setting up the structure, database, user, role, profiles, space as per teradata best practices.
- experience in suse linux, netbackup and emc datadomain system administration.
- extensive experience with teradata upgrade like dbs version, floor sweep.
- experience in database cloning, disaster recovery, workload management, down amp recovery.
- hands-on experience on utilities like showspace, showlocks, packdisk, checktable, scandisk, tstsql, vprocmanager, config, etc.
- hands-on experience in backup, restore and data copy using datamover, fe-ml, arcmain, dsa, etc.
- perform security audits, which includes designing and implementing ip-filtering, gateway security.
- perform capacity planning and forecasting.
- maintain workload management (tasm) to appropriately match the current requirement and making changes to workload based on new requirement for the better management of the system.
- generating tset report for day to day teradata incidents and also importing data demographics/stats using tset.
- exceptional knowledge on dbs control parameters.
- building the teradata dr systems by cloning the production environment and automation of dr synchronization process based on given rpo/rto.
- creating and managing data labs & deploying udf's (sha, oracle, java) on user request.
- implementing and reviewing the acl/firewall rules to ensure required security rules in place.
- keep up to update on database systems and features, 3rd party tools, and match with current industry standards