Position Title: Software Developer IV
Duration: 12 months contract (with high possibility of extending into Long Term depending on the performance)
Location: Parsippany, NJ
Must haves:ย
Excellent Communication Skillsย
5-8+ years Software Development experienceย
7+ years - Advance T-SQL and Database development skillsย
3 - years - Database modelling and design experienceย
5 years - Database - SQL Server 2008/20012 or higherย
4+ years of experience in creating and maintaining SQL code for medium to large OLTP applicationsย
Experienced with Stored procedure creation/debugging/ optimization/tuningย
Experienced with functions, triggers, Views and T-SQLย
Job Responsibilityย
Develops code (writes software application programs).ย
Responsible for unit testing.ย
Develops and codes programs to integrate multiple subsystems.ย
Identifies and recommends system enhancements to improve or expand customer services by anticipating customer problems and recommending solutions.ย
Responsible for leading technical aspects of project from inception through to deployment. Participate in analysis and system design specification sessions.ย
Documentation of design options and solutions according to System Development Life Cycle (SDLC) methodology. Ensure that solutions adhere to development bestย
practices and architectural principles.ย
Apply analytical skills to resolve problems and deliver viable solutions. Anticipate obstacles and execute proactive approaches to issues. Activeย
participation in issue resolution.ย
Responsible for coding, testing, packaging, deployment and support of builds as code is promoted from development, system, acceptance and productionย
environments. May lead code reviews.ย
Design and Develop SQL Server Integration packages using SSISย
Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner dailyย
Working with application developers to assist in database design, query tuning, index assignment, and trigger and procedure creationย
Ability to research and trouble-shoot application problems using SQL programming skillsย
Monitoring and troubleshooting SQL jobs, DTS, and integration servicesย
Ensuring that the integrity of company databases is maintainedย
Work closely with QA team and ops team on Stage to ensure that environments are fully functional and that builds are properly deployed.ย
Provide technical support to business and testing team during testing phases. Track defects, defect triage and resolution.ย
Data set up and environment shake down.