S M Shafiqul Islam, Developer in Dhaka, Dhaka Division, Bangladesh
S is available for hire
Hire S

S M Shafiqul Islam

Verified Expert  in Engineering

Software Developer

Location
Dhaka, Dhaka Division, Bangladesh
Toptal Member Since
June 18, 2020

S M Shafiqul Islam, an Oracle Certified Developer and DBA, brings 14+ years of global expertise in database development, administration, and architecture across international mid to enterprise-level organizations. Proficient in SQL, PL/SQL, administration, BI, and project management, he excels in optimizing database systems (Oracle, MySQL, PostgreSQL) for efficiency and is adept at leveraging cloud environments and diverse tools to deliver impactful solutions.

Portfolio

BRAC Bank
Solutioning, Database Design, Oracle, Solution Design, Database Optimization...
Asalat Al-Sharq For General Trading...
Oracle, Oracle PL/SQL, C#, Database Design, Relational Databases...
Deligram
MySQL, Vue, IT Projects, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL...

Experience

Availability

Full-time

Preferred Environment

PL/SQL, SQL, MySQL, Oracle, Database Administration (DBA), Database Design, Microsoft Power BI, PostgreSQL, Performance Tuning, Amazon

The most amazing...

...experience I had was working as a database architect for Aurea Inc., where I had to consolidate extensive volume databases into one, keeping performance intact.

Work Experience

Technical Delivery Manager

2020 - PRESENT
BRAC Bank
  • Managed internet banking applications starting from requirement collection, solution, delivery, and after-go-live support. It's an application used by five lacs people.
  • Managed delivery of digital onboarding application for a bank.
  • Oversaw software used for customer query management.
  • Acted as a solution architect and delivery manager for a digital onboarding application.
Technologies: Solutioning, Database Design, Oracle, Solution Design, Database Optimization, Microsoft Excel, Architecture, Web Dashboards, Database Modeling, Distributed Systems, Leadership, Critical Thinking, Risk Management, Data Warehouse Design, Database Performance

Oracle Database Architect (Contract)

2022 - 2022
Asalat Al-Sharq For General Trading, Solutions Systems Information Technology Co.Ltd
  • Investigated a long pending performance issue and provided a permanent solution with no performance bottleneck faced.
  • Designed a database for the new module in the existing ERP solution.
  • Implemented a physical standby database for backup and recovery.
Technologies: Oracle, Oracle PL/SQL, C#, Database Design, Relational Databases, Database Optimization, Data Engineering, Databases, Excel 365, Dashboards, PostgreSQL, Database Migration, Oracle 10g, Oracle Database Architecture, Oracle 11g, Unix, Linux, Database Architecture, Performance Tuning, Oracle Database, PL/SQL Tuning, Optimization, Microsoft Excel, Architecture, Leadership, Data Warehouse Design, Database Performance

Head of Product Development

2019 - 2021
Deligram
  • Managed the development of Deligram's eCommerce product for web and mobile, including Android and iOS.
  • Directed the successful rollout of every feature of this omnichannel eCommerce platform to generate tractions.
  • Planned, developed, and managed operations for other B2B products like dgKhata—a simple accounting for Mudir Dokan (small-scale retail stores), dgSupply—a B2B platform for ordering bulk products by the shopkeeper, and dgNow—a hyperlocal product.
Technologies: MySQL, Vue, IT Projects, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Microsoft Power BI, Data Architecture, Database Schema Design, SaaS, Oracle SQL, Oracle DBA, Data Analytics, Data Visualization, Data Engineering, Excel 365, eCommerce, Database Migration, Data-driven Dashboards, Business Intelligence (BI), DAX, Power Query, Oracle 10g, Oracle Database Architecture, Oracle 11g, Unix, Linux, MariaDB, Database Architecture, Dynamic SQL, PL/SQL Tuning, Optimization, Database Optimization, Microsoft Excel, Architecture, Metabase, Web Dashboards, Database Modeling, Amazon CloudWatch, Distributed Systems, Leadership, Critical Thinking, Risk Management, Database Performance

Development Manager | Solution Architect

2015 - 2018
Monstar Lab Bangladesh
  • Established PMO, managed multiple projects simultaneously, and oversaw resource allocation.
  • Ensured best practices, techniques, and tools for project planning, execution, project management, ongoing milestone/deliverable tracking, communication, and key performance metrics.
  • Provided software solutions for projects and served as a company strategic board member.
  • Contributed to developing the following projects: an Uber-like application for Japan Taxi, a video-enabled fashion eCommerce platform, and a parking eCommerce platform for the Japanese market.
