JD:
Develop the required logic for mapping data from old systems(DB) to the new system(DB)
● create a SQL job to migrate data
● Need to be an expert in DB and migrating data from multiple old DB's to new DB. And
also possess the ability to handle transformations between DB
● Understand the existing Stored Procedures, functions and triggers
● Need to be able to handle task independently once the documentation required for the
development of functionality has been shared
● the capability to drive the client discussions independently as required.
Key Skills:
1. He should be good with MSSQL writing procedures, functions, triggers and optimizing the
queries
2. Git, Agile, Scrum
Roles & Responsibilities:
Understanding of MS SQL server DB, should be through with SQL procedures,views,
Jobs able to help in DB administration jobs like backup, restore, creating new user and
permissions management
- Should be able to optimize queries for maximum performance
- Must have data migrations experience, merging multiple databases
- Positive attitude towards getting things done along with the ability to work independently
- Able to think and work independently to contribute to the project
- Able to talk to the client, and solve the problems
- Building reusable procedures for future use
- Optimizing queries for maximum performance
- Participate in the full life-cycle development process from product definition, through
design, development, test, release and maintenance.
- Experience using tools Jira, Git
- Perform Code reviews and provide recommendations for improvements
Good to have Skills:
DB administrative tasks like backups, restoring and user access