Role: SQL Developer

Location: Torrance, CA

Contract Type: W2 only, No Corp to Corp applicants

Role Type: Hybrid 2 days onsite at Torrance, CA

Responsibilities

• Application Development and Production Support for multiple large projects
• Research and resolve production issues, troubleshooting of Mid-Tier MS SQL Server online and batch issues
• Evaluate the daily and monthly batch process to improve performance and shorten the critical path window
• Perform Impact Analysis across multiple platforms and applications
• Deliver complete documentation for estimates, design and development
• On-call for production support during off-office hours (night and weekend).

What will this person be working on:

• Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements
• Codes, tests, and debugs new software or makes enhancements to existing software
• Writes programs according to specifications from higher level staff or business analysts
• Develops technical documentation
• Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components
• Collaborates with technical staff to learn and understand software problems
• Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques
• Provides general system users and management with system analysis and feedback
• Influences system design by identifying and recommending design and requirements needs for software enhancements
• Mentors and coaches less experienced staff
• Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
• Follows established configuration/change control processes

Must Haves

• 6+ years of strong SQL Server backend experience in a batch environment
• Very strong SQL development skills and very comfortable with Stored procedures, views, DTS packages, Windows batch scripts etc.
• We have manual workflow and queues implemented using SQL, so they need solid SQL skills to debug any issues.
• Knowledge of Salesforce Service & Marketing cloud platform is preferred
• Experience in working in Agile and Waterfall methodologies.