Detailed JD (Roles and Responsibilities)
JD : SQL Migration Engineer - Demand 203447Y2
- Installation/Upgradation/Migration of Servers.
- Experience on Migrating SQL Server Clusters to Azure Cloud
- Configure, SQL Jobs, SSIS, SSAS, SSRS, Linked servers, credentials etc.
- Involve in Service Management Process
- Apply any patches or service packs for Server.
- Configure High Availability/Disaster recovery solutions.
- Work on incidents, change tickets and problem tickets.
- Setup Maintenance plans for Backups, Database integrity check, rebuild index and Update statistics and make sure to run all the jobs without any issues.
- Execute all changes of DB schema and maintain controlled development database setting.
- Work closely with application developers to test, configure, and optimize servers based on application demands
- Handle database object deployment to Integration, QA, UAT, and Production
- Provide day to day support of high OLTP HA of Server databases- Identify root causes of production problems and work with developers to resolve such problems.
- Work on performance tuning like creating missing indexes.
- Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
- Conduct T- Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
- Attend CAB (Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
- Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
- Work on Writing custom stored procedures, T- queries, PowerShell scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
- Work on writing technical and RCA (Root Cause Analysis) documentation.
- Work on performance tuning like provide suggestions to create indexes
📌 SQL Migration Engineer (Pune)
🏢 Infosys
📍 Pune