All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-20034-14474

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-20034-14474

Case Status

Certified

Received Date

2020-03-10

Decision Date

2020-06-30

Refile

N

Original File Date

2020-01-01 08:35:48

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

HOMESITE GROUP, INCORPORATED

Employer Name Slug

homesite-group-incorporated

Employer Address 1

ONE FEDERAL STREET

Employer Address 2

Employer City

BOSTON

Employer City Slug

boston

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2110

Employer Phone

617-832-1325

Employer Number of Employees

1200

Employer Year Commenced Business

1997

NAICS Code

5241

FW Ownership Interest

N

Employer Contact Name

Fedelay RINCON

Employer Contact Address 1

ONE FEDERAL STREET

Employer Contact Address 2

Employer Contact City

BOSTON

Employer Contact State/Province

MASSACHUSETTS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

2110

Employer Contact Phone

617-832-1325

Employer Contact Email

fedelay.rincon@homesite.com

Agent Attorney Name

Aviva MEERSCHWAM

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy LLP

Agent Attorney Phone

2126888555

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

9th Floor

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10018

Agent Attorney Email

ameerschwam@fragomen.com

PW Track Number

P10019193019949

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

81661.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-10-29

PW Expiration Date

2020-06-30

Wage Offer From

118450.08

Wage Offer To

0.00

Average Salary

118450.08

Wage Unit of Pay

Year

Worksite Address 1

One Federal Street

Worksite Address 2

Worksite City

Boston

Worksite City Slug

boston

Worksite State

MASSACHUSETTS

Worksite Postal Code

2110

Job Title

SQL Database Administrator with

Job Title Slug

sql-database-administrator-with

Minimum Education

Master's

Major Field of Study

Civil Engineering, Computer Science, or a closelyrelated field

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

60

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

Performing SQL database administration and application development See H.14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

This position requires that a successful candidate must have a Masters degree or foreign equivalent in Civil Engineering, Computer Science, or a closelyrelated field, and two years of experience or a Bachelors degree and five 5 years of progressively responsible experience performing SQL database administration and application development within a SQL Server andor Oracle environment. Experience must include completing deployment of builds to various environments for development and testing prior to deployment to production; Configuring security and access per PCI standards; Monitoring SQL Server performance using Performance monitor and Profiler; Creating and managing database objects that include Tables, Views, Userdefined Functions, and Stored Procedures; and utilizing TSQL, SQL sentry, SQL server, PowerShell, and Windows server.br QUALIFICATIONS OF THE FOREIGN NATIONAL See also Sections J and Kbr Mr. Ramineni readily meets the minimum education requirement for the position. In May 2015, Mr. Ramineni was awarded a Master of Science degree in Civil Engineering by Lamar University in Beaumont, Texas. Therefore, Mr. Ramineni clearly meets the minimum education requirement for the position.br Mr. Ramineni readily meets the experience requirement through his prior experience with Tekorg Inc., as outlined below.br br Mr. Ramineni was employed by Tekorg Inc. in the role of SQL Database Administrator from August 31, 2015 to May 31, 2018. In this capacity, Mr. Ramineni installed, configured and deployed SQL server 2014 and SQL server 2012 in clustered and standalone environment. He provided Database Administration and Support for SQL Server 2008, 2008R2, 2012 and 2014. He completed deployment of builds to various environments for development and testing prior to deployment to production. Mr. Ramineni configured security and access per PCI standards. He also monitored MS SQL Server performance using Performance monitor and Profiler. He created and managed database objects that include Tables, Views, Userdefined Functions, and Stored Procedures. Additionally, Mr. Ramineni utilized TSQL, SQL sentry, SQL server, PowerShell, and Windows server.br br As a result of his more than two years of qualifying experience as described above, Mr. Ramineni meets the experience requirement for the position.

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-10-31

SWA Job Order End Date

2019-12-02

Sunday Edition Newspaper

Y

First Newspaper Name

The Boston Globe

First Advertisement Start Date

2019-11-03

Second Newspaper Ad Name

The Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-11-10

Employer Website From Date

2020-01-01 08:35:48

Employer Website To Date

2020-01-01 08:35:48

Professional Organization Ad From Date

2020-01-01 08:35:48

Professional Organization Advertisement To Date

2020-01-01 08:35:48

Job Search Website From Date

2019-10-31

Job Search Website To Date

2019-11-14

Employee Referral Program From Date

2019-10-31

Employee Referral Program To Date

2019-11-15

Local Ethnic Paper From Date

2019-11-04

Local Ethnic Paper To Date

2019-11-04

Radio/TV Ad From Date

2020-01-01 08:35:48

Radio/TV Ad To Date

2020-01-01 08:35:48

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

CIVIL ENGINEERING

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

LAMAR UNIVERSITY

Foreign Worker Education Institution Address 1

4400 MLK

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BEAUMONT

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

77710

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Aviva Meerschwam

Preparer Title

Associate

Preparer Email

ameerschwam@fragomen.com

Employer Information Declaration Name

Fedelay Rincon

Employer Information Declaration Title

Human Resources Generalist