Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
online marketing manager Internship Opportunites for Students Internship Opportunities for Students Business Insights Staff Accountant Developer Enablement Manager Senior Graphic Designer Coordinator Marketing Specialist Staff Accountant II Staff Accountant I Jr Staff Accountant Accountant Staff Accountant Consulting Associate Part Time Credit Card and Vendor German Certified Public Accountant Bookkeeper Staff Accountant SR Staff Accountant Staff Accountant II Accountant Staff Accountant Accountant ACCOUNTANT I - OFFICE OF FINANCE Staff Accountant Staff Forensic Accountant Staff Accountant - NextGen Internship Staff Accountant - Palomar South Beach Accountant Staff Accountant Staff Accountant Staff Accountant Controller Audit Intern - Spring Project Controls Support Associate Accountant Staff Accountant Staff Accountant Staff Accountant STAFF ACCOUNTANT Staff Accountant in Tax Staff Accountant Non-Profit Staff Accountant Senior Accountant Adjunct Faculty Pool Audit Associate Assurance Staff RI Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Aecom Two Sigma Aerotek Exact Media WeWork Jane Street AsteroidX Doordash First Convenience Bank Borrowell AT&T Insight Global Shopify Square Amazon Flex American Income Life Hatchways Peel Regional Police Creative Circle Vector Marketing Instacart Recovhub Walgreens Akira Clickworker LowCostWebDesignFirm.com 51talk Scotiabank Microsoft TD Bank UnitedHealth Group Top Hat Paylocity CI&T Desjardins mappedin Checkout 51 Mobeewave The Youth Connection Hootsuite GoParkr autoTRADER.ca ScribbleLive SnapTravel Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

SQL Developer At Calance US

Location: Torrance, California

Job Description

FOR IMMEDIATE DETAILS ABOUT THIS POSITION, contact ANY of us direct, referencing the job# below:

Kindest Regards:
JUSTIN MATLIN: (949) 860-4716
SUMIT KUMAR: (949) 860-4718
MICHELL CASEY: (949) 860-4715
E M A I L: Recruiter.key1@calance.com

=====================
=====================

** We will NOT accept 3rd Party/Corp to Corp (C2C) consultants **

Position: SQL Developer
JOB REF#: 18400
Duration: 12+ Months (On-going Contract)
Location: Torrance, CA 90501 (on-site only)
Rate: Open, depends on exp level (W2/H1 Transfer)

** LOCAL CANDIDATES ONLY **

SQL Developer will support Connect to Consumer B2C Applications. They provide production support and project development for consumer facing websites. This includes developing, maintaining and supporting the web sites. We are looking for a high-end, expert level SQL Developer. This resource will need to describe their experience with SQL Server SSIS and Stored Procedures. They need someone who has supported high performance production/public website. Understands how to work with web developers and understanding the requirements from the website, from the application tiers so they can write the source procedures and optimize the tables and queries so that they can get high performance on the website.

This is NOT a SQL Reports or SQL Server DBA role, this is a SQL Developer role.

RESPONSIBILITIES INCLUDE:
  • Provide Database development for public websites.
  • Troubleshoot and correct bugs/defects related to database objects.
  • Optimize queries and identify bottlenecks in OLTP, warehouse and SSIS.
  • Experience creating/updating database design requirements, document the database design, review with DBA team
  • Analyze, design and code database enhancements.
  • Perform unit, system and integration testing of database objects as appropriate.
  • Assist the QA analyst, programmers and architects.
  • Assist the other DBA’s and programmers as necessary.
  • Ensure performance tuning is working with production, this is not a DBA role.

REQUIRED SKILLS/EXPERIENCE: (Resume must reflect this experience)
  • 5+ years as a SQL Developer, developing, maintaining and supporting the public web sites.
•• Experience working with web services and high performance/high load web sites (work with 1 Million records)
•• Experience working with high load systems
  • Working with SQL XML on SQL Server 2008 r2 or higher
  • Experience developing database objects, stored procedures, functions, packages and triggers using SQL and T-SQL
  • Experience working with web developers, understanding requirements to write stored procedures and optimize table and queries.
  • Experience creating, maintaining and deploying SQL Server Integration Services (SSIS) packages
  • Documenting database designs and using ERWIN
  • Experience working with SQL Server 2008, 2017 and 2019 databases
  • EDUCATION: BA/BS in Information Technology, Computer Science, related field or equivalent work experience.

DESIRED SKILLS:
  • Support and troubleshooting for high traffic consumer facing web sites

Calance Benefits Offerings:
  • H1 Transfers/Green Card processing
  • Medical/Dental/Vision benefits (HMO/PPO)
  • 401K Retirement program
  • Paid Bi-Weekly/Direct Deposit
  • Flex Spending Plan
  • Voluntary Life, AD&D, STD or LTD plans