Database Migration Specialist - Chennai, India - YO HR CONSULTANCY

Description

Database MigrationSpecialistExperience 3 to 6yearsLocation Chennai(hybrid)
Musthave Experience with Databasemigration.
Experience with SQLServer.

KeyResponsibilities:
Design and developdatabase solutions that meet business requirements. This istypically the responsibility of a databasedeveloper. Create and maintain SQL scriptsand stored procedures for data manipulation and retrieval. This istypically the responsibility of a databaseadministrator. Optimize database performancethrough query tuning indexing and other techniques. This istypically the responsibility of a database performanceengineer. Design and implement datamigration plans and strategies.

This includes assessing the sourceand target databases identifying the data that needs to be migratedand developing a plan to migrate the data in a safe and efficientmanner.

Use ETL tools and techniques tomigrate data between different database platforms. This may involveusing thirdparty ETL tools or developing custom ETLsolutions. Cleanse and transform data toensure its accuracy and consistency before it is migrated. This mayinvolve removing duplicate data correcting errors and convertingdata to the appropriate format for the targetdatabase. Test and validate migrated data toensure data integrity. This may involve running queries against themigrated data to compare it to the source data and identifying anydiscrepancies. Work with stakeholders toidentify and resolve data migration issues.

This may involveworking with business analysts developers and testers to understandthe business requirements and ensure that the data migration issuccessful.

Document data migrationprocesses and procedures.

This includes creating documentation thatdescribes the steps involved in the data migration process thetools and techniques used and the tests performed to validate themigrated data.

Developing and maintainingdata migration infrastructure. This may involve setting up andconfiguring servers database software and ETLtools. Automating data migration tasks. Thismay involve using scripting languages or developing customautomation tools. Monitoring data migrationperformance and troubleshooting issues. This may involve usingmonitoring tools to identify and resolve any problems that occurduring the data migrationprocess.

etl,databasemigration,database solutions,ai,data validation,cloudcomputing,monitoring,analytics,sql server,etl tools,ms sql,datacleansing,sql scripts,data migration plans,datamigration