SQL Developer

AditiStaffing; Parsippany-Troy Hills (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading staffing firm is seeking a Software Developer IV for a 12-month contract in Parsippany, NJ. The candidate should have 5-8 years of software development experience, with a strong emphasis on advanced T-SQL and database skills. Responsibilities include developing application code, unit testing, and liaising with various teams to enhance system functionality. This role provides an opportunity to work on large OLTP applications and requires proficiency in SQL Server. Competitive compensation and potential for long-term extension.

Qualifications

• 5-8+ years Software Development experience.
• 7+ years in Advanced T-SQL and Database development.
• 3 years experience in Database modeling and design.

Responsibilities

• Develops software application programs.
• Responsible for unit testing.
• Integrates multiple subsystems.

Skills

Software Development experience

Advance T-SQL and Database development skills

Database modeling and design experience

SQL Server (2008/2012 or higher)

Stored procedure creation/debugging/optimization/tuning

Functions, triggers, Views, and T-SQL

Job description

Aditi Staffing is an MBE certified, IT Staffing firm in the US offering contract, contract-to-hire & direct hire career opportunities with Fortune Firms. Recently recognized as one of the fastest growing staffing firms and top diversity firm by the Staffing Industry Analysts, Aditi Staffing has been a partner of choice for candidates and clients.

Visit our website: http://www.aditistaffing.com/

Job Description

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:

• 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

Technical Recruiter