Database Architect

Project required to work upon

1. Split the one big SQL DB into multiple smaller DBs and maintain the entity sanctity.

2. SQL Scripting and versioning process for 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 equivalentAnalyse 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 a DB like MongoDB.

Soft Skills:

Strong analytical and problem-solving abilities.

Effective communication and documentation skills.

Ability to speak to various stakeholders/teams like Dev Team, DBA, Solution architects, business analyst, etc.

Leadership and mentorship qualities.

Job Types: Full-time, Contractual / Temporary
Contract length: 6 months

Pay: ₹383,918.95 - ₹1,458,355.09 per year

Application Question(s):

• Have you worked on splitting the SQL DBs & SQL Scripting?
• Do you have experience in data modelling, database design principles?

Experience:

• Microsoft SQL Server: 6 years (Preferred)

Work Location: Remote