S M Shafiqul Islam
Verified Expert in Engineering
Software Developer
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
Experience
- Database Administration (DBA) - 13 years
- Oracle - 12 years
- SQL - 12 years
- Database Design - 10 years
- Databases - 10 years
- Database Modeling - 10 years
- MySQL - 8 years
- PostgreSQL - 7 years
Availability
Preferred Environment
PL/SQL, SQL, MySQL, Oracle, Database Administration (DBA), Database Design, Microsoft Power BI, PostgreSQL, Performance Tuning, Amazon, Windows
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
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.
Oracle Database Architect (Contract)
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.
Head of Product Development
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.
Development Manager | Solution Architect
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.
Database Architect
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.
DBA and Development Lead
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).
Manager (IT) | Group DBA & Technical Lead
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.
Assistant Manager | DBA & Developer
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.
Senior Software Engineer | Database Developer
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.
Programmer
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.
Experience
DB Consolidation
https://www.aurea.com/• 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/• 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
• 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
• 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
• 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
• 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
• 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)
• 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
• 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
Education
Master of Business Administration Degree in Operations Management
East West University - Bangladesh
Bachelor's Degree in Information Technology
University of Peshawar - Pakistan
Certifications
Project Management Professional (PMP)
Project Management Institute (PMI)
Agile Certified Practitioner (PMI-ACP)
PMI
Scrum Master Certified (SMC)
SCRUMstudy
Oracle Database 10g Administrator Certified Associate
Oracle
Oracle PL/SQL Developer Certified Associate
Oracle
Skills
Libraries/APIs
REST APIs, Vue
Tools
Redmine, SQLyog, Toad, Microsoft Power BI, Data Guard, Microsoft Excel, Power Query, Amazon CloudWatch, Google Analytics, RMAN, Navicat, Oracle SQL Data Modeler, Visio, VMware
Languages
Java, SQL, Stored Procedure, XML, C#, Snowflake
Paradigms
Database Design, Business Intelligence (BI), Oracle Database Architecture, ETL, B2B
Platforms
Linux, Amazon Web Services (AWS), Java EE, Oracle, Unix, Oracle Database, Windows, 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, Oracle Rdb, 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
Frameworks
Spring
Other
Technical Project Management, IT Projects, Accounting Systems, Oracle Forms & Reports, Server Administration, Data Migration, APIs, 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, Dashboard Development, BI Reports, Data Reporting, Oracle ASM, Data Modeling, Data Visualization, Data-driven Dashboards, Distributed Systems, Data Warehouse Design, UX Testing, Projects, Forms, Reports, Document Management Systems (DMS), exp, expdp, IMPDP, Relational Database Services (RDS), Data Administration, Backup & Recovery, Import/Export, Solution Architecture, API Integration, Data, Email, Solutioning, Solution Design, IT Project Management, Operations Management
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring