Position Title: T-SQL Developer

Duration: CTH

Location: Onsite Omaha, NE & Hybrid, onsite at Lenexa, KS for sprint planning every other Wednesday for 1-2 hours and for additional meetings. Realistically, the team is pretty much remote and doesn’t have to go onsite much more than the biweekly Wednesday meetings.

Recent update from RM:

Required Technologies: T-SQL, SSIS, ETL

Preferred: Microsoft tools, SSRS

Soft Skills: The team likes individuals who voice their opinion, easy to talk to, shares and comes up with ideas for improvement. Quiet, reserved individuals would NOT do well with this team.

Daily Responsibilities: Knowledge transfer, reading documentation, attending refinement meetings, working on enhancements to the ETL process and front-end.

Interview Process: WWT Standard + one call with Branko and a senior DBA team member. Mix of technical and generic interview questions. NE – remote/video call. KS – onsite 9701 Renner Road 1 hour in person.

Job Description:

We are seeking a Microsoft Transact SQL (T-SQL) Developer with expertise in troubleshooting and supporting custom applications as well as building new systems. The successful candidate will be responsible for writing complex SQL queries, ensuring their stability, reliability, and performance, and collaborating with other team members and stakeholders to meet business needs..

Job Responsibilities:

• Design and Develop Database Structures: Design and implement new database systems based on project requirements. Database structures to include tables, indexes, views, functions, and stored procedures.
• Write Complex SQL Queries: Develop, implement, and optimize stored procedures, functions, and triggers using T-SQL.
• Database Performance: Ensure the performance, security, and availability of databases.
• Data Management Support: Provide data management support including data extraction and load of data related to engineering and construction.
• Collaboration: Work closely with product owners, business analysts, corporate database analysts, and other developers to meet business needs.
• Documentation: Prepare documentation and specifications for database design, coding, and testing.
• Performance Tuning: Analyze existing SQL queries for performance improvements and optimize database systems for efficiency.
• Problem Resolution: Identify potential problems and provide solutions in a timely manner.
• Stay Updated: Keep up with recent technological advancements and industry trends in database development.

Qualifications:

• Bachelor’s or Master’s degree in Computer Science, information Systems, or a related field
• Experience:
• 3+ years of experience in SQL Server development.
• Strong knowledge of Transact-SQL (T-SQL), including stored procedures, functions, and triggers.
• Experience with database design, data modeling, and normalization.
• Familiarity with SQL Server tools (e.g., SSMS, Profiler, DTA).

Skills:

• Proficient in writing and optimizing SQL queries withing the context of stored procedures
• Ability to design and implement database schemas.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
• Knowledge of performance tuning and optimization techniques.
• Understanding of data security and privacy principles.

“Tekgence is an equal opportunity employer. Applicants must be authorized to work in the U.S.A. U.S. citizens and Green Card holders are strongly encouraged to apply”.