SQL Developer

About the role

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.

• Additional Information: Thanks & Regards
• Arun Kumar
• Technical Recruiter