SQL Developer

Role: Junior Level Software Engineer II (SQL) Duration: 12-month contract Location: Atlanta, GA, Birmingham, AL, or Charlotte, NC 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.