Job Description :
SQL Developer with C#
Client : Go daddy/Pactera
Location : Tempe AZ and Kirkland WA
1. 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
Strong OOD skills
Experience with RESTful API design
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.
Docker or Kubernetes experience is a plus
3-5yrs experience is good.