Years Experienced on Database Technolgy
MOHSEN TAHERI
Senior Oracle Database Administartor
OTTAWA,ON
Summary
As a seasoned Database Administrator and Data Architect, brings extensive experience in managing large-scale RDBMS and NoSQL systems, including Oracle, SQL Server, MySQL, and Mongodb. Key achievements include successful large-scale data migrations, proficient management of Very Large Databases (VLDB), and the implementation of stringent data security protocols. My expertise extends to supporting high-transaction-per-second (TPS) databases in both clustered and single-instance setups, ensuring optimal performance and reliability. Skilled in data warehousing, ETL processes, and addressing complex data layer challenges, I have consistently demonstrated the ability to optimize performance, maintain high availability, and ensure disaster recovery. My comprehensive experience and commitment to data integrity and compliance with standards like GDPR and HIPAA positions me as a versatile professional adept at enhancing data systems for performance, scalability, and security.
Skills:
- Database Management Systems Expertise: Proficiency in Oracle, SQL Server, MySQL, and MongoDB.
- Performance Optimization: Skills in tuning database performance for high efficiency.
- High Availability Systems: Experience in managing and maintaining high-availability environments.
- Disaster Recovery Planning: Proficiency in developing and implementing disaster recovery strategies.
- Data Security: Implementing robust security measures and staying compliant with regulations like GDPR and HIPAA.
- SQL and NoSQL Query Optimization: Deep understanding of query optimization in both SQL and NoSQL environments.
- Data Warehousing and ETL Processes: Expertise in managing data warehousing operations and ETL processes.
- Data Migration and Integration: Experience in handling large-scale data migrations and integrations with Zero or minimum downtime
- Cloud Database Solutions: Familiarity with cloud-based database services like oracle Cloud
- Database Monitoring and Troubleshooting: Skills in monitoring database health and troubleshooting issues.
Achievements:
- Successful Large-Scale Data Migrations: Demonstrating capability in migrating extensive datasets with minimal downtime.
- Management of Very Large Databases (VLDB): Efficient handling of VLDBs, ensuring their performance and stability.
- Optimization of High TPS Databases: Enhancing the performance of high-transaction-per-second databases in various settings.
- Implementing High-Availability Systems: Establishing and maintaining highly available database systems for critical business operations.
- Significant Reduction in Operational Costs Through strategic database management and optimization techniques.
- Robust Data Security Implementations: Successfully securing sensitive data and maintaining compliance with industry standards.
- Streamlining Data Warehousing Operations: Effectively managing data warehouses to improve data analysis and business intelligence capabilities.
- Improvement in Query Response Times: Achieving substantial enhancements in database query efficiencies.
- Resolving Complex Database Issues: Proven track record in identifying and resolving intricate database problems.
- Adaptation of Database Architecture for Microservices: Implementing best practices in database layer management within a microservices architecture.
Overview
14
14
12
12
Certificate on Database
Work History
Oracle Database Administrator -Part Time
Padisar Informatics Inc.
Tehran
02.2023 - 12.2023
- Maximized System Continuity and Reliability: Orchestrated a robust Oracle cluster infrastructure ensuring 95% system reliability, crucial for uninterrupted digital banking operations.
- Optimized Resource Utilization for Cost-Efficient Solutions: Leveraged Oracle Multitenant cluster architecture, reducing operational costs by 65%, aligning with cost-effective strategies in digital banking.
- Transformed Customer Experience through Database Efficiency: Streamlined services, achieving an 85% reduction in customer response times by fine-tuning Oracle Cluster performance, enhancing user experience in digital banking platforms.
Oracle Database Administrator - Part Time
NAK (World-class Telecom Managed Services Company)
11.2022 - 12.2023
- Enhanced Business Continuity: Achieved 95% reduction in potential data loss, ensuring uninterrupted operations, and minimizing unplanned downtime by 4 hours annually, ensuring seamless service for customers.
- Boosted Efficiency and Performance: Improved database efficiency by 60%, reducing query times by 40%, leading to a 10% productivity gain and saving 15 hours weekly, enhancing service responsiveness.
- Enhanced Security and Compliance: Maintained 95% compliance, reducing security incidents by 50% annually. Improved data retrieval by 45%, enabling faster access and saving 30%-60% Response time for some query, streamlining operations.
Senior Database Engineer -Full Time
Informatics Services Corporation (ISC)
01.2018 - 12.2023
- Revolutionized Cost Efficiency with Oracle Multitenant: Achieved an unprecedented 50% reduction in infrastructure costs by harnessing Oracle Multitenant, reshaping cost optimization paradigms in banking and finance domains.
- Enhanced Operational Efficiency and Stability: Established standardized protocols for an envisaged 45% efficiency surge and precision-based partitioning, potentially averting 60% of transaction disruptions, ensuring unparalleled operational stability.
- Pioneered High Availability and Minimal Downtime: Spearheaded seamless Oracle RAC 19c migrations, foreseeing a staggering 95% reduction in downtime, guaranteeing mission-critical high availability for uninterrupted banking services.
- Infrastructure Optimization and Stability:
by Implemented best practices of backup/recovery and also Data Guard ensured disaster recovery by 95%, and workload distribution for 25% faster response times. - High Availability and Data Security enhancement : Achieved a 95% downtime reduction with Oracle RAC and GoldenGate. Strengthened security measures for critical databases.
- Database Infrastructure Expansion: Scaled from 4-5 to 25 databases, fostering substantial growth.
- Elevated Business Continuity and Resilience Implemented rigorous patching, fortified security measures, and refined disaster recovery strategies, aiming for up to 95% business continuity, a cornerstone for continuous 24/7 CBI government database support.
Senior Database Engineer - Part Time
Shabakeh Afzar Co.
02.2016 - 12.2023
- Optimized Efficiency & Cost Savings: Implemented high TPS (1300+) data pipelines, saving 40% in infrastructure costs.
- Efficient Data Management & Insights: Improved data insights by 60% with successful high performance heterogeneous golden gate data replication.
- Enhanced Continuity & Infrastructure Alignment: Achieved 95% improvement in continuity & service awareness by gracefully implement oracle rac and oracle data guard in MAA architecture .
- Seamless Scalability & Performance: Enabled 300% increased workload with only 5% impact on response times with vertically scale up of oracle rac and using oracle work load management .
- Cost Efficiency via Virtual Hosting: Reduced expenses by 50% with VM ESX migration for setup production oracle clustered infrastructure.
- Reliable Supporting and Monitoring & Exceptional Uptime: Achieved 99.99% uptime, reducing outage incidents by 90%
Oracle Database Administrator - Part Time
Iran Kish Credit Card Co (KICCC)
02.2011 - 04.2023
- System Availability & Response Time: Achieved 99.99% system availability and improved response time by 60% by implement oracle rac , tuning ,parallelism in application and ETL and implement MAA for reporting .
- Migration to Oracle RAC & Efficiency Boost: Orchestrated migration to Oracle RAC, potentially enhancing response time and performance by 40% and improving call center Reporting service efficiency by 80%.
- Enhanced Security & Reliability: Boosting Data durability and business reliably with GoldenGate and Data Guard, resulting in a 90% reliability increase and a 75% enhancement in customer service.
- PCI-DSS Compliance & Vulnerability Reduction: Attained PCI-DSS compliance, patching and database and system hardening potentially reducing vulnerabilities by 80%.
- Oracle Multitenant RAC & Cost Efficiency: gracefully implement Oracle Multitenant RAC with micro services targeting 60% cost savings and ensuring 98% high availability and manageability of database service by oracle pdb/cdb architecture .
- Junior DBA Training & Knowledge Transfer: Facilitated junior DBA training for seamless skill development and knowledge transfer.
Oracle Database Consultant
Modern ISC Co
04.2017 - 01.2019
- Enhanced Database Performance & Efficiency: Elevated CBI core banking database performance , availability and response time by up to 40% through strategic partitioning, index suggestions, and query optimizations, significantly boosting operational efficiency.
- Collaborative System Optimization: Collaboratively improved system performance by 15% by fine-tuning database and Linux kernel parameters, leveraging Oracle AWR and ASH reports for substantial gains.
- Risk Mitigation & Improved Responsiveness: Reduced data loss risks by 70% and improved query response times by 36% through a focused partition model, revamped backup scripts, ensuring system fault tolerance for a more responsive system.
- Successful Project Execution: Successfully implemented the CBI's Central Bill System Payment project, ensuring uninterrupted banking operations despite implementation challenges.
Oracle Database Consultant -Part Time
Sadad Informatic Corporation
11.2014 - 01.2018
- Project Downtime Reduction: Consulted on Oracle DB installations, reducing project downtime by 30%.
- Migration and Support: Led BMI's TASHILAT EDW migration, ensuring zero data loss and a 70% decrease in migration time. Provided CMS database support, maintaining uptime at 99.9%. Implemented RMAN-based backups, reducing recovery time by 60%.
- Leadership and Training: Spearheaded 3 key phases in BMI's data warehouse project, contributing to a 45% acceleration in project delivery.
Mentored and trained junior staff, resulting in a 70% increase in team productivity. - Stakeholder Engagement: Advised stakeholders on database layer strategies, optimizing data design, resulting in a 35% improvement in system performance.
Oracle Database Administrator -Part Time
Iran Grid Management Company(IGMC)& Talashgaran san'at
03.2015 - 11.2016
- High-Performance Cluster Deployment: Installed Oracle cluster ensuring 60% reduced downtime, guaranteeing uninterrupted operations and better response times.
- Integrated Database Solutions for Efficiency: Integrated multiple databases by oracle rac multi instance solution, significantly enhancing system throughput by 50%, , HA by 95% , resulting in 60% cost savings. and ensure fault tolerance.
- Robust Data Protection and Operational Enhancement: Implemented Data Guard and OEM, achieving 99.9% data availability, data and service availability by 95% and operations and system continuity up to 99%.
- Strategic Optimization and Business Integration: Optimized system for a 60% boost in performance, ensuring agile operations and cost savings.
Collaborated for a 30% improvement in customer response times, enhancing business outcomes and client satisfaction.
Oracle Database Consultant
Iranian National Tax Administration
02.2014 - 05.2016
- Robust Database Configuration for Business Continuity: Orchestrated Oracle RAC 11g setup with Data Guard, Golden Gate, and Data Guard Hub, ensuring 99.9% uptime during critical tax periods.
- Enhanced Database Resilience and Service Availability: Implemented Oracle MAA for high availability, guaranteeing 100% service availability for tax operations.
- Efficient Migration and Operation Optimization: Oversaw ERIS TAX Solution migration, minimizing unplanned downtime to less than 1 hours in year and improving query performance by 60%.
- Strategic Consultancy and Data Durability: Provided expert guidance for technology adoption and seamless Oracle integration, achieving a 65% efficiency improvement in tax systems and ensuring 99.99% data durability.
- Mentoring and Training for On-Site Tax DBAs: Conducted mentoring and training sessions for on-site tax DBAs, resulting in a 70% cost-saving through improved HR ability to support and maintain database layers.
Oracle Database Consultant
Ayandeh BANK
12.2011 - 05.2015
- Enhanced Uptime and Data Integrity for AYANDEH Internet Banking Services: Implemented Oracle 11g RAC and Data Guard on VMware ESX, reducing outages by 80% and ensuring 99.9% data integrity and database availability for internet banking services.
- Optimized Backend Databases for Performance: Managed backend databases, achieving a 30% improvement in response times and ensuring 99.5% service availability.
- Strategic Oversight for Revenue Growth: Directed infrastructure and ETL operations, contributing to revenue growth with targeted client strategies.
- Data-Driven Operational Enhancements: Conducted data analysis leading to a 70% efficiency boost within the Oracle DBA domain, enhancing processes and effectiveness.
Oracle Database Administrator - Part Time
Pardakht Novin
12.2012 - 08.2014
- Enhanced Performance and Reliability: Optimized PNA Payment Switch database with RAC, resulting in a 30% improvement in transaction processing speed.
- Critical Architecture Design: Developed MAA for Shaparak Cluster, achieving 99.99% uptime for essential payment operations.
- Real-time Data Availability: Established Oracle Golden Gate replication, enabling data access within 5 seconds for improved analytics.
- Continuous Support and Optimization: Provided 24/7 management for PNA ROLAP, maintaining 99.9% uptime for reporting.
- Stringent Data Security Measures: Implemented PCI DSS compliance, ensuring adherence to all 12 requirements for payment data security.
Oracle Database Administrator -Part Time
Eniac Tech
05.2011 - 08.2013
- Enhanced Payment Switch Performance: Upgraded TEJARAT Bank's payment switch with Oracle RAC 11g, Improve successful Transaction by 40%, processing transactions at 1,120 TPS (Transactions Per Second).
- Robust Support and Data Efficiency: providing 24/7 support across nine clusters, managing 10TB data and handling 800+ TPS, ensuring uninterrupted banking services and efficient data handling by 60%.
- Strategic Protection and Performance Improvement: Engineered efficient real-time data replication, achieving data transfer within 5 seconds, and enhanced overall database performance by 30%.
Oracle Database Administrator -Full Time
TOSAN (Banking and Payment Solutions Provider)
09.2009 - 08.2011
- Enhanced Database Modeling: Leveraged Sybase Power Designer, resulting in a 60% reduction in development time , enterprise system development ,Data Model integrity which leading to significant cost savings.
- Tailored Oracle Expertise: Completion of specialized Oracle courses led to a 80% decrease in system maintenance costs, generating substantial savings.
- Operational Efficiency and Security Enhancement: Operational streamlining and security measures in the core banking project resulted in a 35% reduction in incident-related costs, contributing to cost efficiencies.
Education
Master's degree - Computer Software Engineering
Sheikh Bahaei University
Isfahan , Iran01.2010
Bachelor's degree - Computer Science
Shahid Babonar University of Kerman (SBU)
Kerman,Iran01.2006
Diploma - Mathematics and Physics
Nemoneh High School-Amol
Amol,Iran01.2002
Skills
- Database Management Systems Expertise: Proficiency in Oracle, SQL Server, MySQL, and Redis
- Performance Optimization: Skills in tuning database performance for high efficiency
- High Availability Systems: Experience in managing and maintaining high-availability environments
- Disaster Recovery Planning: Proficiency in developing and implementing disaster recovery strategies
- Data Security: Implementing robust security measures and staying compliant with regulations like GDPR and HIPAA
- SQL and NoSQL Query Optimization: Deep understanding of query optimization in both SQL and NoSQL environments
- Data Warehousing and ETL Processes: Expertise in managing data warehousing operations and ETL processes
- Data Migration and Integration: Experience in handling large-scale data migrations and integrations
- Cloud Database Solutions: Familiarity with cloud-based database services like AWS RDS and Azure SQL Database
- Database Monitoring and Troubleshooting: Skills in monitoring database health and troubleshooting issues
Websites
Certification
- Certified Ethical Hacker (CEH) - Informatics Services Corporation
- Oracle Database 11g Data Warehousing Essentials - Informatics Services Corporation
- MongoDB Certified DBA Associate - Informatics Services Corporation
- Oracle Data Integrator 12c Certified Implementation Specialist - Informatics Services Corporation
- Certified Big Data Professional - Informatics Services Corporation
- Oracle Certified Expert, Oracle Database 12c: Data Guard Administrator - ORACEL
- Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator - ORACEL
- Oracle Real Application Clusters (RAC) 11g Release 2 and Grid Infrastructure Administration - TOSAN (Banking and Payment Solutions Provider)
- Oracle Database 11g: SQL Fundamentals - TOSAN (Banking and Payment Solutions Provider)
- PL/SQL Programming Courses (Basic and Advanced, TOSAN)
- Data Science Certification (TOSEE Institute, Tehran)
- Python Programming Course -Anisa -Tehran
Languages
English
Full Professional
Timeline
Oracle Database Administrator -Part Time
Padisar Informatics Inc.
02.2023 - 12.2023
Oracle Database Administrator - Part Time
NAK (World-class Telecom Managed Services Company)
11.2022 - 12.2023
Senior Database Engineer -Full Time
Informatics Services Corporation (ISC)
01.2018 - 12.2023
Oracle Database Consultant
Modern ISC Co
04.2017 - 01.2019
Senior Database Engineer - Part Time
Shabakeh Afzar Co.
02.2016 - 12.2023
Oracle Database Administrator -Part Time
Iran Grid Management Company(IGMC)& Talashgaran san'at
03.2015 - 11.2016
Oracle Database Consultant -Part Time
Sadad Informatic Corporation
11.2014 - 01.2018
Oracle Database Consultant
Iranian National Tax Administration
02.2014 - 05.2016
Oracle Database Administrator - Part Time
Pardakht Novin
12.2012 - 08.2014
Oracle Database Consultant
Ayandeh BANK
12.2011 - 05.2015
Oracle Database Administrator -Part Time
Eniac Tech
05.2011 - 08.2013
Oracle Database Administrator - Part Time
Iran Kish Credit Card Co (KICCC)
02.2011 - 04.2023
Oracle Database Administrator -Full Time
TOSAN (Banking and Payment Solutions Provider)
09.2009 - 08.2011
Master's degree - Computer Software Engineering
Sheikh Bahaei University
Bachelor's degree - Computer Science
Shahid Babonar University of Kerman (SBU)
Diploma - Mathematics and Physics
Nemoneh High School-Amol
Similar Profiles
Niranjani Janet RajaratnamNiranjani Janet Rajaratnam
Group Head of Human Resources at Informatics International Limited /Informatics Private Limited/Informatics Agrotech LtdGroup Head of Human Resources at Informatics International Limited /Informatics Private Limited/Informatics Agrotech Ltd
Muhammad EjazMuhammad Ejaz
Technical Analyst at NA-SA Informatics FZETechnical Analyst at NA-SA Informatics FZE
Georgina GoldmanGeorgina Goldman
Client Success Manager at Place Informatics LtdClient Success Manager at Place Informatics Ltd
Mostafa Saad AwadMostafa Saad Awad
Food Service Attendant at Bruyere HealthFood Service Attendant at Bruyere Health
Charlotte PerryCharlotte Perry
Parts Pro at PartSource, HamiltonParts Pro at PartSource, Hamilton