IT Programmer

Position has responsibility for software development, implementation, and maintenance on applications varying in size from small departments to large client organizations. Troubleshoots system problems and issues, researches and implements improvements to the application. Participates in other departmental duties as needed. Performs duties with a maintained focus on customer satisfaction.

Responsibilities:
•Responsible for designing, developing, and maintaining databases. Provide operational and maintenance support to several existing systems. Responsible for installations, upgrades, back-ups and configurations. Ability to implement database security, perform tuning, monitoring and create policies and procedures. Resolve performance issues, data replication, indexing and data integrity problems
•Ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
•Extract Transfer and Load data from applications into the data warehouse.
•Develop business intelligence solutions using the Microsoft Business Intelligence stack.
•Write stored procedures for application logic.
•Create reports using SSRS Write stored procedures for reports.
•Core database administrative tasks that include creating a new SQL Server instance, adding a new login, and performing database backups.
•Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
•Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
•Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.

Education:
•Associates or Bachelors degree in computer information technology, management information systems, computer programming, computer science or related field preferred;

Experience:
•3-7 years experience with relational database software with additional experience with .Net programming framework and Windows based server administration.

Skills:
•Computer skills including the ability to operate software, and/ or client servers at a highly proficient level;
•Software development and maintenance;
•Experience in enterprise scale web application development;
•Ability to manage multiple projects simultaneously, set priorities, and meet deadlines;
•Excellent written/verbal communication and organizational skills;
•Ability to work independently with high degree of initiative;
•Excellent analytical, problem solving, decision making skills;
•Excellent customer service skills;

Required Software Skills:
•SQL Server Analysis Services/Cube Designer
•SQL Reporting Services
•.Net Framework C#, VB.net
•T-SQL
•Access 2007/2010

Required Platforms:
•Windows Server 2008, 2008 R2
•SQL Server 2005,2008, 2008 R2

Required Software Tools:
•Visual Studio 2008, 2010
•Business Intelligence Studio 2008, Report Builder 2.0/3.0
•SharePoint designer

Other skills not required:
•SharePoint 2007/2010 Platform
•Windows 2003, 2008, 2008 R2, Server Administration
•Redhat/CentOS/Linux Administration
•Web Services, Soap
•Oracle 10g, Oracle 11g
•PL-SQL