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 "