
Piyus Kumar
Verified Expert in Engineering
Database Developer
Bengaluru, Karnataka, India
Toptal member since June 18, 2020
Piyus is equipped with 12+ yrs of software development experience in building products in startups, the travel industry, and VMware. With a sound background in mathematics, he loves to play with data. Most of his time was spent writing back-end applications, providing scalable and high availability solutions to the distributed applications, and writing automated test suites and continuous integration to bind the application with a scale of robustness.
Portfolio
Experience
- Linux - 10 years
- Python - 10 years
- PostgreSQL - 8 years
- REST APIs - 8 years
- Django - 7 years
- MySQL - 5 years
- DevOps - 5 years
- Docker - 2 years
Availability
Preferred Environment
Kubernetes, Docker, Go, Python, PostgreSQL
The most amazing...
...thing I have learned is a way to set the baseline of the product and continuously make it better every day,
Work Experience
Senior Member of Technical Staff
VMware
- Made improvements to our product which spawns and deletes 150,000+ VMs every day.
- Completed upgrades with very little downtime by using SQL script in phases and application design acceptability.
- Wrote reporting SQL queries and designed beautiful charts.
- Split several monolithic giant applications into microservices. Used Docker and Kubernetes to host on the cloud with easy deployment and horizontal scalability.
- Wrote a pipeline script in Jenkins and Groovy to enable continuous integration wich verifies your code before submitting.
- Introduced a test-driven development approach that helped set a baseline for our product feature before heading towards production and then later gauges the improvement based on that.
- Improved the backup strategy with logical (pg_dump) and physical (binary files + WALs) backup availability.
Tech Lead
HTMedia Ltd
- Contributed to the revamp of the education portal of the giant Indian media company.
- Improved the time to serve page bytes and rendering time in browsers using Steve Souders' high-performance websites technique. Improved the overall speed by 250%.
- Added a review tool called ReviewBoard to the development process and used it to onboard all the developers across the company.
- Prepared and delivered the training content for Python and MySQL along with coding guidelines for the new members of the company to enhance productivity.
- Improved code quality after writing the unit test as an integral part of the project and increased code coverage.
Product Development Engineer
Knowlarity Communications Pvt Ltd
- Created RESTful APIs using the Knowlus platform to make bulk calls and reporting—2 million calls per day.
- Developed a CRM like a tool in Django using MySQL as the back end to handle the data for the sales team along with the call recordings; they target 10 million SMEs in India.
- Developed a voicelet application using Knowlus back-end API and Facebook graph API. People were able to post voice messages on their Facebook wall following the IVR call instructions.
- Involved in most of the architecture planning and DB migrations.
- Served as the key person for any DB scaling improvement and review; we used PostgreSQL as well as MySQL for different projects.
Software Engineer
TravelBoutiqueOnline
- Integrated GDS for air ticketing e.g. Amadeus and Hermes, for a web panel for booking air tickets and hotels by agents across India—15,000 tickets per day back in 2009.
- Integrated hotel booking sources like HotelBeds, Tourico, and IAN (Expedia).
- Wrote APIs to expose the search and booking for customers to integrate into their portal.
Software Engineer
Viplav Communications Pvt Ltd
- Contributed to desktop software that matches voters in polling booths using Levenshtein distance algorithm for name matching on a probabilistic parameter of matches based on similar phonetic alphabets with acceptance rate 64%.
- Created reports from SQL Server data with a variety of SQL queries.
- Involved in most of the CPU time/memory-based performance improvement on old projects.
Experience
Dashboard Using Python, PostgreSQL, and Highcharts
Customers get an insight into product usage in a different part of the system. It helped them to understand the real use and improve pipeline accuracy.
This has helped us to reduce the daily job numbers by 30% for many old customers and improved the reusability of the components. It gave a pathway to the new customers to accommodate their usage.
Continuous Improvements on The Ongoing Product
Making a shallow clone during the sync phase has sped it up by 5X, as it was earlier loading the whole index for the repo.
Instantiating machines by tracking historical usage and pre-configuration have reduced the machine requesting time by 50%.
Making use of multi-core processing at several places has given performance a boost up.
Wrote client-side binaries in Golang to make it independent of the client OS configuration and ease of use. Since Golang comes with cross-compilation, it has reduced the maintenance of the code and improved developer productivity.
A Giant MySQL Database Migration to PostgreSQL
This was done along with an upgrade to the application which needed to run some offline processing to change the underlying data structures from the old format to the new format.
Added multiprocessing code in Python to handle the in-migration phase smoother and faster.
Adapted a load testing framework for the application to test it well before moving ahead to production.
We did set the baseline for the project to handle the 5X instant load on the production server.
Raahi a Carpool Initiative
Alert and Monitoring Setup Using Grafana
It keeps us aware of the system load and infrastructure status as our current project is mostly dependent on cloud-native applications.
It sends us alerts whenever a threshold is crossed.
HTMedia Educational Background
Developed an SDA (student dashboard access) app using Python, Django, and MySQL. It was used by a team of callers to update certain info after calling the students over the phone, which can later be sent to colleges using an automated filter job.
Knowlarity an Exposure With APIs
Used C/lua based open source FreeSWITCH API and integrated with Python to make an IVR system to make and receive bulk calls. This was using the PRI lines from a telecom service provider and PRI cards to connect them in the computer.
Education
Bachelor of Technology Degree in Computer Science and Engineering
Dr K N Modi Instt of Engg and Technology - Ghaziabad, India
Skills
Libraries/APIs
REST APIs
Tools
Git, Celery, GoLand
Languages
SQL, Python 2, Python 3, Python, C#, Go
Frameworks
Django, Django REST Framework, ASP.NET
Paradigms
Database Design, DevOps, Testing, REST, RESTful Development
Storage
PostgreSQL, MySQL, DB, Databases, Memcached, Database Migration, SQL Server 2005
Platforms
Docker, Kubernetes, Linux, Amazon Web Services (AWS)
Other
Performance Tuning, Database Optimization
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