APEX ANALYTIX LLC

Manager - Database Administration

A-22234-09797 H-1B 2023 Certified

Salary

$117,312

Visa Type

H-1B

Job Title

Manager - Database Administration

Employee's Citizenship

INDIA

Graduate School

SIKKIM MANIPAL UNIVERSITY

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22234-09797

Case Status Certified

Received Date 2022-09-20

Decision Date 2023-07-12

Refile N

Original File Date -

Previous State Work Force Agency (SWA) Case Number Stete -

Schedule A or a Sheepherder Occupation N

Company Info

14 fields

Employer Name APEX ANALYTIX LLC

Employer Address_Line 1 1501 HIGHWOODS BLVD

Employer Address_Line 2 SUITE 200

Employer City GREENSBORO

State -

Employer State/ Province NORTH CAROLINA

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 27410

Employer Phone No. 3362912314

Employer Phone Extent No. -

Total Number of Employees 350

Employer Year of Commenced 1988

NAICS Code 541519

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Shen-Li Yap

Employer Contact Address Line1 1501 Highwoods Blvd.

Employer Contact Address Line2 Ste. 200

Employer Contact City Greensboro

Employer Contact State/ Provice NORTH CAROLINA

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 27410

Employer Contact Phone 3367904468

Employer Contact Email syap@apexanalytix.com

Attorney

11 fields

Agent/ Attorney Name William R Hummel

Agent/ Attorney Firm Name Garfinkel Immigration Law Firm

Agent/ Attorney Phone 704-442-8000

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 6100 Fairview Road

Agent/ Attorney Address Line 2 Ste 200

Agent/ Attorney City Charlotte

Agent/ Attorney State/ Province NORTH CAROLINA

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 28210

Agent/ Attorney Email attorneys@garfinkelimmigration.com

Position Info

89 fields

Prevailing Wage Track Number P10021273616753

Prevailing Wage SOC Code 15-1141

Prevailing Wage SOC Title Database Administrators

Prevailing Wage Skill Level Level IV

Prevailing Wage 117312

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-03-30

Prevailing Wage Expiration Date 2022-06-30

Wage Offer From 133000

Wage Offer To -

Wage Offer Unit of Pay Year

Workstie Address Line 1 1501 Highwoods Blvd.

Worksite Address Line 2 Ste. 200

Worksite City Greensboro

Worksite State NORTH CAROLINA

Worksite Postal Code 27410

Job Title Manager - Database Administration

Minimum Education Bachelor's

Other Degree/ Diploma -

Major Field of Study Computer Science

Required Training N

Required Training Month -

Required Field of Training -

Required Experience N

Required Expreience Months -

Accept Alternate Field of Study Y

Accept Alternate Major Applied Computer Science, or Management Information Systems or related.

Alternate Combination of Education/ Experience N

Required Alternate Level of Education -

Other Alternate Level of Education -

Acceptable Years of Experience -

Accept Foreign Educationa Y

Acceptable Alternate Occupation Y

Acceptable Alternate Occupation Month 60

Accept Alternate Job Title Same or related like Vice President

Normal Requirements of Job Opportunity N

Required Foreign Language N

Specific Skills Requires a Bachelors degree in Computer Science, Applied Computer Science, Management Information Systems or related field or foreign equivalent. Requires five 5 years MSDBA or similar competency; MS SQL Server experience in MS SQL 2014, 2016, or 2017; MS SQL Installation, Patching and configuration; MS SQL Server architecture including query plan optimization, physical DB design, system maintenance, Windows Server and hardware configuration especially RAID; Managing Backups Recovery Process; Managing MS SQL Environment DEV, QA, UAT and Production; Relational Database Design Architecture; Query Writing TSQL; High Availability using Log Shipping, Always On and Mirroring; Performance Tuning, Query Optimization and Resource management; four 4 years Data modeling and database design; Managing Disaster Recovery Environment; Data security; Capacity planning; three 3 years utilizing knowledge of OLAP; two 2 years utilizing knowledge of OLTP; Managing MYSQL Environment DEV, QA, UAT and Production. All hires must submit to a drug screen and background check.

Combination Occupation N

Offered to Applied Foreign Worker Y

ForeignWorker Live on Premises N

Live in Domestic Service Worker N

Employment Contract -

Professional Occupation Y

College/ University Teacher N

Competitive Process -

Basic Recruitment Process -

Teacher Select Date -

Teacher Publish Journal Name -

Additional Recruitment Information -

Job Oder Start Date 2022-05-20

Job Oder End Date 2022-06-20

Sunday Edition Newspaper Y

First Newspaper Name News Record

First Advertisement Start Date 2022-06-05

Second Newspaper Name News Record

Second Advertisement Type Newspaper

Second Ad Start Date 2022-06-12

Job Fair From Date -

Job Fair to Date -

On Campus Recruiting from Date -

On Campus Recruiting to Date -

Employer Website from Date -

Employer Website to Date -

Pro. Org. Ad from Date -

Pro.Org. Ad to Date -

Job Search Website from Date 2022-06-10

Job Search Website to Date 2022-06-16

Private Employment Firm from Date -

Pricate Employment Firm to Date -

Employee Referral Program from Date 2022-05-20

Employee Referral Program to Date 2022-05-24

Campus Placement from Date 2022-05-20

Campus Placement to Date 2022-05-27

Local Ethnic Newspaper from Date -

Local Ethnic Newspaper to Date -

Radio/TV Ad from Date -

Radio/TV Ad to Date -

Employer Received the Payment N

Payment Details -

Bargaining Representative Notified N/A

Posted Notice at Worksite Y

Layoff in Past Six Months N

US Worker Considered -

Country of Citizenship INDIA

Foreign Worker Birth Country INDIA

Class of Admission H-1B

Employee Info

24 fields

Foreign Worker Education Bachelor's

Foreign Worker Education Other -

Foreign Worker Major APPLIED COMPUTER SCIENCE

Year of Compelted Education 2011

Foreign Worker Istitution of Eduation SIKKIM MANIPAL UNIVERSITY

Foreign Worker Education Instution Address Line 1 TADONG

Foreign Worker Education Institution Address Line 2 -

Foreign Worker Education Institution City GANGTOK

Foreign Worker Educatution Institution State SIKKIM

Foreign Worker Education Institution Country INDIA

Foreign Worker Education Training Post Code 7373102

Foreign Worker Training Completion N/A

Foreign Worker Required Experience N/A

Foreign Worker Alternate Education and Experience N/A

Foreign Worker Alternate Occupation Experience Y

Foreign Worker Experience with Employer N

Foreign Worker Employer Pay for Education N

Foreign Worker Currently Employed Y

Employer Completed Application N

Preparer Name William R Hummel

Preparer Title Partner

Preparer Email attorneys@garfinkelimmigration.com

Employer Information Declaration Name ShenLi Yap

Employer Declaration Title Manager, Human Resources