Database Admin (DWH, SQL Server)

Location: Detroit, Michigan
Date Posted: 08-11-2016

Technosoft Corporation is hiring Database Administrator (DWH, SQL Server) for Detroit, MI location

Title: Database Admin (DWH, SQL Server)
Location: Detroit, MI
Type: Full time
Employment Type: W2
Duties and Responsibilities:
Supports data warehouses, data marts, software and hardware systems including third party products and software upgrades as directed by the management.
Designs and implements data warehousing components, ETL, Analytical Cubes, Stored Procedures, Complex SQL queries to support Dashboards and reports
Administers operational activities to refresh data marts, analytical cubes, indexing and performance tuning of various data warehousing components.
Coaches data warehousing programmers to write efficient SQL, SSIS and SSAS code
Monitors database, operating system and user activities, and ensures necessary resources are present so that systems function properly by removing or deleting old or obsolete files/resources.
Develops complex data retrieval queries and optimizes data queries within programs for performance and maintainability. Determines data to collect and analyzes information as appropriate.
Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for complex databases. Recommends and implements course of action based on analyses.
Defines logical attributes and inter-relationships and designs complex data structures to accommodate database production, storage, maintenance and accessibility to enhance performance.
Defines and manage user roles, access and permissions to access database and other system resources.
Installs, implements and supports complex systems within user base; creates and updates database installation instructions and design changes for client use.
Monitors and coordinates installation and upgrades of hardware and software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products.
Utilizes standard corporate tools to record changes and problem activities for tracking and resolution purposes
Participates in cost analysis studies to determine feasibility of approaches
Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions.

Required Experience/Knowledge:
Good experience as a DBA in data warehousing environment;
Strong experience in data warehousing programming.
Strong experience of Microsoft Technologies, including .Net, SSIS and SSAS
Ability to work off hours in 24X7 production support environment
Excellent communication and interpersonal skills
Proven ability to peer review functional and technical tasks
Proven ability to work independently and as a team member.
Ability to be flexible and work analytically in a problem-solving environment
Good organizational, multi-tasking, and time-management skills

Technosoft Corporation

At least a bachelor’s degree in Computer Science, Engineering or related field or an equivalent in education is required for this position.
We are an Equal Opportunity Employer.
Manoj Kumar
Technosoft Corporation
Phone: 206-274-8524
Cell: 248-952-7036
this job portal is powered by CATS