🏴☠️Oracle RDBMS
🤡 Sepah Bank’s large customer database
including primary and secondary keys, data types, and modular architecture
🏴☠️In the previous infrastructure, with a significant increase in data volume and the execution of heavy and analytical queries, our servers faced numerous challenges.
The structure based on transactional tables with complex foreign key dependencies, multiple composite indexes, and hardware limitations, and ultimately the involvement of CPU resources in parallel processing, led to instability and frequent crashes at peak times.
🏴☠️Currently, after a complete migration to an optimized infrastructure and precise configuration of Oracle Optimizer, stability tests and appropriate response time on initial loading have been successfully passed.
🤡At this stage, we need to cooperate with a professional Oracle DBA; Someone with practical experience in analyzing Iranian banking data structures, proficient in SQL at an advanced level, and capable of data profiling and extracting analytical insights from inter-table relationships.
🤡Payment will be project-based, confidential, and in cryptocurrency.