Imej profil awaissheikh151
@awaissheikh151
Ahli semenjak 9 Mac 2019
0 Cadangan

awaissheikh151

Dalam Talian Luar Talian
With more than 5 years extensive experience as database administrator in SQL server , MySQL, hadoop and Teradata, My specialties are: 1) Database Design: Normalization, Dimensional Modeling and OLAP Cubes 2) RDBMS : MYSQL, SQL SERVER, Amazon Redshift and Teradata 3) Hadoop : Spark , Hive , Hbase , PIG and phoenix. 4) Languages : Python and Java 5) Data Visualization : PowerBI and Tableau 6) ETL: Talend, pentaho Apart from above mentioned Skill, My performance tuning Skills and workload management in databases for mysql , SQL Server and Teradata will make your database optimized and faster
$10 USD/hr
3 ulasan
2.8
  • 100%Kerja Diselesai
  • 100%Mengikut Bajet
  • 100%Tepat Pada Masa
  • N/AKadar Ulang Upah

Portfolio

Ulasan Terkini

  • Imej Martin S. Quick MYSQL query $79.00 USD

    “very prompt and available”

  • Imej Simone B. Create database schema for booking app $45.00 USD

    “Excellent work and very propositive and comunicative. Will work with him again!”

  • Imej Timothy F. Import Data to SQL $120.00 USD

    “Excellent Communication (in English) with a high level of experience in SQL DB. Strongly recommended. We look forward to working with you again.”

Pengalaman

Database Administrator

Oct 2015

Developed master schema for BrokerGenius Data warehouse. Developed data pipelines using Python and SQL for migrations of data from Elastic Search to Hive. Responsible for Extracting data from different flat files, transformed the data using TALEND and SQL scripts and loaded data into Amazon Redshift data warehouse. Developed and optimized SQL scripts(MySQL) for BrokerGenius API. Developed pipelines using python to migrate client Point of sale data from SQL server to Elastic Search.

Database Administrator

Oct 2014 - Sep 2016 (1 year)

Responsible for creating database, database objects, users , roles and profiles. Optimized SQL queries (PI Revision and Stats management) which were slow and taking intensive Resources. Responsible for Performance tuning of Teradata SQL. This demands good knowledge in understanding the parameters like Teradata Explain, Stats Collection, multi value Compression, Skewing etc. Developed stored procedures to optimize the statistics collection process on Production databases.

Pendidikan

Software Engineering

2010 - 2014 (4 years)

Kelayakkan

Mapr Certified Hbase Developer (2017)

Mapr.com

Teradata Certified Professional (2015)

Teradata

Pengesahan

  • Facebook Disambung
  • Freelancer Keutamaan
  • Bayaran Disahkan
  • Telefon Disahkan
  • Identiti Disahkan
  • E-mel Disahkan

Kemahiran Teratas Saya

Cari Freelancer yang serupa