SQL Conversion Developer

Tyler Technologies Headquarters Plano , TX 75023

Posted 2 months ago

The SQL Developer converts client data into Tyler's courts and justice software in a way that meets our clients' business needs.

Location

Plano, Texas

Responsibilities

  • Design, develop, and execute ETL packages to convert client data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.

  • Learn, use, and maintain an established set of internal tools and other technologies as necessary.

  • Collaborate with project management and business analysts to develop data conversion packages that meet client business rules.

  • Perform data analysis to identify data patterns and anomalies.

  • Perform basic troubleshooting of conversion logic.

  • Create and update conversion logic to resolve client issues in test and production environments.

  • Engage in query performance tuning.

  • Develop and modify stored procedures and T-SQL scripts in response to validation exceptions.

  • Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion projects.

  • Perform SQL Server administration activities (backup, restore, DBCC commands, indexing, shrink).

  • Stay current with Microsoft SQL Server technologies and current database concepts

  • Perform other job-related duties and responsibilities that may be assigned from time to time.

Qualifications

  • Bachelor's Degree in Computer Science, Management Information Systems (MIS), or related field or relevant work experience

  • Ability to work well within deadline-oriented development structure.

  • Ability to work well both independently and collaboratively within a team environment.

  • Strong technical abilities and desire to learn new things.

  • Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills.

  • Technical knowledge requirements:

  • Proficiently use Microsoft SQL Server Management Studio (SSMS) 2008 R2 and 2012

  • Write and maintain stored procedures and functions using T-SQL and SSMS

  • Use aggregate functions in Microsoft SQL Server

  • Create and maintain complex queries in Microsoft SQL Server using T-SQL

  • Understand and use database schemas, tables, relationships, and constraints

  • Develop, maintain, and troubleshoot conversion packages using SQL Server Business Intelligence Design Studio

  • Ability to write reports using Microsoft SQL Server Reporting Services (SSRS) is a plus

  • Development experience with the .NET Framework is a plus

  • Application development experience is a plus

  • May be required to undergo and satisfactorily pass a fingerprint background check (for CJIS requirements).

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Conversion Engineer

Tyler Technologies Headquarters

Posted 1 week ago

VIEW JOBS 11/10/2018 12:00:00 AM 2019-02-08T00:00 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 converted data to allow Tyler software functions to execute as expected for our clients. Location Plano, Texas Open to other Tyler office locations Responsibilities * Design, develop, and execute procedures to convert client data using stored procedures, functions, and SQL scripts in an Oracle environment * Learn, use, and maintain an established set of internal tools and other technologies as necessary * Collaborate with implementation staff and clients to develop data conversion procedures that meet client business rules * Perform basic data analysis to identify data patterns and anomalies * Perform basic troubleshooting of conversion logic * Perform data verification and balancing of values between old and new systems * Create and update conversion logic to resolve client issues in test environments * Stay current with Oracle technologies and current database concepts * Perform other job-related duties and responsibilities that may be assigned from time to time 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 * Excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills Tyler Technologies Headquarters Plano TX

SQL Conversion Developer

Tyler Technologies Headquarters