New Jobs

SQL Consultant job

Please enable JavaScript in your browser to complete this form.

Your Details

Name
Address

Position Details

Click or drag a file to this area to upload.

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges.

We currently looking for Sr SQL Consultant – REMOTEPlease see the job description below for your reference.

Sr SQL Consultant

REMOTE

Long term contract

Job Description

Sr SQL Consultant

Exp Range: 10 Plus

Primary Work

  • Standard Product Work Shops – Training
  • In-Depth Product Reviews – White Board (Chalk Talk) Sessions
  • Health Checks / Assessments
  • Post Operational Review of Product Implementations
  • Product Upgrade / Migration Assessments
  • Systems Performance Reviews
  • Act as the primary onsite technical contact, providing customer visibility, advanced technical support, and problem resolution for corporate customers, including issues raised to the highest levels of management

Required Experience

  • Enterprise-level support and administration focused explicitly on 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 the ability to dissect query plans, 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.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Thanks,

Arif M

Momento USA | Exceeding Customer Expectations

Interstate Business Park

Tel : Direct : 856 432 1156 / (856) 456-1805 Ext 1013 ;Fax: (866) 605-1171

Email: arif@momentousa.com Web: www.MomentoUSA.com

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button