Technologies: Amazon Web Services (AWS), MongoDB, Spring, MySQL, Project Management, Relational Database Services (RDS), IT Projects, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Technical Project Management, Redmine, Data Modeling, Oracle SQL Developer, SQLyog, Data Architecture, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, Dashboards, eCommerce, Database Migration, DAX, Oracle 10g, Oracle Database Architecture, Unix, Linux, Database Architecture, Dynamic SQL, Amazon EC2, PL/SQL Tuning, Optimization, Database Optimization, Microsoft Excel, Architecture, Metabase, Web Dashboards, Database Modeling, Amazon CloudWatch, Distributed Systems, Leadership, Database Performance

Database Architect

2016 - 2017
Aurea Inc (via an Online Freelance Agency)
  • Performed database consolidation for various types of databases.
  • Increased performance of queries and database server performance.
  • Created and monitored multiple databases that Aurea used and solved problems.
Technologies: IMPDP, expdp, exp, Document Management Systems (DMS), RMAN, PostgreSQL, MySQL, SQL, Oracle, ETL, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Amazon S3 (AWS S3), Data Architecture, Amazon RDS, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, Dashboards, Amazon Aurora, Database Migration, Oracle 10g, Oracle Database Architecture, Oracle 11g, Unix, Linux, Data Guard, Performance Tuning, Dynamic SQL, Oracle Database, PL/SQL Tuning, Optimization, Database Optimization, Microsoft Excel, Architecture, Web Dashboards, Database Modeling, Amazon CloudWatch, Database Performance

DBA and Development Lead

2014 - 2015
Jaatra.net, MGH Group
  • Served as a group database administrator (DBA) of the MGH Group. Led a Jaatra back office development project to create a travel agency's accounting software.
  • Managed the software support and implementation team. Built a scalable database for the Jaatra.net portal and eCommerce solution for the travel industry.
  • Created a database for travel agency accounting software (ERP).
Technologies: Java, Reports, Forms, Accounting, Oracle, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Visio, Redmine, Data Modeling, Oracle SQL Developer, SQLyog, Data Architecture, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, PostgreSQL, Database Migration, Business Intelligence (BI), Power Query, Oracle 10g, Oracle Database Architecture, Unix, Linux, VMware, Database Architecture, Performance Tuning, Dynamic SQL, Oracle Database, PL/SQL Tuning, Optimization, Database Optimization, Microsoft Excel, Architecture, Web Dashboards, Database Modeling, Database Performance

Manager (IT) | Group DBA & Technical Lead

2012 - 2013
Jaatra.net, MGH Group
  • Served as group DBA for MGH Group. Led and managed the technical team.
  • Contributed to SMART software development and customization. Developed software to increase the efficiency of the Galileo GDS system, and led implementation of subscriptions of SMART.
  • Led Jaatra.net portal development. Participated in Jaatra.net back office development. Designed, installed, and configured database and application server for an online portal.
Technologies: Oracle, SQL, PL/SQL, IT Projects, Toad, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Visio, Redmine, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle DBA, Data Analytics, Excel 365, Database Migration, Oracle 10g, Oracle Database Architecture, Data Guard, Database Architecture, Performance Tuning, Dynamic SQL, Oracle Database, PL/SQL Tuning, Database Optimization, Microsoft Excel, Architecture, Web Dashboards, Database Performance

Assistant Manager | DBA & Developer

2011 - 2011
Jaatra.net, MGH Group
  • Led SMART back office and other software development teams across Bangladesh, Nepal, and Mauritius.
  • Served as a project development lead of Jaatra.net, the first online travel portal of Bangladesh. Developed software to increase the efficiency of the Galileo GDS system and led implementation for every subscription of SMART.
  • Performed database administration for all in-house and customer databases.
Technologies: XML, Java, Database Administration (DBA), Reports, PL/SQL, SQL, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Redmine, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle DBA, Data Analytics, Excel 365, Database Migration, Oracle 10g, Oracle Database Architecture, Data Guard, Database Architecture, Performance Tuning, Dynamic SQL, Oracle Database, PL/SQL Tuning, Database Optimization, Microsoft Excel, Architecture, Database Performance

Senior Software Engineer | Database Developer

2010 - 2010
Jaatra.net, MGH Group
  • Acted as a key developer of the SMART software section. Development was based on user requirements. Tools included Oracle Forms 6i, Oracle 9i, and Oracle XML parsing.
  • Served as a group member to implement jaatra.net, the first online travel portal of Bangladesh. Tools included Jakarta EE and ORACLE.
  • Configured, monitored, and performance-tuned the database server and application server for jaatra.net (www.jaatra.net).
  • Provided support to the SMART Software across Mauritius, Madagascar, Nepal, and Bangladesh.
  • Provided full DBA support to the travel agency database with a proper recovery policy.
