TRANSFORM SEARS HOME SERVICES LLC

Database Administrator

A-22235-10358 H-1B 2023 Certified

Salary

$117,645

Visa Type

H-1B

Job Title

Database Administrator

Employee's Citizenship

INDIA

Graduate School

ACHARYA NAGARJUNA UNIVERSITY

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22235-10358

Case Status Certified

Received Date 2022-08-30

Decision Date 2023-06-21

Refile N

Original File Date -

Previous State Work Force Agency (SWA) Case Number Stete -

Schedule A or a Sheepherder Occupation N

Company Info

14 fields

Employer Name TRANSFORM SEARS HOME SERVICES LLC

Employer Address_Line 1 3333 BEVERLY ROAD

Employer Address_Line 2 -

Employer City HOFFMAN ESTATES

State -

Employer State/ Province ILLINOIS

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 60179

Employer Phone No. (847) 286-5921

Employer Phone Extent No. -

Total Number of Employees 11900

Employer Year of Commenced 2019

NAICS Code 45211

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Raymond G Covarrubias

Employer Contact Address Line1 3333 Beverly Road

Employer Contact Address Line2 -

Employer Contact City Hoffman Estates

Employer Contact State/ Provice ILLINOIS

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 60179

Employer Contact Phone (847) 286-5921

Employer Contact Email Raymond.Covarrubias@transformco.com

Attorney

11 fields

Agent/ Attorney Name Michelle Gergerian

Agent/ Attorney Firm Name Seyfarth Shaw LLP

Agent/ Attorney Phone (617) 946-4983

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 2 Seaport Lane Seaport East

Agent/ Attorney Address Line 2 Suite 1200

Agent/ Attorney City Boston

Agent/ Attorney State/ Province MASSACHUSETTS

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 2210

Agent/ Attorney Email mgergerian@seyfarth.com

Position Info

89 fields

Prevailing Wage Track Number P10021260590171

Prevailing Wage SOC Code 15-1141

Prevailing Wage SOC Title Database Administrators

Prevailing Wage Skill Level Level IV

Prevailing Wage 117645

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-03-21

Prevailing Wage Expiration Date 2022-06-30

Wage Offer From 117645

Wage Offer To -

Wage Offer Unit of Pay Year

Workstie Address Line 1 3333 Beverly Road

Worksite Address Line 2 -

Worksite City Hoffman Estates

Worksite State ILLINOIS

Worksite Postal Code 60179

Job Title Database Administrator

Minimum Education Master's

Other Degree/ Diploma -

Major Field of Study Computer Science, Engineering, Information Systems, Information Technology or related field

Required Training N

Required Training Month -

Required Field of Training -

Required Experience N

Required Expreience Months -

Accept Alternate Field of Study N

Accept Alternate Major -

Alternate Combination of Education/ Experience Y

Required Alternate Level of Education Bachelor's

Other Alternate Level of Education -

Acceptable Years of Experience 5

Accept Foreign Educationa Y

Acceptable Alternate Occupation Y

Acceptable Alternate Occupation Month 36

Accept Alternate Job Title Please see H.11.

Normal Requirements of Job Opportunity Y

Required Foreign Language N

Specific Skills 1 Demonstrated Expertise DE implementing and maintaining database backup and restoration strategies for disaster recovery and data distribution;br br 2 DE installing, configuring, upgrading, and maintaining the database monitoring tools, including MEM, Grafana, OEM, NewRelic, and Ops Manager for databases and application health checkup;br br 3 DE configuring, troubleshooting and resolving high availability functionality using Masterslave replication, Master replication, Semi Syncronous replication, group replication, Innodb cluster, and SQL clustering;br br 4 DE in data migration and data based objects including tables, views, sequences, constraints, indexes, functions, and triggers from Oracle to MySQL; and,br br 5 DE writing Shell, Python, Power shell, and Ansible scripting, and Terraform code for automation.

Combination Occupation N

Offered to Applied Foreign Worker Y

ForeignWorker Live on Premises N

Live in Domestic Service Worker N

Employment Contract -

Professional Occupation Y

College/ University Teacher N

Competitive Process -

Basic Recruitment Process -

Teacher Select Date -

Teacher Publish Journal Name -

Additional Recruitment Information -

Job Oder Start Date 2022-05-20

Job Oder End Date 2022-06-22

Sunday Edition Newspaper Y

First Newspaper Name Chicago Tribune

First Advertisement Start Date 2022-06-05

Second Newspaper Name Chicago Tribune

Second Advertisement Type Newspaper

Second Ad Start Date 2022-06-12

Job Fair From Date -

Job Fair to Date -

On Campus Recruiting from Date -

On Campus Recruiting to Date -

Employer Website from Date 2022-05-18

Employer Website to Date 2022-06-22

Pro. Org. Ad from Date -

Pro.Org. Ad to Date -

Job Search Website from Date 2022-05-20

Job Search Website to Date 2022-06-03

Private Employment Firm from Date -

Pricate Employment Firm to Date -

Employee Referral Program from Date 2022-05-18

Employee Referral Program to Date 2022-06-02

Campus Placement from Date -

Campus Placement to Date -

Local Ethnic Newspaper from Date -

Local Ethnic Newspaper to Date -

Radio/TV Ad from Date -

Radio/TV Ad to Date -

Employer Received the Payment N

Payment Details -

Bargaining Representative Notified N/A

Posted Notice at Worksite Y

Layoff in Past Six Months N

US Worker Considered -

Country of Citizenship INDIA

Foreign Worker Birth Country INDIA

Class of Admission H-1B

Employee Info

24 fields

Foreign Worker Education Master's

Foreign Worker Education Other -

Foreign Worker Major COMPUTER ENGINEERING

Year of Compelted Education 2014

Foreign Worker Istitution of Eduation ACHARYA NAGARJUNA UNIVERSITY

Foreign Worker Education Instution Address Line 1 NH16, NAGARJUNA NAGAR

Foreign Worker Education Institution Address Line 2 -

Foreign Worker Education Institution City GUNTUR

Foreign Worker Educatution Institution State ANDHRA PRADESH

Foreign Worker Education Institution Country INDIA

Foreign Worker Education Training Post Code 522510

Foreign Worker Training Completion N/A

Foreign Worker Required Experience N/A

Foreign Worker Alternate Education and Experience N

Foreign Worker Alternate Occupation Experience Y

Foreign Worker Experience with Employer N

Foreign Worker Employer Pay for Education N

Foreign Worker Currently Employed Y

Employer Completed Application N

Preparer Name Michelle Gergerian

Preparer Title Attorney

Preparer Email mgergerian@seyfarth.com

Employer Information Declaration Name Raymond Covarrubias

Employer Declaration Title Senior Manager, Human Resources