Download PDF

Summary

Database Administrator with more than 6 years of experience in database management, query optimization, Teradata Active System Management (TASM), system administration, BAR and ETL methodologies.

Well-versed in designing, developing, implementing and managing database policies and procedures to ensure integrity and availability of databases and their accompanying software. Competent in designing, coding, testing and supporting database environments. Commended for handling demanding production support environment while managing large volumes of business-critical data. Committed team player with ability to communicate at all levels and perform production support administration tasks including proactive monitoring, troubleshooting, tracing, backup, recovery and on-call support to ensure availability and performance requirements are met.

Experience working in international markets and customer facing technical consultancy roles, worked closely with major credit card company in United Kingdom for 18 months. Delivered technical training to customer DBA team in Abu Dhabi, UAE. Attended and delivered various international technical training sessions.

Work History

Apr 2010Present

Global Delivery Control Consultant

Teradata

I have been primarily engaged as a Teradata DBA in Teradata Global Delivery Center, Pakistan and have the privilege of providing services to Fortune 500 companies in offshore/onshore 24 x 7 delivery models. Major responsibilities include but are not limited to:

  • Database Operations and Administration
  • Data Storage Management
  • Security Administration
  • Teradata Database Optimization
  • Teradata Metrics Collection and Reporting
  • System Administration
  • Database Objects Release Management
  • BAR Environment Administration
  • BAR Operations
  • Physical Database Modelling
  • Basic Big Data/Hadoop Administration (Hortonworks Data Platform)
  • System performance assessment
  • Application performance review and tuning
  • Capacity forecast for current and new workload

Major client engagements include but are not limited to:

Unilever, Barclays, Telefonica O2 Ireland & UK, Emirates Integrated Telecommunications Company,Telenor Pakistan, Capital One UK, Mobilink Pakistan, Intesa SanPaolo Bank Italy and OP Pohjola Group Finland.

Key deliverables:

  • Developed and implemented end to end workload management strategies (TASM) at various client systems
  • Providing ongoing support of the environment by developing processes and executing object migrations and database performance monitoring.
  • Designing, building and maintaining the physical Teradata database objects (databases, tables, views, macros etc.) to support business requirements

 

 

  • Developed various Physical Data Models (PDMs) by following SDLC and ITIL best practices
  • Provided technical and business consultancy on best practices of managing and admnistering Teradata database system
  • Working knowledge of Teradata PDCR, CPPT, MSM and UDA
  • Providing leadership and mentoring to team members while adopting a broad business approach.
  • Providing basic administration services on Big Data, Hortonworks Data Platform (HDP)
Nov 2009Apr 2010

IT Executive

Earth Factor

I was extensively involved in development, optimization and end to end live deployment of different IVR based services for Pakistan’s leading telecommunication companies. Some of the services which I successfully developed and deployed were: Telenor’s Karo Mumkin, Music, Regional and health portals for Ufone, Telenor and Zong. 

Major tools utilized included Asterisk PBX, MySQL, Perl and Groovy.

Jun 2009Aug 2009

Research Assistant

Systems Research (Pvt) Ltd.

During my stay here, I worked on Open Source Java to assist development in the reporting module for the enterprise software which was a complete Telecommunication billing as a Service (TbaaS) solution for Telecommunication Companies. The billing solution was developed using Eclipse IDE, Java and Jasper Reports.

Certifications

Apr 2016Present

AWS Technical Professional

Amazon Web Services
Aug 2015Present

Teradata 14 Certified Professional

Teradata
Apr 2013Present

ITIL v3 Foundation Certified

EXIN

Education

Trainings/Achievements

  • Teradata GDC Quarterly Award (Q2 2011) 
  • Delivered hands-on workshop on Teradata Viewpoint Administration to Etisalat in Abu Dhabi, UAE on behalf of NCR Gulf.
  • Attended Teradata Unity implementation workshop in London, United Kingdom.
  • Attended HDP Administration workshop in Islamabad, Pakistan.
  • Attended Unity implementation workshop: Train The Trainer in Manila, Philippines.
  • Attended Teradata Performance Optimization workshop in Prague, Czech Republic. 
  • Successfully built, administering and managing personal website (http://muhammad-usman.com)