Customer Engineer / Architect- SQL Server (Data Platform)

ABOUT SONATA SOFTWARE

Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services.

Customer Engineer / Architect- SQL Server/ Data Platform

Permanent Role

Remote (within Egypt)

We are seeking a skilled and experienced SQL Server & Data Platform Solution Architect with expertise in SQL Server, Azure SQL, and Data Warehousing. For SQL Server, there should be a strong focus on Performance, High Availability, and Failover Clustering. An ideal candidate will play a key role in design, development and optimization of SQL Server Data Platform deployments as well as assisting in migration and modernization to Azure.

Skills/ Job expertise needed

· Enterprise level support and administration focused specifically on:

o 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

Mandatory o Data modeling and database design.

o Indexing strategy o Performance Optimization and Tuning Capabilities o Partitioning data implementations o Metadata management and repository usage.

o Database schema creation and management.

o Backup and recovery.

o Ensuring data integrity.

o Ensuring High availability and Disaster recovery.

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

o Data security.

o Data Encryption o Auditing o Replication of data o SQL Edition and version differences with discontinued and deprecated features o Upgrade process.

o Storage management techniques.

o Data Engine Capacity planning.

o General database management, Policy based management.

o Extended events and Traces o Basic Licensing and support scenarios o Windows Failover Clustering o SQL Server Reporting service o SQL server Integration Service o SQL Server Analysis Service o Power Shell development skills needed.

Why join Sonata Software?

At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes net.