SQL Data Engineer (Full time)

SQL Data Engineer (Full time)

Location: Remote

SQL Resource

"Required Experience:

Enterprise level support and administration focused specifically with the following: Power BI, SQL performance and tuning optimization, core sql + migration on prem and cloud, Azure data lake, Azure data factory, and Synapse

Strong Business Acumen / Business Focused Technology Application

Candidates must be able to work independently

All versions of SQL Server (2012 and onwards)

Solving performance problems, query tuning, and optimization

Delivering and/or authoring technical training

SQL Server Integration Services, Reporting Services, Analysis Services

Expert level of Microsoft enterprise software product offerings

Effective learning skills

Works well in a team environment

Advanced Microsoft certifications preferred

Technical Skills:

Mandatory

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

Sargability of statements

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

Extended events and Traces

Basic Licensing and support scenarios

Preferred:

Windows Failover Clustering

SQL Server Reporting service

SQL server Integration Service

SQL Server Analysis Service

Powershell "

Apply tot his job

Apply To this Job