Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:UNITED AIRLINES, INC.
Employer Address_Line 1:233 S. WACKER DRIVE
Employer Address_Line 2:16TH FLOOR
Employer City :CHICAGO
State:
Employer State/ Province:ILLINOIS
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:60606
Employer Phone No.:847-700-0243
Employer Phone Extent No.:
Total Number of Employees:92000
Employer Year of Commenced :
NAICS Code:48111
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Kirstin Roberts
Employer Contact Address Line1:609 Main Street
Employer Contact Address Line2:18th Floor
Employer Contact City:Houston
Employer Contact State/ Provice:TEXAS
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:77002
Employer Contact Phone:346-265-3432
Employer Contact Email:immigration@united.com
Attorney
Agent/ Attorney Name:Victoria M Ger
Agent/ Attorney Firm Name:FRAGOMEN, DEL REY, BERNSEN LOEWY, LLP
Agent/ Attorney Phone:(312) 263-6101
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:333 West Wacker Drive
Agent/ Attorney Address Line 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
Position Info
Prevailing Wage Track Number:P10020170664545
Prevailing Wage SOC Code :15-1141
Prevailing Wage SOC Title :Database Administrators
Prevailing Wage Skill Level:N/A
Prevailing Wage:107312
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:Other
Prevailing Wage Other Source:Towers Watson - 10/10/2019
Prevailing Wage Determination Date :2020-09-22
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:110000
Wage Offer To:130000
Wage Offer Unit of Pay:Year
Workstie Address Line 1:233 S Wacker Drive
Worksite Address Line 2:
Worksite City :Chicago
Worksite State:ILLINOIS
Worksite Postal Code:60606
Job Title:Senior DBA - SQL IT PDW, APS
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:Computer Science, Information Technology, Engineering Management, or rltd fld
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
Alternate Combination of Education/ Experience:Y
Required Alternate Level of Education :Bachelor's
Other Alternate Level of Education:
Acceptable Years of Experience:10
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:98
Accept Alternate Job Title:SQL server and Parallel Data Warehouse or related.
Normal Requirements of Job Opportunity:N
Required Foreign Language: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 Applied Foreign Worker:Y
ForeignWorker Live on Premises :N
Live in Domestic Service Worker:N
Employment Contract :
Professional Occupation :Y
College/ University Teacher:N
Competitive Process:
Basic Recruitment Process :
Teacher Select Date:
Teacher Publish Journal Name:
Additional Recruitment Information:
Job Oder Start Date:2021-03-05
Job Oder End Date:2021-04-06
Sunday Edition Newspaper:Y
First Newspaper Name:Chicago Tribune
First Advertisement Start Date:2021-03-21
Second Newspaper Name:Chicago Tribune
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-03-28
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:
Employer Website to Date:
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-03-22
Job Search Website to Date:2021-04-05
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:2021-03-05
Campus Placement to Date:2021-03-22
Local Ethnic Newspaper from Date:2021-03-26
Local Ethnic Newspaper to Date:2021-03-26
Radio/TV Ad from Date:
Radio/TV Ad to Date:
Employer Received the Payment:N
Payment Details:
Bargaining Representative Notified:N/A
Posted Notice at Worksite:Y
Layoff in Past Six Months:N
US Worker Considered:
Country of Citizenship:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:ENGINEERING MANAGEMENT
Year of Compelted Education:2015
Foreign Worker Istitution of Eduation:UNIVERSITY OF HOUSTON CLEAR LAKE
Foreign Worker Education Instution Address Line 1:2700 BAY AREA BLVD
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:HOUSTON
Foreign Worker Educatution Institution State:TX
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:77058
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :N/A
Foreign Worker Alternate Education and Experience :N
Foreign Worker Alternate Occupation Experience:Y
Foreign Worker Experience with Employer:N
Foreign Worker Employer Pay 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
