Job Description :
Role - SQL developer with some C# experience
Locations : 2 Scottsdale, AZ and Kirkland, WA
Visa - GC/USC
Must Have’s

1. Strong SQL Database Development
1. Stored procedures & scripts
2. Performance tuning
3. Troubleshooting
2. Some C# development exp
3. Some C++ development – ideally since they have some sustained work that was written in C++

Updated JD:
This position is more a balance of SQL Server and C# .Net. No web. C++ experience would be a plus. Communication skills are important. Troubleshooting skills are as well. Please keep in mind that the initial tasks will be daily devops types of activities (error resolution, trouble ticket investigation, box validation post patching (with supplied scripts There is discussion about expanding to light dev support for the legacy eCommerce applications.


Main task
a. Check fulfillment logs (including MSQM logs, error in various SQL table, other log files) etc to identify the root-cause and fix accordingly in the database (by using SQL statement)
b. Support partner team’s requests and inquires on fulfillment issues in all environments.
c. Document in detail all the incidents handled and create knowledge base articles for future reference.
2. Some additional tasks
a. Run post-patching validation testing for each app server before putting them into rotation
b. Enable certificates for partner teams to access eCOMM system through SQL update
c. Do Price Lock for customers
d. Weekly GeoIP database update
e. Address redemption code requests on a regular base.
f. Performing min variant spins on re seller domain pricing through SQL update

Skills needed
1. Strong T-SQL skills, experiences on writing SQL statement to fix customer data on large-scale production database without causing performance bottleneck.
2. Strong problem-solving skills, be able to deduce the possible root cause based on symptoms observed, and invalidate/validate them through reasonable approaches.
3. Pro-active communicator, be able to grasp the partners team’s need quickly and understand what they really want and translate that into business requirement clearly
4. Basic understanding on technology related to Web Server and Message Queues
5. Bachelor’s degree in CS or a relevant technical field; Master’s degree preferred
1. Strong OOD skills
2. Experience with RESTful API design
3. Experience in an Agile development environment is preferred, fluent in writing code on the MSFT stack (C#, C++, ASP.net, etc. experience/knowledge in SOAP and REST will be plus.
4. Docker or Kubernetes experience is a plus
5. 3-5yrs experience is good.