Pradipta is available for hire
Hire PradiptaPradipta Kumar Roy
Verified Expert in Engineering
Software Developer
Kolkata, West Bengal, India
Toptal member since January 18, 2022
Bio
Pradipta is an experienced and accomplished database architect and project manager with over thirteen years of experience leveraging extensive backgrounds in database management, project management, and technical consultancy in different organizations. He has completed the complex upgrade, migration, and implementation projects for reputable international clients like Elisa, HFM, and Dex Media.
Portfolio
Tata Consultancy Services
Databases
Experience
- Linux - 13 years
- Databases - 13 years
- Oracle DBA - 7 years
- IT Service Management (ITSM) - 4 years
- Perl - 3 years
- Amazon Web Services (AWS) - 3 years
- Microsoft Azure - 2 years
- DevOps - 2 years
Availability
Part-time
Preferred Environment
Linux, Databases, Amazon Web Services (AWS), DevOps, Microsoft Azure
The most amazing...
...thing I've achieved is upgrading PeopleTools, Oracle DB, and OS from HP to AIX and migrating all the servers prod, UAT, and dev instances to different hardware.
Work Experience
Database Administrator, PeopleSoft Admin, Database Architect, and Project Manager
2004 - 2018
Tata Consultancy Services
- Provided end-to-end database support for UCO bank branches running company's banking software under Mumbai region. Received a certificate of appreciation from UCO Bank Regional Office, Mumbai.
- Upgraded PeopleSoft PeopleTools, Oracle DB from 10g to 11g, and operating system from HP to AIX while migrating all the servers prod, UAT, and dev instances of PS to different hardware without any issue. Received appreciation from HFMUS, New York.
- Led the replication trigger bug fix discussions with MariaDB for Elisa Oyj. Upgraded all the instances of MariaDB to the latest version. Received a certificate of appreciation and CIO appreciation from Elisa Oyj, Helsinki, Finland.
Technologies: Databases
Experience
UCO Bank | India
• Provided project support for ISBS, banking software.
• Made code changes in Pro*C and installed Oracle 7 along with the ISBS software.
• Fixed implementation bugs.
• Provided run-time application support of ISBS at UCO Bank branches across India.
• Project management for the ISBS Implementation.
• Made code changes in Pro*C and installed Oracle 7 along with the ISBS software.
• Fixed implementation bugs.
• Provided run-time application support of ISBS at UCO Bank branches across India.
• Project management for the ISBS Implementation.
HFMUS | New York, US
• Provided PeopleSoft upgrade support and implementation support for Oracle 10g.
• Conducted data migration from PostgreSQL to MySQL and provided corresponding database support.
Successfully upgraded PeopleSoft PeopleTools, Oracle DB from 10g to 11g, and operating system from HP to AIX alongside migrating all the servers prod, UAT, and dev instances of PS to different hardware without any issue. Received appreciation from HFMUS, New York.
• Conducted data migration from PostgreSQL to MySQL and provided corresponding database support.
Successfully upgraded PeopleSoft PeopleTools, Oracle DB from 10g to 11g, and operating system from HP to AIX alongside migrating all the servers prod, UAT, and dev instances of PS to different hardware without any issue. Received appreciation from HFMUS, New York.
SuperMedia (Dex Media) | Dallas, US
• Provided extensive support for PeopleSoft and Oracle 10g and 11i database and upgraded complex production database environments.
• Project management and onsite and offshore coordination.
• Release management, change management, and appraisal management.
• Performed proof of concept installations for MongoDB and AWS installation and administration.
• Project management and onsite and offshore coordination.
• Release management, change management, and appraisal management.
• Performed proof of concept installations for MongoDB and AWS installation and administration.
Elisa Oyj | Helsinki, Finland
• Database administration, upgrades, and production support for MariaDB. Planning and upgrading Oracle and Postgres databases.
• Complex legacy Perl and Python code changes along with timely migration-upgrade.
• Management of new service developments supporting master data management.
• DevOps activities using Jenkins, Ansible, OpenShift, Docker containerization, and ensuring GDPR compliance of applications, scripts, and demons.
• Project management and onsite and offshore coordination.
• Migration upgrade management and change management coordination.
Successfully upgraded all the instances of MariaDB to the latest version. Led the replication trigger bug fix discussions with MariaDB for Elisa Oyj and received a certificate of appreciation and CIO appreciation.
• Complex legacy Perl and Python code changes along with timely migration-upgrade.
• Management of new service developments supporting master data management.
• DevOps activities using Jenkins, Ansible, OpenShift, Docker containerization, and ensuring GDPR compliance of applications, scripts, and demons.
• Project management and onsite and offshore coordination.
• Migration upgrade management and change management coordination.
Successfully upgraded all the instances of MariaDB to the latest version. Led the replication trigger bug fix discussions with MariaDB for Elisa Oyj and received a certificate of appreciation and CIO appreciation.
Academic Projects | Haaga-Helia University of Applied Sciences
• Developed a chatbot using Dialogflow and Microsoft Azure.
• Data analytics and forecasting projects using Microsoft Azure, Power BI, and SAP Lumira.
• Machine learning project handling Twitter feeds using the KNIME workflow.
• Developed different projects using UiPath robotic automation.
• Breakfast concept design for Delicatessen Restaurant in Finland.
• Written a master’s thesis on a framework for the selection of software-as-a-service products for small and medium-sized enterprises.
• Data analytics and forecasting projects using Microsoft Azure, Power BI, and SAP Lumira.
• Machine learning project handling Twitter feeds using the KNIME workflow.
• Developed different projects using UiPath robotic automation.
• Breakfast concept design for Delicatessen Restaurant in Finland.
• Written a master’s thesis on a framework for the selection of software-as-a-service products for small and medium-sized enterprises.
Certifications
MAY 2020 - PRESENT
RPA Business Analyst Foundation
UiPath
MAY 2020 - PRESENT
RPA Developer Foundation
UiPath
APRIL 2020 - PRESENT
AWS Cloud Practitioner Essentials
AWS
AUGUST 2015 - PRESENT
Oracle Exadata Database Machine 2014 Certified Implementation Specialist
Oracle
MARCH 2015 - PRESENT
ITIL 2011 Foundation Certificate in IT Service Management
Exin
MARCH 2015 - PRESENT
M102: MongoDB for DBAs
MongoDB University
DECEMBER 2014 - PRESENT
Oracle Database 11g Administrator Certified Associate
Oracle
Skills
Tools
Jenkins, Ansible Tower, Ansible, Dialogflow, Microsoft Power BI
Platforms
Linux, Amazon Web Services (AWS), Docker, KNIME
Storage
Databases, Oracle DBA, Database Administration (DBA), MongoDB, MySQL, PostgreSQL, MariaDB
Languages
Python, Perl
Paradigms
DevOps
Other
IT Service Management (ITSM), Microsoft Azure, Robotic Process Automation (RPA), Service Design, PeopleSoft, Shell Scripting, SAP Lumira, UiPath
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