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 "

Job Type: Full-time

Salary: $100,000.00 - $110,000.00 per year

Experience level:

• 11+ years

Schedule:

• 8 hour shift

Experience:

• SQL: 5 years (Preferred)
• Azure Data Lake: 5 years (Preferred)
• AWS: 5 years (Preferred)

Work Location: Remote

Speak with the employer
+91 8482711849

Please Note :
chrismaxcer.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, chrismaxcer.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.