SQL Data Engineer (Full time)
SQL Data Engineer (Full Time)
Location: RemoteSQL 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 trainingSQL 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 AuditingReplication of dataSQL 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 TracesBasic Licensing and support scenarios
Preferred:
Windows Failover ClusteringSQL Server Reporting serviceSQL server Integration ServiceSQL Server Analysis Service