AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF13754
profile image
Samaddar D AXF13754 Active
SQL Server DBA in Noida
Professional Summary: • Proven track record of handling end-to-end projects, including design, implementation, managing and post-production support. • Expertise in MS SQL Server and Oracle Database Administration, Data Migration, and Performance Tuning. • Proficient in ETL tools (Hitachi Pentaho) and cloud platforms (Microsoft Azure). • Strong diagnostic and problem-solving skills, ensuring optimal database performance and security. • Extensive experience in client-site and onsite project implementation, rollout, and post-production support. • Skilled in working with diverse domains, including Banking, Credit Monitoring Security, Automobile, Manufacturing, Hospitality, Entertainment, Payroll. ➢ Professional Skills: • Database: - MS SQL Server 2019 and earlier, Oracle 19C, Microsoft Azure, MySql, Teradata • Programming Skills: - PL Sql, HTML, D2k, Python • Operating System: - Windows • Tools: - ETL Pentaho, Microsoft Azure, TFS, Toad, Query Surge, RedGate SQL Data Generator, JIRA, Visual Studio • Testing Skills: - Performance Testing and Optimization, Monitoring, Report Analysis
Industries : BFSI, Hospitality, Automobile
Share
Hire Samaddar D
Download PDF
Availability
Full-time
Total experience
13 years
Technical skills
Database development
12 Years
Performance optimisation
10 Years
Database Administration
8 Years
data migration
7 Years
ETL Processes
5 Years
MS SQL Server 2017, Oracle 19c, Microsoft Azure, ETL Pentaho, Teradata, Data Warehouse Tools: SSMS, Query Surge, Teradata developer, SSMS, Database: MS SQL Server 2012 Tools: SSMS, Visual Studio 2013, TFS, DM tool by Niit
Projects
UCO Bank - EWS (Early Warning Signal for Securities on Loans)
April-2021 to
Description
Develop and maintenance of product EWS (Early Warning Signal) for client UCO bank. Production support, performance optimisation, defect solutions, data extraction and transformation using ETL, Security and backup maintenance.
Roles and Responsibilities
• Led database team of 6 members, product development, and production support. • Database design, query tuning and optimization, administration and maintenance of multiple databases. • Successfully migrated legacy databases to newer versions of MSSQL Server and Oracle DB. • Designed and executed ETL processes for streamlined data workflows for the migration project. • Implemented database backup and recovery strategies, ensuring minimal downtime and data loss during system failures. • Developed and maintained PL/Sql packages and Sql procedures as per RBI and DFS guidelines. • Install, configure and maintain DBMS. Manage database users, permissions and roles.
Technologies: MS SQL Server 2017, Oracle 19c, Microsoft Azure, ETL Pentaho
Industry: BFSI
CAESARS
June-2018 to April-2021
Description
Migration of existing legacy data to new system. Data validation. Performance optimisation. Sql DBA activity.
Roles and Responsibilities
Led migration project to Migrate legacy data to MSSQL Server and Azure SQL DB. Post deployment data validation with Teradata DB. • Implemented automated backup and recovery process. • Worked on data analysis processes for validating data between different legacy systems. • Managed performance and tuning of MS SQL queries and reports. • Database design, optimization, high availability and disaster recover solution.
Technologies: Teradata, MS SQL Server 2017, Data Warehouse Tools: SSMS, Query Surge, Teradata developer, SSMS
Industry: Hospitality
MIRAI Dealer Management System for Isuzu
September-2014 to September-2018
Description
Database development, performance tuning, data migration.
Roles and Responsibilities
• Customized and create DB objects for data migration tool based on business functionality. • Design and implemented scalable database solution for new migration environment. • Executed data migration processes for Rollout and Go Live activities. • Monitored and diagnosed performance issues, conducting detailed analysis and implementing performance tuning techniques. • Implemented and optimized database security measures, including user access controls and encryption protocols.
Technologies: Database: MS SQL Server 2012 Tools: SSMS, Visual Studio 2013, TFS, DM tool by Niit
Industry: Automobile
Work history
Technical Lead(DBA) • April-2021
Description: • Led database team of 6 members, product development, and production support. • Database design, query tuning and optimization, administration and maintenance of multiple databases. • Successfully migrated legacy databases to newer versions of MSSQL Server and Oracle DB. • Designed and executed ETL processes for streamlined data workflows for the migration project. • Implemented database backup and recovery strategies, ensuring minimal downtime and data loss during system failures. • Developed and maintained PL/Sql packages and Sql procedures as per RBI and DFS guidelines. • Install, configure and maintain DBMS. Manage database users, permissions and roles.
Technical analyst • June-2011 to April-2021
Coforge ltd
Description: • Led migration project to Migrate legacy data to MSSQL Server and Azure SQL DB. Post deployment data validation with Teradata DB. • Implemented automated backup and recovery process. • Worked on data analysis processes for validating data between different legacy systems. • Managed performance and tuning of MS SQL queries and reports. • Database design, optimization, high availability and disaster recover solution.
Education
Bachelors degree in Software engineering
Niit ltd
2007 to 2011
Language
English - Advanced