Database Analyst 8/31/2016

Healthcare IT Company Cincinnati, OH

Company
Healthcare IT Company
Job Classification
Full Time
Company Ref #
29312640
AJE Ref #
576044734
Location
Cincinnati, OH
Job Type
Regular

JOB DESCRIPTION

APPLY
_StarSource Consulting we specialize in Information technology, providing superior resources to companies. We take pride in providing professional and ethical services to suit our client's needs. At Star Source Consulting we are a dynamic, high-growth, full service commerce and outsourcing solutions provider looking for the best to work in our fast paced, entrepreneurial team environment._

FUNCTION:

DEVELOPMENT OF DATA MARTS/WAREHOUSING/SCRIPTS

* Works with customers and other IS&T departments to define tables to meet needs-Uses software tools to extract, load, and transform data for tables-Updates tables in a timely manner to meet customer needs-Works with users to automate schedulereport printing-Monitors automated report printing and re-prints reports as needed in a timely manner

MAINTENANCE, MONITORING AND PROBLEM RESOLUTION

* Writes scripts to automate database backups and performs periodic testing of database recoveries from backups-Applies knowledge of resources, constraints and organizational values in decision making process-Upgrades to current stable versions on all servers and systems to minimize problems and in accordance with vendor specifications

SYSTEM DEFINITION AND INTEGRATION

* Designs and configures database systems based on collected specifications-Works with vendors to define specifications-Works with IS&T staff to coordinate deployment

SYSTEM DEFINITION AND INTEGRATION

* Designs and configures database systems based on collected specifications-Works with vendors to define specifications-Works with IS&T staff to coordinate deployment

DOCUMENTATION

* Appropriately documents application information, backup and disaster recovery procedures, and database structures-Provides necessary documentation for network, installations, configurations, procedures, and other related network functions-Identifies data sources and constructs data diagrams, data flow diagrams and documents processes

KNOWLEDGE AND SKILLS:

EDUCATION: Bachelor's degree in related field or an equivalent combination of education and experience required.
YEARS OF EXPERIENCE: 5 or more years of experience with database systems preferred
REQUIRED SKILLS AND KNOWLEDGE:

5+ years MS SQL Server Administration experiencerequired.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Experience with backups, restores and recovery models

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Experience working with Windows server, including Active Directory

Flexible, team player, "get-it-done" personality

Ability to organize and plan work independently

Ability to work in a rapidly changing environment

Ability to multi-task and context-switch effectively between different activities and teams

MCSE: Data Platform certifications a plus

REQUIRED DEVELOPMENT TOOLS AND PROGRAMMING LANGUAGE EXPERIENCE

Microsoft Visual Studio and Microsoft SQL Server development tools

Experience in SQL Server 2008, 2012, 2014 SQL Server 2016 (a plus)

Visual Basic.NET, ASP.NET, HTML, C# and XML programming languages