Amit Malakar
DB Migration Specialist/ Database Administrator/ Cloud Consultant
Bangalore
Summary
Highly skilled and results-driven Database Administrator and DB Migration Specialist with 14 years of experience in managing, optimizing, and migrating enterprise-level databases. Expertise in cloud infrastructure and cloud migration services, including comprehensive knowledge of AWS.Adept at leveraging DevOps principles and tools like Docker and Git to streamline database deployments and enhance operational efficiency.
Overview
2026
2026
years of professional experience
3
3
Languages
Work History
Technical Lead
Data Template Infotech Pvt. Ltd.
02.2023 - Current
- Company Overview: Through innovative solutions, progressive technologies and strong alliances, ClosingCorp delivers timely, accurate and transparent results that help optimize closing processes and services for mortgage lenders, title and settlement companies and real estate professionals
- Worked as a SSIS team lead for this project
- Involved in all client discuss regarding different activities to be implemented
- Need to assign ticket as raised by the client to team members
- Support and guide the team so that there will be no impact on deliverables
- Migrated around 26 Databases from Azure platform to AWS platform
- Migrated SSIS server from Azure to AWS platform
- Migrated SSRS server from Azure to AWS Platform
- Configured HA configuration on two nodes and one listener in EC2 hosted SQL servers
- Suggested and guide the team to develop a SSIS package to migrate the databases
- Fixed issues during the migration and also post migration
- Created report which hold the detailed information about the migration of databases.
- Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.
- Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
- Implemented continuous integration and deployment strategies for faster release cycles and improved application reliability.
- Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
Technical Lead
HCL Technologies Pvt. Ltd.
08.2015 - 02.2023
- Company Overview: We manage the network that distributes natural and green gas to 5.9 million homes and businesses across Scotland and the south of England. Whoever your supplier is, our pipes deliver gas safely, reliably and efficiently to every one of our customers.
- Worked as a DevOps and SQL DBA team lead for this project
- Involved in all client discuss regarding different activities to be implemented in respect to cost optimization
- Involved in all the discussion with client for the implementation of AWS recommendation given by AWS, towards different AWS resources like RDS, EC2, EBS volumes etc
- Accomplish all the three types of monthly patching (Manual, Inline and Blue Green) for around 40 application in lower environment and Production every month
- Accomplish the new requirement in respect to provision new environment for different application end - to -end
- Worked closely with the development and operations organizations to implement the necessary tools and process to support the automation of builds, deployments, testing and infrastructure (infrastructure as code)
- Responsible for code build, release and configuration on Amazon EC2
- Establish CI/CD for trunk and branches to support parallel development
- Monitor the UAT/Production Environments for any down time issues by performing regular cron job updates in servers
- Worked closely with Amazon management service
- Created triggers, alarms and notifications for EC2 hosts using Cloud Watch
- As a DBA lead involve in all the activities towards RDS and SQL Server like creating new RDS, Creating Policies, HA configuration on two node and one listener in EC2 hosted SQL servers
- Involved in restore and Backup activities
- Creating roles and securities
- Involved in creating SQL procedures and triggers etc
- Involved to resolve different types of data related issues
- Written different shell scripts to automate the installation of SQL server and deployment of SSIS packages in the SQL server
- Involved in the configuration of SMTP server to trigger the jobs from SQL Agent jobs for different purpose.
Sr. Software Engineer
Nexgen Technology Services Pvt. Ltd.
09.2012 - 07.2015
- Company Overview: Crate & Barrel was started in 1962 by Gordon and Carole Segal. Their stores create an inspiring setting for their popular house wares and extensive furniture collection
- Worked on SSIS Packages, which involves the Transformations like Merge join, Lookup, Aggregate, Merge, SCD, Derived columns, Union All, Conditional Split
- Generated Reports on Daily Basis for tallying the sales
- Generated multiple Enterprise reports using SSRS from SQL Server (OLTP) and SQL (OLAP) and reporting as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink), Cascading Parameters, Parameterized Reports(single valued parameters, multi-value parameters) etc.
Sr. Software Engineer
Nexgen Technology Services Pvt. Ltd.
07.2011 - 05.2015
- Company Overview: Founded by Mar grit and Marcel Schurman in 1950, PAPYRUS and each of its uniquely creative divisions continue to uphold the principles by which the company began: To always offer products of the highest possible quality, to lead the market in product innovation, to remain focused on superior service and to strive for continued customer satisfaction
- Worked on SSIS Packages, which involves the Transformations like Conditional Split, Lookup, Aggregate, Merge, SCD, Derived columns, Union All, Merge join
- Used Control Flow like for Loop Container, SQL Task, File system task and Data Flow Task in Designing packages
- Hands on experience of scheduling the packages in SQL server Agent
- Experience in providing Logging, Error handling by using Handler
- Analyzing the problem and solving SQL related issues.
Software Engineer
Dion Global Solutions Ltd. (Formerly known as Religare Technova Ltd.)
- Company Overview: This project has been developed for Religare Securities Ltd.This project is upgrade version of Unison developed in VB.Net using new technologies like user interface of VB.Net 2005, DTS
- Developing business process & database designing
- Developing Database process using Stored Procedure, Complex Queries, Joins Triggers, Functions, and DTS Packages
- Optimization of Database by optimizing the store procedures
- Manage database performance
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
- Communicated with clients to ensure end-user information discrepancies resolved.
Software Engineer
Dion Global Solutions Ltd. (Formerly known as Religare Technova Ltd.)
- Company Overview: Surveillance is a window based system that monitors all the activities performed by the various clients involved in trading
- Developing business process & database designing
- Developing Database process using Stored Procedure, Complex Queries, Joins, Triggers, Functions, and DTS Packages
- Resolving customer issues involving front end and Database issues
- Surveillance is a window based system that monitors all the activities performed by the various clients involved in trading.
Education
Master - Computer Science
Assam University
Skills
OPERATING SYSTEMS: Windows XP, Vista, Windows 7, Window Server 2003 and 2008 R2,2012
DATABASES: SQL Server 2008, 2005, 2000,2012, PostgreSQL
DW/BI TOOLS: SQL Server Integration Services (SSIS),
Business Intelligence Development Studio (BIDS)
FRAMEWORK: Dot Net
VERSION CONTROL SYSTEMS : GITHUB
BUILD TOOL : MAVEN
CONTINUES INTEGRATION TOOL : JENKIN
IAAC (Infrastructure as a code) : CLOUD FORMATION
LOG ANALYSIS TOOL : SPLUNK
PERFORMANCE MONITORING TOOL : NAGIOS
CLOUD TECHNOLOGY : Amazon Web Services (AWS)
DB MIGRATION TOOLS: AWS DMS, ETL Tools
Team collaboration
Agile methodologies
Project documentation
Personal Information
Date of Birth: 12/02/83
Timeline
Technical Lead
Data Template Infotech Pvt. Ltd.
02.2023 - Current
Technical Lead
HCL Technologies Pvt. Ltd.
08.2015 - 02.2023
Sr. Software Engineer
Nexgen Technology Services Pvt. Ltd.
09.2012 - 07.2015
Sr. Software Engineer
Nexgen Technology Services Pvt. Ltd.
07.2011 - 05.2015
Software Engineer
Dion Global Solutions Ltd. (Formerly known as Religare Technova Ltd.)
Software Engineer
Dion Global Solutions Ltd. (Formerly known as Religare Technova Ltd.)
Master - Computer Science
Assam University
Similar Profiles
Megha KoshleMegha Koshle
Development Manager at Electronic Arts & Game Pvt. LtdDevelopment Manager at Electronic Arts & Game Pvt. Ltd
Khubeb Ishaq ShaikhKhubeb Ishaq Shaikh
Consultant at Alpha Data Processing Pvt. Ltd And 3i-Infotech Pvt Ltd For ICICI BankConsultant at Alpha Data Processing Pvt. Ltd And 3i-Infotech Pvt Ltd For ICICI Bank
Madhumala GMadhumala G
Technical Executive at Data Collection Infotech (India) Private LimitedTechnical Executive at Data Collection Infotech (India) Private Limited