Technologies: XML Parsing, Oracle, Oracle9i, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle SQL, Oracle DBA, Excel 365, Oracle 10g, Oracle Database Architecture, Microsoft SQL Server, Database Architecture, Performance Tuning, Oracle Database, PL/SQL Tuning, Database Optimization, Microsoft Excel, Architecture, Database Performance

Programmer

2008 - 2009
IICT, BUET
  • Configured Oracle physical standby database for database high availability and recovery.
  • Designed and implemented a database for BMET considering all business processes.
  • Collected new requirements, analyzed and designed database accordingly.
Technologies: Java, Oracle, IT Projects, Toad, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle SQL, Oracle DBA, Excel 365, Database Migration, Oracle 10g, Microsoft SQL Server, Data Guard, Database Architecture, Performance Tuning, Oracle Database, PL/SQL Tuning, Database Optimization, Architecture, Database Performance

DB Consolidation

https://www.aurea.com/
• Administered Oracle Database and improved performance by removing bottleneck due to significant volume.
• Database consolidation—moved small databases into big Amazon RDS for Oracle.
• Migrated database from another heterogeneous platform to Oracle.

Toku P

https://toku-p.earth-car.com/
Scope and solution details:
• Parking reservation eCommerce platform for Japan.
• Customers can reserve parking on a specific day, time for multiple slots.
• Parking owners upload and showcase their parking.
• Partner and admin to manage all things.

Technology included:
• Jakarta EE, Spring Framework
• Hibernate as ORM
• MySQL database
• AngularJS
• Google Maps
• AWS

Contribution:
• Acted as a project manager

runway.moda

Scope:
• Fashion eCommerce platform (unique featured) development
• Buy products from video

Solution details:
• Fashion eCommerce platform developed from where the product can be purchased from video by clicking on it.

Technology:
• Jakarta EE, Spring Framework
• Hibernate as ORM
• MySQL database
• AngularJS

Contribution:
• Acted as a project manager, solution architect, and database head.

Jaatra Back Office Development

Scope:
• With the advancement of technology, we needed to change our existing specialized travel agency back office system into a new web platform.

Solution details:
• It is cloud-based accounting software accessible from anywhere over the internet.
• It can fulfill the diversified requirements of travel agencies from different countries.
• It automates the travel agency business process.

Technology:
• Jakarta EE, Jakarta Server Faces (JSF) Framework
• Hibernate as ORM
• Oracle database
• JasperReports for reporting

Contribution:
• Acted as a project manager
• Major contribution in analyzing system and design, leading team for deliverables, and taking part in the development
• Server deployment and administration.

Galileo SMS Solution

Scope:
• SMS Solution for the travel agencies using Galileo GDS (Global Distribution System) to send an automatic SMS to the passenger when a ticket is confirmed.

Solution details:
• Developed a centralized software solution by which passengers get an automatic SMS when they ticket by Galileo GDS System.

Technology:
• C#,.NET and Crystal's reports were used for development.
• Visual Studio 2008 was used as the development tool.
• Runtime XML is captured from Galileo GDS, parses data, and generates a high graphical ticket with all relevant information.
The facility prints passenger tickets or emails passengers using Gmail's free mail server.
• Oracle database is used to schedule processes, generate and send SMS, and parse GDS-created XML.

Contribution:
• Acted as the leading developer.

Smart e-Ticket

Scope:
• Email solution for the travel agencies using Galileo GDS to send an automatic email to the passenger.

Solution details:
• Developed a database-independent software solution by which the agency owner can email the e-ticket to their passengers with their company information.

Technology:
• C#.NET and Crystal's reports were used for development.
• Visual Studio 2008 was used as a development tool.
• Runtime XML is captured from Galileo GDS, parses data, and generates a high graphical ticket with all relevant information.
• The facility provided to print a passenger ticket or email the passenger using Gmail's free mail server.

Contribution:
• Acted as the leading developer.

Jaatra.net Project Development (Outsourcing) and Implementation

Scope:
• With the growth of online business trends in Bangladesh, MGH decided to go for a new software implementation for travel agencies.
• The software will enable travel agencies to have a web presence, introducing a new sales channel for agencies.

Solution details:
• MGH decided to build a web portal that will connect to all major global distribution systems.
• The project was decided to be developed with a partnership with ANMsoft India.
• A survey was conducted to understand different travel agencies' needs.

