Conversion Developer CIS

Tyler Technologies Lubbock , TX 79401

Posted 3 days ago

Tyler Technologies is seeking a SQL Conversion Developer to join our agile, fun, fast paced, stable team. The SQL Conversion Developer converts client data into Tyler's Utility Billing software using SQL in order to meet our clients' business needs. Simply put, we migrate data from one source system to another. Conversion team members fulfill an important role in a software solution because they are one of the first contacts a new client will interact with and set the stage in the software for years to come.

We write SQL code. Yes, raw T-SQL code. In scripts, in stored procswe write SQL in a Microsoft SQL Server environment. We are not a drag and drop shop using SSIS. We are a team of people who love to problem solve with SQL scripts. That's certainly not the only thing we do, but it is a fundamental part of it.

We have some great tools we use to sequence and run the SQL we write. We are always looking to innovate and make our tools and processes more efficient. That's just how we do things here.

This role involves data analysis - finding where the data fits into our database structure, and problem solving - this client stores their financials rolled up and we need a more granular breakdown.

We are looking for experienced SQL developers who really love to code in SQL to join a very collaborative team. You'll have some very experienced folks around you and some newer folks, all of whom are learning together. No one knows everything, so we lean on each other. A lot. We share scripts, we do code reviews to help, and we have active mentoring happening every day.

We are part of something bigger than ourselves at Tyler. We are making government more effective and efficient in how they run their community systems.

Responsibilities

  • We do data analysis on each project, so you'll need to be good at piecing together data puzzles, asking discerning questions, and working with colleagues and clients to get answers

  • We have a custom tool set built. We want you to learn it, use it, and tell us how we can improve it.

  • We have some solid processes that have been honed through years of doing data conversions. We want you to learn these processes - because they really do work - and then help us find ways to improve or replace them with better ways to get the job done.

  • Work in SQL Server environments. We work with multiple versions of SQL Server depending upon the project. We usually cover the current release of SQL Server and two earlier releases.

Qualifications

  • BS/BA degree in Computer Science, Management Information Systems (MIS) or related field or equivalent experience is desired.

  • Value deadlines and regularly complete work on time

  • Strong problem solver

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

  • Work independently while remaining team-oriented

  • Proficiency in Microsoft SQL Server Management Studio (SSMS) is a major plus

  • 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

  • Python and C#.NET knowledge ideal but not required

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
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
Software Engineer II Web Developer

Patterson Companies

Posted 3 weeks ago

VIEW JOBS 1/31/2021 12:00:00 AM 2021-05-01T00:00 Overview The Software Engineer II's role is to define, develop, test, analyze, and maintain software applications in support of the achievement of Patterson software requirements. This includes writing, coding, testing, and analyzing software programs and applications. The Software Engineer II will also research, design, document, and modify software specifications throughout the development life cycle. * Position can be remote* Responsibilities Major Duties Software Development: Collaborates with clients, developers and other team members in the conceptualization and development of new or existing software applications. Assists in the definition, development, and documentation of software's business requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments. Helps research, identify, analyze, and fulfill requirements of all internal and external program users and stakeholders. Writes programming scripts to enhance functionality and/or performance of company applications as directed. Executes software testing on new and existing programs for the purposes of correcting errors and general debugging. Project Team Work: Participates in defining software development project plans, including scoping, scheduling, and implementation. Performs program turnover to production support and customers upon completion of development, testing, and documentation. Issue Resolution: Provides higher level support for incoming incident tickets from end users to resolve application and software issues. Partners with other engineers in resolving problems with software products or company software systems. Performs other duties as assigned. Critical Competencies: Technical Expertise: Maintains current technical knowledge and best practices and actively builds new skills. Provides ideas to help solve business and technical problems for the organization through technical expertise. Able to work across multiple platforms and applications and see interconnections with some guidance. Action Orientation: Uses time effectively to complete tasks in a thorough and timely manner. Focuses on most important items first. Maintains high levels of personal organization and works at high level of efficiency and rapid pace. Seeks out challenges and initiates action on issues even when scope is unclear. Maintains composure in times of stress. Flexibility: Easily adapts to and models positive adoption of new methods and Company procedures. Responds to disruptions and organizational change as an opportunity for improvement. Receives feedback from peers, managers, and customers openly as a tool for growth. Collaboration: Establishes rapport and is straightforward and approachable. Modifies personal style to work more effectively within a team. Listens effectively and uses language and examples appropriate to the audience. Maintains credibility by doing what he/she says he/she will do and taking responsibility for correcting mistakes. Speaks and writes in a clear and concise manner. Takes time to get to know others outside of his/her immediate functional area. Aligns personal goals to team and organizational goals. Results Focus: Drives for results and puts in necessary effort to ensure work is completed on time. Creates visibility around progress toward key milestones. Identifies and removes barriers to task completion. Pushes through challenges and obstacles to achieve results. Continuously strives to raise personal standards of performance. Qualifications Minimum Qualifications: * Bachelor's Degree in Computer Science, Management Information Sciences, Mathematics, Engineering, Business, or area of functional responsibility preferred, or a combination of equivalent education and experience * 3-4 years of programming experience required. Should have prior experience within various platforms and languages, including: MS SQL, C#, and Object-Oriented Programming. * Knowledge of all aspects of application development and project life cycles, including Agile and Scrum practices. * Excellent understanding of coding methods and best practices * Extensive relational database and operating systems experience * Fluency in object-oriented programming and design * Ability to conduct research into software-related issues and products * Proficiency with office productivity tools such as Microsoft Excel, Word and PowerPoint Preferred Qualifications: * Experience using source code management system GIT and SVN * Knowledge of WCF, Web API, or ServiceStack * Knowledge of Microsoft SQL, UWP, XAML, WPF, .Net, Xamarin, and C# * Knowledge of MVVM * Knowledge of Agile and SCRUM practices * Knowledge of accounting principles. * Understanding of corporate governance, business cases and return on investment concepts Benefits Benefits: We provide competitive benefits, unique incentive programs and rewards for all eligible employees. Please click here for an overview of benefits offered. EEO Statement An Equal Opportunity Employer As a people-first company, Patterson promotes a culture that embodies and celebrates diversity and inclusivity. We believe our employees' unique experiences and differences are what strengthen us and drive our success. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status. We are Patterson. We welcome you. Patterson Companies Lubbock TX

Conversion Developer CIS

Tyler Technologies