What are the responsibilities and job description for the Junior Level Software Engineer II position at Techgene Solutions LLC?
Job Details
Role: Junior Level Software Engineer II (SQL)
12- month contract
Location : Atlanta GA , Birmingham AL or Charlotte NC as preference with a hybrid schedule.
We are in need of a Software Engineer who oversees application development, modification, and maintenance of applications. This position monitors system applications, ensures systems run smoothly, and creates reports and other documentation outlining findings/solutions.
Primary Responsibilities
- Assists with the development and installation of new hardware and software
- Installs and configures systems and other software
- Tests installed software for malfunction detection
- Identifies and resolves business systems issues
- Designs and deploys new applications and enhancements to existing applications, software, and operation systems
- Measures effectiveness and efficiency of existing systems
- Develops and implements strategies to improve systems
- Monitors and tests system performance
- Performs work with some independence of thought, but refers more complex problems to senior associates or supervisor/manager
Required Skills:
- Bachelor's degree in Computer Science, Computer Engineering or a related field
- 3-5 years of SQL experience
- SQL Server Databases
- Standalone queries: Writing and optimizing T-SQL queries.
- Stored procedures & functions: Creating reusable logic in the database.
- Scripting data and schema changes: Using tools like SQL Server Management Studio (SSMS) or Visual Studio to generate scripts for deployments.
- SQL Server Integration Services (SSIS)
- Development & testing: Building ETL packages in Visual Studio.
- Deployment: Publishing SSIS projects to SQL Server.
- Management: Handling SSIS components like:
- Environments (via SSISDB or configuration files)
- Packages
- Projects
- C# Scripting
- Likely used within SSIS Script Tasks or Script Components for custom logic.
- SQL Server Agent
- Job creation & management: Automating tasks like ETL runs or report generation.
- Debugging: Monitoring job history and troubleshooting failures.
- Flat File Processing
- Extraction: Importing data from CSV, TXT, etc., using SSIS.
- Creation: Exporting structured data to flat files using SSIS.
- Database Projects in Visual Studio: Managing schema changes using .sqlproj files.
- SQL Server Tools in Visual Studio:
- Schema Compare: Compare and sync database schemas.
- Data Compare: Compare and sync data between databases.
- GitHub Source Management: Version control for SQL scripts, SSIS packages, and Visual Studio projects.
- Flat File Management in SSIS: Advanced handling of file formats, delimiters, and error handling.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
