Working at ICFWorking at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth. If you??re seeking to make a difference in the world, visit /careers to find your next career. ICF??together for tomorrow.SQL Server DeveloperDescriptionConsolidated Business Operations and Support ServicesMartinsville, VirginiaJob Description:The Consolidated Business Operations and Support Services group provides broad range services to support survey research, business processing, customer contact or fulfillment operations. We are currently seeking a SQL Server Developer to collaborate with analysts and software engineers to design and develop database schema, stored procedures, reports, and processes for a variety of applications.Key Responsibilities:Works with management to develop database strategies to support organization requirementsWorks with the technical team to create database structure and queriesWorks with testers to ensure the database is collecting the necessary data and is producing the correct outputsMakes recommendations for changes in database structure, inputs and outputs based on user and client inputResponsible for the quality control and auditing of databases to ensure accurate and appropriate use of dataConsults with end users to gather requirements, develop, test and support reporting needCollects, collates, models, interprets and analyzes data; explains variances and trendsDevelop, troubleshoot, and performance tune T-SQL scripts.Create and maintain SSIS ETL packages and processesParticipate in proposal development from a database and reporting perspectiveInstall and configure new SQL Servers.Determine most effective ways to optimize performance, including making hardware purchasing decisions, server configuration changes, and index/query adjustments.Ensure all database backups meet recovery point objectivesQualificationsBasic Qualifications:Associate??s degree in Information Technology or related field3 years of T-SQL development experience in SQL Server 2008 R2 or 2012, with an emphasis on stored procedures, user defined functions, and triggers2 years of experience SSIS package maintenance and developmentExperience creating, managing, and deploying SSRS reportsCurrent active US Government security clearance desired OR the ability to obtain a US Government security clearancePreferred Skills/Experience:Bachelor??s degree in Information Technology or related fieldExperience with complex query optimization and performance benchmarkingExperience writing PowerShell scripts, commandlets, and functions for automated tasks.Experience working with Microsoft SharePoint, Microsoft Dynamics CRM, or Cisco UCCEExperience with SSDTExperience using Profiler traces and other tools to find the most frequently run queriesExperience with clustering, log shipping, mirroring, and replication.Prior experience working in a contact center environmentExperience with using Veeam for SQL Server backupsICF offers an excellent benefits package, an award winning talent development program, and fosters a highly skilled, energized and empowered workforce. ICF is an equal opportunity employer that values diversity at all levels. (EOE ?? Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity)Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email icfcareercenter@ and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination: EEO is the law and Pay Transparency Statement.Martinsville, VA (VA23)
Associated topics: application, backend, c++, develop, developer, java, matlab, php, programming, sw
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.