Data Archive Developer

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

• Bachelors 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.