Fiscal Year

2021

Case Number

A-20234-90913

Case Status

Certified

Received Date

2020-08-31

Decision Date

2021-04-05

Refile

N

Original File Date

2021-01-01 09:10:55

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CHARLES SCHWAB CO., INC.

Employer Name Slug

charles-schwab-co-inc

Employer Address 1

211 MAIN STREET

Employer Address 2

Employer City

SAN FRANCISCO

Employer City Slug

san-francisco

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

94105

Employer Phone

415-636-7000

Employer Number of Employees

15300

Employer Year Commenced Business

1974

NAICS Code

52311

FW Ownership Interest

N

Employer Contact Name

Brendon Saul

Employer Contact Address 1

9800 Schwab Way

Employer Contact Address 2

Employer Contact City

Lone Tree

Employer Contact State/Province

COLORADO

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

80124

Employer Contact Phone

737-247-3218

Employer Contact Email

immigrationadministrator@schwab.com

Agent Attorney Name

Nadine K Bahnan

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

4159861446

Agent Attorney Address 1

555 Montgomery Street

Agent Attorney Address 2

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

nbahnan@fragomen.com

PW Track Number

P10019212031622

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

108285.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-11-25

PW Expiration Date

2020-06-30

Wage Offer From

122888.00

Wage Offer To

0.00

Average Salary

122888.00

Wage Unit of Pay

Year

Worksite Address 1

4750 E Francisco Drive

Worksite Address 2

Worksite City

Phoenix

Worksite City Slug

phoenix

Worksite State

ARIZONA

Worksite Postal Code

85044

Job Title

Sr Staff Database Administrator

Job Title Slug

sr-staff-database-administrator

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Engineering, or a related field

Required Training

N

Required Experience

Y

Required Experience Months

120

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

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

120

Accept Alternative Job Title

job offered or related occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Position requires a Bachelors degree in Computer Science, Engineering, or a related field followed by 10 years of progressive, professional experience in database administration and development or related field.br br Experience andor education must includebr 1. Splunk and OEM;br 2. Building and implementing automation tasks;br 3. Creating clear and concise technical documentation;br 4. Reviewing code and providing peer feedback relative to best practices;br 5. Database tuning processes, database replication, and scaling;br 6. Siebel Analytics Business Reporting Requirements and how the map to the Siebel database schema;br 7. Coding with either Python, PHP, Perl, Ruby, Java, or Splunk;br 8. Overall IT;br 9. Oracle DBA and Siebel CRM;br 10. PQLSQL Scripts, triggers, stored procedures, System DBA tasks;br 11. SQL Server.

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

SWA Job Order End Date

2020-06-08

Sunday Edition Newspaper

Y

First Newspaper Name

The Arizona Republic

First Advertisement Start Date

2020-04-19

Second Newspaper Ad Name

The Arizona Republic

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-04-26

Employer Website From Date

2020-03-23

Employer Website To Date

2020-04-06

Professional Organization Ad From Date

2021-01-01 09:10:55

Professional Organization Advertisement To Date

2021-01-01 09:10:55

Job Search Website From Date

2020-04-14

Job Search Website To Date

2020-04-28

Employee Referral Program From Date

2020-03-23

Employee Referral Program To Date

2020-04-06

Local Ethnic Paper From Date

2021-01-01 09:10:55

Local Ethnic Paper To Date

2021-01-01 09:10:55

Radio/TV Ad From Date

2021-01-01 09:10:55

Radio/TV Ad To Date

2021-01-01 09:10:55

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

PAKISTAN

Foreign Worker Birth Country

PAKISTAN

Class of Admission

H-1B

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2006

Foreign Worker Institution of Education

UNIVERSITY OF MANAGEMENT AND TECHNOLOGY

Foreign Worker Education Institution Address 1

CII, JOHAR TOWN

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

LAHORE

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

PAKISTAN

Foreign Worker Education Institution Postal Code

54782

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Nadine K Bahnan

Preparer Title

Attorney at Law

Preparer Email

nbahnan@fragomen.com

Employer Information Declaration Name

Brendon Saul

Employer Information Declaration Title

Sr Team Manager, HR Operations