All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-20100-41532

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-20100-41532

Case Status

Certified

Received Date

2020-04-23

Decision Date

2020-09-24

Refile

N

Original File Date

2020-01-01 19:59:17

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

FANDANGO MEDIA LLC

Employer Name Slug

fandango-media-llc

Employer Address 1

407 NORTH MAPLE DRIVE

Employer Address 2

SUITE 300

Employer City

BEVERLY HILLS

Employer City Slug

beverly-hills

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

90210

Employer Phone

3109540278

Employer Number of Employees

480

Employer Year Commenced Business

2000

NAICS Code

561599

FW Ownership Interest

N

Employer Contact Name

Darlene Bayani

Employer Contact Address 1

407 North Maple Drive

Employer Contact Address 2

Suite 300

Employer Contact City

Beverly Hills

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

90210

Employer Contact Phone

2134189055

Employer Contact Email

dbayani@fandango.com

Agent Attorney Name

Jenna Robinson

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen and Loewy LLP

Agent Attorney Phone

9498629443

Agent Attorney Address 1

18401 Von Karman Avenue

Agent Attorney Address 2

Suite 255

Agent Attorney City

Irvine

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

92612

Agent Attorney Email

jrobinson@fragomen.com

PW Track Number

P10019213031847

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

115419.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-11-26

PW Expiration Date

2020-06-30

Wage Offer From

128750.00

Wage Offer To

0.00

Average Salary

128750.00

Wage Unit of Pay

Year

Worksite Address 1

407 N. Maple Drive

Worksite Address 2

Suite 300

Worksite City

Beverly Hills

Worksite City Slug

beverly-hills

Worksite State

CALIFORNIA

Worksite Postal Code

90210

Job Title

Sr. DBA

Job Title Slug

sr-dba

Minimum Education

Master's

Major Field of Study

Computer Science, Electrical Engineering or related Engineering field

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

In job offered or closely related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

1. Experience with SQL server, DB2, Sybase, and MySQL to design and manage multiple data systems in NoSQL and Relational data systems in standalone and clustered environments.br 2. Experience with AWS or Azure to design and maintain databases and data warehouse across multiple environments onpremise and in the cloud.br 3. Experience with production rollout of systems through multiple project management cycles and test phasesbr 4. Implement and support database high availability and disaster recovery solutions using AlwaysOn, database mirroring, clustering and replication.br 5. Knowledge of data security best practices and compliance.br 6. Formulate, implement and validate ETL solutions using SSIS and Cbr 7. Knowledge of Idera and Datadogbr 8. Microsoft Certification Administering SQL Server 20122014 requiredbr br Employer will accept any suitable combination of education, training or experience. Experienceknowledge must be sufficient to perform the required job duties in the normally accepted manner.

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-12-31

SWA Job Order End Date

2020-02-03

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2020-01-26

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-02-02

Employer Website From Date

2020-01-01 19:59:17

Employer Website To Date

2020-01-01 19:59:17

Professional Organization Ad From Date

2020-01-01 19:59:17

Professional Organization Advertisement To Date

2020-01-01 19:59:17

Job Search Website From Date

2020-01-28

Job Search Website To Date

2020-02-04

Employee Referral Program From Date

2019-12-31

Employee Referral Program To Date

2020-01-15

Local Ethnic Paper From Date

2020-01-29

Local Ethnic Paper To Date

2020-01-29

Radio/TV Ad From Date

2020-01-01 19:59:17

Radio/TV Ad To Date

2020-01-01 19:59:17

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

2014

Foreign Worker Institution of Education

UNIVERSITY OF ARKANSAS

Foreign Worker Education Institution Address 1

1 UNIVERSITY OF ARKANSAS

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FAYETTEVILLE

Foreign Worker Education Institution State/Province

AR

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

72701

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jenna Robinson

Preparer Title

Associate

Preparer Email

jrobinson@fragomen.com

Employer Information Declaration Name

Darlene Bayani

Employer Information Declaration Title

HR Generalist