Conversion Engineer

Apply Online

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 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, shrinketc.).
  • 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 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.
  • Programming knowledge requirements – SQL or related technology:
    • Proficiently use SQL Server Management Studio
    • Write and maintain stored procedures and functions
    • Use aggregate functions in SQL
    • Create and maintain queries of moderate complexity in SQL Server
    • 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 SQL Server Reporting Services (SSRS)
    • Development experience with the .NET Framework is a plus
    • Application development experience is a plus
    • Knowledge of AWS environments, services and processes is a plus

 

Location

Remote | Travel/Home-Based | Troy, Michigan

Travel

0-5%

State-Specific Salary Range Disclosure Requirements

Salary will generally fall between $51,035 - $67,151 before adjustment for geographic differences. Recruiter can confirm if position is incentive eligible.

Great Place to Work & Grow Your Career

Come join us as we transform the public sector! Our mission, vision, and values guide everything we do. We’re also frequently recognized as a great workplace locally and nationally. See our many awards and accolades.

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:2022-1907

#DICEPS

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.
spacer module is 50px
Didn’t find what you’re looking for?

Start your search again

spacer module is 27px
SCAM ALERT

Don't be fooled by criminals making false employment offers, requesting personal and financial information, or impersonating Tyler management. In our recruiting practice, we do not …

  • Extend job offers to candidates we have never spoken with on the phone or in-person
  • Request financial information from candidates
  • Offer jobs through chat rooms, meetups, or hangouts

If you feel you may have been in contact with someone falsely representing Tyler, please contact info@tylertech.com immediately and provide us with as much information as possible about the exchange. If you opened or clicked on any links or attachments within a suspicious job offer, we recommend running a full antivirus scan on your computer to make sure no malware was downloaded.

spacer module is 25px
Get to Know Our Tyler Family

At Tyler, team members are valued and encouraged to innovate, while having fun along the way. Join us and see why we love working here.

Meet our Tyler family
Meaningful Work, Valuable Benefits

To make work even more rewarding, we offer a wide range of benefits to support the overall wellness of you and eligible family members.

Check out our benefits
Why Work at Tyler?

While committed to serving the public sector, we’re also dedicated to investing in our people. Be a part of our passionate community where you can grow.

Come work with us
Upcoming Job Fairs & Recruiting Events

Interested in learning more about what it's like to be a part of our team? Our recruiting team would love to meet you at an upcoming event in your area or virtually.

See our hiring events