Fiscal Year

2021

Case Number

A-21063-58499

Case Status

Certified

Received Date

2021-03-09

Decision Date

2021-08-13

Refile

N

Original File Date

2021-01-01 09:59:44

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

EAU CLAIRE COOPERATIVE HEALTH CENTER

Employer Name Slug

eau-claire-cooperative-health-center

Employer Address 1

1800 ST. JULIAN PLACE

Employer Address 2

3RD FLOOR

Employer City

COLUMBIA

Employer City Slug

columbia

Employer State

SOUTH CAROLINA

Employer State Slug

south-carolina

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

29204

Employer Phone

8037335969

Employer Number of Employees

524

Employer Year Commenced Business

1981

NAICS Code

621498

FW Ownership Interest

N

Employer Contact Name

Shauna Robertson

Employer Contact Address 1

169 Laurelhurst Avenue

Employer Contact Address 2

Employer Contact City

Columbia

Employer Contact State/Province

SOUTH CAROLINA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

29210

Employer Contact Phone

8037335969 4139

Employer Contact Email

srobertson@cooperativehealth.org

Agent Attorney Name

Alison P Hitz

Agent Attorney Firm Name

Clark Hill PLC

Agent Attorney Phone

(415) 984-8563

Agent Attorney Address 1

505 Montgomery Street

Agent Attorney Address 2

13th Floor

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94111

Agent Attorney Email

ahitz@ClarkHill.com

PW Track Number

P10020156627228

PW SOC Code

15-1141

PW SOC Title

Database Adminstrators

PW Skill Level

Level I

PW Wage

53310.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-28

PW Expiration Date

2021-06-30

Wage Offer From

65000.00

Wage Offer To

0.00

Average Salary

65000.00

Wage Unit of Pay

Year

Worksite Address 1

1777 St. Julian Place

Worksite Address 2

Worksite City

Columbia

Worksite City Slug

columbia

Worksite State

SOUTH CAROLINA

Worksite Postal Code

29204

Job Title

Database Administrator (SQL)

Job Title Slug

database-administrator-sql

Minimum Education

Bachelor's

Major Field of Study

Information Technology

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Computer Science or an Engineering field

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

24

Accept Alternative Job Title

Database Administrator, Network Administrator, Security Analyst, or a sub. sim. pos.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have a Bachelors degree, or foreign degree equivalent, in Information Technology, Computer Science, or an Engineering field, plus 2 years of experience as a Database Administrator, Network Administrator, Security Analyst, or a substantially similar position performing the following job duties utilizing Security Information Management SIM and Unified Threat Management tools such as IoT scanners, network monitoring, antivirus intervention and packet inspection to analyze network traffic for malicious activities and develop safety measures, standards, and guidelines to safeguard vulnerable information against accidental or unauthorized damage, modification, or disclosure; monitoring uptime of routers and other networking equipment; coordinating the implementation, configuration, maintenance, and performance of information systems and database development to ensure availability and consistent performance; reviewing, revising, and analyzing existing program logic and performing root cause analysis in order to identify program issues, resolve defects, and recommend longterm solutions; implementing security measures to safeguard computer databases and adhering to industry best practices; determining project scope and limitations, including estimated deadlines and budget requirements, to ensure consistent performance throughout project lifecycle; overseeing integration of different products into system databases to enable successful functioning; creating and designing reports for data analytics to promote adherence to requirements specifications and functional specifications; and utilizing knowledge of relational database design and SQL queries, triggers, and stored procedures in order to conduct computer database reviews, administer tests, and implement new processes.

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

2020-10-22

SWA Job Order End Date

2020-11-24

Sunday Edition Newspaper

Y

First Newspaper Name

The State

First Advertisement Start Date

2020-11-08

Second Newspaper Ad Name

The State

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-11-15

Employer Website From Date

2021-01-01 09:59:44

Employer Website To Date

2021-01-01 09:59:44

Professional Organization Ad From Date

2020-11-09

Professional Organization Advertisement To Date

2020-12-09

Job Search Website From Date

2020-11-10

Job Search Website To Date

2020-11-24

Employee Referral Program From Date

2021-01-01 09:59:44

Employee Referral Program To Date

2021-01-01 09:59:44

Local Ethnic Paper From Date

2021-01-01 09:59:44

Local Ethnic Paper To Date

2021-01-01 09:59:44

Radio/TV Ad From Date

2020-12-16

Radio/TV Ad To Date

2020-12-17

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

TURKEY

Foreign Worker Birth Country

TURKEY

Class of Admission

H-1B

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

US EQUIV TO B.S. IN INFORMATION TECHNOLOGY

Foreign Worker Years of Education Completed

2012

Foreign Worker Institution of Education

KADIR HAS UNIVERSITY

Foreign Worker Education Institution Address 1

CIBALI, KADIR HAS CD.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

ISTANBUL

Foreign Worker Education Institution State/Province

FATIH

Foreign Worker Education Institution Country

TURKEY

Foreign Worker Education Institution Postal Code

34083

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Alison P Hitz

Preparer Title

Attorney

Preparer Email

ahitz@clarkhill.com

Employer Information Declaration Name

Delgado Cantave

Employer Information Declaration Title

President and CEO