Image de profil de awaissheikh151
@awaissheikh151
Membre depuis le 9 mars 2019
0 Recommendations

awaissheikh151

En ligne Hors ligne
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 commentaires
2.8
  • 100%Travaux complétés
  • 100%Selon le budget
  • 100%Dans les temps
  • N/ATaux de Réembauche

Portfolio

Avis récents

  • image de Martin S. Quick MYSQL query $79.00 USD

    “very prompt and available”

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

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

  • image de 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.”

Expérience

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.

Éducation

Software Engineering

2010 - 2014 (4 years)

Qualifications

Mapr Certified Hbase Developer (2017)

Mapr.com

Teradata Certified Professional (2015)

Teradata

Vérifications

  • Connecté à Facebook
  • Freelance Préféré
  • Paiement vérifié
  • Téléphone Vérifié
  • Identité Vérifiée
  • E-mail vérifié

Mes meilleures compétences

Voir des freelances similaires