Share the resume Print Download PDF
Mahdi Ghaffari

Mahdi Ghaffari

Software Engineer, Computer Programmer, Database Administrator, Applications DBA

Contact Info

About me

I am an IT engineer who has worked as a Java programmer, Software designer, Data Architect and Oracle Database Administrator for 3 years so far​. I like to provide High Availability solutions, mostly in terms of technical advice for banks and governmental organizations​. I have worked both in development and production environments​. I also enjoy learning new technologies, concepts, and paradigms​. I produce reports and documentation on capacity planning, network, and data center component designing, backup and disaster recovery strategies, and creating software architectural solutions​. I have gained in-depth knowledge and experience as a result of working in a wide range of industries ranging from banking solution providers with large HA databases to software house testing environments​.

Skills

  • Oracle Database Administration
  • Linux Administration
  • Oracle SQL and PLSQL
  • Oracle Business Intelligence Enterprise
  • Oracle Database Data Guard
  • Oracle Fusion Middleware
  • Oracle Database Backup and Recovery
  • Oracle SQL Tuning
  • Java Programming
  • Python Programming
  • C# Programming
  • Data Warehouse Design
  • Linux Shell Scripting
  • Oracle Performance Tuning
  • Data Warehousing
  • Oracle GoldenGate
  • Microsoft Database Administration
  • Microsoft Integration Services-SSIS
  • IBM DB2 - SQLPL
  • IBM DB2 Administration
  • Apache ServiceMix
  • Jboss Application Servers
  • Tomcat Application Servers
  • IIS Application Servers
  • Tuning Java Virtual Machines
  • Oracle Data Integrator
  • Websphere Application Servers
  • Weblogic Application Servers

Work Experience

  • SocialBox

    Tehran, Iran
    July 2017 Until now
    CoFunder and Software Enginer
    SocialBox is as a toolkit for management of telegram channels it was developed using these technologies: .NET Framework, ASP.NET MVC,
    Entity Framework, Microsoft SQL Server 2014, IIS WebServer
  • Magfa IT Development Center

    Tehran, Iran
    June 2016 to April 2018
    Software Engineer
    Magfa IT Development Center is one of the most renowned ICT companies in Iran, founded in 1981. I worked for them as a software engineer and DBA.
    Some of my tasks as a DBA in this company include:
    * Oracle Database 11g administrator,
    * Installing and patching up Oracle software products,
    * Setting up brand-new machines including Oracle software installation and Oracle configuration,
    * Query Optimization,
    * Generating reports from the database using PL/SQL and SQL,
    * Developing Oracle Backup and Recovery strategy and scripts implement.

    Select project(s):
    Oracle Database Consultant - Installation, configuration, and supporting data warehouse databases at Mashhad Municipality
  • Iran Info-Tech Development

    Tehran, Iran
    September 2016 to February 2018
    Software Engineer
    I was working as a Java Developer and Oracle Database Administrator at Bank Saderat Iran (BSI) (lit. "Export Bank of Iran") on behalf of Iran Info-Tech Development Company, maintaining their online banking channel manager.
    Banking Channel Manager is a Core Banking Wrapper (a 'wrapper' is used for communication between core banking systems and modern services which are developed in DPI (Ex IBM of Iran)).

    Technologies: Spring, Spring-JDBC, Log4j, Axis, Junit, Mockito, and Springockito.
    Environment: IntelliJ IDEA, Maven, SVN, Jira Issue Tracker, Jira Green hopper(Scrum Board), Jenkins, JBoss 7.1(development), WebSphere(production).
    Database: Oracle Database 11gR2, IBM DB2 Version 9.7, Oracle GoldenGate 12c
  • FANAP

    Tehran, Iran
    January 2016 to January 2018
    Application DBA
    FANAP ICT Co. is owned by the Pasargad Financial Group (PFG), the strongest private financial and investment corporate group in Iran. FANAP ICT was established by a small band of experienced engineers within PFG who aspired to elevate the domestic FinTech industry to support -and lead- global innovation.

    * Tuning Oracle WebLogic Server
    * Tuning JBoss Application Server
    * Tuning Java Application Performance
    * Tuning Application Server Switch Banking
  • JAPCo

    Tehran, Iran
    May 2017 to July 2017
    Software Engineer
    JAPCo is a science-based IT company founded in 2009, providing digital printing and other photo-related services to high-profile local organizations.

    Select project(s):
    Database Converter - Compression of photos and documents for the Iranian Ministry of Interior. Main tasks in this project include: Converting Microsoft SQL Server databases to Oracle databases using Oracle Database Gateways and Open Database Connectivity (ODBC) to reduce maintenance cost; moving database schema changes from staging to production; using Oracle backup utility RMAN to implement Oracle backup and performed media recovery; performing database tuning.
  • AVA SALAMAT

    Tehran, Iran
    September 2015 to August 2016
    SQL and PL/SQL Developer
    AVA SALAMAT is a company providing the Iranian Ministry of Health and Medical Education with technological services and IT solutions.
    I was a SQL and PL/SQL Developer at the Iraninan Ministry of Health and Medical Education.
    We have designed and setup Oracle Data Warehouse at the Ministry of Health and Education.

    Some of my tasks include:
    * Creating dashboards of Oracle BI on data warehouse
    * Developing PL/SQL Program Units
    * Administrating Oracle Database 11g
    * Building Repository in OBIEE
    * Creating logical dimension hierarchies and level-based measures
    * Administrating Oracle Linux 6
    * Building and Maintaining Data Warehouse

