Harris Computer Systems

Data Migration Specialist

US-FL-Pensacola
3 weeks ago
Job ID
2017-3591
Company
SmartCOP
Category
Professional Services

Position Overview

SmartCOP

 

The Data Migration Specialist uses various tools and languages to extract, transform, and load client legacy data into disparate target application databases in accordance with contractual obligations. Candidates are competent to work on fairly complex assignments (and/or portions of larger, complex systems) and perform a full range of data conversion services. The Data Migration Specialist generally works under deadlines and is capable of handling heavy workloads, and operating with only general supervision by the Professional Services Manager. Candidates are required to define high-level conversion scope, develop data conversion strategies and estimate work effort, in addition to the programming and documentation required.

Primary Functions

  • Conducts on site analysis of Client legacy system(s) and database(s) with the goal of producing the initial Data Mapping for the Extract process.
  • Working closely with client end users to find where data is stored in a database if client does not have intimate knowledge of database.
  • Creates accurate code to Load the data into the target database.
  • Executes onsite conversion test runs in order to obtain program run times, derive database sizing estimates, and uncover software / hardware / environment constraints.
  • Creates data verification plans to be used following trial runs at the client site.
  • Works with users to ensure successful system implementation; may assist in user training.
  • Ability to install and configure SQL Server database software using common best practices.
  • Ability to migrate databases and security settings and logins to new operating platforms (server migration).

Qualifications

  • Strong written and verbal communication skills.
  • Strong understanding of relational database concepts required.
  • Experience in MS SQL server 2012 and later versions.
  • Ability to build complex TSQL code.
  • Customer site visits may be required.
  • Ability to package and export data to external sources and various  (ie fixed length files, XML, CSV)
  • Minimum 2 years of technical experience.
  • Data Conversion experience.

Company Overview

SmartCOP, Inc. is a public safety software business engaged in system development, implementation, and support services for a fully integrated suite of products including Computer Aided Dispatch (CAD), Records Management System (RMS), Mobile Computing with Field Based Reporting, and Jail Management System (JMS).

Headquartered in Pensacola, Florida, SmartCOP actively and successfully competes in all size markets, with products that scale from an agency of ten officers to thousands of officers. Agencies all across the United States depend on SmartCOP and they have seen the benefits of a fully-integrated, single source solution. The system’s ability to furnish information through a single database reduces redundant data entry and improves information flow. Users of the SmartCOP system find that it enhances agency efficiency, improves response times, and improves officer and citizen safety in a cost effective manner.

SmartCOP is a division of Harris Computer Systems, a member of the Constellation Software Inc. group of companies. Constellation Software is a rapidly growing conglomerate of vertical market software (VMS) companies, each focused upon dominating its respective market niche. Constellation's growth is based on a simple strategy: identify promising VMS firms, acquire them, and then integrate them into the Constellation family while building on their fundamental strengths to help them become world class organizations.


Harris is an Equal Opportunity Employer.

#WeAreHarris

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.