Customer Engineer / Architect- SQL Server (Data Platform)
Description
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.
Skills
Sign in to read and join the discussion.