Looking after Technology Stack for Customers in MEA & Pakistan Region for below competencies!BigData & AICloud Service ProvidersAnalytics & BIManaged Services Integrations

Hortonworks Hadoop Administrator

Providing Services For Hadoop & Aster platform. i.e.• Cloudera Administration.• Teradata Aster DB Administration.• AMC (Aster Management Console) Monitoring.• Patch Upgradations on Hadoop & other system level upgradations.• Cloudera Navigator• Processes implementation and improvement• Data Loading in Hadoop.• Security on Hadoop

I have 8 years of experience in the IT industry and has working in Teradata as Operational Team Lead (Lead Teradata DBA).SKILLS:• Problem Solving, Logic Building skills• Viewpoint Administration.• TASM• Database design, Logical data modeling• Teradata and Oracle DBA services • Database Administration Skills include Space Administration, Database Security Administration and DBC Tables maintenance.• Knowledge of Teradata Load/Unload utilities• Multi Valued Compression• System Analysis using ResUsage.• DBQL.• History Maintenance.• User Session and Spool Space Monitoring • Logical Data Modeling• Software Engineering & Shell Scripting• Distributed applications design and development • Applications design and development TECHNOLOGIES & TOOLS• Teradata SQL• Teradata Tools & Utilities• BTEQ.• Oracle 10g DBA Track – Certified• Teradata Active System Managements• Teradata Active System Monitoring• Toad for Oracle from Quest Software• MySQL, PL/SQL, T-SQL• Operating Systems ( Windows NT/2000/XP, MP-RAS)

Claudera Hadoop (Version 5.4.5) Administration and Operational Support - Managed ServicesTeradata Aster 6.20 Administration and Operational Support - Managed Services

- Hadoop Administration.- Teradata Aster Administration.- Teradata DBA Admistration.- Datamover & Ecosystem. - Teradata Systems Administration and Configuration.

Job responsibilities included- Service Delivery as per the agreed Scope and Service Level Agreements- Team and Resource Management- Account reporting to Senior Teradata Management as well as Client - Database Administration - Technical ownership and mentoring

My responsibilities included:- Database Administration- Space Management- Platform DBA activities- Occasional Development DBA tasks- Database Performance Monitoring and Optimization- Involvement in Capacity Planning- Security Administration using Roles, Profiles and Accessrights- PDCR reports- Application Tunning etc- Team ManagementBackup & Restore Designing/Administration- Design and Schedule Daily and Weekly job strategies, - Handling Tapes and Drives, Plan and execute Disaster- Recovery Plan.

Key responsibilities include: • Planning and implementation of sound policies for backup and recovery of databases• Backups (Offline (Cold) Weekly, Online (Hot) on daily basis, Incremental on daily basis)• Preparation of ad-hoc reports from the databases (OLTP) according to the requirements • of higher management• Administration of OLAP database and make sure the availability of data from OLTP to OLAP for Remote Sensing and GIS staff for reporting purposes.• Monitoring of online users.• Supervision of updation of official webportal • Performing ongoing tuning of the database instances.• Implementation and enforcement of security for all of the Oracle Databases (create and maintain users and roles, assign privileges)• Administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.• Import/Export of data to and from the oracle databases.• Disasters and Recovery Strategy (Implemented Data Guard)• Work with development teams to assist in overall database design.