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