Mohammad Rajabi Email & Phone Number

Iran

Tehran, Tehran Province, Iran

• Designing and developing distributed databases with HA/DR architecture across two independent data centers.• Establishing a secure database structure based on ISMS (ISO 27001) standards.• Creating separate independent database environments: Dev, Pre-Release, Stage, and Production.• Implementing a documented encrypted backup scenario using SSIS and Veeam Backup, following the Grandfather-Father-Son backup strategy.• Setting up monitoring with RedGate SQL Monitor and Solarwinds for real-time monitoring of servers and databases.• Monitoring the performance and availability of servers and clusters.• Continuous analysis of resource-intensive queries using monitoring tools, analyzing execution plans, and applying performance tuning strategies to optimize database speed and efficiency (Indexing, Data Compression, Partitioning, Rewriting, etc.).• Assessing index fragmentation and creating an automated process for effective rebuilding of operational indexes.• ETL for live market data to Data Warehouse for reporting and admin panel development.• Database maintenance and updates.• Transferring audit logs from operational databases to Splunk log server.• Developing stored procedures, views, triggers, and user-defined functions to enforce business rules.• Documenting changes.• Designing and developing a Data Warehouse in an OLAP environment for reporting and BI systems.• Installing and configuring Power BI Report Server and creating analytical reports using Power BI Desktop.• Hardening security measures.• Establishing a periodic internal audit procedure to track security requirements.• Conducting disaster recovery drills.• Creating a Log Management infrastructure using Splunk software with a multi-tier architecture.

Tehran, Tehran Province, Iran

• Designing and developing distributed databases with HA/DR architecture.• Implementing Transparent Data Encryption (TDE) for databases with certificates.• Hardening security measures.• Establishing a secure database structure based on ISMS (ISO 27001) standards.• Creating separate database environments for Local, Stage, and Production.• Developing a documented backup scenario using SSIS.• Establishing a log server infrastructure with ELK database.• Transferring audit logs to the log server.• Documenting and recording changes.• Defining stored procedures, views, triggers, and user-defined functions to enforce business rules.• Implementing database infrastructure requirements from the Information Security Monitoring Center of the Capital Market (ISMS) and the Informatics Organization (to obtain service provision permits).• Setting up a Zabbix monitoring server and creating specialized dashboards to monitor server performance in both data centers.

Tehran, Iran

Designing and developing distributed databasesCreating a structured backup scenario with SSIS and saving backup files to FTPLogging server with SQL databaseImplementing database infrastructure requirements on behalf of the Informatics Organization (to obtain service provision authorization)Project manager for the nationwide integrated CRM software for the East Azerbaijan Telecommunications OrganizationDesign and Development scenario for migrating user data from legacy systems to the new system for approximately 1 million users

Iran

Designing and developing distributed databasesCreating a structured backup scenario with SSIS and saving backup files to FTPLogging server with SQL databaseImplementing database infrastructure requirements on behalf of the Informatics Organization (to obtain service provision authorization)Project manager for the nationwide integrated CRM software for the East Azerbaijan Telecommunications OrganizationDesign and Development scenario for migrating user data from legacy systems to the new system for approximately 1 million users

Tehran, Iran

Tehran, Tehran Province, Iran

Designing and developing distributed databasesDatabase programming and developing business procedures