project required to work upon
1. split the one big sql db into multiple smaller db and maintaining the entity sanctity
2. sql scripting and versioning process to the release
3. migrate east db data to west db and eliminate east db
4. once db is split migrate data to mongodb (this would also require dev team
involvement)
required skills
strong experience with ms sql server - t-sql
experience with data modelling, database design principles
ability to write and execute complex sql scripts for data manipulation, querying, and
reporting.
knowledge of ci/cd pipelines for databases using tools like git or equivalent
analyse database landscapes to identify migration challenges, risks, and opportunities,
translating these into technical specifications and migration plans.
collaborate closely with cross-functional teams to ensure alignment of proposed
migration solutions with technical capabilities and product roadmaps.
prepare comprehensive technical documentation, migration plans, and proposals,
articulating migration strategies, methodologies, and expected outcomes clearly.
stay abreast of the latest trends, tools, and best practices in database migration,
ensuring the proposed solutions incorporate cutting-edge methodologies and
technologies.
planning and executing data migration projects, including moving data from existing
systems to db like mongo db.
soft skills:
strong analytical and problem-solving abilities.
effective communication and documentation skills.
ability to speak to various stakeholders/team like dev team, dba, solution architects,
business analyst etc.
leadership and mentorship qualities.