Alireza Amirbiglou

Senior Database Engineer @ TMX Group

About

Over 10 years of experience in Db2 (LUW/zOS) & Oracle database administration, migration, and management. Experienced in high workload OLTP/OLAP environments for financial, banking, and insurance businesses. Expertise in performance/query tuning, and monitoring for high-available high-volume transactional 7*24 systems. Technical experience summary: • Database vendors and versions: Oracle (11g/12c/19c), Db2 z/OS (9.1 & 10.1), Certified Db2 LUW (9.7 & 10.5), Informix 12.10, SQL Server (2005 & 2008) • Software and tools: sql*plus, pl/sql developer, Oracle GoldenGate, db2top, spotlight, db2 admin tool, Performance Experts, IBM Data Studio, Visual Explain, MXI, DB2I, SDSF, ... • Configure database parameters • Installation, upgrade, and fix packs • Tune and write functions and stored procedures • Define MQTs and MDCs tables for management reports • Design indexes based on query performance issues and statistics • Online/offline full/incremental/delta backup and recovery • Plan and implement HA/DR 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 planning • Expert on database concepts: transaction, consistency, logging, concurrency control, serialization, access paths, …

Country

Canada

City

Richmond Hill

Industry

Financial Services

Skill

Extract, Transform, Load (ETL), SQL, DB2, Microsoft SQL Server, XML, z/OS, Databases, Database Administration, Database Design, COBOL, Data Warehousing, Linux, Java, Mainframe, Performance Tuning, Oracle, Unix, Software Development, SQL Tuning, MySQL

Experience

Senior Database Engineer

TMX Group

2022-9 - Present · 4 yrs 1 mo

Toronto, Ontario, Canada

• Design, develop, and maintain Db2 databases and related software components. • Develop and maintain database schema and data models. • Create and optimize SQL queries to improve database performance. • Ensure database schema and data conform to industry best practices and standards. • Collaborate with development teams to design and implement database applications. • Develop and maintain ETL (Extract, Transform, Load) processes to populate and update databases. • Perform database testing and debugging to identify and resolve issues. • Document database design, including data models, schema diagrams, and system architecture diagrams. Plan and execute database migrations and upgrades. Stay up-to-date with emerging trends and technologies in database design and development.

Data Engineer

Morgan Stanley

2021-3 - 2022-9 · 1 yr 7 mos

Montreal, Quebec, Canada

• Managing a data processing infrastructure on Db2 LUW for stability, scalability, and capacity planning. • Plan and execute database schema changes, bottleneck analysis, outage prevention/resolution, server/database performance improvements, database maintenance, and database recovery. • Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization. • User/role/group data access management over database objects to enforce database security, standards & guidelines. • Heavy daily exports/imports to provide a near real-time reporting OLAP environment. • SQL tuning, access plan explain queries and online monitoring database performance. • Developing python/shell scripts and stored procedures, generating reports, and running database utilities.

Database Administrator

Videotron

2020-11 - 2021-1 · 3 mos

Montreal, Quebec, Canada

Oracle & DB2 DBA

TOSAN (Banking and Payment Solutions Provider)

2018-2 - 2020-7 · 2 yrs 6 mos

Tehran Province, Iran

Administrate and maintenance of over 100s test/develop/product databases in Oracle 11g/12c/19c on a fully developed Oracle infrastructure: ASM, RAC, RMAN, Data Guard (Physical/Logical ), and GoldenGate. Developing a migration plan from Oracle to Db2 z/OS for our new customers as a team leader. Training and teaching staff to get familiarized with z/OS and Db2 on 2 courses/workshops.

DB2 DBA-DBD zOS/LUW

Sadad Informatic Corporation

2015-10 - 2018-2 · 2 yrs 5 mos

Tehran Province, Iran

Design and administer Bank Melli databases based on DB2 LUW v10.5 and DB2 z/OS 10.1 – over 50 databases such as Core Banking, eBanking, and payment solutions. Implementing a high-available disaster-recovery solution on all databases mostly focused on High Availability needs.

DBA on IBM Informix

Informatics Services Corporation

2015-6 - 2015-10 · 5 mos

Tehran Province, Iran

Card Operations Maintenance at Central Bank of Iran on IBM Informix Database Servers v12.10, include card, mobile, and internet payments. Replication data using HDR and ER utilities, for the purpose of short/long-distance disaster recovery respectively.

Informix DBA

Informatics Services Corporation

2015-6 - 2015-10 · 5 mos

Tehran Province, Iran

DBA on DB2 zOS/LUW

Behpardakht Mellat (Payment Service Provider)

2009-12 - 2015-6 · 5 yrs 7 mos

Tehran Province, Iran

Manage and maintenance Mellat Bank Database Systems for payment gateways on z/OS v9.1 and DB2 LUW v9.7 platforms with over 4000 TPS. Replicate SQL transactions for the purpose of MIS and OLAP workloads.