Role : Database Migration
- Design and implement solutions using indigenous database scripts and proprietary as well as third party tools like Microsoft smart bulk copy, Cosmosdb data migration tool and DMS to migrate data seamlessly across platforms in an automated manner through integrated run time environments. Plan, execute, and validate online and offline data migration strategies for enterprise-scale databases.
- HA / DR : Develop and implement high availability and disaster recovery solutions for migrated databases in AWS and Azure for various databases especially Azure SQL database, AWS RDS Mysql database, Cosmos DB and DyanamoDB.
- Leadership & Mentorship : Provide guidance and mentorship to junior data engineers and peers, fostering a culture of continuous learning and development within the team.
- Security and Compliance : Ensure that data handling practices comply with industry standards and regulations, maintaining the highest levels of data security and privacy in line with client expectations which includes migrating databases with PII and PHI data.
- Collaboration : Work closely with our clients business stakeholder, their data engineer and data scientists, AI researchers, and software engineers and solution architects.
- Innovation : Stay abreast of the latest advancements in data engineering, AI, and machine learning technologies, and apply this knowledge to improve our clients data landscape and capabilities.
Experience and skills youll use to solve :
Experience in multiple databases in an enterprise setting preferably on Azure and AWSExperience in migrating databases from on-prem to cloud platforms like AWS and Azure or across cloud platforms or across subscriptions in Azure and AWS.Utilize tools such as Azure DMS, AWS DMS, AWS Glue, Cosmosdb data migration tool, smart bulk copy tool etc. to manage end-to-end database migration lifecycle.Automate database schema deployment and ensure consistency across dev, test, and production environments with respect to database objects and user profilesAssess and handle large database migrations, ensuring minimal downtime and data integrity.Configure, manage, and monitor Azure SQL Databases using vCore / DTU models.Manage and administer AWS RDS for SQL Server, ensuring backup strategies align with recovery objectives.Design, configure, and optimize DynamoDB tables, indexes, and throughput capacity.Hands on exposure to AWS RDS, AWS DynamoDB, Azure SQL Server, Azure CosmosDB preferably as database administratorConfiguring high availability and disaster recovery solutions for databases including but not restricted to AWS RDS, AWS DynamoDB, Azure SQL Server, Azure CosmosDB.Added preference will be given to candidates to have hands on exposure to cross account data replications for various databases.Working knowledge with modern data architecture and platforms : Azure Blob storage, AWS S3 with working knowledge of migrating data using tools like Az copy and AWS Data SyncAdvanced knowledge of SQL language, proficiency with Python for data validation and analysisProblem-Solving : Strong analytical and problem-solving skills, with the ability to think critically and creatively.Communication : Excellent verbal and written communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.Ability to work independently and in a team.(ref : hirist.tech)