SQL Conversion Engineer, Tyler Supervision

company banner
TYLER TECHNOLOGIES INC
Engineer, SQL, MySQL, Oracle, Computer, PL/SQL
Full Time

Job Description

The Conversion Engineer is responsible for converting and migrating client's existing data from their legacy system to Tyler's applications. The Conversion Engineer handles projects which are of moderate complexity

Responsibilities

  • Design, develop, troubleshoot and execute packages to convert client data using stored procedures, functions, and scripts (i.e. SQL, etc.) in a database environment (such as MySQL, Oracle, SQL Server, etc.).
  • Collaborate and communicate effectively with development staff, project management, business/implementation analysts and other relevant parties to develop data conversion packages that meet client business rules/requirements.
  • Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion 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 data analysis to identify data patterns and anomalies of moderate complexity.
  • 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 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.
  • Identify and write performance tuning scripts and tools to efficiently extract and process large data sets.
  • Perform database administration activities (i.e. backup, restore, DBCC commands, indexing, shrink, etc.).
  • May install converted data at the client site.
  • Create and update conversion logic to resolve client issues in test and production environments.
  • Engage in query performance tuning.
  • Support on-site Implementation as needed.
  • Manage workload to meet strict deadlines and communicates status regularly to team.
  • Develop, maintain, and document conversion programs and processes.
  • May occasionally travels to client sites.
  • Perform other duties as assigned.


Qualifications


  • Bachelor's Degree in Computer Science or related field.
  • Solid database knowledge and understanding involving experience and understanding of database structures and with using database schemas, database objects, tables, indexes, relationships and constraints leveraging technologies such as SQL Server, Oracle and/or related technologies.
  • Typically two or more years of prior work experience effectively designing, implementing and maintaining stored procedures and functions and using aggregate functions involving leveraging SQL or related technology.
  • Solid knowledge, understanding and experience creating and maintaining queries in MySQL, SQL Server, Oracle or related technology.
  • Solid knowledge and understanding identifying and writing performance tuning scripts and tools to efficiently extract and process data.
  • Solid experience with SQL, PL/SQL or related technologies and with writing and debugging moderately complex scripts and statements (such as SQL).
  • Understanding of full life cycle development.
  • Prior experience effectively implementing testing plans and scripts.
  • Ability to work well within deadline-oriented development structure.
  • Ability to work well both independently and within a team environment.
  • Strong organizational and time management skills with prioritizing/organizing multiple work streams to ensure deadlines are met.
  • Skilled technical abilities and desire to learn new things.
  • Strong attention to detail.
  • Demonstrable problem solving skills.
  • Excellent interpersonal skills including teamwork collaboration skills.
  • Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills.

Work with our integrated solutions that help courts and public safety organizations of all sizes better protect and serve the public. By helping provide solutions that improve efficiency and response time, you can help serve our citizens and make communities safer.

Location

Plano, Texas

Travel

10-25%

Great Place to Work & Grow Your Career

Tyler is continually recognized as a great workplace locally and nationally. See our recent awards and accolades across Tyler

Taking Care of You & Your Family

Your health and well-being are important to us. That's why we invest in our team members by offering competitive benefits to support their health and financial wellness. Learn more about how we care for our people

Tyler is subject to regulations, guidelines, and/or client requirements relating to the qualifications of Tyler personnel performing certain client work. Because of the nature of this position, it is a requirement that the candidate can successfully pass a federal background check at the time an offer is extended and over the course of employment with Tyler.

Apply Online

Requisition Number:2021-29
INDCJ
#DICECJ
Tyler Technologies is proud to be an affirmative action / equal opportunity employer. All qualified applicants will receive consideration without regard to race, creed, gender, marital status, sexual orientation, citizenship status, color, religion, national origin, age, disability, veteran status, or any other status protected under local, state or federal laws. If you require reasonable accommodation for any part of the application or hiring process due to a disability, please submit your request by emailing jobs@tylertech.com or by calling 800.646.2633 ext. 791008. Please keep in mind these methods are reserved for individuals who require accommodation due to a disability.


Company Information

At Tyler, we empower the people who serve the public by providing local governments and school districts with innovative, fully integrated software and services. In fact, we devote all our time, energy and resources to help local governments and school districts become more efficient, accessible and responsive to the needs of their constituents. Our comprehensive software solutions span the full range of mission-critical services that government entities address every day.
Dice Id : 10180326
Position Id : 2021-29
Originally Posted : 4 months ago

Similar Positions at TYLER TECHNOLOGIES INC

SQL Data Engineer, Courts & Justice
  • Plano, TX
  • 45 minutes ago
Deployment Engineer, Courts & Justice
  • Plano, TX
  • 45 minutes ago
Systems Administrator, SoftCode
  • Plano, TX
  • 45 minutes ago
Oracle Database PL/SQL Developer
  • Dayton Metropolitan Area, OH
  • 45 minutes ago
SQL Data Analyst
  • Dayton Metropolitan Area, OH
  • 1 day ago
.NET Software Engineer
  • Toronto,
  • 45 minutes ago
.NET Software Engineer
  • Dayton Metropolitan Area, OH
  • 45 minutes ago