Fiscal Year

2020

Case Number

A-20029-12797

Case Status

Certified

Received Date

2020-04-22

Decision Date

2020-09-29

Refile

N

Original File Date

2020-01-01 08:34:42

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

STANCORP FINANCIAL GROUP

Employer Name Slug

stancorp-financial-group

Employer Address 1

STANDARD INSURANCE COMPANY

Employer Address 2

1100 SW SIXTH AVE.

Employer City

PORTLAND

Employer City Slug

portland

Employer State

OREGON

Employer State Slug

oregon

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

97204

Employer Phone

971-321-7995

Employer Number of Employees

2429

Employer Year Commenced Business

1906

NAICS Code

524113

FW Ownership Interest

N

Employer Contact Name

Jami A Johnson

Employer Contact Address 1

900 SW Fifth Ave.

Employer Contact Address 2

Employer Contact City

Portland

Employer Contact State/Province

OREGON

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

97204

Employer Contact Phone

971-321-7995

Employer Contact Email

jami.johnson@standard.com

Agent Attorney Name

Matthew W McClellan

Agent Attorney Firm Name

McClellan Immigration Law Offices, P.C.

Agent Attorney Phone

503-607-0444

Agent Attorney Address 1

16771 Boones Ferry Road

Agent Attorney Address 2

Suite 100

Agent Attorney City

Lake Oswego

Agent Attorney State/Province

OREGON

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

97035

Agent Attorney Email

matthew@m2io.com

PW Track Number

P10019241048483

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

108867.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-01-02

PW Expiration Date

2020-06-30

Wage Offer From

120000.00

Wage Offer To

0.00

Average Salary

120000.00

Wage Unit of Pay

Year

Worksite Address 1

1100 SW Sixth Avenue

Worksite Address 2

Worksite City

Portland

Worksite City Slug

portland

Worksite State

OREGON

Worksite Postal Code

97204

Job Title

SQL Server Database Engineer

Job Title Slug

sql-server-database-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Closely related 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

60

Accept Alternative Job Title

In job offered or as Database Admin, Database Infrastructure EngArchitect, or similar.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Note regarding Section H.4.10. EDUCATION, EXPERIENCE AND SPECIAL REQUIREMENTS, the minimum requirements are Bachelors degree in Computer Science or a closely related field, or the equivalent to the degree; 5 years of experience as a database administrator dealing with day to day operations and 5 years as a database infrastructure engineerarchitect with a focus on enterprise database strategy, design and implementation of new services, which experience may have been gained concurrently; the experience also must include the following minimum skills, which may have been gained concurrently 3 years with SQL Server database automation; 5 years with performance tuning; 5 years with TSQL development; 5 years with Database High availability disaster recovery Design Implementation; 5 years with SQL Database Upgrades Migration; 5 years with Power BI Dash Board SSRS; 5 years with SSIS SSAS; 2 years with Azure SQL PaaSIaaS; 1 year with Agile Scrum and Kanban workstyles.br br Other Information Standard Insurance Company, The Standard Life Insurance Company of New York, Standard Retirement Services, Inc., StanCorp Equities, Inc., StanCorp Mortgage Investors, LLC and StanCorp Investment Advisers, Inc., marketed as The Standard, are Affirmative ActionEqual Opportunity employers. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, national origin, gender identity, sexual orientation, age, disability, or veteran status or any other condition protected by federal, state or local law. The Standard offers a drug and alcohol free work environment where possession, manufacture, transfer, offer, use of or being impaired by an illegal substance while on Standard property, or in other cases which the company believes might affect operations, safety or reputation of the company is prohibited. The Standard requires a criminal background investigation, drug test, employment, education and licensing verification as a condition of employment. All employees of The Standard must be bondable.br br Note regarding Section H.10B. JOB TITLES OF ACCEPTABLE ALTERNATE OCCUPATIONS, acceptable alternate or related occupations may include the following Consultant, Associate Consultant, Module Lead, or similar, provided the role includes database administration or database infrastructure architectengineering responsibilities. By quot;or similarquot;, it is meant that the listed job or occupation titles are typical, but there could be additional acceptable job titles not specifically listed.br br Note regarding Section H.8 H.9. regarding the phrase, quot;or the equivalent to the degree in the education requirements, the employer intends that degree equivalent can be achieved by one or more foreign degrees, but not by any combination of education and experience.br br Note regarding Section J.1116. BENEFICIARYS EDUCATION, The Beneficiarys foreign masters degree has been evaluated by an education evaluation agency and has been found to be educationally equivalent to a Masters Degree in Computer Information Systems from a regionally accredited institution in the United States. The Beneficiary also has an education equivalent to a U.S. Bachelors degree in Computer Information Systems.

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

SWA Job Order End Date

2020-03-15

Sunday Edition Newspaper

Y

First Newspaper Name

The Oregonian

First Advertisement Start Date

2020-02-16

Second Newspaper Ad Name

The Oregonian

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-02-23

Employer Website From Date

2020-02-11

Employer Website To Date

2020-03-16

Professional Organization Ad From Date

2020-01-01 08:34:42

Professional Organization Advertisement To Date

2020-01-01 08:34:42

Job Search Website From Date

2020-02-16

Job Search Website To Date

2020-03-16

Employee Referral Program From Date

2020-01-01 08:34:42

Employee Referral Program To Date

2020-01-01 08:34:42

Local Ethnic Paper From Date

2020-03-05

Local Ethnic Paper To Date

2020-03-05

Radio/TV Ad From Date

2020-01-01 08:34:42

Radio/TV Ad To Date

2020-01-01 08:34:42

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

COMPUTER APPLICATIONS

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

BHARATHIDASAN UNIVERSITY

Foreign Worker Education Institution Address 1

PALKALAIPERUR

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

TIRUCHIRAPPALLI

Foreign Worker Education Institution State/Province

TAMIL NADU

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

620024

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Matthew W McClellan

Preparer Title

Attorney at Law

Preparer Email

matthew@m2io.com

Employer Information Declaration Name

Emily Warren

Employer Information Declaration Title

Attorney