Role: teradata database administration (dba)
location: mexico city // guadalajara, mexico
type of employment: full time
start date: immediate
technical skills required:
• 5 to 8 years of experience in teradata core and application dba.
• work as part of teradata database administration team to maintain teradata dev, uat, prod, cob environments.
• 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.
• 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.