Wipro limited (nyse: wit, bse: 507685, nse: wipro) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs.
we leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help clients realize their boldest ambitions and build future-ready, sustainable businesses.
a company recognized globally for its comprehensive portfolio of services, strong commitment to sustainability and good corporate citizenship, we have over 250,000 dedicated employees serving clients across 66 countries.
we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world.
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:
* 5 to 8 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 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.
* performing periodic audits especially for the users who are having destructive/dml access. Raise sirt if required.
* hands-on experience with sysyinit, tdput, dip, tvs (teradata virtual storage) & tim (heatmap udf), sws.
* scheduling upgrades according to the need or eos/eovs requirements.
* develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities.
* resolve database performance, capacity, replication issues and other distributed data issues.
* defining and monitoring stats collection and also proactively optimizing them as needed to help the queries to run efficiently on system.
* constantly research to improve the performance of the system by sharing any new changes/features available in the teradata system with the development team.
* perform production implementations and work with application developers to tune their sql for standard coding practices and creating dba policies, procedures and standards.
* set teradata standards w.r.t database design, physical data storage, maintenance, access and security administration.
* design and implement standards for monitoring; ensure database environment are running effectively, including backups and disaster recovery.
* hands-on experience with different hardware system models such as appliance, enterprise, etc.
* provide mentoring and education, along with technical guidance and direction to the teams.
seniority level
mid-senior level
employment type
full-time
job function
information technology
industries
it services and it consulting
#j-18808-ljbffr