Mohammadreza Khorrami Email & Phone Number

Experienced Database Administrator over 8 years with a demonstrated history of working in thebanking industry and telecommunication with high workload OLTP/OLAP environments and Implement data warehouse of bank acceptors.Skilled in RDBMS like db2, Oracle, PostgreSQL database administration, migration, and management.Up to 4 years database administration for MongoDB and Acceptable experience in non-relational databases,Beyond database management, I possess programming skills in C#.net and Python, which I've utilized to develop practical applications, including a reporting tool for DB2. My diverse technical background allows me to bridge the gap between database administration and application development, delivering solutions that meet complex business needsStrong information technology professional with a Master's degree focused in data.Technical experience summary:• Database vendors and versions: Oracle (9g/10c/12c), Db2 z/OS (9.1 & 10.1), Certified Db2 LUW (9.7/10.5/11.1), SQL Server (2008 & 2012) ,PostgreSQL(14-15-16) - MongoDB(3.4-8) • database concepts: transaction, consistency, logging, concurrency control, serialization, CAP• Software and tools: Toad, sql*plus, pl/sql developer, db2top, spotlight, db2 admin tool, Performance Experts, IBM Data Studio, Visual Explain, RMF, MXI, DB2I, SDSF, ...• Configure database parameters• Installation, upgrade, and fix packs• Write functions and stored procedures and Tune • Design indexes based on query performance issues and statistics• Online/offline full/incremental/delta backup and recovery• Plan and implement HADR solutions• Plan and implement automatic fail over• Implement DB2 JSON NoSQL capabilities• Data movements: export, load, and import• Performance utilities: stats and reorgs• Query analysis and problem determination• Monitoring and tuning performance issues• Capacity planningFamiliarity with Data Warehouse and implementation of Bank acceptors portal projectThe experiences gained in this case are as follows• Deep understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, including the concepts, designs and usage of data warehouses/• Mastery of Microsoft Development Tools (SSIS-SSAS) versions 2008 and 2012• Introduction to IBM Development Tools (Infosphere – Datastage-IBM cognos)

• 

  Iran University Of Science And Technology

  Computer Software Engineering