Fiscal Year

2022

Case Number

A-21078-64423

Case Status

Certified-Expired

Received Date

2021-05-03

Decision Date

2021-10-07

Refile

N

Original File Date

2022-01-01 10:15:25

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

TricorBraun, Inc.

Employer Name Slug

tricorbraun-inc

Employer Address 1

6 CityPlace Dr

Employer Address 2

Suite 1000

Employer City

St. Louis

Employer City Slug

st-louis

Employer State

MISSOURI

Employer State Slug

missouri

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

63141

Employer Phone

3149832043

Employer Number of Employees

998

Employer Year Commenced Business

1902

NAICS Code

424990

FW Ownership Interest

N

Employer Contact Name

Valerie Soberanis

Employer Contact Address 1

6 CityPlace Dr

Employer Contact Address 2

Suite 1000

Employer Contact City

St. Louis

Employer Contact State/Province

MISSOURI

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

63141

Employer Contact Phone

3149832043

Employer Contact Email

vsoberanis@tricorbraun.com

Agent Attorney Name

Kelli J Meilink

Agent Attorney Firm Name

Husch Blackwell LLP

Agent Attorney Phone

8169838309

Agent Attorney Address 1

4801 Main Street

Agent Attorney Address 2

Suite 1000

Agent Attorney City

Kansas City

Agent Attorney State/Province

MISSOURI

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

64112

Agent Attorney Email

Kelli.Meilink@huschblackwell.com

PW Track Number

P10020140584614

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

104187.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-03

PW Expiration Date

2021-06-30

Wage Offer From

131062.00

Wage Offer To

0.00

Average Salary

131062.00

Wage Unit of Pay

Year

Worksite Address 1

6 CityPlace Drive

Worksite Address 2

Suite 1000

Worksite City

St. Louis

Worksite City Slug

st-louis

Worksite State

MISSOURI

Worksite Postal Code

63141

Job Title

Senior Database Architect

Job Title Slug

senior-database-architect

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Computer IS, Engineering or closely 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

60

Accept Alternative Job Title

Any database administrator position

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

REQUIRED EXPERIENCE MUST INCLUDE FIVE YEARS OF ARCHITECTURE AND DESIGN EXPERIENCE WITH AZURE CLOUDBASED DATA STORAGE, PROCESSING, AND PUBLISHING TECHNOLOGIES; HYBRID CLOUD ARCHITECTURE; AND HIGH AVAILABILITY CLUSTERS, DISASTER RECOVERY, GEOREDUNDANT, AND HYPERSCALE SOLUTIONS. FIVE YEARS OF EXPERIENCE IN DATA MANAGEMENT, DATA MODELING, MASTER DATA MANAGEMENT, METADATA MANAGEMENT CONCEPTS, AND ETL EXTRACT, TRANSFER, LOAD TOOLS E.G., SSIS, TALEND AND FRAMEWORKS. FIVE YEARS OF EXPERIENCE IN AGILE DEVELOPMENT PROCESSES AND LARGESCALEbr ERP SOLUTIONS. FIVE YEARS OF EXPERIENCE WITH LARGESCALE DATA PLATFORMS USING BIG DATA, CLOUD, AND RDBMS RELATIONAL DATABASE MANAGEMENT SYSTEM TECHNOLOGIES. FIVE YEARS OF PORTFOLIO DELIVERY EXPERIENCE IN FULL SOFTWARE LIFECYCLE. FIVE YEARS OF EXPERIENCE MANAGING LARGE DATA MIGRATION EFFORTS FROM LEGACY ERP SOLUTIONS INTO NEW MODERN PAAS SOLUTIONS USING NATIVE AND THIRDPARTY TOOLS. DEMONSTRATED UNDERSTANDING DATA ARCHITECTURE PATTERNS, DATA WAREHOUSE, INTEGRATIONS, APIS, DATA LAKE, AND CLOUD TECHNOLOGY CAPABILITIES. DEMONSTRATED KNOWLEDGE OF REPORTING TOOLS E.G., SQL SERVER REPORTING SERVICES, POWERBI, BUSINESS OBJECTS, AND TABLEAU IN A LARGESCALE ENTERPRISE ANDbr PROGRAMMINGSCRIPTING LANGUAGES, INCLUDING SQL, TSQL, POWERSHELL, XML, XSLT, AND DAX. DEMONSTRATED EXPERTISE IN SECURITY MODELS FOR DATABASES, DATA WAREHOUSE, AD, REPORTS SSRS, POWERBI, WORKSPACES, FILES, AND INTEGRATIONS.

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-01-25

SWA Job Order End Date

2021-03-08

Sunday Edition Newspaper

Y

First Newspaper Name

St. Louis PostDispatch

First Advertisement Start Date

2021-01-24

Second Newspaper Ad Name

St. Louis PostDispatch

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-01-31

Employer Website From Date

2022-01-01 10:15:25

Employer Website To Date

2022-01-01 10:15:25

Professional Organization Ad From Date

2022-01-01 10:15:25

Professional Organization Advertisement To Date

2022-01-01 10:15:25

Job Search Website From Date

2021-01-21

Job Search Website To Date

2021-02-22

Employee Referral Program From Date

2022-01-01 10:15:25

Employee Referral Program To Date

2022-01-01 10:15:25

Local Ethnic Paper From Date

2021-02-17

Local Ethnic Paper To Date

2021-02-17

Radio/TV Ad From Date

2022-01-01 10:15:25

Radio/TV Ad To Date

2022-01-01 10:15:25

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

BIOMEDICAL ENGINEERING

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

THE UNIVERSITY OF TENNESSEE

Foreign Worker Education Institution Address 1

320 STUDENT SERVICES BUILDING

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

KNOXVILLE

Foreign Worker Education Institution State/Province

TN

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

37996-0230

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kelli J Meilink

Preparer Title

Attorney

Preparer Email

kelli.meilink@huschblackwell.com

Employer Information Declaration Name

Chris Bartlow

Employer Information Declaration Title

Vice President, Global IT Infrastructure