Job Description :
Company Overview
Pactera is a consulting and technology services provider with global headquarters strategically located in China and regional headquarters in North America, Asia Pacific and Europe. Since 1995, Pactera has been delivering world-class business IT consulting solutions and outsourcing services to global clients, including a wide range of Fortune 500 companies. With more than 26,000 employees worldwide, the company’s global footprint encompasses a diverse offering of technologies, services and business models focused on providing clients a holistic digital vision to drive business outcomes and transform user experience. This is a long-term contract opportunity with decent pay. Local WA and W-2 are only preferred.

Required Skills:
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.

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 E-COMM 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
1.Experience with RESTful API design
2.Experience in an Agile development environment is preferred, fluent in writing code on the 3.MSFT stack (C#, C++,, etc. experience/knowledge in SOAP and REST will be plus.
4.Docker or Kubernetes experience is a plus
5.3-5years experience is good.