Solution Architect - SQL Server & Data Platform

About Sonata Software :

Sonata Software, with $1 Billion Revenue, is the leading Modernization company. Our unique Modernization approach through Platformation.

AI helps create Efficient and Agile digital businesses to drive intelligent ecosystems of the future. Our bouquet of Modernization Engineering Services cuts across Data, Cloud, Dynamics, Automation, Cyber Security, and around newer technologies like Generative AI, Microsoft Fabric, and other modernization platforms.

Role Overview : We are looking for a SQL Server & Data Platform Solution Architect to join our team.

Key Responsibilities :

- Enterprise level support and administration focused specifically on SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability, Core SQL + Migration, on-premises and cloud.

- SQL Server on IaaS experience on Azure/ Other public cloud required.

- All versions of SQL Server (2012 and onwards).

- Solving performance problems, query tuning, and optimization.

- Architectural experience for Data Platform.

- Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups.

- Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, Azure Synapse knowledge is a plus.

- Delivering and/or authoring technical training.

- SQL Server Integration Services, Reporting Services, Analysis Services.

- Power BI experience and knowledge are a plus.

- Advanced Microsoft certifications preferred.

- Previous Consulting and/or customer facing role.

Technical Skills :

- Data modeling and database design.

- Indexing strategy.

- Performance Optimization and Tuning Capabilities.

- Partitioning data implementations.

- Metadata management and repository usage.

- Database schema creation and management.

- Backup and recovery.

- Ensuring data integrity.

- Ensuring High availability and Disaster recovery.

- SQL code reviews with ability to dissect query plan, T-SQL code.

- Procedural skills.

- Data security.

- Data Encryption.

- Auditing.

- Replication of data.

- SQL Edition and version differences with discontinued and deprecated features.

- Upgrade process.

- Storage management techniques.

- Data Engine Capacity planning.

- General database management, Policy based management.

Skills

SQL Server, Database Design, Database Performance Tuning, Azure, Data Backup, IaaS, DBA, Data Architect, HADR, Data Modeling