All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20007-03562
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-20007-03562
Case Status
Certified
Received Date
2020-01-15
Decision Date
2020-05-18
Refile
N
Original File Date
2020-01-01 08:29:25
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
Johnson Johnson Services, Inc.
Employer Name Slug
johnson-johnson-services-inc
Employer Address 1
One Johnson Johnson Plaza
Employer Address 2
Employer City
New Brunswick
Employer City Slug
new-brunswick
Employer State
NEW JERSEY
Employer State Slug
new-jersey
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
8933
Employer Phone
7325245931
Employer Number of Employees
126400
Employer Year Commenced Business
1979
NAICS Code
3254
FW Ownership Interest
N
Employer Contact Name
James Kim
Employer Contact Address 1
501 George Street
Employer Contact Address 2
Employer Contact City
New Brunswick
Employer Contact State/Province
NEW JERSEY
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
8933
Employer Contact Phone
7325245931
Employer Contact Email
jkim43@its.jnj.com
Agent Attorney Name
Timothy M Nelson
Agent Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy LLP
Agent Attorney Phone
7328625000
Agent Attorney Address 1
90 Matawan Road
Agent Attorney Address 2
4th Floor
Agent Attorney City
Matawan
Agent Attorney State/Province
NEW JERSEY
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
7747
Agent Attorney Email
TNelson@fragomen.com
PW Track Number
P10019137599263
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
127982.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-09-09
PW Expiration Date
2020-06-30
Wage Offer From
128000.00
Wage Offer To
158000.00
Average Salary
143000.00
Wage Unit of Pay
Year
Worksite Address 1
1003 US Highway 202 N
Worksite Address 2
Worksite City
Raritan
Worksite City Slug
raritan
Worksite State
NEW JERSEY
Worksite Postal Code
8869
Job Title
Database Manager
Job Title Slug
database-manager
Minimum Education
Bachelor's
Major Field of Study
Info Tech, Comp Sci, Network admin mngmt
Required Training
N
Required Experience
Y
Required Experience Months
96
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
96
Accept Alternative Job Title
Database administration.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Qualified applicants must possess Bachelors degree in Information Technology, Computer Science or related and 8 years of experience in database administration. In lieu of Bachelors employer will accept 1 year additional work experience for each year not completed towards the Bachelors degree. Must possess 4 years of experience with Scrum and Agile Development environment; DevOps model; SSIS; RDBMS databases, including SQL Server and Oracle; Powershell; AWS and Microsoft Azure; Tableau and SSRS; Apache Impala; ITIL; ServiceNow; Configuration Management Database; and Microsoft Licensing.
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
2019-10-03
SWA Job Order End Date
2019-11-04
Sunday Edition Newspaper
Y
First Newspaper Name
Newark Star Ledger
First Advertisement Start Date
2019-10-27
Second Newspaper Ad Name
Newark Star Ledger
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-11-03
Employer Website From Date
2019-10-23
Employer Website To Date
2019-11-05
Professional Organization Ad From Date
2020-01-01 08:29:25
Professional Organization Advertisement To Date
2020-01-01 08:29:25
Job Search Website From Date
2019-10-28
Job Search Website To Date
2019-11-04
Employee Referral Program From Date
2020-01-01 08:29:25
Employee Referral Program To Date
2020-01-01 08:29:25
Local Ethnic Paper From Date
2019-11-01
Local Ethnic Paper To Date
2019-11-01
Radio/TV Ad From Date
2020-01-01 08:29:25
Radio/TV Ad To Date
2020-01-01 08:29:25
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
BRAZIL
Foreign Worker Birth Country
BRAZIL
Class of Admission
H-1B
Foreign Worker Education
Other
Foreign Worker Information: Major
NA
Foreign Worker Years of Education Completed
2004
Foreign Worker Institution of Education
NA
Foreign Worker Education Institution Address 1
NA
Foreign Worker Education Institution Address 2
NA
Foreign Worker Education Institution City
NA
Foreign Worker Education Institution State/Province
NA
Foreign Worker Education Institution Country
BRAZIL
Foreign Worker Education Institution Postal Code
N/A
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Timothy Nelson
Preparer Title
Partner
Preparer Email
tnelson@fragomen.com
Employer Information Declaration Name
James Kim
Employer Information Declaration Title
Senior Manager, Global Immigration