All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-22110-43106

Fiscal year: 2023

Fiscal Year

2023

Case Number

A-22110-43106

Case Status

Certified

Received Date

2022-05-09

Decision Date

2023-01-23

Refile

N

Original File Date

2023-01-01 08:12:42

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MARSH MCLENNAN SHARED SERVICES LLC

Employer Name Slug

marsh-mclennan-shared-services-llc

Employer Address 1

1166 AVENUE OF THE AMERICAS

Employer Address 2

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10036

Employer Phone

212-345-5000

Employer Number of Employees

83000

Employer Year Commenced Business

2011

NAICS Code

524130

FW Ownership Interest

N

Employer Contact Name

Pamela Keppel

Employer Contact Address 1

121 River Street

Employer Contact Address 2

Employer Contact City

Hoboken

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

7030

Employer Contact Phone

201-284-4970

Employer Contact Email

Pamela.Keppel@mmc.com

Agent Attorney Name

Hyla K Rosenberg

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

2126888555

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

ebrettschneider@fragomen.com

PW Track Number

P10021180433202

PW SOC Code

15-1199

PW SOC Title

Database Architects

PW Skill Level

Level II

PW Wage

76045.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-02-22

PW Expiration Date

2022-06-30

Wage Offer From

100000.00

Wage Offer To

140000.00

Average Salary

120000.00

Wage Unit of Pay

Year

Worksite Address 1

155 N. Wacker Drive

Worksite Address 2

Worksite City

Chicago

Worksite City Slug

chicago

Worksite State

ILLINOIS

Worksite Postal Code

60606

Job Title

Senior Database Engineer/ Specialist – IT Systems Engineering

Job Title Slug

senior-database-engineer-specialist-it-systems-engineering

Minimum Education

Bachelor's

Major Field of Study

Information Technology or a related field of study

Required Training

N

Required Experience

Y

Required Experience Months

36

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

36

Accept Alternative Job Title

related position such as Database Administrator, SQL Server Database Administrator, and IT Analyst

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Bachelors degree or a foreign equivalent in Information Technology or a related field of study plus three 3 years of progressively responsible experience in the job offered or a related position such as Database Administrator, SQL Server Database Administrator, and IT Analyst. Must have three 3 years of progressively responsible experience with SQL Server; TransactSQLTSQL scripts to automate database monitoring; SQL Backups; Installation, configuration, administration, maintenance of SQL Server; SQL performance and monitoring; SentryOne tool; Database administrationbr and maintenance for SQL server; and Technical expertise in handling the high availability solutions in SQL, including Always ON, Failover Clustering, and Log shipping.

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-02-08

SWA Job Order End Date

2022-03-11

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Tribune

First Advertisement Start Date

2022-02-27

Second Newspaper Ad Name

Chicago Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-03-06

Employer Website From Date

2022-01-18

Employer Website To Date

2022-05-04

Professional Organization Ad From Date

2023-01-01 08:12:42

Professional Organization Advertisement To Date

2023-01-01 08:12:42

Job Search Website From Date

2022-03-01

Job Search Website To Date

2022-03-14

Employee Referral Program From Date

2023-01-01 08:12:42

Employee Referral Program To Date

2023-01-01 08:12:42

Local Ethnic Paper From Date

2022-03-02

Local Ethnic Paper To Date

2022-03-02

Radio/TV Ad From Date

2023-01-01 08:12:42

Radio/TV Ad To Date

2023-01-01 08:12:42

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

Not in USA

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

INFORMATION TECHNOLOGY US EQUIV

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

SIKKIM MANIPAL UNIVERSITY

Foreign Worker Education Institution Address 1

5TH MILE, UPPER TADONG, TADONG

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

GANGTOK

Foreign Worker Education Institution State/Province

SIKKIM

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Hyla K Rosenberg

Preparer Title

Partner

Preparer Email

ebrettschneider@fragomen.com

Employer Information Declaration Name

Annette Baer

Employer Information Declaration Title

Senior Global Mobility Manager, Americas