Technology:
• Jakarta EE is the primary technology
• WebService is used to integrate the portal with the global distribution system (GDS)
• Oracle is the database

Contribution:
• Project technical manager while outsourcing development.
• Major contribution in testing, customization, implementation, application, and database server administration.

Galileo Management Information System (GBL-MIS)

Scope:
• Full software package for Galileo Bangladesh Ltd (sister concern of MGH) and other NDC for keeping track of assets, earned segments.
• Full automation of hardware purchase, distribution, and maintenance log.
• Competitive analysis report between investment and earned money from markets in terms of segments.

• Financial integration with the group's main accounting software technology:
• Oracle Application Server Forms and Reports Services
• The Oracle Application Server 10g

Contribution:
• Acted as the leading developer and project coordinator.

SMART Implementation in Mauritius, Madagascar, Nepal, and Bangladesh

Scope:
• Galileo, a sister concern of MGH, decided to spread the SMART software among travel agencies of the mentioned countries.
• The main target was to lock the existing customers by providing this software as a value-added service.
• Two major parts of the SMART implementation are sales and finance.
• Automatic data retrieval from the corresponding GDS, namely Amadeus, Abacus, and Galileo system, in the sales module, was a challenge.

Solution details:
• A major study was done to understand the country-specific business need.

Technology:
• Used Oracle Forms 6i for this implementation
• GDS data retrieval was designed in Java

Contribution:
• Acted as a developer.

Omnichannel eCommerce Platform

Developed and managed one of the leading eCommerce platforms of Bangladesh, focused on bridging the gap between online and offline shopping. We built a digital platform for mudir dokan (small-scale retail stores) and helped them create their digital presence.

Languages

Java, SQL, Stored Procedure, XML, C#, Snowflake

Tools

Redmine, SQLyog, Toad, Microsoft Power BI, Data Guard, Microsoft Excel, Power Query, Amazon CloudWatch, RMAN, Navicat, Oracle SQL Data Modeler, Visio, VMware

Paradigms

Database Design, Oracle Database Architecture, ETL, B2B, Business Intelligence (BI)

Platforms

Linux, Amazon Web Services (AWS), Java EE, Oracle, Unix, Oracle Database, Amazon EC2, Mobile, Web, Amazon

Storage

Database Administration (DBA), PL/SQL, PostgreSQL, Database Modeling, MySQL, Oracle SQL Developer, Databases, Oracle 10g, Database Architecture, SQL Stored Procedures, Oracle PL/SQL, Oracle DBA, Amazon Aurora, Database Migration, Oracle 11g, MariaDB, Database Performance, Database Replication, NoSQL, Dynamic SQL, Oracle9i, XML Parsing, Amazon S3 (AWS S3), Oracle RDS, MongoDB, Web SQL, Oracle Database Tuning, Oracle SQL, Relational Databases, Microsoft SQL Server

Industry Expertise

Project Management, Accounting

Other

Technical Project Management, IT Projects, Accounting Systems, Oracle Forms & Reports, Server Administration, Data Migration, Data Architecture, Amazon RDS, Database Schema Design, SaaS, Data Analysis, Data Analytics, Data Engineering, Database Optimization, Excel 365, Dashboards, eCommerce, DAX, Performance Tuning, PL/SQL Tuning, Optimization, Architecture, Metabase, Web Dashboards, Leadership, Critical Thinking, Risk Management, Data Modeling, Data Visualization, Data-driven Dashboards, Distributed Systems, Data Warehouse Design, Projects, Forms, Reports, Document Management Systems (DMS), exp, expdp, IMPDP, Relational Database Services (RDS), Data Administration, Backup & Recovery, Import/Export, Solution Architecture, APIs, API Integration, Data, Email, Solutioning, Solution Design, IT Project Management, Operations Management

Frameworks

Spring

Libraries/APIs

Vue

2014 - 2016

Master of Business Administration Degree in Operations Management

East West University - Bangladesh

2004 - 2008

Bachelor's Degree in Information Technology

University of Peshawar - Pakistan

MARCH 2020 - MARCH 2023

Project Management Professional (PMP)

Project Management Institute (PMI)

DECEMBER 2018 - PRESENT

Agile Certified Practitioner (PMI-ACP)

PMI

FEBRUARY 2016 - PRESENT

Scrum Master Certified (SMC)

SCRUMstudy

MAY 2008 - PRESENT

Oracle Database 10g Administrator Certified Associate

Oracle

SEPTEMBER 2007 - PRESENT

Oracle PL/SQL Developer Certified Associate

Oracle

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring