Fiscal Year

2018

Case Number

A-17268-90946

Case Status

Certified-Expired

Received Date

2017-09-27

Decision Date

2018-02-06

Refile

N

Original File Date

2018-01-01 05:38:57

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MERCURY INSURANCE SERVICES, LLC (D/B/A MERCURY INSURANCE GROUP)

Employer Name Slug

mercury-insurance-services-llc-dba-mercury-insurance-group

Employer Address 1

555 W. IMPERIAL HIGHWAY

Employer Address 2

Employer City

BREA

Employer City Slug

brea

Employer State

CA

Employer State Slug

ca

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92821

Employer Phone

714-255-5294

Employer Number of Employees

4200

Employer Year Commenced Business

1963

NAICS Code

FW Ownership Interest

N

Employer Contact Name

Employer Contact Address 1

Employer Contact Address 2

Employer Contact City

Employer Contact State/Province

Employer Contact Country

Employer Contact Postal Code

Employer Contact Phone

Employer Contact Email

Agent Attorney Name

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen & Loewy, LLP

Agent Attorney Phone

Agent Attorney Address 1

Agent Attorney Address 2

Agent Attorney City

Atlanta

Agent Attorney State/Province

GA

Agent Attorney Country

Agent Attorney Postal Code

Agent Attorney Email

PW Track Number

P10017053721464

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

108.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2017-05-23

PW Expiration Date

2017-08-21

Wage Offer From

108.00

Wage Offer To

138.00

Average Salary

123.00

Wage Unit of Pay

Year

Worksite Address 1

Worksite Address 2

Worksite City

Brea

Worksite City Slug

brea

Worksite State

CA

Worksite Postal Code

92821

Job Title

Sr. Database Administrator

Job Title Slug

sr-database-administrator

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science or related technical field

Accept Alternative Combination

Accept Alternative Combination Education

N

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

Computer Science or related technical field

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Any occupation in which required experience is gained.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

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

2017-07-06

SWA Job Order End Date

2017-08-08

Sunday Edition Newspaper

Y

First Newspaper Name

The Orange County Register

First Advertisement Start Date

2017-06-18

Second Newspaper Ad Name

The Orange County Register

Second Advertisement Type

Y

Second Ad Start Date

2017-06-25

Employer Website From Date

2017-07-06

Employer Website To Date

2017-09-27

Professional Organization Ad From Date

2018-01-01 05:38:57

Professional Organization Advertisement To Date

2018-01-01 05:38:57

Job Search Website From Date

2018-01-01 05:38:57

Job Search Website To Date

2018-01-01 05:38:57

Employee Referral Program From Date

2017-06-09

Employee Referral Program To Date

2017-06-29

Local Ethnic Paper From Date

2018-01-01 05:38:57

Local Ethnic Paper To Date

2017-06-23

Radio/TV Ad From Date

2018-01-01 05:38:57

Radio/TV Ad To Date

2018-01-01 05:38:57

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

ELECTRICAL ENGINEERING

Foreign Worker Years of Education Completed

2010

Foreign Worker Institution of Education

CALIFORNIA STATE UNIVERSITY, LOS ANGELES

Foreign Worker Education Institution Address 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

Foreign Worker Education Institution Postal Code

Foreign Worker Experience with Employer

Foreign Worker Employer Pays for Education

Foreign Worker Currently Employed

Employer Completed Application

Preparer Name

Preparer Title

Partner

Preparer Email

Employer Information Declaration Name

Employer Information Declaration Title

Recruiting Associate