All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-19151-12556

Fiscal year: 2020

Fiscal Year

2020

Case Number

A-19151-12556

Case Status

Certified-Expired

Received Date

2019-08-01

Decision Date

2019-10-09

Refile

N

Original File Date

2020-01-01 07:21:55

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

PHARMAVITE

Employer Name Slug

pharmavite

Employer Address 1

8531 FALLBROOK AVENUE

Employer Address 2

Employer City

WEST HILLS

Employer City Slug

west-hills

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

91304

Employer Phone

818-221-6200

Employer Number of Employees

1801

Employer Year Commenced Business

1973

NAICS Code

325411

FW Ownership Interest

N

Employer Contact Name

Lucia Owens

Employer Contact Address 1

8531 Fallbrook Avenue

Employer Contact Address 2

Employer Contact City

West Hills

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

91304

Employer Contact Phone

818-221-6520

Employer Contact Email

lowens@pharmavite.net

Agent Attorney Name

Shelly Song

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

310-820-3322

Agent Attorney Address 1

444 S. Flower Street

Agent Attorney Address 2

Suite 500

Agent Attorney City

Los Angeles

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

90071

Agent Attorney Email

ssong@fragomen.com

PW Track Number

P10019106675146

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

115419.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-07-30

PW Expiration Date

2020-06-30

Wage Offer From

147084.00

Wage Offer To

0.00

Average Salary

147084.00

Wage Unit of Pay

Year

Worksite Address 1

8531 Fallbrook Avenue

Worksite Address 2

Worksite City

West Hills

Worksite City Slug

west-hills

Worksite State

CALIFORNIA

Worksite Postal Code

91304

Job Title

Senior Database Administrator

Job Title Slug

senior-database-administrator

Minimum Education

Bachelor's

Major Field of Study

Information Systems, Information Technology, Electronic Engineering, or rltd

Required Training

N

Required Experience

Y

Required Experience Months

72

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

72

Accept Alternative Job Title

Oracle EBus Apps DBA, Oracle App DBA, Team Lead, Sys Exec, Oracle Apps DBA Consultant, or rltd

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Experience with Oracle or DB2 Database technologies; 3 years of infrastructure and application experience working on large scale UNIXLinux systems; Experience working in a large company environment on multiple, complex projects simultaneously where critical deadlines must be met; 2 years of database design processes experience, including logical and physical data modeling; Experience with High Availability or Disaster Recovery Design; Experience with database infrastructure implementation, controls reengineering, distributed system recovery, and distributed systems administration; Experience with UNIX, Linux, and AS400 IBM iSeries; Experience with Windows 2000 or Windows 2003 Operating Systems; Experience writing, debugging, and executing SQL scripts; Knowledge of high availability, backup and recovery strategies for various Platforms; Knowledge of data securityintegrity and systems performance; Knowledge of WindowsAIXAS400 server operating systems and systems utility programs; Experience with Visio diagrams of the ERP environments such as database architecture, backup methods, or object relationships; Experience translating business and technical language, scenarios, and processes into written and visual technical documentation; Experience writing policies and procedures; Knowledge of project management or project process methodologies; Experience with security auditing and reporting techniques for database, infrastructure and application control environments; Experience in Oracle RDBMS and EBIZ Applications DBA supporting both Production Support and Projects Implementation; Experience in the following Oracle RDBMS, Oracle EBusiness Suite and other dependent Oracle technologies used in the deployment of EBusiness Suite like Java, JVM, OC4J, J2EE, Apache, OPMN, Oracle 10.1.2 and Oracle 10.1.3; Oracle RMAN and Legato backup software, including experience on Oracle Fusion Middleware Product Installations and Administrations; Knowledge of Oracle EBusiness ASCP Application; Experience working on multiple Operating Systems, such as IBM AIX, RedHat Linux, Oracle Linux, Windows; Experience supporting Oracle HTTPHTTPS SSL protocol; Experience in handling Oracle client users requirements Oracle ODBC, Oracle SQLNet, TCP, Access Database; Knowledge of developing SHELL scripts to support Oracle DBA tasks; Knowledge of debugging Oracle PLSQL code; Knowledge of deploying Oracle FMW Web Services and migration of web composites; Experience working independently, managing assigned projects and reviewing and resolving issues across multiple systems. Experience in H.6A and H.10A must be post baccalaureate and progressive. Any suitable combination of education, training, or experience is acceptable. Except as quantified above, the years of experience listed in H.6A and H.10A do not apply to the required skills listed in this section, and the employer will accept any level of experience, knowledge, or proficiency in the specific skills listed in this section.

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-16

SWA Job Order End Date

2019-05-18

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2019-04-28

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-05-05

Employer Website From Date

2020-01-01 07:21:55

Employer Website To Date

2020-01-01 07:21:55

Professional Organization Ad From Date

2019-04-25

Professional Organization Advertisement To Date

2019-05-02

Job Search Website From Date

2019-04-25

Job Search Website To Date

2019-05-02

Employee Referral Program From Date

2020-01-01 07:21:55

Employee Referral Program To Date

2020-01-01 07:21:55

Local Ethnic Paper From Date

2019-05-02

Local Ethnic Paper To Date

2019-05-02

Radio/TV Ad From Date

2020-01-01 07:21:55

Radio/TV Ad To Date

2020-01-01 07:21:55

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

1997

Foreign Worker Institution of Education

UNIVERSITY OF PUNE

Foreign Worker Education Institution Address 1

PUNESATARA ROAD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

PUNE

Foreign Worker Education Institution State/Province

MAHARASHTRA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

411043

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Shelly Song

Preparer Title

Associate

Preparer Email

ssong@fragomen.com

Employer Information Declaration Name

Lucia Owens

Employer Information Declaration Title

Talent Acquisition Manager