Education

  • Islamic Azad University

    September 2014 to August 2017
    Bachelor's Degreee, Software Engineering
    Some of the courses i passed include: - Engineering mathamatics - Discrete mathematics - Algorithm design - System programming - Advanced software enginnering - Computer architecture - Artificial intelligence - Computer simulation - Internet engineering - Advanced Database - Webpage design - Digital Design - Automata theory - Entrepreneurship
  • Technical and Vocational University

    January 2011 to January 2014
    Associate’s Degree, Software Engineering
    Some of the courses i passed include:* Introduction to computer operating systems* Advanced programming* Database fundamentals* Data structure fundamentals* LAN networks practicum* Information and storage and retrieval* Software engineering fundamentals* Web programming* Entrepreneurship in IT industry* Work placement

Social Activities - Iran OUG

- The Iranian Oracle Users Group (IROUG) is an independent, not for profit, organization created by users of Oracle software products (DBAs, Developers, Analysts, and IT management) to extend our knowledge about Database, APEX, BI, ADF, and JAVA‌. Our meetings are held in Tehran, Iran‌. Role: Leader and Website Engine Developer

Social Activities - Tehran LUG

- Tehran LUG is Linux User Group based in Tehran‌. It is a community of Linux enthusiasts who share their knowledge about GNU/Linux operation systems and make their best effort to contribute in promoting GNU/Linux operation systems, open-source software product, and digital freedom‌. Role: Participant

Achievements

  • Certificate

    Oracle Administration Workshop I
    from Artarad Company
  • Certificate

    CCNA Routing and Switching
    from Shahid Beheshti University
  • Certificate

    Oracle Database 11g SQL Fundamentals
    from Oracle School
  • Certificate

    Oracle Database 11g PL-SQL Program Units Develop
    from Oracle School
  • Certificate

    Oracle BI Suite 11gR1 Create Analyses and Build Repositories
    from Ministry of Health and Medical Education
  • Certificate

    Certified Ethical Hacking
    from Sharif University of Technology
  • Certificate

    Security Evaluated Operating System
    from Sharif University of Technology
  • Certificate

    Linux Kernel Compile
    from Sharif University of Technology
  • Certificate

    Linux Professional Institute-1
    from Sharif University of Technology
  • Certificate

    Linux Professional Institute-2
    from Sharif University of Technology
  • Certificate

    Linux Shell Scripting
    from Sharif University of Technology
  • Certificate

    Oracle Database 11g Administrator Workshop-1
    from Sharif University of Technology
  • Certificate

    Oracle Database 11g Administrator Workshop-2
    from University of Oxford
  • Certificate

    Workshop SSIS, OracleBI, SAS, Target
    from Andish System
  • Certificate

    Oracle Database 11g Administrator Certified Associate
    from Oracle University
  • Certificate

    CompTIA Network+
    from Shahid Beheshti University
Updated on 2018 May 30th