All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19234-47973
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19234-47973
Case Status
Certified-Expired
Received Date
2019-09-07
Decision Date
2019-12-16
Refile
N
Original File Date
2020-01-01 07:52:34
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
Allegiant Travel Company
Employer Name Slug
allegiant-travel-company
Employer Address 1
1201 N Town Center Drive
Employer Address 2
Employer City
Las Vegas
Employer City Slug
las-vegas
Employer State
NEVADA
Employer State Slug
nevada
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
89144
Employer Phone
7028308889
Employer Number of Employees
2846
Employer Year Commenced Business
1998
NAICS Code
48111
FW Ownership Interest
N
Employer Contact Name
Melissa Weinberg
Employer Contact Address 1
1201 N Town Center Drive
Employer Contact Address 2
Employer Contact City
Las Vegas
Employer Contact State/Province
NEVADA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
89144
Employer Contact Phone
7028308638
Employer Contact Email
Melissa.Weinberg@allegiantair.com
Agent Attorney Name
Matthew P Hellrung
Agent Attorney Firm Name
Meltzer Hellrung, LLC
Agent Attorney Phone
3123409619
Agent Attorney Address 1
211 S. Clark Street
Agent Attorney Address 2
#735
Agent Attorney City
Chicago
Agent Attorney State/Province
ILLINOIS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
60690
Agent Attorney Email
gov@meltzerhellrung.com
PW Track Number
P10018310311325
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
103854.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-03-13
PW Expiration Date
2019-06-30
Wage Offer From
110000.00
Wage Offer To
0.00
Average Salary
110000.00
Wage Unit of Pay
Year
Worksite Address 1
1201 N Towncenter Drive
Worksite Address 2
Worksite City
Las Vegas
Worksite City Slug
las-vegas
Worksite State
NEVADA
Worksite Postal Code
89144
Job Title
Database Administrator
Job Title Slug
database-administrator
Minimum Education
Bachelor's
Major Field of Study
Information Technology, Computer Science, Engineering, or related field
Required Training
N
Required Experience
Y
Required Experience Months
60
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
60
Accept Alternative Job Title
Programmer Analyst, Sr. Manager IMS or related
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Bachelors degree in Information Technology, Computer Science, Engineering, or related plus 5 years of experience. Also requires 5 years of experience as a multiplatform IT database administrator, designer, developer, or architect on IBM DB2 databases, 5 years of Handson programming experience with DDL, Stored Procedures, SQL, and Triggers, 5 years of Experience in database implementation using proper data modeling and normalization principles., 5 years of Experience with database performance analysis and tuning in an IBM Linux environment, 1 year of Experience understanding DDS physical and logical file objects.
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-06-07
SWA Job Order End Date
2019-07-07
Sunday Edition Newspaper
Y
First Newspaper Name
Las Vegas ReviewJournal
First Advertisement Start Date
2019-07-07
Second Newspaper Ad Name
Las Vegas ReviewJournal
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-07-14
Employer Website From Date
2020-01-01 07:52:34
Employer Website To Date
2020-01-01 07:52:34
Professional Organization Ad From Date
2020-01-01 07:52:34
Professional Organization Advertisement To Date
2020-01-01 07:52:34
Job Search Website From Date
2020-01-01 07:52:34
Job Search Website To Date
2020-01-01 07:52:34
Employee Referral Program From Date
2020-01-01 07:52:34
Employee Referral Program To Date
2020-01-01 07:52:34
Local Ethnic Paper From Date
2019-07-12
Local Ethnic Paper To Date
2019-07-12
Radio/TV Ad From Date
2019-07-09
Radio/TV Ad To Date
2019-07-09
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
Bachelor's
Foreign Worker Information: Major
ELECTRONIC ENGINEERING
Foreign Worker Years of Education Completed
2002
Foreign Worker Institution of Education
BHARATHIDASAN UNIVERSITY
Foreign Worker Education Institution Address 1
AMMAPETTAI POOLANGULATHUPATTI
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
TIRUCHIRAPPALLI
Foreign Worker Education Institution State/Province
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
620009
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Matthew P Hellrung
Preparer Title
Partner
Preparer Email
gov@meltzerhellrung.com
Employer Information Declaration Name
Melissa Weinberg
Employer Information Declaration Title
People Services Administrator