Role: Engineering and IT Support

Candidate Location Requirement: Las Colinas, Redmond, or Charlotte

Duration: 12 Months Contract

Skills Required:

• Years of Experience Required: 3 overall years of experience in the field.

• Degrees or certifications required: No degree is required to be eligible for this role, but it is preferred to have a relevant degree.

• Disqualifiers: Candidates with a majority of their experience in developer work, has poor communication skills, has not worked in a customer facing support role, or are missing any of the required technologies will not be eligible for the role. Candidates who are not fluent in English, they will not be eligible.

• Best vs. Average: The ideal resume would contain multiple years of experience with support engineering, troubleshooting, and is well articulated both on paper and in person.

Responsibilities:

• Installed SQL Server 2005/2008/2008R2/2012/2014/2016/2017 on new 32-bit and x64-bit Operating System.

• Experience in Migrating from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 to SQL Server 2014/2016.

• Experience in upgrading SQL server software to new versions and applying service packs and patches.

• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server.

• Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks.

• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.

• Experience with High Availability and Disaster Recoveries like Replication, Log Shipping, Mirroring, and Clustering.

• Proficient in implementing different types of Replication Models like Snapshot, Transactional, and Merge.

• Experience in Implementing Always On in SQL Server 2012, 2014, 2016 and 2017.

• Experience in Implementing Database Mirroring in SQL server 2005/2008/2008R2.

• Involved in Installing, Configuring, and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 in Active/Passive.

• Auditing database configuration and security configurations.

• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor.

• Experience with Database Backup and Restore.

Top 3 Hard Skills Required

1. Minimum 3 years' experience interacting with customers/end-users in any of the following: customer support, product support, technical support, end-user support, IT Admin support, Consulting, product development, network operations, software engineering, or I.T. consulting.

2. Minimum 3 years experience with Microsoft SQL Server Database Administration experience in SQL Server 2008R2/2008/2012/2014/2016.

3. Minimum 3 years experience in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.