Fiscal Year

2023

Case Number

A-22104-40641

Case Status

Certified

Received Date

2022-05-25

Decision Date

2023-01-26

Refile

N

Original File Date

2023-01-01 08:11:08

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

McGraw Hill LLC

Employer Name Slug

mcgraw-hill-llc

Employer Address 1

860 Taylor Station Rd.

Employer Address 2

Employer City

Blacklick

Employer City Slug

blacklick

Employer State

OHIO

Employer State Slug

ohio

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

43004

Employer Phone

3802023018

Employer Number of Employees

1200

Employer Year Commenced Business

2020

NAICS Code

611710

FW Ownership Interest

N

Employer Contact Name

Mandy Franceschina

Employer Contact Address 1

860 Taylor Station Rd.

Employer Contact Address 2

Employer Contact City

Blacklick

Employer Contact State/Province

OHIO

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

43004

Employer Contact Phone

3802023018

Employer Contact Email

mandy.franceschina@mheducation.com

Agent Attorney Name

Ryan H Bay

Agent Attorney Firm Name

Global Immigration Associates, P.C.

Agent Attorney Phone

3127226300

Agent Attorney Address 1

230 W. Monroe St., Suite 2800

Agent Attorney Address 2

Agent Attorney City

Chicago

Agent Attorney State/Province

ILLINOIS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

60606

Agent Attorney Email

ryan.bay@giafirm.com

PW Track Number

P10021168405913

PW SOC Code

15-1199

PW SOC Title

Computer Occupations, All Other

PW Skill Level

Level IV

PW Wage

108826.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-02-14

PW Expiration Date

2022-06-30

Wage Offer From

125000.00

Wage Offer To

0.00

Average Salary

125000.00

Wage Unit of Pay

Year

Worksite Address 1

8787 Orion Place

Worksite Address 2

Worksite City

Columbus

Worksite City Slug

columbus

Worksite State

OHIO

Worksite Postal Code

43240

Job Title

Database Engineer

Job Title Slug

database-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science or related field

Required Training

N

Required Experience

Y

Required Experience Months

120

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

120

Accept Alternative Job Title

related occupations

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Requires Bachelors degree in Computer Science or related field plus 10 years of experience. Requires 5 years of experience configuring, tuning, and optimizing RDBMS solutions on AWS Aurora or RDS or onpremises and expertise in indexing, access methods, locking, logging, caching, transaction processing, replication, backuprestore and buffer management Oracle, PostgreSQL, mySQL. Requires 2 years of experience in the design, development, and management of data on graph database clusters and nodes, including performance, capacity planning, and cost forecasting. Requires 5 years of experience with database engine internalsquery processing query compilation, optimization, execution, parallel execution. Requires 2 years of experience with NoSQL system implementation, distributed systems, or consensusbased quorum replication. Requires 5 years of experience utilizing advance coding skills SDLC of ObjectOriented Analysis Design OOAD, Service Oriented Architecture SOA design principles, design patterns, application architectures, unit, integration, or system testing strategies. Requires 2 years of experience with middleware caching strategies such as Redis, Couchbase, ElasticSearch or other noSQL Cache systems. Requires 5 years of experience designing and coding solution in the most clear, concise, and optimal way possible, based on time and other constraints; coordinating best development approach with Architects, Engineers, Database Developers, and others. Requires 2 years of experience with eventdriven system architectures. Requires 5 years of experience reviewing existing code and recommending refactoring where applicable. Requires 3 years of experience supporting layers of connectivity from a service call to the DB, transaction control, isolation level, and debugging. Requires 5 years of experience with CICD version control or GitHubSVN source control repository experience. Requires 3 years of experience with CICD release management. Requires 2 years of experience with AWS services, which must have included 2 years of strong practical experience in at least 2 of the following EC2, Amazon Aurora Cluster Services, DMS Data Migration Service, Hadoop, Kinesis, RedShift, S3, DynamoDB, Apache Spark, or DataBricks; AND 1 year of experience with IAM, Lambda, Kinesis, Spark, Hadoop, EMR, CloudWatch, CloudFormation. Requires knowledge of Sonar, Puppet, CloudFormation, or Terraform as demonstrated through employment experience. Requires knowledge of SQLLoader as demonstrated through employment experience. Requires 5 years of experience analyzing functional requirements and business logic as they apply to database and data engineering practices Requires 5 years of experience designing and developing database computer programs and computer systems. Requires 8 years of experience testing and debugging database computer programs. Requires 8 years of experience with maintenance of database computer programs. Requires 8 years of experience with Oracle and PLSQL. Requires 2 years of experience with ETL Informatica. Requires 2 years of experience with Agile Scrum. Requires 2 years of experience with ExportImport. Requires 6 years of experience with Functions, Procedures, Triggers and various other platforms.br br Telecommuting is permitted.

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

2022-03-11

SWA Job Order End Date

2022-04-13

Sunday Edition Newspaper

Y

First Newspaper Name

The Columbus Dispatch

First Advertisement Start Date

2022-03-20

Second Newspaper Ad Name

The Columbus Dispatch

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-03-27

Employer Website From Date

2023-01-01 08:11:08

Employer Website To Date

2023-01-01 08:11:08

Professional Organization Ad From Date

2023-01-01 08:11:08

Professional Organization Advertisement To Date

2023-01-01 08:11:08

Job Search Website From Date

2022-03-14

Job Search Website To Date

2022-03-28

Employee Referral Program From Date

2022-03-15

Employee Referral Program To Date

2022-03-29

Local Ethnic Paper From Date

2022-03-24

Local Ethnic Paper To Date

2022-03-24

Radio/TV Ad From Date

2023-01-01 08:11:08

Radio/TV Ad To Date

2023-01-01 08:11:08

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

Bachelor's

Foreign Worker Information: Major

COMPUTER ENGINEERING

Foreign Worker Years of Education Completed

2003

Foreign Worker Institution of Education

SARDAR PATEL UNIVERSITY

Foreign Worker Education Institution Address 1

HW4G422, MOTA BAZAAR, VALLABH VIDYANAGAR

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

ANAND

Foreign Worker Education Institution State/Province

GUJARAT

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

388120

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Ryan H Bay

Preparer Title

Attorney

Preparer Email

ryan.bay@giafirm.com

Employer Information Declaration Name

Mandy Franceschina

Employer Information Declaration Title

Manager, Global Immigration Mobility