Please share resumes to anu...@reqroute.com
Role: Teradata DBA Location: Richardson, TX Duration: 6-12+ Months *Database Object Management:* The creation, update and deletion of database objects such as Databases, Views, Users, Roles and Profiles etc. *System Performance:* System monitoring using view point, Performance tuning of queries, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. Analysing explain *Workload Management:* Resource partitions, classify and govern the query before its execution in the database. *Resource Monitoring:* Database Query Log(DBQL) , ResUsage, Access Logging *User Management:* Creation and managing Users, Databases, Roles, Profiles and Accounts. Assigning profiles, granting or revoking access rights or roles, changing of passwords etc. *Space Management:* Managing the allocation of database space (Permanent Space, Spool Space and Temporary Space) across the entire system. Recording and tracking of Space Movements to assist with capacity planning and forecasting.Using techniques such as Multi-value compression (MVC) to reduce unnecessary disk space usage. *Access of Database Objects:* Granting and Revoking Access Rights on different database objects. *Security Control:* Handling logon and logoff rules for Users. *System Maintenance:* Specification of system defaults, restart etc. *Capacity Planning & Management:* Analyze the past and current data to predict the future capacity (CPU processing and Storage ) requirements *Data Storage and Management:* Archiving and restoring data using the Teradata DSA and ARCMAIN utility. *Load/Unload utilities:* In depth knowledge of TPT,Multi Load,Fastload , etc.. Utilities *Incident Management:* Experience in handling live incident related to Teradata system -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.