SQL Conversion Engineer, Enterprise Supervision

Professional Services United States Plano, Texas


Description

The Conversion Engineer is primarily responsible for converting and migrating client’s existing data from their legacy system to Tyler’s applications. The Conversion Engineer simultaneously works on multiple projects performing data analysis and development of programs/scripts of varying complexities. The resource provides support to Tyler staff as well as clients to provide high-quality and accurate migrated data to allow Tyler software functions to execute as expected for our clients.

Work with our technology-driven solutions for Enterprise Supervision services. We are making government more effective and efficient in how they run their local justice system. Work with our integrated solutions that help law enforcement agencies better serve and protect our communities.

Responsibilities

  • Design, develop, and execute procedures to migrate client data in MySQL on AWS platform.
  • Learn, use, and maintain an established set of internal tools and other technologies as necessary
  • Analyze legacy database structures and translate them into the Enterprise Supervision target schemas.
  • Collaborate with implementation staff, project managers, and clients to develop data conversion procedures that meet client business rules
  • Perform in-depth data analysis to identify data patterns and anomalies
  • Perform intermediate troubleshooting of conversion logic
  • Perform data verification and balancing of values between old and new systems
  • Stay current with technologies and current database concepts
  • Performance tuning on data migration queries
  • Write ETL solutions that are durable and reusable
  • Manage workload to meet strict deadlines and communicates status regularly to team.
  • Perform other job-related duties and responsibilities that may be assigned

Qualifications

  • Bachelor’s Degree in Computer Science, Management Information Systems, or related field or relevant work experience
  • Ability to work well within a deadline-oriented development structure
  • ability to work well both independently and within a team environment
  • Strong technical abilities and desire to learn new things.
  • Strong attention to detail and analytic thinking skills
  • Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills
  • Familiarity with programming languages such as MySQL, SQL
  • AWS experience a plus
  • Strong understanding of database structures, how to create databases, import and export data in and out of a database (i.e. SQL Server, Oracle, etc)
  • ·Ability to quickly learn the business processes and software functionality
  •  Adept at communicating technical challenges with non-technical resources including end user.
  • Learn new technologies and concepts quickly.
  • Demonstrate ability to analyze and resolve problems of medium complexity with some guidance.