Muhmud Ahmad
Verified Expert in Engineering
Database and Data Engineering Developer
For over the past 20 years, Muhmud has been working with database services, mainly in the UK. He is a specialist in database development, administration, and business intelligence. Muhmud is also an accomplished Java/Spring full-stack developer, and AWS DevOps engineer, using tools such as Gitlab, Docker, and Kubernetes. More recently, he has also been involved with Go and Rust development. Muhmud's highly developed, hybrid skill set makes him a tremendous asset to any team.
Portfolio
Experience
Availability
Preferred Environment
Amazon Web Services (AWS), PostgreSQL, MySQL, Spring, Java, Docker, Go, Rust
The most amazing...
...我参与的项目是使用MS SQL和 .NET to provide real-time business intelligence.
Work Experience
Rust/Go/C Developer
Anjuna
- Developed and maintained back-end services written in Go.
- Deployed Kubernetes clusters on Amazon EKS and Azure AKS using Terraform.
- Built and maintained complex CI pipelines using Jenkins and Groovy.
- Maintained low-level, customer-facing applications written in Go, Rust, and C.
- Wrote automated system tests using Python and Pytest.
Senior Developer
Design Barn, Inc.
- 使用Make创建了一个跨平台构建系统,用于编译具有多个C/ c++依赖关系的Rust库, which would also be accessed via UniFFI by Android, Mac/iOS, and WASM.
- Used Emscripten to compile Rust and add bindings for access through WASM.
- 设置GitHub操作来控制发布过程,上传发布工件并验证pr.
- 帮助指导Rust开发,帮助最佳实践,并为最佳性能提供建议.
Data | Java Architect
Yara
- Designed a migration path for a web application from monolith to microservices. The web application has more than 100,000 users.
- Led a team of four developers to implement the designed application migration path.
- Took ownership of all PostgreSQL changes related to the migration.
- 设计数据库表结构,允许Outbox模式实现数据流到Apache Kafka.
Database Architect | Java Lead | AWS Architect
Open Practice Solutions
- Designed a database, optimized queries, indexed, and performed administration work for MySQL.
- 设计并部署了一个新的MySQL数据库环境到一个基于aws的带有ZFS存储的Galera集群.
- Led the design and development of new micro-services environment using Java and Spring WebFlux, and implemented services for payments and notifications.
- Containerized all application deployments and migrated to Docker.
- Built the AWS cloud environment from scratch, including site-to-site VPN, cross-site DNS, AWS Auto Scaling, database deployment, Redis caching, and more.
- 为使用Graphite的所有AWS和私有云服务器和应用程序设计并实现了一个监控平台, ElasticSearch, logstash, Telegraf, and Grafana.
- 使用Java、MySQL、Debezium和Apache Kafka构建了一个事件驱动的流数据管道解决方案.
- 使用MonetDB列式数据库和Pentaho Mondrian OLAP服务器,设计并实现了OLAP数据分析平台.
Technical Writer
IOD (via Toptal)
- Wrote technical articles, whitepapers, and blog posts for NetApp relating to their latest cloud offerings, including ONTAP Cloud and Cloud Sync.
- Worked with stakeholders to create ideas for new articles, determine article scope, and review changes.
- 使用ONTAP Cloud在AWS中执行概念验证和性能测试工作,以便为各种文章提供统计数据和测试结果.
- Ensured the technical accuracy of articles produced by other writers.
Database Architect | Node.js Developer
Perdoor (via Toptal)
- Designed and implemented a back-end RESTful API for mobile property app, including a database design and development using MySQL.
- Developed Node.js and JavaScript API using Express.js and Swagger.
- Worked with project owner to aid in product development and design of the iOS mobile app UI.
- Deployed all back-end services to AWS and the setup of cloud-based dev/test environments.
AWS RDS | Database Developer
Quick, Inc. (via Toptal)
- Designed new, relational database schema in PostgreSQL for migration to AWS RDS from existing Firebase system.
- Created the full documentation, including database diagrams, design overview, additional functionality, such as for encryption-at-rest & field-level encryption, etc.
- Built models in JavaScript using the Objection.js ORM for access to the database with tests created for basic CRUD operations.
- 构建了一种在JavaScript中自动处理PostgreSQL类型到JSON的机制,允许在客户端轻松操作数据,并在数据库服务器中结构化存储.
- 创建了其他JavaScript数据库维护功能,例如为PostgreSQL枚举添加值, generating unique user-friendly ID values with efficient duplicate handling, etc.
Database Designer | Node.js Developer
Humanlytics (via Toptal)
- 完全重新设计了由中国开发人员创建的MS SQL数据库系统,该系统需要通过翻译的Skype会话与中国团队合作以了解需求.
- 编写迁移脚本,从现有数据填充新的数据库模式,并执行协调以确保迁移的数据是准确的.
- Developed a RESTful API from scratch using Node.js (ESLint, Flow, Jest, Sequelize) and based on the newly developed database system.
- 为报表创建API端点,使用户能够指定自定义数据仓库样式的聚合查询,从而为仪表板和报表返回数据.
- 实现了Apache Solr,为客户、人员、部门等提供搜索功能. 开发独立的业务逻辑模块,用于工资计算,具有完整的单元测试覆盖率.
- Managed the set up and deployment of the API and front-end UI in AWS and Ali Cloud using Docker. Created a daily database refresh mechanism for the new database system hosted in Ali Cloud RDS.
Data Engineer | BI Developer
Cartful Solutions, Inc. (via Toptal)
- Developed complex reporting functions in SQL for event data stored in Amazon RDS for PostgreSQL.
- Made significant use of PostgreSQL JSON support to query event payloads.
- Designed a reporting schema for the data to be hosted on Amazon RedShift.
- Developed an ETL process for the event data to be loaded into the reporting schema.
CTO
Vedel IT Sdn Bhd
- Developed a back-end REST API for an in-house recruitment system using Java and PostgreSQL.
- Took ownership of the technical evaluation for new hires in various technology areas.
- Provided presales technical consultations for prospective clients.
- 对公司后台流程的竞争第三方软件平台进行结构化评估.
- Implemented the line management for the company's internal IT team.
SQL Server BI Architect
Cubic Transportation Systems Ltd.
- 使用SQL Server 2014 Analysis Services设计并实现了一个涉及会计和运营数据仓库的项目.
- Developed a web application to manage invoicing information using ASP.NET MVC and AngularJS.
- Built a back-end SOAP web service in C# to support the invoicing application's front-end.
- Implemented an SSIS ETL process to pull data from multiple data sources, including Oracle.
- Performed on-call support for the TfL's (Transport for London) SQL Server infrastructure.
MySQL Database Administrator and Developer
City Link, Ltd.
- 将MySQL服务器从物理云迁移和升级到虚拟云,包括配置审查, performance testing of new servers, and setup of replication for high availability.
- Developed a message processing back-end system using Java, RabbitMQ, and Memcached for the processing of over a million real-time messages per day.
- Built a WebSockets-based web front-end dashboards for real-time reporting using D3.js.
- Assessed various NoSQL solutions, including Redis and Riak, to be used alongside MySQL.
- Designed and implemented a financial data warehouse using SQL Server Analysis Services.
Database Architect
Aspect Capital, Ltd.
- Rearchitected the legacy environment from multiple platforms, including Oracle and MySQL, to a single MS SQL environment with OLTP and reporting clear separation.
- 在NetApp SAN基础架构之上实现了一个系统,以提供基于快照的备份/恢复,并为任何大小的数据库即时创建可写克隆副本以供测试.
- 为高可用性设置一个数据库镜像,并实现PowerShell脚本来执行故障转移.
- Developed a transformative transactional replication system using C++, CLI, and MS SQL features, such as CDC and Service Broker, to implement a real-time reporting system.
- 为三个相互竞争的平台执行POC,以托管具有数十亿行量的金融tick数据库, including Oracle Hybrid Columnar Compression (HCC) and Vertica.
- Applied a PowerShell-based SQL Server build system for performing repeatable server builds, allowing for full operating system and database server configuration.
- Implemented a Windows service using C++ and CLI to manage the MS SQL database environment, including backups, maintenance, archiving, monitoring, and documentation.
- Used XSLT to create code generators for Java, C++, CLR, and SQL.
MS SQL | DBA | Developer
Newchurch Ltd.
- 为托管外部访问的报告后端的双节点故障转移集群环境管理一个MS SQL服务器.
- Maintained Oracle development servers as well as provided support and advice to .NET and database developers.
- Designed and implemented a large-scale Oracle batch processing system using PL/SQL and Java.
- 使用Oracle实现了一个医院事件统计数据转换系统,该系统具有复杂的多行计算功能.
- 使用XSLT在Oracle中为数据清理和转换服务生成PL/SQL代码,并创建XML数据报告.
Developer
The Retail Experience, Ltd.
- Developed a handheld-based productivity system for a major footwear retailer.
- 构建了一个PoC,使用MS SQL复制来管理300个远程站点的数据分布.
- Implemented a complex reporting SQL for the company's back-end MIS reporting system.
- 实现了系统的委托部分,包括应用程序开发和后台SQL报表.
Experience
Business Intelligence Project for Healthcare Sector
AWS Migration from Private Cloud Provider
Java/Spring Boot Microservices Development
qsh - Query SHell
http://github.com/muhmud/qshRelated Blog: http://medium.com/@muhmud.ahmad/improving-on-the-command-line-sql-experience-48c2b544c71b
Smart.SqlClr
http://github.com/muhmud/Smart.SqlClrSkills
Languages
T-SQL (Transact-SQL), SQL, Java, C#, C++/CLI, XML, XSLT, MDX, Bash, XSD, C++, Go, C, Visual Basic, PHP, Python, JavaScript, Scala, CSS3, HTML5, GraphQL, Snowflake, Rust, Kotlin, Swift
Tools
SSAS, Eclipse IDE, Apache Maven, Emacs, Solr, Jira, Git, Docker Compose, ELK (Elastic Stack), Logstash, Zenoss, DTS, Grafana, Mondrian, Terraform, Visio, Amazon Simple Email Service (SES), Microsoft Visual Studio, RabbitMQ, TFS, Erwin, AccuRev, ScalaTest, AWS SDK, GitLab, Kibana, Jenkins, Xcode
Paradigms
ETL, Entity-relationship Diagrams, Business Intelligence (BI), Test-driven Development (TDD), Scrum, REST, OLAP, Microservices, RESTful Development, Model View Controller (MVC), Functional Programming, Behavior-driven Development (BDD), Reactive Programming, DevOps, Cross-platform
Storage
PostgreSQL, Database Administration (DBA), Database Modeling, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Database Migration, MySQL, Database Replication, NetApp, Oracle PL/SQL, JSON, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), PL/SQL, Redshift, Database Management Systems (DBMS), MariaDB, MonetDB, Vertica, NoSQL, Redis, Riak, Memcached, Amazon S3 (AWS S3), Elasticsearch, Databases, MongoDB
Other
Data Engineering, Data Architecture, Data, Data Warehousing, Query Optimization, Software Development, Data Warehouse Design, Freelancing, Back-end, Business Continuity & Disaster Recovery (BCDR), SANs, SSH, SMO, Architecture, Multithreading, Relational Database Services (RDS), Business, Reporting, Boot, Galera Cluster, Graphite, Shell Scripting, RESTful Microservices, Entity Relationships, SOAP, SCOM, WebSockets, Clustering, IIS, High Availability Disaster Recovery (HADR), Cloud, TypeORM, Apollo, Computer Science, Scripting, Cross-compilation, Lottie, Graphics
Frameworks
Spring, Windows PowerShell, .NET, JUnit, Dropwizard, Hibernate, Spring 5, Express.js, Swagger, Spring Boot, ASP.NET, WebFlux, AngularJS, Lift, JNI
Libraries/APIs
Node.js, Objection.js, Vue, D3.js, REST APIs
Platforms
Oracle, Amazon EC2, Linux, Windows Server, Docker, Azure, Firebase, Amazon Web Services (AWS), Apache Kafka, Kubernetes, Android, iOS
Education
Bachelor's Degree in Computer Science (Software Engineering)
Wolverhampton University - Wolverhampton, UK
How to Work with Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring