Job description: - work as part of teradata databaseadministration team to maintain teradata dev, uat, prod, cobenvironments.
- monitor and maintain all teradata infrastructureincluding backup servers, tape libraries and datadomain servers.
-coordinate with vendors on issues with software, hardware, etc.
-conduct capacity planning and performance analysis of teradatadatabase & netbackup.
- work on projects to upgrade existinginfrastructure or deploy new systems to increase performance orcapacity.
- improve teradata system performance by performing queryperformance tuning and implementing appropriate workload rules.
-designing and implementing custom disaster recovery solutions toreplicate the data from production to disaster recovery system.
-respond and resolve complex customer-related issues.
- in-depthknowledge of teradata, netbackup, emc datadomain and scriptingskills to optimize the teradata environments.
- work on securityadministration like full disk, network, media encryption andhardening.
- pdcr (performance data collection and reporting)installation, migration, configuration, troubleshooting andreporting.
- vewpoint, datalab, querygrid, datamover, bar setup andconfiguration.
technical skills required: - 5 to 8 years ofexperience in teradata core and application dba.
- extensivehands-on experience in setting up the structure, database, user,role, profiles, space as per teradata best practices.
- experiencein 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 onutilities like showspace, showlocks, packdisk, checktable,scandisk, tstsql, vprocmanager, config, etc.
- hands-on experiencein backup, restore and data copy using datamover, fe-ml, arcmain,dsa, etc.
- perform security audits, which includes designing andimplementing ip-filtering, gateway security.
- perform capacityplanning and forecasting.
- maintain workload management (tasm) toappropriately match the current requirement and making changes toworkload based on new requirement for the better management of thesystem.
- generating tset report for day to day teradata incidentsand also importing data demographics/stats using tset.
-exceptional knowledge on dbs control parameters.
- building theteradata dr systems by cloning the production environment andautomation 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 theacl/firewall rules to ensure required security rules in place.
-keep up to update on database systems and features, 3rd partytools, and match with current industry standards.
- performingperiodic audits especially for the users who are havingdestructive/dml access.
raise sirt if required.
- hands-onexperience with sysyinit, tdput, dip, tvs (teradata virtualstorage) & tim (heatmap udf), sws.
- scheduling upgradesaccording to the need or eos/eovs requirements.
- develop andimplement database performance monitoring process and analyzemonitoring data for performance optimization opportunities.
-resolve database performance, capacity, replication issues andother distributed data issues.
- defining and monitoring statscollection and also proactively optimizing them as needed to helpthe queries to run efficiently on system.
- constantly research toimprove the performance of the system by sharing any newchanges/features available in the teradata system with thedevelopment team.
- perform production implementations and workwith application developers to tune their sql for standard codingpractices and creating dba policies, procedures and standards.
-set teradata standards w.r.t database design, physical datastorage, maintenance, access and security administration.
- designand implement standards for monitoring; ensure database environmentare running effectively, including backups and disaster recovery.
-hands-on experience with different hardware system models such asappliance, enterprise, etc.
- provide mentoring and education,along with technical guidance and direction to theteams.