All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-22034-07129

Fiscal year: 2023

Fiscal Year

2023

Case Number

A-22034-07129

Case Status

Certified

Received Date

2022-02-08

Decision Date

2022-10-11

Refile

N

Original File Date

2023-01-01 18:18:50

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Pharmacy Corporation of America

Employer Name Slug

pharmacy-corporation-of-america

Employer Address 1

805 N Whittington Parkway

Employer Address 2

Employer City

Louisville

Employer City Slug

louisville

Employer State

KENTUCKY

Employer State Slug

kentucky

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

40222

Employer Phone

5023942100

Employer Number of Employees

541

Employer Year Commenced Business

2007

NAICS Code

446110

FW Ownership Interest

N

Employer Contact Name

Matt Tierney

Employer Contact Address 1

805 N Whittington Parkway

Employer Contact Address 2

Employer Contact City

Louisville

Employer Contact State/Province

KENTUCKY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

40222

Employer Contact Phone

5023942100

Employer Contact Email

[email protected]

Agent Attorney Name

Charles R Baesler

Agent Attorney Firm Name

Stoll Keenon Ogden PLLC

Agent Attorney Phone

8592313944

Agent Attorney Address 1

300 West Vine Street

Agent Attorney Address 2

Ste. 2100

Agent Attorney City

Lexington

Agent Attorney State/Province

KENTUCKY

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

40507

Agent Attorney Email

[email protected]

PW Track Number

P10021034058985

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

69659.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-06-21

PW Expiration Date

2021-09-19

Wage Offer From

91481.25

Wage Offer To

0.00

Average Salary

91481.25

Wage Unit of Pay

Year

Worksite Address 1

3802 Corporex Park Drive

Worksite Address 2

Worksite City

Tampa

Worksite City Slug

tampa

Worksite State

FLORIDA

Worksite Postal Code

33619

Job Title

Database Administrator

Job Title Slug

database-administrator

Minimum Education

Bachelor's

Major Field of Study

computer science

Required Training

N

Required Experience

Y

Required Experience Months

24

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

computer engineering, information systems or a related technical field, or its foreign equivalent

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

This position requires a Bachelor of Science degree in computer science, computer engineering, information systems or a related technical field, or its foreign equivalent followed by 2 years of work experience in each of the following 1. SQL server installations, clustering, highavailability, upgrades, migrations, database failover mechanisms, backup and DR strategies; 2. SQL server system internals and architecture, resource management and distributed computing; powershell scripting, DB monitoring tools and any backup software; 3. Experience working in production database environments, performance and index tuning, optimize sql code, execution plans, developing TSQL stored procedures, functions, views, cursors, triggers, data security and TDE; 4. Develop and administering SSIS, SSRS and SSAS; and 5. Experience in data modelling, MSMQ and VSTS. Must be a Microsoft Certified IT Professional Database Administrator.

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-10-07

SWA Job Order End Date

2021-11-11

Sunday Edition Newspaper

Y

First Newspaper Name

Tampa Bay Times

First Advertisement Start Date

2021-09-19

Second Newspaper Ad Name

Tampa Bay Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-09-26

Employer Website From Date

2023-01-01 18:18:50

Employer Website To Date

2023-01-01 18:18:50

Professional Organization Ad From Date

2021-09-15

Professional Organization Advertisement To Date

2021-10-15

Job Search Website From Date

2021-09-15

Job Search Website To Date

2021-09-29

Employee Referral Program From Date

2023-01-01 18:18:50

Employee Referral Program To Date

2023-01-01 18:18:50

Local Ethnic Paper From Date

2021-09-22

Local Ethnic Paper To Date

2021-09-22

Radio/TV Ad From Date

2023-01-01 18:18:50

Radio/TV Ad To Date

2023-01-01 18:18:50

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

COMPUTER SCIENCE ENGINEERING

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

PONDICHERRY UNIVERSITY

Foreign Worker Education Institution Address 1

KALAPET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

PUDUCHERRY

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

605014

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Charles R Baesler

Preparer Title

Attorney

Preparer Email

[email protected]

Employer Information Declaration Name

Matt Tierney

Employer Information Declaration Title

Sr Director, HR Ops and MA