SQL Developer
- Compensation
- Not disclosed
- Location
- Parsippany-Troy Hills, NJ, us
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 4+ years
- Category
- Not specified
- Posted
Skills
Must have
- 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.
- Thanks & Regards
Full description
Position Title: Software Developer IVDuration: 12 months contract (with high possibility of extending into Long Term depending on the performance)Location: Parsippany, NJMust 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.