What are the responsibilities and job description for the Software Engineer II (SQL) - Remote position at ConsultNet Technology Services and Solutions?
Software Engineer II (SQL)
Remote (CST or EST)
12- month contract
Pay Rate: $50.00 to $56.00 per hr.
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
Remote (CST or EST)
12- month contract
Pay Rate: $50.00 to $56.00 per hr.
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
- 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.
Salary : $50 - $56
