About the Role:
- You will design, implement, and maintain database systems to support web application and services.
- Your role involves optimizing database performance and ensuring data integrity and security.
- You will collaborate closely with developers and other stakeholders to align database design with application requirements.
About the Team:
- You will be part of a dynamic and skilled team of database professionals committed to achieving excellence.
- You will have opportunities to mentor junior team members and contribute to team growth through innovation.
You are Responsible for:
- Design and develop scalable database architecture.
- Database migration from legacy system to Azure SQL Managed Instance using Azure Data Factory and other ETL tools.
- Write complex SQL queries, stored procedures, and scripts for advanced data processing.
- Perform database performance tuning and query optimization.
- Implement data security measures, backup, and disaster recovery solutions.
- Manage batch job processing, triggers, scheduled jobs and automate data workflows.
- Monitor database health using Azure tools and perform root cause analysis for problems.
- Collaborate on database design and implementation with developers and infrastructure teams.
- Maintain data integrity and consistency during migration and operations.
- Document migration plans, architecture, and technical details for project and compliance purposes.
- Monitoring and tuning database performance, identifying bottlenecks, and implementing necessary improvements.
- Ensuring effective backup and recovery strategies are in place to safeguard critical data.

Keyskills: Data Migration Stored Procedures Etl Developer SQL Server Azure SQL Managed Instance Data Pipeline Triggers Scheduling Database Developer Scripting
Sonata is a global technology company, that enables successful platform based digital transformation initiatives for enterprises, to create businesses that are connected, open, intelligent and scalable. Sonata€™s Platformation„¢ methodology brings together industry expertise, platform technol...