Data Engineer

Stem Xpert; Plymouth (MI); On-site; USD 75,000 - 95,000; Full time

Job summary

A global consulting firm based in Plymouth, MI, is seeking a SQL Server Database Administrator. The role involves setting up testing environments and managing SQL security audits, requiring a Master's degree in Computer Science or related field with three years of experience, or a Bachelor's degree with five years of experience. Proficiency in TSQL, C#, PowerShell, and experience with DTS/SSRS/SSIS packages is essential. Candidates must also have certification as a Microsoft SQL Server database designer.

Qualifications

• Master's degree or equivalent in Computer Science, Engineering, or related field.
• 3 years of relevant work experience or 5 years for Bachelor's degree.
• Experience with DTS/SSRS/SSIS packages and TSQL programming.

Responsibilities

• Set up testing environments with physical servers.
• Work as SQL Server database administrator and manage SQL security audits.
• Conduct user acceptance and integration testing.

Skills

SQL Server Database Administration

TSQL

C#

PowerShell

Data Management

Education

Master's degree in Computer Science or Engineering

Bachelor's degree in Computer Science or Engineering

Tools

DTS

SSRS

SSIS

Hadoop

Hive

Job description

StemXpert is a global management consulting, technological service and outsourcing company delivering technology-driven business solutions to meet the strategically driven objectives for our numerous clients.

Job Description

• Set up in test, preproduction & dvlper environment w/ physical servers.
• Work as SQL Server d/base admin & set up SQL security Audit & write prgms for Big Data solutions.
• Conduct user acceptance testing & integration testing. Master's deg in Comp Sci, Engg or related field of study w/ 3 yrs' work exp in the position offered or
  related occupation w/ similar duties.
• Exp reqd w/ DTS/SSRS/SSIS packages, SSRS reports & writing comp prgms in TSQL,
  C#, Powershell & Hive.
• Alternatively, employer will accept a Bach's deg in Comp Sci, Engg or related field w/ 5 yrs of exp in position offered or related occupation w/ exp reqd w/ DTS/SSRS/SSIS packages, SSRS reports & writing comp prgms in TSQL,C#,Powershell, Hadoop & Hive.
• All exp mentioned above may be acquired concurrently.
• Position also reqs certification as Microsoft SQL Server 2000 d/base Dsgn & Implmtn.