All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-19217-40135

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-19217-40135

Case Status

Certified-Expired

Received Date

2019-08-13

Decision Date

2019-10-31

Refile

N

Original File Date

2020-01-01 07:47:08

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

IPSOFT INCORPORATED

Employer Name Slug

ipsoft-incorporated

Employer Address 1

17 STATE STREET

Employer Address 2

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

8884776388

Employer Number of Employees

800

Employer Year Commenced Business

1999

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

Kenneth Martin

Employer Contact Address 1

17 STATE STREET

Employer Contact Address 2

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

8884776388

Employer Contact Email

hr@ipsoft.com

Agent Attorney Name

Richard C Lear

Agent Attorney Firm Name

IPsoft Incorporated

Agent Attorney Phone

2127085376

Agent Attorney Address 1

17 State Street

Agent Attorney Address 2

FL 14

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10004

Agent Attorney Email

Richard.Lear@ipsoft.com

PW Track Number

P10018353198805

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level III

PW Wage

102856.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-04-15

PW Expiration Date

2019-07-14

Wage Offer From

103000.00

Wage Offer To

143000.00

Average Salary

123000.00

Wage Unit of Pay

Year

Worksite Address 1

7 World Trade, 250 Greenwich Street

Worksite Address 2

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10007

Job Title

Oracle Database Administrator

Job Title Slug

oracle-database-administrator

Minimum Education

Bachelor's

Major Field of Study

Computer Sci, Computer Engg, Electronic Engg, or relequiv

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

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

48

Accept Alternative Job Title

Oracle Database Administrator, Specialist, or related

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Four 4 years of experience administering Clusterware, RDBMS, ASM, and OEM patching, installation, and configuration. Must have four 4 years of experience with deploying and maintaining high availability and failover technologies including Data Guard, Disaster Recovery, and RAC; handling physical backups and recovery through RMAN, including duplication, refresh, and cloning in Standalone, RAC, and Data Guard environment; leveraging Golden Gate, Shareplex, and CDC for data replication across datacenters to ensure realtime data availability; identifying poor SQL statements using AWR, ADDM, SQL Trace, OEM Grid Monitoring, customized scripts, and analyzing details using EXPLAIN PLAN, STATSPACK, and TKPROF; tuning performance using SQL tuning Advisor, SQL access Advisor, creating hints, SQL baselines, new indexes, and SQL profiles; developing automation scripts through shell, PLSQL, and automation software to enhance stability and speed of task implementation, development, and support; and defining, implementing, and enforcing database security standards in compliance with company policies and compliance frameworks including SOX and PCI. In the alternative, employer will accept a Masters degree in a related field and two 2 years of experience.

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-04-22

SWA Job Order End Date

2019-05-24

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2019-06-30

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-07-07

Employer Website From Date

2019-04-25

Employer Website To Date

2019-05-03

Professional Organization Ad From Date

2020-01-01 07:47:08

Professional Organization Advertisement To Date

2020-01-01 07:47:08

Job Search Website From Date

2019-04-26

Job Search Website To Date

2019-05-03

Employee Referral Program From Date

2019-04-25

Employee Referral Program To Date

2019-05-09

Local Ethnic Paper From Date

2020-01-01 07:47:08

Local Ethnic Paper To Date

2020-01-01 07:47:08

Radio/TV Ad From Date

2020-01-01 07:47:08

Radio/TV Ad To Date

2020-01-01 07:47:08

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

ELECTRONIC ENGINEERING

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

ANNA UNIVERSITY CHENNAI

Foreign Worker Education Institution Address 1

12, SARDAR PATEL RD., GUINDY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CHENNAI

Foreign Worker Education Institution State/Province

TAMILNADU

Foreign Worker Education Institution Country

Foreign Worker Education Institution Postal Code

600025

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Richard C Lear

Preparer Title

Immigration Attorney

Preparer Email

richard.lear@ipsoft.com

Employer Information Declaration Name

Ken Martin

Employer Information Declaration Title

Director of HR