Data Archive Developer

Overview

On Site
Full Time

Skills

Scripting
Microsoft SQL Server
Project Management
Business Rules
Database
Stored Procedures
Data Migration
Data Analysis
Issue Resolution
Test Scripts
Data Conversion
Database Administration
Backup
Recovery
Transact-SQL
Supervision
Software Development
Training
Performance Tuning
Management
Computer Science
Attention To Detail
Conflict Resolution
Problem Solving
Communication
Collaboration
Teamwork
Customer Service
SQL
JSON
Amazon Web Services
Microsoft Office
GitHub

Job Details

Description

Responsibilities
  • Design, develop, troubleshoot, and execute processes to migrate client data using stored procedures, functions, and scripts (i.e. SQL, etc.) in a database environment (such as SQL Server, etc.).
  • Assist development staff, project management, business/implementation analysts and other relevant parties to provide support relevant to experience so that client business rules/requirements are met.
  • Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data migration utilities and projects.
  • Ensure data conversion solutions are appropriate, technically sound, and successfully meet client requirements.
  • Obtain data conversion specifications from implementation, project manager or another internal technology resource. May occasionally interface with clients directly.
  • Perform basic data analysis to identify data patterns and anomalies.
  • Troubleshoot conversion logic involving resolving data verification and related issues (i.e. identifying and resolving missing/incorrect data elements; issues involving data balancing, data transporting, data corruption and other data conversion and related issues). Maintain issue resolution logs as appropriate.
  • Perform basic level data verification and balancing between old and new systems.
  • Create and update conversion logic to resolve client issues in test and production environments.
  • Understand and implement test scripts and plans, assess results, and identify effective data conversion solutions.
  • Perform database administration activities (i.e. backup, restore, DBCC commands, indexing, shrink, etc.).
  • Demonstrate basic knowledge of T-SQL and to be able to work towards improving their technical expertise.
  • Write basic SQL statements.
  • Follow documented instructions and work well with supervision.
  • Perform routine, repeatable conversions tasks.
  • Learn new technologies and concepts quickly.
  • Demonstrate basic knowledge of software development, concepts and technology obtained through formal training and/or work experience.
  • Attain basic knowledge of technical/business environment.
  • Demonstrate programming aptitude and ability for logical and abstract thinking.
  • Demonstrate ability to analyze and resolve problems of simple-medium complexity.
  • May install converted data in the client environment.
  • Engage in query performance tuning.
  • Support on-site Implementation as needed.
  • Manage workload to meet strict deadlines and communicates status regularly to team.
  • Maintain, and document conversion programs and processes.
  • May occasionally travel to client sites.
  • Perform other duties as assigned.
Qualifications
  • Bachelor's Degree in Computer Science or related field.
  • Understanding of full life cycle development preferred.
  • Ability to work well within deadline-oriented development structure.
  • Ability to work well both independently and within a team environment.
  • Adequate technical abilities and desire to learn new things.
  • Strong attention to detail.
  • Demonstrable problem-solving skills.
  • Excellent interpersonal skills including verbal and written communication skill, teamwork, and customer service skills.
  • Programming knowledge requirements - SQL or related technology:
  • Familiar with json preferred.
  • Experience with AWS preferred.
  • Knowledge of Microsoft Office.
  • Familiar with GitHub or similar repository.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.