Fiscal Year

2022

Case Number

A-21229-32724

Case Status

Certified

Received Date

2021-10-22

Decision Date

2022-05-06

Refile

N

Original File Date

2022-01-01 11:24:58

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

DUKE UNIVERSITY AND MEDICAL CENTER

Employer Name Slug

duke-university-and-medical-center

Employer Address 1

DUKE VISA SERVICES, SMITH WAREHOUSE, BAY 7 1ST FLOOR

Employer Address 2

114 S. BUCHANAN BOULEVARD, BOX 90790

Employer City

DURHAM

Employer City Slug

durham

Employer State

NORTH CAROLINA

Employer State Slug

north-carolina

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

27708

Employer Phone

919-681-8472

Employer Number of Employees

52994

Employer Year Commenced Business

1839

NAICS Code

611310

FW Ownership Interest

N

Employer Contact Name

Dylan Sugiyama

Employer Contact Address 1

Duke Visa Services, Smith Warehouse, Bay 7 1st Floor

Employer Contact Address 2

114 S. Buchanan Boulevard, Box 90790

Employer Contact City

Durham

Employer Contact State/Province

NORTH CAROLINA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

27708

Employer Contact Phone

919-681-8472 232

Employer Contact Email

dylan.sugiyama@duke.edu

Agent Attorney Name

John T Combs

Agent Attorney Firm Name

OGLETREE, DEAKINS, NASH, SMOAK STEWART, P.C.

Agent Attorney Phone

3037646809

Agent Attorney Address 1

2000 S. Colorado Blvd.

Agent Attorney Address 2

Tower 3 – Suite 900

Agent Attorney City

Denver

Agent Attorney State/Province

COLORADO

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

80222

Agent Attorney Email

john.combs@ogletreedeakins.com

PW Track Number

P10020218752396

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

61901.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-01-12

PW Expiration Date

2021-06-30

Wage Offer From

61901.00

Wage Offer To

88873.00

Average Salary

75387.00

Wage Unit of Pay

Year

Worksite Address 1

3 Genome Court

Worksite Address 2

Worksite City

Durham

Worksite City Slug

durham

Worksite State

NORTH CAROLINA

Worksite Postal Code

27710

Job Title

Database Analyst I

Job Title Slug

database-analyst-i

Minimum Education

Master's

Major Field of Study

Data Science

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Statistics, Economics Computation, or a related field of study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

6

Accept Alternative Job Title

See H.14.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

10B. Identify the job title of the acceptable alternate occupation Database Administrator or other data warehousedata infrastructure focused positions including research or teaching assistant.br br 14. Specific skills or other requirements Masters or Bachelors degree Data Science, Statistics, Economics Computation, or a related field of study. Experience in a data warehousedata infrastructure related position is required six months with Masters or two years with Bachelors. Position requires education or experience in the following SQL in RDBMS MySQL and PostgreSQL; CAP theorem and ACID properties; Database security, backup and recovery; Query optimization and indexing; Relational and dimensional data modeling, data warehousing and integration; Building databasemanagement applications onpremise, cloud and hybrid infrastructure environments virtualization with scalability and security; Cloudnative software development methodologies and tools to support application developmentdeployment stages including CICD; Platform security, cryptography, network security, systems security; Content Delivery Networks CDN and distributed systems; UnixLinux environments and shell scripting; Programming languages CC, Go, PHP and Python; Programming of Web Services HTML, JavaScript, CSS, RESTful API, and JSON.

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-05-14

SWA Job Order End Date

2021-06-15

Sunday Edition Newspaper

Y

First Newspaper Name

The HeraldSun

First Advertisement Start Date

2021-05-23

Second Newspaper Ad Name

The HeraldSun

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-05-30

Employer Website From Date

2022-01-01 11:24:58

Employer Website To Date

2022-01-01 11:24:58

Professional Organization Ad From Date

2022-01-01 11:24:58

Professional Organization Advertisement To Date

2022-01-01 11:24:58

Job Search Website From Date

2022-01-01 11:24:58

Job Search Website To Date

2022-01-01 11:24:58

Employee Referral Program From Date

2022-01-01 11:24:58

Employee Referral Program To Date

2022-01-01 11:24:58

Local Ethnic Paper From Date

2021-05-26

Local Ethnic Paper To Date

2021-05-26

Radio/TV Ad From Date

2021-05-27

Radio/TV Ad To Date

2021-05-27

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

SOUTH KOREA

Foreign Worker Birth Country

SOUTH KOREA

Class of Admission

F-1

Foreign Worker Education

Master's

Foreign Worker Information: Major

ECONOMICS AND COMPUTATION

Foreign Worker Years of Education Completed

2019

Foreign Worker Institution of Education

DUKE UNIVERSITY

Foreign Worker Education Institution Address 1

614 CHAPEL DRIVE

Foreign Worker Education Institution Address 2

BOX 90563

Foreign Worker Education Institution City

DURHAM

Foreign Worker Education Institution State/Province

NC

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

27708

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

John Combs

Preparer Title

Attorney

Preparer Email

john.combs@ogletreedeakins.com

Employer Information Declaration Name

Dylan Sugiyama

Employer Information Declaration Title

Associate Director, Duke Visa Services