Fiscal Year

2021

Case Number

A-20055-22250

Case Status

Certified

Received Date

2020-05-04

Decision Date

2021-04-16

Refile

N

Original File Date

2021-01-01 09:13:35

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

GENERAL REINSURANCE CORPORATION

Employer Name Slug

general-reinsurance-corporation

Employer Address 1

120 LONG RIDGE ROAD

Employer Address 2

Employer City

STAMFORD

Employer City Slug

stamford

Employer State

CONNECTICUT

Employer State Slug

connecticut

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

6902

Employer Phone

203 328 5000

Employer Number of Employees

1960

Employer Year Commenced Business

1921

NAICS Code

524130

FW Ownership Interest

N

Employer Contact Name

Linda Dalesio

Employer Contact Address 1

120 Long Ridge Road

Employer Contact Address 2

Employer Contact City

Stamford

Employer Contact State/Province

CONNECTICUT

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

6902

Employer Contact Phone

203 328 5385

Employer Contact Email

ldalesio@genre.com

Agent Attorney Name

Peter J Choi

Agent Attorney Firm Name

EY Law LLP

Agent Attorney Phone

416 943 7123

Agent Attorney Address 1

100 Adelaide Street West

Agent Attorney Address 2

Floor 31

Agent Attorney City

Toronto

Agent Attorney State/Province

Ontario

Agent Attorney Country

CANADA

Agent Attorney Postal Code

M5H 0B3

Agent Attorney Email

eyimmgovtnotices@ca.ey.com

PW Track Number

P10019093950569

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

131622.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-09-03

PW Expiration Date

2020-06-30

Wage Offer From

131622.00

Wage Offer To

0.00

Average Salary

131622.00

Wage Unit of Pay

Year

Worksite Address 1

35 Nutmeg Drive

Worksite Address 2

Floor 3

Worksite City

Trumbull

Worksite City Slug

trumbull

Worksite State

CONNECTICUT

Worksite Postal Code

6611

Job Title

Database Administrator/Architect

Job Title Slug

database-administratorarchitect

Minimum Education

Bachelor's

Major Field of Study

Comp. Sci., Comp. Eng. Electrical Eng., Electronic Eng., Info. Sys., or a related technical field

Required Training

N

Required Experience

Y

Required Experience Months

84

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Comp. Sci., Comp. Eng. Electrical Eng., Electronic Eng., Info. Sys., or a related technical 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

84

Accept Alternative Job Title

Any closely related occupation.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have a bachelors degree in Computer Science, Computer Engineering, Electrical Engineering, Electronic Engineering, Information Systems, or a related technical field, plus 7 years of experience 5 of which must be postbaccalaureate progressively responsible experience designing and implementing enterprise database systems within the financial services industry.br br Of the required experience, must have 7 years of experience in managing database systems including SQL Server, Oracle, Sybase, and Datacom.br br Of the required experience, must have 5 years of experience in each of the followingbr br Designing and implementing redundant and scalable SQL Server infrastructures;br Using database mirroring, log shipping, replication, and Always On availability group technologies;br Managing and administering SQL Server installations and databases by developing maintenance plans, configuring server resources, monitoring performance, configuring instances and databases, and administering security; andbr Working with a support team on production support, including familiarity with formal support processes.br br Of the required experience, must have 4 years of experience in each of the followingbr br Designing, deploying, and maintaining SQL Server infrastructure on versions 2012, 2014, 2016, and 2017;br Using SQL Server Integration Services, SQL Server Reporting Services, SSAS, SQL Profiler, and SQL Server Management Studio; andbr Defining backup strategy, performing backups, restores, and disaster recovery.br br Of the required experience, must have 3 years of experience in each of the followingbr br Designing High Availability HA and Disaster Recovery DR solutions for SQL Server;br Implementing operational automation using scripts in Windows, Unix, and Linux platforms;br Designing, implementing, supporting, and analyzing enterprise scale applications that perform extracttransformload ETL operations with external data sources and SQL Server; andbr Performance Tuning and Optimization using native monitoring and monitoring tools.br br Of the required experience, must have 2 years of experience in crossplatform database migration.

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

2019-12-18

SWA Job Order End Date

2020-01-20

Sunday Edition Newspaper

Y

First Newspaper Name

Connecticut Post

First Advertisement Start Date

2020-01-12

Second Newspaper Ad Name

Connecticut Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-01-19

Employer Website From Date

2019-12-20

Employer Website To Date

2020-01-20

Professional Organization Ad From Date

2021-01-01 09:13:35

Professional Organization Advertisement To Date

2021-01-01 09:13:35

Job Search Website From Date

2020-01-10

Job Search Website To Date

2020-01-23

Employee Referral Program From Date

2021-01-01 09:13:35

Employee Referral Program To Date

2021-01-01 09:13:35

Local Ethnic Paper From Date

2020-01-20

Local Ethnic Paper To Date

2020-01-20

Radio/TV Ad From Date

2021-01-01 09:13:35

Radio/TV Ad To Date

2021-01-01 09:13:35

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

ELECTRICAL AND ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

2011

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Peter J Choi

Preparer Title

Attorney

Preparer Email

eyimmgovtnotices@ca.ey.com

Employer Information Declaration Name

Linda Dalesio

Employer Information Declaration Title

VP, Regional HR Manager