What are the responsibilities and job description for the SQL Developer position at Tentek, Inc.?
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.
