Teradata dba (cdmx or guadalajara)
what we need:
• 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.
required experience with:
• 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 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 date 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.
working hours:
* monday to friday, 9:00 am to 6:00 pm
what we offer:
* benefits above the law
* indeterminate contact
* hybrid scheme
#j-18808-ljbffr