What are the responsibilities and job description for the Sr. SQL Developer position at Technix LLC?
Position: Sr. SQL Developer
Duration: 6 months extendible after fiscal year ends on 09/30/2025
Location: Montgomery, AL (Onsite from Day 1)
Project Description
We are looking for an experienced IT System Analyst with a strong background in SQL, financial applications, interface design / support / development, and ERP application experience. The ideal candidate will have hands-on experience with Boomi integration and the GoAnywhere platform, but it is not a requirement. Candidate should possess technical / interpersonal skills to effectively analyze, design, and implement IT solutions that support our business objectives. This position will provide IT solutions for a variety of systems including timekeeping and leave, financial and purchasing systems, grant management, and the GoAnywhere file administration platform.
Key Responsibilities
Duration: 6 months extendible after fiscal year ends on 09/30/2025
Location: Montgomery, AL (Onsite from Day 1)
Project Description
We are looking for an experienced IT System Analyst with a strong background in SQL, financial applications, interface design / support / development, and ERP application experience. The ideal candidate will have hands-on experience with Boomi integration and the GoAnywhere platform, but it is not a requirement. Candidate should possess technical / interpersonal skills to effectively analyze, design, and implement IT solutions that support our business objectives. This position will provide IT solutions for a variety of systems including timekeeping and leave, financial and purchasing systems, grant management, and the GoAnywhere file administration platform.
Key Responsibilities
- Analyze and develop technical solutions for timekeeping and leave, financial and purchasing systems, grant management, and file transfer administration platform systems.
- Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications.
- Design, develop, optimize, and implement SQL queries, reports, stored procedures, and database structures to ensure data integrity, stable integrations, and efficient SQL performance.
- Support, Implement, and Maintain integration processes using Boomi, GoAnywhere, API, and file-based integration platforms, ensuring seamless data flow across applications and systems.
- Conduct system testing in web applications, integration platforms, or SQL clients for troubleshooting and debugging to resolve issues and ensure optimal performance.
- Prepare and maintain comprehensive technical documentation including system designs, technical specifications, script process designs, and user manuals.
- Provide knowledge transfer and support to colleagues / end-users to ensure effective system utilization.
- Manage workload and update tasks through ServiceNow / work management platforms.
- Key duties include updating the task management system with progress, assigning tasks to other users as applicable, and resolving issues with sufficient documentation to grow the knowledge base effectively.
- Experience working with stored procedures, SSIS packages, and complex Data Manipulation commands (select, update, insert, delete) strong understanding of database design and development.
- Experience with ERP web-based applications and integration/file transfer platforms such as Boomi and GoAnywhere.
- Strong analytical and problem-solving skills, with the ability to think critically and make data-driven decisions.
- Excellent communication and interpersonal skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.
- Ability to manage multiple tasks and priorities in a fast-paced environment.
- Familiarity with Boomi and GoAnywhere integration platforms and tools.
- Experience with enterprise resource planning (ERP) systems such as SAP or Oracle.
- Experience with agile methodologies and project management.
- Proficiency in programming languages such as Python, Java, or C# for scripting and automation purposes.
- Experience with data visualization tools such as Power BI or Tableau for creating insightful reports and dashboards.
- Certification in relevant technologies such as Microsoft SQL Server, Boomi Professional Developer, or AWS Solutions Architect.
- Experience in test automation platforms such as TestSavvy
- 3 to 5 years of programming/systems analysis experience.
- Bachelor's Degree in Computer Science, Information Systems or other related field. Or equivalent work