Senior SQL Consultant

SQL Consultant

Job Title:

SQL Consultant

Job Description

The Sr Advisor I, Technical Support provides the most advanced technical support to client customers. This position responds to escalated and unresolved calls from other technical support advisors.

Immediate opportunities for SQL Customer Engineers (CE). In this role, you will have the opportunity to work with some of the largest, and most sophisticated companies in the world, usually F1000. You will be responsible for customer satisfaction, deployment, adoption, and support of SQL initiatives. Customer Engineers work with and assist customers in building, deploying, operating, and optimizing complex enterprise environments. This job has proven to be a career accelerator for hundreds of engineers over the years. You will be a trusted advisor, a specialist the room is looking to for guidance, education and adherence for best practices, risk mitigation etc.

Travel:

Customer Engineers are home based. Due to the impact of COVID, most deliveries are remote, however, some travel may be required.

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 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

Location:

IND Pune - RMZ 1st Floor (Sublease to CIND)

Language Requirements:

Time Type:

Full time

If you are a California resident, by submitting your information, you acknowledge that you have read and have access to the Job Applicant Privacy Notice for California Residents

Experience Level

Senior Level