All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21198-18767
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21198-18767
Case Status
Certified-Expired
Received Date
2021-07-22
Decision Date
2022-01-04
Refile
N
Original File Date
2022-01-01 10:42:08
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
MARKET AMERICA, INC.
Employer Name Slug
market-america-inc
Employer Address 1
1302 PLEASANT RIDGE ROAD
Employer Address 2
Employer City
GREENSBORO
Employer City Slug
greensboro
Employer State
NORTH CAROLINA
Employer State Slug
north-carolina
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
27409
Employer Phone
3365446335
Employer Number of Employees
442
Employer Year Commenced Business
1992
NAICS Code
541613
FW Ownership Interest
N
Employer Contact Name
Sherry Spesock
Employer Contact Address 1
1302 Pleasant Ridge Road
Employer Contact Address 2
Employer Contact City
Greensboro
Employer Contact State/Province
NORTH CAROLINA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
27409
Employer Contact Phone
3365446335
Employer Contact Email
sherrys@marketamerica.com
Agent Attorney Name
Penni P Bradshaw
Agent Attorney Firm Name
Constangy Brooks Smith Prophete
Agent Attorney Phone
336-721-6842
Agent Attorney Address 1
100 N. Cherry St., Suite 300
Agent Attorney Address 2
Agent Attorney City
Winston-Salem
Agent Attorney State/Province
NORTH CAROLINA
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
27101
Agent Attorney Email
pbradshaw@constangy.com
PW Track Number
P10020335930829
PW SOC Code
15-1199
PW SOC Title
Director of SQL Server Database Development
PW Skill Level
Level II
PW Wage
59384.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-04-09
PW Expiration Date
2021-07-08
Wage Offer From
59384.00
Wage Offer To
174900.00
Average Salary
117142.00
Wage Unit of Pay
Year
Worksite Address 1
1302 Pleasant Ridge Road
Worksite Address 2
Worksite City
Greensboro
Worksite City Slug
greensboro
Worksite State
NORTH CAROLINA
Worksite Postal Code
27409
Job Title
Director of SQL Server Database Development
Job Title Slug
director-of-sql-server-database-development
Minimum Education
Master's
Major Field of Study
Computer Science or related field
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
Bachelor's
Accept Alternative Combination Education Years
5
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
24
Accept Alternative Job Title
related experience as a Database Administrator, Operations Manager or related IT occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Experience is required and must include the following Planning, organizing, directing, controlling and evaluating the operations of different data processing and development projects related to Microsoft SQL Server; Overseeing, managing and improving MS SQL Server including performance tuning and high availability by developing and implementing standard operating procedures and policies; Implementing and executing disaster recovery and high availability database strategies using EnterpriseClass cluster environments; monitoring and tuning MS SQL database systems; and Managing multiple MS SQL Servers on EnterpriseClass Server clusters.br br The employer requires a preemployment background check and drug screening.br br This position has the option to work remotely 100 of the time.
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-05-19
SWA Job Order End Date
2021-06-21
Sunday Edition Newspaper
Y
First Newspaper Name
News and Record
First Advertisement Start Date
2021-05-30
Second Newspaper Ad Name
News and Record
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-06-06
Employer Website From Date
2022-01-01 10:42:08
Employer Website To Date
2022-01-01 10:42:08
Professional Organization Ad From Date
2022-01-01 10:42:08
Professional Organization Advertisement To Date
2022-01-01 10:42:08
Job Search Website From Date
2021-05-17
Job Search Website To Date
2021-06-01
Employee Referral Program From Date
2022-01-01 10:42:08
Employee Referral Program To Date
2022-01-01 10:42:08
Local Ethnic Paper From Date
2021-06-02
Local Ethnic Paper To Date
2021-06-08
Radio/TV Ad From Date
2022-01-01 10:42:08
Radio/TV Ad To Date
2022-01-01 10:42:08
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
Master's
Foreign Worker Information: Major
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2007
Foreign Worker Institution of Education
UNIVERSITY OF TEXAS, SAN ANTONIO
Foreign Worker Education Institution Address 1
1 UTSA CIRCLE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
SAN ANTONIO
Foreign Worker Education Institution State/Province
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
78249
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Penni P Bradshaw
Preparer Title
Partner
Preparer Email
pbradshaw@constangy.com
Employer Information Declaration Name
Sherry Spesock
Employer Information Declaration Title
Director of Human Resources