SQL Server Developer

• Seeking a skilled SQL Server Developer through Knowledge Services with a broad breadth of technical experience. As a part of the application development team making modifications to or creating new components for application processes, the Developer will participate in activities related to the creation and/or modification of processes for backend database processing, .NET user interfaces, OIC, and Salesforce components. This Developer will be focused on the design, documentation, and development of new application API integrations for internal/external user interfaces in Salesforce and other SQL components.
• The Developer shall have excellent attention to detail, an analytical mind, and strong organization and problem-solving skills.
• The Developer shall also be a good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box. Additionally, the role shall be able to effectively communicate relevant project analysis information to team members as well as customers and leadership.

On-Job Requirements:

• Created and/or modified SQL SSIS packages
• Creation and/or modification of exiting extraction, transformation, and loading SQL processes.
• Creation and/or modification of other SQL components as required.
• Support of SIT and/or UAT integration testing of SQL components.

Skills & Number of years of Experience

• 4-year college degree or equivalent technical study
• Minimum 3 years’ experience SQL server administrative management and development skills
• Minimum 3 years’ experience knowledge and ability to write stored procedures, temporary tables, views, indexes, and triggers when required.
• Minimum 3 years’ experience with DDL and DML statements, RDBMSs, data dictionaries, and normal forms.
• Proficient in Installing SQL Server 2005/2008 and configuration of their tools.
• Experience maintaining Database authentication modes, creation of users, configuring permissions, and assigning roles to users.
• Knowledge in MS-SQL Server 2008 OR ABOVE
• Experience leveraging both Agile and traditional SDLCS practices with the ability to blend them in the right proportions to fit a project and business environment.