All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
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