Fiscal Year

2022

Case Number

A-21357-90306

Case Status

Withdrawn

Received Date

2021-12-29

Decision Date

2022-08-11

Refile

N

Original File Date

2022-01-01 11:50:57

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ASSET MARKETING SERVICES, LLC

Employer Name Slug

asset-marketing-services-llc

Employer Address 1

1300 CORPORATE CENTER CURVE

Employer Address 2

Employer City

EAGAN

Employer City Slug

eagan

Employer State

MINNESOTA

Employer State Slug

minnesota

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

55121

Employer Phone

952707216

Employer Number of Employees

307

Employer Year Commenced Business

2009

NAICS Code

454390

FW Ownership Interest

N

Employer Contact Name

Eva Zuccarelli

Employer Contact Address 1

1300 Corporate Center Curve

Employer Contact Address 2

Employer Contact City

Eagan

Employer Contact State/Province

MINNESOTA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

55121

Employer Contact Phone

19527077216

Employer Contact Email

ezuccarelli@amsi-corp.com

Agent Attorney Name

Rebecca J Bernhard

Agent Attorney Firm Name

Dorsey Whitney LLP

Agent Attorney Phone

612-492-6186

Agent Attorney Address 1

50 South Sixth Street, Suite 1500

Agent Attorney Address 2

Agent Attorney City

Minneapolis

Agent Attorney State/Province

MINNESOTA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

55402

Agent Attorney Email

mpls-iv@dorsey.com

PW Track Number

P10021032046647

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

116958.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-06-15

PW Expiration Date

2021-09-13

Wage Offer From

116958.00

Wage Offer To

0.00

Average Salary

116958.00

Wage Unit of Pay

Year

Worksite Address 1

1300 Corporate Center Curve

Worksite Address 2

Worksite City

Eagan

Worksite City Slug

eagan

Worksite State

MINNESOTA

Worksite Postal Code

55121

Job Title

Database Administrator

Job Title Slug

database-administrator

Minimum Education

Bachelor's

Major Field of Study

Management Information Systems, Comp Sci or clsly rel

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Management Information Systems, Comp Sci or clsly rel

Accept Alternative Combination

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Database Administrator, Systems Analyst or Application Developer

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Position requires a Bachelors degree in Management Information Systems, Computer Science, or closely related degree, plus at least 5 five years of progressive postbaccalaureate experience as a database administrator, systems analyst or application developer. Experience must include Microsoft SQL Server and MySQL replication setup and performance tuning; writing and optimizing stored procedures, functions using TSQL; SSIS, SSRS; troubleshooting database performance bottlenecks, deadlocks, and connectivity issues; Azure SQL databases, data factory; and data warehouse configuration, planning and tuning. Alternatively, a Masters degree in Management Information Systems, Computer Science, or closely related, plus two years of the specified experience is accepted. All experience may be gained concurrently.

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-07-23

SWA Job Order End Date

2021-08-26

Sunday Edition Newspaper

Y

First Newspaper Name

Minneapolis Star Tribune

First Advertisement Start Date

2021-08-01

Second Newspaper Ad Name

Minneapolis Star Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-08-08

Employer Website From Date

2021-07-23

Employer Website To Date

2021-08-26

Professional Organization Ad From Date

2022-01-01 11:50:57

Professional Organization Advertisement To Date

2022-01-01 11:50:57

Job Search Website From Date

2021-08-01

Job Search Website To Date

2021-08-08

Employee Referral Program From Date

2022-01-01 11:50:57

Employee Referral Program To Date

2022-01-01 11:50:57

Local Ethnic Paper From Date

2021-08-06

Local Ethnic Paper To Date

2021-08-06

Radio/TV Ad From Date

2022-01-01 11:50:57

Radio/TV Ad To Date

2022-01-01 11:50:57

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-4

Foreign Worker Education

Master's

Foreign Worker Information: Major

MANAGEMENT INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

TEXAS AM INTERNATIONAL UNIVERSITY

Foreign Worker Education Institution Address 1

5201 UNIVERSITY BOULEVARD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

LAREDO

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

78041

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Rebecca J Bernhard

Preparer Title

Attorney

Preparer Email

mpls-iv@dorsey.com

Employer Information Declaration Name

Eva Zuccarelli

Employer Information Declaration Title

Sr HR Generalist