Mehdi Pourhadi

Mehdi Pourhadi

Data Engineer

Tehran

About Me

Skilled Data Professional with over 10 years of hands-on experience in managing, optimizing, and automating data workflows across diverse platforms and technologies. Proven expertise in database systems (relational and NoSQL), big data ecosystems, and Linux environments, with a strong focus on performance tuning, scalability, and operational efficiency. Passionate about leveraging automation to streamline processes and improve productivity. Adept at collaborating with cross-functional teams and delivering robust solutions in high-pressure production environments

Experiences

DBA Engineer

12/2024 - Present · Snapp

  • Automated SQL Server backups using PowerShell lead to reduce file sizes by 60% while ensuring security, integrity and performance.
  • Exploring Scala for big data, Kafka for real-time streaming, LLMs for AI computing.

Data Engineer

03/2023 - 12/2024 · Blu Bank

  • Responsible for maintaining and updating Airflow jobs ensuring efficient data processing and workflow automation.
  • Developed the Suspicious Transaction Report (STR) for the Anti-Money Laundering (AML) department with custom rules.
  • Streamlined the ETL process to provide analytical reports, data migration to third party vendors collaboration and data sharing.

Oracle DBA/Big Data Engineer

09/2022 – 03/2023 · MCI (BRTech)

  • Deploy Master-To-Master MySQL database for storing Apache Hive metastore.
  • Experience with MapReduce and YARN Architecture and different HDFS filesystems such as Avro, Parquet and ORC.
  • Choosing efficient methods for Data migration from Oracle to Big Data environment using Sqoop or PySparkto Reduce migration time upto 50% and vice versa.

SysOps/Backend Administrator

09/2020 – 09/2022 · MTN Irancell (Ariana)

  • Facilitate Django Applications deployment requirements, Compile & installation methods.
  • Develop Python CMDB Network Discovery for Huawei/Cisco using regex for JIRA Insights.
  • Optimized MySQL to PostgreSQL migrations, reducing data transfer time by 30% using pgloader.
  • Designed JIRA workflows improving tracking efficiency by 25% through Apache Groovy automation.
  • Automated browser interactions using Python Selenium, resulting in a 40% increase in testing efficiency and process completion.

Senior Database Administrator

12/2016 – 12/2019 · MTN Irancell (Tecnotree)

  • Using explain plan to optimize query performance up to 80% Both on Oracle/MongoDB.
  • Using efficient methods for collecting data from different sources at large data sacle more than 500 GB.
  • Automated ETL report generation with Python scripts, resulting in a 20% time savings for report delivery.
  • Good comprehension of MongoDB Database Architecture working on big data scale like 2 TB collections.
  • Monitoring and health Management Oracle/MongoDB Database Using: Enterprise Manager, Ops Manager.

Data Engineer

05/2014 – 12/2016 · Atos (Iran Nara)

  • Installation and process management of Oracle Goldengate for the data warehouse.
  • Backup/Restore data using all Oracle features such as exp(dp)/imp(dp), DBCA, RMAN.
  • Good comprehension of Oracle 11g Database Architecture and WebLogic for Installation.
  • Using RMAN auxiliary database duplication for cloning database decrease time migration up to 70%.
  • Self-Study on diverse Linux Distribution such as Ubuntu, Debian, Arch, Fedora, OpenSUSE to LPIC-1 & LPIC-2 level.
  • Processed logs using Logstash and optimized retrieval with Elasticsearch for events per second, enhancing monitoring capabilities

Education

B.S. in Computer Science

2022 - 2024 · Allameh Hali Higher Education Institute

Skills

Linux, Oracle Database, MongoDB, MySQL
Python, Bash, Airflow, Docker, JIRA
Postgres, Hadoop, PySpark

Hobbies

  • Anime
  • Manga
  • Video Games
  • Swimming
  • Gym