All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22318-57285
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22318-57285
Case Status
Certified-Expired
Received Date
2023-02-22
Decision Date
2024-03-12
Refile
N
Original File Date
2024-01-01 00:55:02
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
AMAZON WEB SERVICES, INC.
Employer Name Slug
amazon-web-services-inc
Employer Address 1
2250 7TH AVE
Employer Address 2
Employer City
SEATTLE
Employer City Slug
seattle
Employer State
WASHINGTON
Employer State Slug
washington
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98121
Employer Phone
206-266-1000
Employer Number of Employees
647500
Employer Year Commenced Business
2006
NAICS Code
454111
FW Ownership Interest
N
Employer Contact Name
JULIE EISEMANN
Employer Contact Address 1
2250 7TH AVE
Employer Contact Address 2
Employer Contact City
Seattle
Employer Contact State/Province
WASHINGTON
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
98121
Employer Contact Phone
2062661000
Employer Contact Email
amazonimmigration@amazon.com
Agent Attorney Name
JOI MCEACHERN
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
617-574-0400
Agent Attorney Address 1
100 High Street
Agent Attorney Address 2
3rd Floor
Agent Attorney City
Boston
Agent Attorney State/Province
MASSACHUSETTS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
2110
Agent Attorney Email
amazonperm@fragomen.com
PW Track Number
P10022013828240
PW SOC Code
15-1243.00
PW SOC Title
Database Architects
PW Skill Level
Level IV
PW Wage
173909.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-07-21
PW Expiration Date
2023-06-30
Wage Offer From
173909.00
Wage Offer To
0.00
Average Salary
173909.00
Wage Unit of Pay
Year
Worksite Address 1
2021 7th Avenue
Worksite Address 2
Worksite City
Seattle
Worksite City Slug
seattle
Worksite State
WASHINGTON
Worksite Postal Code
98121
Job Title
Database Engineer II
Job Title Slug
database-engineer-ii
Minimum Education
Bachelor's
Major Field of Study
Computer Science
Required Training
N
Required Experience
Y
Required Experience Months
72
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Engineering, or Related Field
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
72
Accept Alternative Job Title
database administrator or software engineering role.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Bachelors degree, or foreign equivalent, in Computer Science, Engineering, or Related Field and six years in a database administrator or software engineering role. Must have six years of experience in the following skills 1 Designing and maintaining relational databases including Oracle, MySQL, Postgres or SqlServer; 2 Translating customers needs and use cases into technical innovation and engineering solutions; 3 Systems engineering including Linux performance, memory management, IO tuning, configuration, security, networking, clusters and troubleshooting; 4 Storage engineering, including NAS, SAN, SSD, multipathing and caching; 5 Building and maintaining complex missioncritical production database systems; 6 Analyzing customer workloads and use cases, including performance, availability and scalability; 7 Working directly with customers, resolving database, systems and infrastructurerelated issues; 8 Knowledge of relational database internals locking, consistency, serialization, recovery paths; 9 Coding in procedural language for at least one database PLSQL, PLSQL, TSQL, or similar; 10 Understanding of data replication with experience in at least one replication technology; 11 General knowledge of the various types data stores relational, data warehouse, file stores, or others similar. Up to 20 domestic travel may be required.
Combination Occupation
N
Offered to Applicant Foreign Worker
Y
Foreign Worker Live on Premises
N
Foreign Worker Live in Domestic Service
N
Foreign Worker Live in Domestic Service Count
Professional Occupation
Y
Application for College/University Teacher
N
SWA Job Order Start Date
2022-09-08
SWA Job Order End Date
2022-10-11
Sunday Edition Newspaper
Y
First Newspaper Name
The Seattle Times
First Advertisement Start Date
2022-09-18
Second Newspaper Ad Name
The Seattle Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-09-25
Employer Website From Date
2022-09-08
Employer Website To Date
2022-11-14
Professional Organization Ad From Date
2024-01-01 00:55:02
Professional Organization Advertisement To Date
2024-01-01 00:55:02
Job Search Website From Date
2022-09-08
Job Search Website To Date
2022-10-11
Employee Referral Program From Date
2024-01-01 00:55:02
Employee Referral Program To Date
2024-01-01 00:55:02
Local Ethnic Paper From Date
2022-09-23
Local Ethnic Paper To Date
2022-09-29
Radio/TV Ad From Date
2024-01-01 00:55:02
Radio/TV Ad To Date
2024-01-01 00:55:02
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
INFORMATION SYSTEMS
Foreign Worker Years of Education Completed
2018
Foreign Worker Institution of Education
THE UNIVERSITY OF WASHINGTON
Foreign Worker Education Institution Address 1
1400 NORTHEAST CAMPUS PARKWAY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
SEATTLE
Foreign Worker Education Institution State/Province
WA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
98195
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
JOI MCEACHERN
Preparer Title
Associate Attorney
Preparer Email
amazonperm@fragomen.com
Employer Information Declaration Name
DanielSarahChongli VAN DEN HANDELJENSENWU
Employer Information Declaration Title
HR Immigration