Home / Jobs

Lucid Technologies Inc

The Logical Solutions

Senior SQL Server Developer
Role/Title: Senior SQL Server Developer
Location :  IOWA  (Remote),
Experience: 5+ Yrs 
Client: State of IOWA  

Agency Interview Type: Either Web Cam or In Person Interview

General Description

This position is for a Senior SQL Database Developer with Transactional system development, ETL, Analytical Reporting experience.  This position also requires experience with ASP.NET, C# and related technologies.

Job Description
  • The successful candidate will spend a good portion of their time working with the Systems that support Medicaid, TANF, and SNAP Systems and expected to work in concert with Front End developer(s) troubleshooting system problem reports and processing enhancement requests. 
  • This role will be primarily focused on backend development with MS SQL Server including SSIS and SSRS development. 
  • While working on system enhancements the successful candidate is expected to propose, design, and develop solutions in concert with the front end developer(s) to fulfill the business requirements. 
  • The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support.  When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.
  • Individual should work well in a team and independently as needed.
Responsibilities:
  • Assist in designing, developing, and enhancing large transaction and reporting databases.
  • Assist in converting existing Legacy applications to newer technologies
  • Assist in integrating in-house applications with enterprise third party solutions.
  • Design, create, and implement database systems based on the end user's requirements. 
  • Develop database schemas, tables and dictionaries using SQL server 2016 and 2019.
  • Translate business requirements into software applications and models.
  • Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and  requirements to support application development
  • Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance.
  • Thoroughly test all approved application and database code additions and changes prior to implementing to staging. Request approval from users prior to implementing any additions or changes to the production environment.
  • Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities.
  • Use Microsoft Team Foundation Server (TFS) and/or Azure Dev Ops to manage changes to code.
  • Participate in requirement analysis discussions and come up with efficient technical solution
  • Develop new and maintain existing reports using SQL Server Reporting Services (SSRS)
  • Build and Deploy ETL processes using SQL Server Integration Services (SSIS).
  • Guide and share knowledge with other SQL developers when the need arises.
Required Experience/Skills:
  • Bachelor’s degree in Computer Science or related field or relevant work experience
  • Demonstrated experience with relational database design and implementation using MS SQL Server
  • Experience optimizing SQL queries for improving performance and maintaining data integrity
  • Experience in creating database migration scripts by using schema and data compare tools
  • Experience in creating batch packages using SSIS
  • Experience using C# and/or VB.NET in SSIS Script tasks
  • Experience in creating reports using SSRS
  • Write efficient, consistent and testable code
  • Proficiency with using Visual Studio 2015, 2017, and 2019
  • Ability to understand and analyze the business requirements and come up with efficient technical solution
  • Experience in using LINQ
  • Being able work with minimal requirements and improve the functionality as requirements are refined
  • Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.
Skills Matrix
  • Experience with working with different versions of SQL server(2016, and 2019) Required 5Years
  • Expert knowledge of TSQL Required 5Years
  • Database modeling & Design Required 5Years
  • Experience in creating batch packages using SSIS Required 5Years
  • Experience in creating reports using SSRS Required 5Years
  • Experience optimizing SQL queries for improving performance and 
  • maintaining data integrity Required 5Years
  • Experience in architecting, writing and maintaining 
  • RESTful APIs/Services Required 2Years
  • Experience in using LINQ Required 2Years
  • Proficiency with different versions of Visual Studio
  • (2019 and previous versions) Required 5Years
  • Experience with C#, .NET framework, Entity framework, 
  • Angular, Bootstrap, CSS3, HTML5, TypeScript, JavaScript,
  • Knockout, ASP.NET forms and object-oriented 
  • design/development Desired
  • Experience in using Power BI Desired 1Years
  • Experience with Microsoft Azure Cloud services Desired
  • OpenText Content Server Nice to have
  • Adobe Experience Manager – specifically using Designer, 
  • Workbench, and Workflow Nice to have

Thanks & Regards,
Salur Lakshmi 
IT Recruiter
Lucid Technologies Inc
O: 214-385-4144 Ext: 204
F: 214-889-5857­­­
W: www.LucidTechINC.com