Contact Us 877.823.3669

Contract-to-hire Database Developer in New Haven at SNI Technology

Date Posted: 4/13/2018

Job Snapshot

Job Description


** This is a contract-to-hire opportunity. NO CORP-TO-CORP/C2C **
Our client is looking for a Database Developer for a contract to hire opportunity. The Database Developer will help design, document, and integrate various enterprise databases and data sources. This position will be responsible for managing multiple data streams and managing procedures and best practices in utilizing these data resources. Additionally, the Database Developer will redesign existing databases and create data warehousing platforms, and create connectors between centralized databases and other data sources.
DUTIES:

  • Architect, design, and code databases and database objects such as tables, stored procedures, views, and functions using SQL Server 2008 R2, SQL Server 2016, and Azure SQL Database environments and manage maintenance of these objects
  • Refactor and document existing database objects and architectures
  • Fulfill requests for reports by designing objects to meet reporting needs
  • Create star schema data models, perform ETL's, and validate results against business rules
  • Work with multiple data sources/streams such as third party flat files, web usage data, cloud, SalesForce, Azure, OneDrive, SharePoint, etc.
  • Design indexes for existing applications, choosing when to add or remove indexes
  • Handle common database procedures such as upgrades, backups, recoveries, migrations, tuning, and performance monitoring
  • Collaborate with Infrastructure and Data teams to ensure performance and optimization of MS SQL Server environments, both onsite and in Azure
  • Create and maintain documentation and standard operating procedures for all databases


REQUIREMENTS:

  • Bachelor's degree in a relevant field of study
  • 3+ years of SQL Server database development in a data-integrated setting
  • 3+ years of working with ETL and multiple data streams
  • 3+ years of experience with documentation of system assets, resources, and procedures
  • 3+ years of experience with .NET and Javascript
  • 3+ years of experience with Reporting Services, Analysis Services, and/or Integration Services
  • Ability to communicate design specifications and requirements within and across multiple teams
  • Effectively manage multiple and rapidly changing priorities calmly and efficiently with an ability to communicate these priorities effectively both orally and in writing
  • Must be analytical and data-driven
  • Strong planning and organizational skills
  • Adaptable within a fast-paced environment and an ability to set expectations with other members of the Data team and management
  • Effective problem-solving skills with an ability to resolve issues efficiently as they arise
  • Ability to provide critical analysis of existing platforms and recommend solutions to existing issues