Dineshkumar Mohan Email & Phone Number

32256

Chennai Area, India

I am working as Teradata Database Administrator having 7.6 years of IT experience in Datawarehousing. I have good amount of experience in Database administration as well asETL. I have worked in several database versions and releases starting from V2r5 to Teradata 15 versions.Very Good knowledge and working experience on Tools like Viewpoint, SQL Assistant, Teradata manager, Teradata Administrator, Priority Scheduler, PMON,TASM, load utilities etc. Expert in maintenance utilities. Well Experienced in Implementing Stored Procedures, Compression techniques, Partitioned Primary Index, JIs/AJIS, etc.Good in Query Tuning, Performance monitoring, writing queries for the business requirements and Database Storage maintenance. Experienced in using STATS Manager and designing SLES 11 workload. Expert in implementing, tuning and administrating the workload using Viewpoint. Well experienced in Net Backup, Netvault, TARA and ARC utilities: Good level of hand on in preparing and running the scripts for Backup/Restore/Copy/NPARC operations and involved in fixing the issues the issues coordinating Storage team and Vendor. Good at writing automated process to move data using ARCMain with Netbackup-TARA and UNIX scripts. Well experienced is writing UNIX scripts related to DB administration and automating DBA work.Experienced in Design, Testing, Implementation, Maintenance and control of Physical and relational databases. Good knowledge of Logical Data Models and Experience in conversion of Logical Model into Physical Data Model to meet the application requirements. Well experienced in Setting up DataLab and implementing best practice for Datalab usage.Good level on knowledge and hand on experience in Mainframe, Informatica and Unix.