Almost 4 Years of experience in Teradata Corporation in supporting Enterprise Data Warehouse Including Service Management, Database administration and ETL Operations.
Specialities:
Data Warehousing Solutions
Teradata RDBMS
Database Administration
ETL Operations
Backup and Recovery processes
System Performance Analysis / Improvement
System Administration in Linux / UNIX
Teradata RDBMS
Volvo Cars:
•Teradata Database Administration that includes all DBA tasks.
• Managing ETL operations of Volvo Car Corporation that involves Datastage ETL monitoring, failure • investigation and applying fixtures for timely ETL batch completion.
• Workload Management through TASM.
• SQL Query optimization.
• DBQL and Resusage data analysis.
• User/Index Management.
• Provide quality control and auditing of databases to ensure accurate and appropriate data usage.
• Work with developers promoting their code and solving day to day issues
• Automation of tasks using Linux Shell Scripting.
• Active monitoring using Viewpoint.
• Backup/Recovery operations using Netvault.
Lloyds Bank:
Project Carries World Wide Largest implementation of ARM, Lloyds Bank Carries All development & MS Tasks which requires extensive TERADATA & ARM knowledge to carry the Project.
To run such a extensive environment MS knowledge with full control on every area is required including System Optimization, Query Optimization, System Health Checks, Workload Management,Warehouse Operations. Business Interaction, helping in ARM Campaign designing, Troubleshooting problems at Application level, Query level with considering system impacts and improvements with introducing best practices for the Project are areas covered by ARM Application with considering Application impacts on TERADATA.