Fiscal Year

2023

Case Number

A-22160-69219

Case Status

Withdrawn

Received Date

2022-06-23

Decision Date

2023-03-13

Refile

N

Original File Date

2023-01-01 08:01:12

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

UNIVERSITY OF KANSAS

Employer Name Slug

university-of-kansas

Employer Address 1

1450 JAYHAWK BOULEVARD, RM 300

Employer Address 2

Employer City

LAWRENCE

Employer City Slug

lawrence

Employer State

KANSAS

Employer State Slug

kansas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

66045

Employer Phone

785-864-6161

Employer Number of Employees

14485

Employer Year Commenced Business

1866

NAICS Code

611310

FW Ownership Interest

N

Employer Contact Name

Keeli Nelson

Employer Contact Address 1

1246 West Campus Road

Employer Contact Address 2

HRM Room 103

Employer Contact City

Lawrence

Employer Contact State/Province

KANSAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

66045

Employer Contact Phone

785-864-4957

Employer Contact Email

keelinelson@ku.edu

Agent Attorney Name

Judy M Bordeau

Agent Attorney Firm Name

Bordeau Noulles LLC

Agent Attorney Phone

9134329994

Agent Attorney Address 1

9303 W. 75th St.

Agent Attorney Address 2

Ste 210

Agent Attorney City

Overland Park

Agent Attorney State/Province

KANSAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

66204

Agent Attorney Email

judy@kcvisa.com

PW Track Number

P10021236540977

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

68744.00

PW Unit of Pay

Year

PW Wage Source

Other

PW Determination Date

2022-02-22

PW Expiration Date

2022-06-30

Wage Offer From

78780.00

Wage Offer To

99715.00

Average Salary

89247.50

Wage Unit of Pay

Year

Worksite Address 1

1515 St Andrews Drive

Worksite Address 2

Worksite City

Lawrence

Worksite City Slug

lawrence

Worksite State

KANSAS

Worksite Postal Code

66047

Job Title

Research Database Administrator

Job Title Slug

research-database-administrator

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Electrical Engineering or other related field

Required Training

N

Required Experience

N

Required Experience Months

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

Programmer Analyst or related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

The employer accepts other job titles, provided the experience is with designing and building data models and schemas to support application requirements; creating and maintaining databases, tables, views, stored procedures and other database objects; performing database tuning, space management, and database administration; writing Queries, Functions, Procedures and DDL scripts for relational database systems; and overseeing PostgreSQL databases. 2 years experience overseeing MySQL and Microsoft SQL Server databases and overseeing RDS databases, Aurora databases and Aurora Serverless databases in AWS is also required.br br Note regarding the address noted in H.1. and H.2. During the case processing, the worksite moved from 1420 Research Gate Park Dr., Lawrence, KS 66049 approximately 2 miles to the 1515 St. Andrews Drive, Lawrence, Kansas 66047 address that is in H.1. and H.2. Both addresses are in Douglas County, Kansas, within the same MSA. All ads and notices placed stated that the work site location would be located in Lawrence, Kansas.

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

2022-03-31

SWA Job Order End Date

2022-04-30

Sunday Edition Newspaper

Y

First Newspaper Name

Topeka CapitalJournal

First Advertisement Start Date

2022-04-03

Second Newspaper Ad Name

Topeka CapitalJournal

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-04-10

Employer Website From Date

2022-03-30

Employer Website To Date

2022-04-30

Professional Organization Ad From Date

2023-01-01 08:01:12

Professional Organization Advertisement To Date

2023-01-01 08:01:12

Job Search Website From Date

2022-03-31

Job Search Website To Date

2022-04-19

Employee Referral Program From Date

2023-01-01 08:01:12

Employee Referral Program To Date

2023-01-01 08:01:12

Local Ethnic Paper From Date

2022-04-03

Local Ethnic Paper To Date

2022-04-10

Radio/TV Ad From Date

2023-01-01 08:01:12

Radio/TV Ad To Date

2023-01-01 08:01:12

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

2012

Foreign Worker Institution of Education

UNIVERSITY OF MISSOURIKANSAS CITY

Foreign Worker Education Institution Address 1

5000 HOLMES STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

KANSAS CITY

Foreign Worker Education Institution State/Province

MO

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

64110

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Judy M Bordeau

Preparer Title

Managing Attorney

Preparer Email

judy@kcvisa.com

Employer Information Declaration Name

Keeli Nelson

Employer Information Declaration Title

Immigration Employment Coordinator Senior