Sql Programming Jobs in Alabama (NOW HIRING)

Position Summary:

We are seeking a Mid-Level Microsoft .Net Developer with Mainframe development experience to support and enhance mission-critical enterprise applications in a complex hybrid environment that includes both legacy mainframe systems and modern Microsoft technologies. This role will be responsible for development, maintenance, modernization, system integrations, reporting solutions, and production support activities.

The ideal candidate will possess strong mainframe and Microsoft .Net development experience, solid database skills, and the ability to bridge legacy systems with modern application architectures. This individual will work closely with business analysts, project managers, database administrators, and cross-functional development teams to deliver scalable, secure, and maintainable solutions.

Essential Responsibilities:

• Analyze, interpret, and decode legacy Easytrieve enterprise applications running on IBM mainframe platforms.
• Analyze business requirements and translate them into technical specifications and application solutions.
• Design, develop, test, and deploy application enhancements and defect fixes.
• Support batch processing, data transformation, and enterprise integration workflows.
• Develop and maintain reports, extracts, and data distribution processes.
• Create and support ETL solutions using SQL Server Integration Services (SSIS).
• Design, develop, and maintain reporting solutions using SQL Server Reporting Services (SSRS).
• Develop and maintain applications and supporting utilities using .NET technologies.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, views, and database objects.
• Monitor and resolve production support issues while ensuring system stability and data integrity.
• Participate in application modernization and legacy migration initiatives.
• Collaborate with business users to troubleshoot issues and identify process improvements.
• Create and maintain technical documentation, application specifications, and support procedures.
• Participate in code reviews and ensure compliance with organizational coding standards.
• Support testing efforts including unit, integration, regression, architecture, and user acceptance testing.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or related field, or equivalent work experience.
• Significant familiarity with the CMS Advise (835) and CMS 837 Health Care Claim file elements and standards.
• 3–7 years of professional software development experience.
• 3+ years of experience in IBM Mainframe development environments.
• Experience supporting large-scale enterprise applications.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.

Required Technical Skills:

Mainframe Technologies:

• JCL
• CICS
• ROSCOE or TSO
• Easytrieve/EasyPlus
• Batch Processing
• Microsoft Technologies
• .NET Framework / .NET Core
• C#
• Entity Framework Core
• Database & Reporting
• SQL Server
• T-SQL
• SSRS (SQL Server Reporting Services)
• SSIS (SQL Server Integration Services)
• Stored Procedures
• Database Performance Tuning
• Development Tools
• Visual Studio
• Git
• Azure DevOps Server
• SQL Server Management Studio (SSMS)
• Markdown File for Documentation
• EDI Fabric SDK

Preferred Qualifications:

• Experience with application modernization and migration of legacy systems.
• Experience using off-the-shelf technologies to manipulate data and report upon CMS data files (835 & 837)
• Experience parsing, generating, and troubleshooting ANSI ASC X12 HIPAA transaction sets, specifically 837 (claims submission) and 835 (Electronic Remittance Advice / ERA)
• Experience working with Medicaid electronic data specifications, companion guides, and proprietary state formats.
• Experience integrating mainframe applications with distributed platforms and APIs.
• Knowledge of ETL design and data transformation best practices.
• Familiarity with REST and SOAP web services.
• Experience with secure file transfer processes and data integration workflows.
• Experience with enterprise reporting and document generation solutions.
• Knowledge of Agile/Scrum methodologies.
• Experience with Microsoft Azure cloud services.
• Experience in healthcare, financial services, government, insurance, or other highly regulated industries.

vTech Solution Inc. is a Managed IT Services firm headquartered in Washington, DC. They specialize in a range of services including cloud computing, managed network security, and cybersecurity. Their primary focus is on providing human-centered IT solutions for government and business sectors, including federal, state, local, and education (SLED) groups, as well as commercial organizations.