Job Description
Job Description
Hello There,
Wish you a Happy Thursday,
My name is Yashmita, and I am a Technical Recruiter at Kanak IT Services LLC. I am reaching out to you regarding the following job opportunity. If you are interested, kindly reply to this email yashmita@kanakits.com with your updated resume.
POSITION: SQL DEVELOPER
LOCATION: ONSITE, MONTGOMERY, AL
DURATION: 6-12 MONTH CONTRACT COULD EXTEND AND GO DIRECT
Position Details:
Employees in this class are responsible for performing moderately to highly complex programming and systems analysis work on projects with integrated systems that impact multiple applications to support end-user needs.
- Requires full proficiency in T- SQL as identified by the development manager Deliverables:
- Create Stored Procedures
- SSIS ETL Packages
- Unit tests
- Documentation of developed code
- Status updates as requested by the Project Manager and Development Manager
Skills Required:
Modify and maintain T-SQL stored procedures, views, user-defined functions, and SSIS packages.
- Advanced T-SQL skills, including CTEs, window functions, joins, dynamic SQL, and error handling.
- Strong experience with stored procedures, scalar/table-valued functions, and views.
- Proficient in SQL Server Management Studio (SSMS) and working in live production environments.
- Triage and resolve incoming production support tickets related to incorrect or missing data.
- Investigate data integrity issues and apply SQL-based fixes safely and efficiently.
Analyze root causes and recommend long-term solutions to prevent recurring issues.
Communicate findings clearly to both technical and non-technical stakeholders. - Track fixes and outcomes for audit/compliance documentation.
- Perform performance tuning and query optimization for high-traffic queries.
- Familiarity with SSIS especially modifying existing packages, understanding workflows, and debugging.
- Solid understanding of data structures, relational modeling, and normalization.
- Comfortable navigating and fixing issues without always having step-by-step documentation.
Possesses a strong analytical mindset with a natural drive to identify root causes and deliver effective, sustainable solutions. Maintains focus when addressing live production
issues. - Pays attention to the details and likes figuring out what went wrong and how to fix it.
- Can work by themselves when needed, adjust when things change, and write things down clearly so others can understand and use their work later.
- Comfortable working in a ticket-driven production support environment, where timely and accurate resolution of issues is critical.
Skills Preferred:
Create moderate to advance T – SQL Stored Procedures and Triggers.
- Ability to write moderate and advance SQL commands.
- Ability to test and troubleshoot database procedures and ETL Packages.
- Excellent written and verbal communication skills
- Experience developing code using C#, .NET, HTML, or other web front-end technologies
- Ability to document code developed by analyst
- Elicit data requirements by assisting with interviews, document analysis, data requirements workshops, Data process descriptions, use cases, Data analysis, task and workflow analysis.
- SQL Servers version 2012 and later
- Programming business requirements in database language.
- Develop new SSIS/SSRS packages to meet business needs
- Working hands-on with all aspects of the System Development Life Cycle.
- Knowledge of Microsoft Team Foundation Server
Experience Required :
5 years of experience in software development experience
- 5 years of experience in database development
- 5 years of experience in tools used for software development (e.g., Visual Studio, Developer Tools, SSRS)
- Experience using TFS as Source Control
- Experience with Agile Scrum project development methodology and able to apply methodology in a practical manner.
Experience Preferred:
Experience with State Government, Medicaid, CHIP and DHR business area or healthcare industry