SQL Server Consultant

Full Time, onsite
Acara Solutions, An Aleron Company
Jakarta Raya, Indonesia

Salary undisclosed

Apply on

Linkedn

Original

Simplified

SQL Server - JOB DESCRIPTION

Customer Engineer

Are you looking for a role that utilizes your passion for technology?

Are you interested in receiving unrivalled training?

Are you interested in joining a team of outstanding technology professionals who, as trusted advisors and subject matter experts, help Microsoft Premier Enterprise Customers - enabling them to make the most out of their technology and moving their business forward?

Our Mission Statement

Customer Engineers provide technical leadership for Premier customers around the world to help ensure their IT environments are kept optimized and healthy. The focus is to do this in a proactive and consultative manner to avoid future issues. This includes guidance on best practices, risk assessments, migrations, and onsite, remote and dedicated support services.

What we do best

Customer Engineers provide various services to our Enterprise customers to increase systems availability, resolve critical issues, and ultimately improve the health of our customers’ environments. We consult with experienced technical staff to ensure they have the skills to troubleshoot and maintain their solution in line with Microsoft best practices. When things do go wrong we provide rapid on site expertise to resolve critical situations.

Customer Engineers deliver onsite and dedicated services for Microsoft’s Premier customers.

We need individuals that:

Possess deep technical expertise in at least one technical specialty and can solve complex technical problems through sound, creative troubleshooting. You will also need to be able to examine possible workarounds and escalations as required.
Set an example of excellence as a Microsoft representative, enhancing the company's image and reputation through your credibility, preparation, commitment, and first-class delivery.
Demonstrate strong communication skills; ability to develop strategic on-going customer relationships, gain trust and respect for the company. Engineers must also possess strong technical writing, presentation and training skills.
Enjoy team work, and actively contribute to their peer group as well as our customer account teams.
Communicate at all levels from CIO to the technical staff on the ground.

Expertise Required

Experience in the enterprise customer arena

Face-to-face customer engagement skills

Excellent written, oral and presentation skills

Troubleshooting knowledge & skills

Degree qualification or equivalent experience

Good understanding of ITIL/Service Management

Technical Expertise Required

SQL Server & Data

The role requires depth knowledge in a number of the following technology areas:

Mandatory

Strong with SQL Server Core/Engine – Concepts, Architecture, Performance, High Availability (Failover Cluster, Availability Group), Migration/Upgrade, Security, Maintenance, Well versed with evolution of SQL server & enhancements with each version of SQL server, Hands on & practical experiences.
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