About wipro wipro limited (nyse: wit, bse: 507685,nse: wipro) is a leading technology services and consulting companyfocused on building innovative solutions that address clients' mostcomplex digital transformation needs.
we leverage our holisticportfolio of capabilities in consulting, design, engineering,operations, and emerging technologies to help clients realize theirboldest ambitions and build future-ready, sustainable businesses.
acompany recognized globally for its comprehensive portfolio ofservices, strong commitment to sustainability and good corporatecitizenship, we have over 250,000 dedicated employees servingclients across 66 countries.
we deliver on the promise of helpingour customers, colleagues, and communities thrive in anever-changing world.
· a proud history of over 75 years · fy22revenue 10.4 bn usd · we're present in 66 countries · over 1,400active global clients job description: - work as part of teradatadatabase administration team to maintain teradata dev, uat, prod,cob environments.
- monitor and maintain all teradatainfrastructure including backup servers, tape libraries anddatadomain servers.
- coordinate with vendors on issues withsoftware, hardware, etc.
- conduct capacity planning andperformance analysis of teradata database & netbackup.
- workon projects to upgrade existing infrastructure or deploy newsystems to increase performance or capacity.
- improve teradatasystem performance by performing query performance tuning andimplementing appropriate workload rules.
- designing andimplementing custom disaster recovery solutions to replicate thedata from production to disaster recovery system.
- respond andresolve complex customer-related issues.
- in-depth knowledge ofteradata, netbackup, emc datadomain and scripting skills tooptimize 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.