All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-22027-03297

Fiscal year: 2023

Fiscal Year

2023

Case Number

A-22027-03297

Case Status

Certified

Received Date

2022-03-17

Decision Date

2022-11-23

Refile

N

Original File Date

2023-01-01 18:08:37

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

AMELIA US LLC

Employer Name Slug

amelia-us-llc

Employer Address 1

17 STATE STREET

Employer Address 2

14TH FLOOR

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10004

Employer Phone

(212) 708-5500

Employer Number of Employees

460

Employer Year Commenced Business

1999

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Jerry Levine

Employer Contact Address 1

17 State Street

Employer Contact Address 2

14th Floor

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10004

Employer Contact Phone

(212) 708-5500

Employer Contact Email

jerry.levine@ipsoft.com

Agent Attorney Name

Derek M Sewall

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

212-688-8555

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

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

dsewall@fragomen.com

PW Track Number

P10021069136431

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level III

PW Wage

119330.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-08-06

PW Expiration Date

2022-06-30

Wage Offer From

119330.00

Wage Offer To

130000.00

Average Salary

124665.00

Wage Unit of Pay

Year

Worksite Address 1

17 State Street

Worksite Address 2

14th Floor

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10004

Job Title

Sr. SQL Database Engineer

Job Title Slug

sr-sql-database-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Computer Engineering, or a related field

Required Training

N

Required Experience

Y

Required Experience Months

48

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

48

Accept Alternative Job Title

a related role

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must have four 4 years of experience with performing database administration of SQL Server, including backup strategy, maintenance, installation, deployment, security administration, performance tuning, capacity planning, configuration, and recovery; leveraging High Availability HA and Disaster Recovery DR options, including replication, log shipping, database mirroring, availability group, and clustering to ensure databases are resistant to risk and disruption and that business continuity remains during emergencies; leveraging MySQL, Excel, and macros programming for operation report generation and analysis, including Service Level Agreement SLA misses, ticket volume, time spent and resolution statistics for further service improvement; developing and reviewing standard operating procedures from current processes to identify viable automation areas to improve productivity and lower operation costs; creating, developing, and enhancing automation using SQL, TSQL, batch script, shell script, and JavaScript for faster service delivery and reducing costs of IT services; and identifying and implementing Continual Service Improvement opportunities by utilizing metrics, problem management, and trends analysis to improve the quality of service.

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

2021-12-08

SWA Job Order End Date

2022-01-10

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2021-12-26

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-01-02

Employer Website From Date

2021-09-27

Employer Website To Date

2022-02-09

Professional Organization Ad From Date

2023-01-01 18:08:37

Professional Organization Advertisement To Date

2023-01-01 18:08:37

Job Search Website From Date

2021-12-26

Job Search Website To Date

2022-01-10

Employee Referral Program From Date

2023-01-01 18:08:37

Employee Referral Program To Date

2023-01-01 18:08:37

Local Ethnic Paper From Date

2021-12-27

Local Ethnic Paper To Date

2021-12-27

Radio/TV Ad From Date

2023-01-01 18:08:37

Radio/TV Ad To Date

2023-01-01 18:08:37

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

PHILIPPINES

Foreign Worker Birth Country

PHILIPPINES

Class of Admission

H-1B

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2004

Foreign Worker Institution of Education

MAPUA INSTITUTE OF TECHNOLOGY

Foreign Worker Education Institution Address 1

333 SEN. GIL PUYAT AVE.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MAKATI CITY

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

PHILIPPINES

Foreign Worker Education Institution Postal Code

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Derek M Sewall

Preparer Title

Associate Attorney

Preparer Email

dsewall@fragomen.com

Employer Information Declaration Name

Gerald Levine

Employer Information Declaration Title

General Counsel