Contact detail:

Email: [email protected]

Mobile: +886-0974273930

WhatsApp number: +91-9870674023


Amirullah Mansoori

  • 9.5 years of experience in  Oracle 11g, 19c PL/SQL, PostgreSQL, MySQL, Redis.
  • Having 2 years of experience in DevOps including tools like, CI/CD, Git-Lab, Jenkins, Ansible and containerization tools like Docker and Kubernetes.
  • Successfully completed the post graduate program in DevOps from Edureka in collaboration with Purdue University.
  • Having worked on experience on Monitoring Tools like Prometheus, Grafana, EKS for log monitoring, ETL tools like Pentaho Data Integration aka Kettle.
  • Worked on Cloud environment like GCP and AWS and managed Kafka cluster.
  • Have good knowledge on pg_squeeze and pg_repack for DB Clean up and perform Database smoothly.
  • Oracle Performance tunning by external hints or by checking awr report time to time.
  • Awarded as Best Employee by 3i Infotech
  • Have a good hands-on experience with different flavors of databases, including Oracle, Postgres, MySQL.
  • Experience in support, maintenance and development in data migration project and development project.
  • Hands on experience in Linux / Unix commands and Shell scripting. 
  • A developer with a reasonable breadth of experience in Oracle DB.
  • Good working knowledge in advanced concepts like Bulk Collect, Bulk Bind, Ref Cursors, Associative Arrays, Stored Procedure, Function, Trigger etc.
  • Has knowledge on Performance Tuning, Indexes rebuilding, re-organization of tables.



Projects

Taiwan (Nov,2018- 2021)

  1. Product: CPS Kastle Universal Lending
  2. Loan Origination, Credit evaluation and Approval

Malaysia (May,2017-Oct,2018)

  1. Product: KASTLE PG system
  2. Loan Origination, Credit evaluation and Approval

Nigeria (Apr,2015-May,2017)

  1. Product: Kastle Treasury
  2. Integrated treasury management solution

India

  1. Product: Trade Flow
  2. Trade Financing, Loan against Gold, Escrow Service, Murabaha and DGCX Physical Delivery.

Working Experiences

May 2021 - Till now

Database Administrator (Carrefour Taiwan) 

  • Have good working experience in Cloud Platforms Like GCP/AWS.
  • Develop and implement the new requirements of all the New CR/BR.
  • Maintain PostgreSQL Database , Oracle Database and MySQL Database  daily basis.
  • Have good knowledge of DB replication, Backup and fine tune Oracle DB using AWR reports.
  • Having hands-on experience in DevOps and having good working experience with CI/CD using Jenkins and Ansible , SCM using Git Lab & Git Hub , Container orchestration using Docker and K8s clusters and monitoring tools to monitor the performance of each server using Prometheus and Grafana, Zabbix and skywalking to monitor the performance of all the servers.
  • Having good working experience with Kafka, Kafka-Eagle, EKS  for log monitoringTerraform, Docker-Swarm, K8s including installation and setup.
  • Installation and upgrade of databases, importing and exporting to create different environments, like developer, QA, test.


April 2014 - May 2021

Oracle Database Engineer

3i-Infotech (Indian IT Company)

  • Provide onsite client implementation, support and consultation for new CR as well as timely production support in Nigeria, Malaysia and Taiwan, .
  • Develop and implement the new requirements of all the CRs.
  • Act as the only business analyst and sales representative for the product and change requests and achieve high performance and satisfaction rate (96%) with good stakeholder management skills and proven tech experiences.
  • Initiate and reinforce the existing products.
  • Develop various modules in the application with good understanding of the work flow and the use cases.
  • Develop PL/SQL database views, stored procedures, functions, packages, and triggers as per user case.
  • Solid experiences in database tuning and debugging (Oracle, MySQL)
  • Familiar with OS Linux and Windows
  • Basic knowledge of Java
  • Develop schema creation, create synonym and assign grants routine.
  • Manage scripts for Development, Testing, UAT and Live DB Environment
  • Demonstrate strong communication skills in collaboration with virtual & onsite teams from different countries

Education

August 2008 - August 2012

Mumbai University

Bachelor of Computer Science

Skills

Language


  • Oracle 9i/10g, 11g, 19c 
  • MySQL
  • PL/SQL
  • PostgreSQL
  • Linux & Windows

  • Chinese - Beginner
  • English - Professional
  • Hindi - Native