All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-21167-02495

Fiscal year: 2022

Fiscal Year

2022

Case Number

A-21167-02495

Case Status

Certified-Expired

Received Date

2021-06-16

Decision Date

2021-12-03

Refile

N

Original File Date

2022-01-01 10:32:09

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Mindteck, Inc.

Employer Name Slug

mindteck-inc

Employer Address 1

205 Grandview Ave, Ste. 302

Employer Address 2

Employer City

Camp Hill

Employer City Slug

camp-hill

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

17011

Employer Phone

7177322211

Employer Number of Employees

86

Employer Year Commenced Business

1995

NAICS Code

541511

FW Ownership Interest

N

Employer Contact Name

ANJALI AJWANI

Employer Contact Address 1

205 Grandview Avenue

Employer Contact Address 2

SUITE 302

Employer Contact City

CAMP HILL

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

17011

Employer Contact Phone

717-732-2211

Employer Contact Email

anjali.ajwani@mindteck.us

Agent Attorney Name

Kendra S Elliott

Agent Attorney Firm Name

Law Offices of Kendra S. Elliott, Esq.

Agent Attorney Phone

717-506-5207

Agent Attorney Address 1

2215 Millennium Way

Agent Attorney Address 2

Agent Attorney City

Enola

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

17025

Agent Attorney Email

kendra.elliott@kelliottlaw.com

PW Track Number

P10020241794192

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level II

PW Wage

72779.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-02-04

PW Expiration Date

2021-06-30

Wage Offer From

72779.00

Wage Offer To

108000.00

Average Salary

90389.50

Wage Unit of Pay

Year

Worksite Address 1

Mult unanticipated locs in USA, report to Camp Hill, PA HQ

Worksite Address 2

Mindteck, 205 Grandview Avenue, Ste. 302

Worksite City

Camp Hill

Worksite City Slug

camp-hill

Worksite State

PENNSYLVANIA

Worksite Postal Code

17011

Job Title

APPLICATION DBA

Job Title Slug

application-dba

Minimum Education

Bachelor's

Major Field of Study

Comp Sci or rel

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Comp Sci or rel

Accept Alternative Combination

Y

Accept Alternative Combination Education

None

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

Any occupation involving relevant experience. See H.14

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

JOB REQUIREMENTS Further to Section H above Must have Bach in Comp Sci or rel field and 3 yrs rel DBA exp OR 5 yrs rel DBA exp. Also, req skill 3 yrs exp in Oracle DBA dev and support critical bus apps, Oracle 12c RAC and multitenant DB support, DB perf tuning, query optimization, deploy schema patches, implement DB config changes, deploy and support DB in cloud, dev CICD pipelines for DB DDLDML using Concourse, Jenkins, Stash, Artifactory and uDeploy. Any suitable combination of education, training, or experience is acceptable.br BUSINESS NECESSITY Further to H.12 All job opportunity requirements are normal except that the minimum requirements for this job appear to exceed the typical requirements per the OES Job Zone 4 definition. The job requirements are absolutely necessary for this particular type and level position, because an Application DBA is a critical position within our structure, and conducts highlevel technical work using stateoftheart tools and technologies. The work involves complex duties and the use of sophisticated technologies and processes. Such abilities only come with the required minimum level of qualifications. The job requirements bear a reasonable relationship to the occupation of Application DBA in the context of our business, and the requirements are essential to perform the job in a reasonable manner.

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-03-18

SWA Job Order End Date

2021-04-17

Sunday Edition Newspaper

Y

First Newspaper Name

The Patriot News

First Advertisement Start Date

2021-03-28

Second Newspaper Ad Name

The Patriot News

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-04-04

Employer Website From Date

2021-03-19

Employer Website To Date

2021-04-07

Professional Organization Ad From Date

2022-01-01 10:32:09

Professional Organization Advertisement To Date

2022-01-01 10:32:09

Job Search Website From Date

2021-03-28

Job Search Website To Date

2021-04-11

Employee Referral Program From Date

2022-01-01 10:32:09

Employee Referral Program To Date

2022-01-01 10:32:09

Local Ethnic Paper From Date

2022-01-01 10:32:09

Local Ethnic Paper To Date

2022-01-01 10:32:09

Radio/TV Ad From Date

2022-01-01 10:32:09

Radio/TV Ad To Date

2022-01-01 10:32:09

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

None

Foreign Worker Information: Major

Foreign Worker Years of Education Completed

Foreign Worker Institution of Education

Foreign Worker Education Institution Address 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

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

Kendra S Elliott, Esq.

Preparer Title

Attorney

Preparer Email

kendra.elliott@kelliottlaw.com

Employer Information Declaration Name

Anjali Ajwani

Employer Information Declaration Title

Contract Compliance Manager