Fiscal Year

2022

Case Number

A-21113-77491

Case Status

Certified-Expired

Received Date

2021-05-21

Decision Date

2021-10-20

Refile

N

Original File Date

2022-01-01 10:17:53

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

UNITED AIRLINES, INC.

Employer Name Slug

united-airlines-inc

Employer Address 1

233 S. WACKER DRIVE

Employer Address 2

16TH FLOOR

Employer City

CHICAGO

Employer City Slug

chicago

Employer State

ILLINOIS

Employer State Slug

illinois

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

60606

Employer Phone

847-700-0243

Employer Number of Employees

92000

Employer Year Commenced Business

1926

NAICS Code

48111

FW Ownership Interest

N

Employer Contact Name

Kirstin Roberts

Employer Contact Address 1

609 Main Street

Employer Contact Address 2

18th Floor

Employer Contact City

Houston

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

77002

Employer Contact Phone

346-265-3432

Employer Contact Email

immigration@united.com

Agent Attorney Name

Victoria M Ger

Agent Attorney Firm Name

FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP

Agent Attorney Phone

(312) 263-6101

Agent Attorney Address 1

333 West Wacker Drive

Agent Attorney Address 2

Floor 15

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60606

Agent Attorney Email

vger@fragomen.com

PW Track Number

P10020170664545

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

N/A

PW Wage

107312.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2020-09-22

PW Expiration Date

2021-06-30

Wage Offer From

110000.00

Wage Offer To

130000.00

Average Salary

120000.00

Wage Unit of Pay

Year

Worksite Address 1

233 S Wacker Drive

Worksite Address 2

Worksite City

Chicago

Worksite City Slug

chicago

Worksite State

ILLINOIS

Worksite Postal Code

60606

Job Title

Senior DBA - SQL IT PDW, APS

Job Title Slug

senior-dba-sql-it-pdw-aps

Minimum Education

Master's

Major Field of Study

Computer Science, Information Technology, Engineering Management, or rltd fld

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

10

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

98

Accept Alternative Job Title

SQL server and Parallel Data Warehouse or related.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must have work experience in Building DB structure including Design schemas. Build tables, FKs, PKs on local DBs created by system DBA that meet the businessapplication needs; Providing PDW DB consultant service to data layer developers who are responsible for merging data from multiple sources into a data warehouse. Designing and implementing physical warehouse, then cleaning, standardizing, and scrubbing data before loading; Building queries and stored procedures that meet business or application needs. Ensuring the application is fully optimized for the database and vice versa; Providing Application or Project security requirement to System DBA and maintaining Application level database security including create and maintain users and roles, and assign privileges; Establishing Application or project backup and recovering policies and procedures and working with system DBA to implement it. Developing archive or purge procedure based on business or application requirement; Planning DB growth and changing capacity plans to fulfill Business requirement; and Working as part of an Application team and providing 724 supports when required.br br Addendum to H.4, H.8 and H.10 Position requires a Masters degree in Computer Science, Information Technology, Engineering Management, or related field, and 8 years of experience with SQL server and Parallel Data Warehouse or related. In the alternative, employer will also accept a Bachelors degree in Computer Science, Information Technology, Engineering Management, or related field, and 10 years of experience with SQL server and Parallel Data Warehouse or related.

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

2021-03-05

SWA Job Order End Date

2021-04-06

Sunday Edition Newspaper

Y

First Newspaper Name

Chicago Tribune

First Advertisement Start Date

2021-03-21

Second Newspaper Ad Name

Chicago Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-03-28

Employer Website From Date

2022-01-01 10:17:53

Employer Website To Date

2022-01-01 10:17:53

Professional Organization Ad From Date

2022-01-01 10:17:53

Professional Organization Advertisement To Date

2022-01-01 10:17:53

Job Search Website From Date

2021-03-22

Job Search Website To Date

2021-04-05

Employee Referral Program From Date

2022-01-01 10:17:53

Employee Referral Program To Date

2022-01-01 10:17:53

Local Ethnic Paper From Date

2021-03-26

Local Ethnic Paper To Date

2021-03-26

Radio/TV Ad From Date

2022-01-01 10:17:53

Radio/TV Ad To Date

2022-01-01 10:17:53

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

ENGINEERING MANAGEMENT

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

UNIVERSITY OF HOUSTON CLEAR LAKE

Foreign Worker Education Institution Address 1

2700 BAY AREA BLVD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HOUSTON

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

77058

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Victoria M Ger

Preparer Title

Senior Associate

Preparer Email

vger@fragomen.com

Employer Information Declaration Name

Kirstin Roberts

Employer Information Declaration Title

Senior Specialist Mobility