SQL Server Consultant

Job Description

<p>Role Name:- <span>SQL Server</span></p><p>Location:-<span>Egypt</span></p><p><span>Experience:-</span><span>7-15 Years</span></p><p><span>Notice Period :-Immediate Joiner/15days Max</span></p><p><br></p><p><strong>Job Description </strong></p><p><span>We need individuals that:</span></p><p><br></p><p>• Possess deep technical expertise in at least one technical specialty and can solve complex technical problems through sound, creative troubleshooting. You will also need to be able to examine possible workarounds and escalations as required.</p><p>• Set an example of excellence as a Microsoft representative, enhancing the company’s image and reputation through your credibility, preparation, commitment, and first-class delivery.</p><p>• Demonstrate strong communication skills; ability to develop strategic on-going customer relationships, gain trust and respect for the company. Engineers must also possess strong technical writing, presentation and training skills.</p><p>• Enjoy team work, and actively contribute to their peer group as well as our customer account teams.</p><p>• Communicate at all levels from CIO to the technical staff on the ground.</p><p><br></p><p><strong>Expertise Required </strong></p><p><span>• Experience in the enterprise customer arena</span></p><p><span>• Face-to-face customer engagement skills</span></p><p><span>• Excellent written, oral and presentation skills</span></p><p><span>• Troubleshooting knowledge &amp; skills</span></p><p><span>• Degree qualification or equivalent experience</span></p><p><span>• Good understanding of ITIL/Service Management</span></p><p><br></p><p><strong>Technical Expertise Required </strong></p><p><br></p><p><strong>SQL Server &amp; Data</strong></p><p><strong>The role requires depth knowledge in a number of the following technology areas:</strong></p><p><br></p><p><strong>Mandatory</strong></p><p><span>• Data modeling and database design.</span></p><p><span>• Indexing strategy </span></p><p><span>• Performance Optimization and Tuning Capabilities</span></p><p><span>• Partitioning data implementations</span></p><p><span>• Metadata management and repository usage. </span></p><p><span>• Database schema creation and management. </span></p><p><span>• Backup and recovery. </span></p><p><span>• Ensuring data integrity. </span></p><p><span>• Ensuring High availability and Disaster recovery. </span></p><p><span>• SQL code reviews with ability to dissect query plan, T-SQL code</span></p><p><span>• Sargability of statements </span></p><p><span>• Procedural skills. </span></p><p><span>• Data security.</span></p><p><span>• Data Encryption</span></p><p><span>• Auditing</span></p><p><span>• Replication of data </span></p><p><span>• SQL Edition and version differences with discontinued and deprecated features</span></p><p><span>• Upgrade process</span></p><p><span>• Storage management techniques.</span></p><p><span>• Data Engine Capacity planning. </span></p><p><span>• General database management, Policy based management </span></p><p><span>• Extended events and Traces</span></p><p><span>• Basic Licensing and support scenarios</span></p><p><br></p><p><strong>Nice to have </strong></p><p><span>• Windows Failover Clustering</span></p><p><span>• SQL Server Reporting service</span></p><p><span>• SQL server Integration Service</span></p><p><span>• SQL Server Analysis Service</span></p><p><span>• PowerShell</span></p><p><br></p>