All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20303-14574
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20303-14574
Case Status
Certified
Received Date
2020-12-04
Decision Date
2021-06-08
Refile
N
Original File Date
2021-01-01 09:33:26
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
JP MORGAN CHASE CO
Employer Name Slug
jp-morgan-chase-co
Employer Address 1
10 SOUTH DEARBORN STREET
Employer Address 2
IL10043
Employer City
CHICAGO
Employer City Slug
chicago
Employer State
ILLINOIS
Employer State Slug
illinois
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
60603
Employer Phone
312-732-2655
Employer Number of Employees
256000
Employer Year Commenced Business
1838
NAICS Code
551112
FW Ownership Interest
N
Employer Contact Name
Jennifer R Shapiro
Employer Contact Address 1
10 South Dearborn Street
Employer Contact Address 2
IL10801
Employer Contact City
Chicago
Employer Contact State/Province
ILLINOIS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
60603
Employer Contact Phone
312-732-2655
Employer Contact Email
jennifer.r.shapiro@jpmchase.com
Agent Attorney Name
Jenny Nieves
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent Attorney Phone
2122302877
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10018
Agent Attorney Email
jnieves@fragomen.com
PW Track Number
P10019308124525
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
114483.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-02-28
PW Expiration Date
2020-06-30
Wage Offer From
118000.00
Wage Offer To
0.00
Average Salary
118000.00
Wage Unit of Pay
Year
Worksite Address 1
10 S Dearborn Street
Worksite Address 2
Worksite City
Chicago
Worksite City Slug
chicago
Worksite State
ILLINOIS
Worksite Postal Code
60603
Job Title
Associate, Database Management
Job Title Slug
associate-database-management
Minimum Education
Bachelor's
Major Field of Study
***Please see section H.14, specific skills or other requirements***
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
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
60
Accept Alternative Job Title
Please see H.14.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Skills required Experience with Oracle Database Administration. Experience with Performance Tuning. Experience with User Access Administration. Experience with Release and Project Management. Experience with capacity planning. Experience with database upgrade and migration. Experience with database modeling and design. Experience with automation and code deployment using Jenkins SVN. Experience with replication tools including Golden Gate and Oracle Streams. Experience with software development life cycle. Experience with production support. Experience with Delphix and virtual databases. Employer will accept any amount of professional experience with the required skills.br br Continued from Sections H.4B and H.10B.br Minimum education required Bachelors degree or equivalent in Information Technology, Business Administration, or related field.br br Minimum experience required 5 years of experience in database development and administration; experience in the banking and financial services industry; experience in the software development lifecycle; experience in performance tuning and production support; and experience in SQL and PL SQL development and tuning, or related experience.
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
2020-06-16
SWA Job Order End Date
2020-07-17
Sunday Edition Newspaper
Y
First Newspaper Name
The Chicago Tribune
First Advertisement Start Date
2020-07-26
Second Newspaper Ad Name
The Chicago Tribune
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-08-02
Employer Website From Date
2020-07-24
Employer Website To Date
2020-08-07
Professional Organization Ad From Date
2021-01-01 09:33:26
Professional Organization Advertisement To Date
2021-01-01 09:33:26
Job Search Website From Date
2020-07-26
Job Search Website To Date
2020-08-03
Employee Referral Program From Date
2021-01-01 09:33:26
Employee Referral Program To Date
2021-01-01 09:33:26
Local Ethnic Paper From Date
2020-07-29
Local Ethnic Paper To Date
2020-07-29
Radio/TV Ad From Date
2021-01-01 09:33:26
Radio/TV Ad To Date
2021-01-01 09:33:26
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
Bachelor's
Foreign Worker Information: Major
BUSINESS ADMINISTRATION
Foreign Worker Years of Education Completed
2010
Foreign Worker Institution of Education
SYMBIOSIS CENTRE FOR DISTANCE LEARNING
Foreign Worker Education Institution Address 1
SYMBIOSIS BHAVAN, 1065 B, GOKHALE CROSS ROAD, MODEL COLONY
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
PUNE
Foreign Worker Education Institution State/Province
MAHARASHTRA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
411016
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Jenny Nieves
Preparer Title
Partner
Preparer Email
JNieves@fragomen.com
Employer Information Declaration Name
Jennifer Shapiro
Employer Information Declaration Title
Attorney in Fact Executive Director