Arwano Inc.Senior Teradata Consultant
Feb. 2007 - Jul. 2008Scottsdate, AZWorked on the DHL project of Arwano Inc., as Senior Teradata Consultant/DBA, with following responsibilities: • Responsible for the overall well being of Teradata (TD) Data Warehouse
• Responsible for Teradata setup, configuration options, startup, shutdown, archive, and recovery
• Develop and/or guide the system capacity planning effort including performance measurement query development
• Plan and guide the execution of Data Warehouse Hardware / Software upgrades
• Track and coordinate with vendors on issues, upgrades and patches.
• Responsible for maintaining Disaster recovery systems synced with Production system.
• Create policies for security, user management, roles, profiles, database access rights, etc.
• Manage super users, space (perm, temp and spool) and databases.
• Implement/Revise indexes (Implement Primary and Secondary indexes and set up Statistics collection process)
• Administer TD security in coordination with overall IT and Corporate security policies
• Create and manage archive/recovery policies.