Share the resume Print Download PDF
Mahdi Ghaffari

Mahdi Ghaffari

Oracle DBA at Info-Tech Development Company

Contact Info

About me

A IT engineer who has functioned as an Oracle programmer, Data Architect and Oracle Database Administrator for over 5 years. A range of experience in providing infrastructure High Availability solutions along with providing technical advice and expertise to large banks and Government&Military solution providers. Has worked in both development and production environments. Has produced reports and documentation for projects detailing capacity planning, network and data center component design along with backup and disaster recovery strategies, created architectural solutions. Has gained in-depth knowledge and experience in a wide sector of industries from banking solution provider companies with large HA databases to software house testing environments.

Skills

  • Oracle SQL and PLSQL
  • Oracle Database Administration
  • Oracle Database Backup and Recovery
  • Oracle Database Active Data Guard
  • Oracle GoldenGate
  • Linux Administration
  • Oracle Fusion Middleware
  • Oracle SQL Tuning
  • Oracle Database Real Application Cluster
  • Linux Shell Scripting
  • Microsoft Database Administration
  • Data Warehousing
  • Oracle Business Intelligence Enterprise
  • Oracle Performance Tuning
  • Microsoft Integration Services-SSIS
  • Oracle Data Integrator

Work Experience

  • Bank Saderat Iran

    Tehran, Iran
    September 2016 Until now
    Database Administrator
    Currently, I am working as an Oracle Database Administrator at Bank Saderat Iran on behalf of Iran Info- Tech Development Company. I am maintaining their online banking channel manager. some tasks:
    • Automation of Daily Monitoring Health Check up Oracle and DB2
    • Online back-up of databases using RMAN utility
    • Creation of standby databases for all Oracle production databases
    • Preparation of PL/SQL procedures, functions, and triggers
    • Processed Daily Data Migration through SSIS jobs by collecting data from different servers.
    • Supported 24X7 in production database issues and User’s issues on applications.
    • Creating DB2 storage Groups, Table spaces
    • Maintaining database security
  • Mashhad Municipality

    Tehran, Iran
    July 2016 Until now
    Oracle Database Consultant
    • Consultant of the project "Installing and configuring Data Guard: Installation, localization, knowledge transfer, maintenance, and one-year support of the infrastructures needed for installing data warehouse and business intelligence dashboard of Mashhad Municipality"
  • Magfa

    Tehran, Iran
    June 2016 Until now
    Oracle Database Administrator
    • Oracle Database Administrator 11g
    • Installed and patched up oracle software
    • Setup brand new machines including oracle software installation,oracle configuration.
    • Query Optimization.
    • Generates reports from database using PL/SQL and SQL.
    • Developed Oracle Backup and Recovery strategy and scripts implement.
  • FANAP

    Tehran, Iran
    January 2016 Until now
    Application DBA
    • Tuning Oracle WebLogic Server
    • Tuning JBoss Application Server
    • Tuning Java Application Performance
    • Tuning Application Server Switch Banking
  • Ministry of Interior of the Republic of Iran

    Tehran, Iran
    May 2017 to July 2017
    Oracle DBA
    • Converted Microsoft SQL Server Databases to Oracle Database using Oracle Database Gateways and Open Database Connectivity (ODBC) to reduce maintenance cost.
    • Moved database schema changes from staging to production.
    • Used oracle backup utility RMAN to implement Oracle backup and performed media recovery.
    • Performed database tuning
  • Ministry of Health and Medical Education of Iran

    Tehran, Iran
    September 2015 to August 2016
    Oracle DBA & BI Expert
    • Oracle Database Administrator 11g, 12c • Oracle Business Intelligence Enterprise Edition 11g
    • Build Repository OBIEE
    • Creating logical dimension hierarchies and level-based measures
    • Oracle Linux 6 Administrator
    • Grid Infrastructure 11g and Oracle ASM
    • Oracle Standby Database and Standby RAC
    • Developing PL/SQL Program Units
    • Tuning Oracle Performance
    • Maintaining Oracle Server
    • Building and Maintaining Data Warehouse
    • Creating Scenarios Backup and Recovery

Education

  • Islamic Azad University

    September 2014 to August 2017
    Bachelor's degree, Computer Software Engineering
    The undergraduate computer software engineering curriculum focuses on programming techniques, information technology and computer science. Some typical courses include: • Computer science and mathematical fundamentals • Techniques and tools of advanced programming • Software specification and design • Software engineering foundations • Computer and human interaction • Database management
  • Technical and Vocational University

    January 2011 to January 2014
    Associate’s Degree, Computer Software
    The following courses are commonly incorporated into the curriculum: • Introduction to computer operating systems • Fundamentals of computer programming • Introduction to software development • Java programming, C++ programming, HTML programming • Database management • Computer networking

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 2017 September 25th