All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19197-31302
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19197-31302
Case Status
Certified-Expired
Received Date
2019-08-27
Decision Date
2019-11-01
Refile
N
Original File Date
2020-01-01 07:36:54
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
COMPANION PROFESSIONAL SERVICES, LLC
Employer Name Slug
companion-professional-services-llc
Employer Address 1
1301 GERVAIS STREET
Employer Address 2
SUITE 1700
Employer City
COLUMBIA
Employer City Slug
columbia
Employer State
SOUTH CAROLINA
Employer State Slug
south-carolina
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
29201
Employer Phone
(803) 765-1310
Employer Number of Employees
220
Employer Year Commenced Business
1976
NAICS Code
541511
FW Ownership Interest
N
Employer Contact Name
Geoff Rhodes
Employer Contact Address 1
1301 Gervais Street
Employer Contact Address 2
Suite 1700
Employer Contact City
Columbia
Employer Contact State/Province
SOUTH CAROLINA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
29201
Employer Contact Phone
(803) 765-1310 1826
Employer Contact Email
grhodes@tmfloyd.com
Agent Attorney Name
Agent Attorney Firm Name
Agent Attorney Phone
Agent Attorney Address 1
Agent Attorney Address 2
Agent Attorney City
Agent Attorney State/Province
Agent Attorney Country
Agent Attorney Postal Code
Agent Attorney Email
PW Track Number
P10019066190071
PW SOC Code
15-1141
PW SOC Title
Database Administrator Tead Lead
PW Skill Level
Level IV
PW Wage
88067.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-06-18
PW Expiration Date
2019-09-16
Wage Offer From
176800.00
Wage Offer To
0.00
Average Salary
176800.00
Wage Unit of Pay
Year
Worksite Address 1
1301 Gervais Street
Worksite Address 2
Suite 1700
Worksite City
Columbia
Worksite City Slug
columbia
Worksite State
SOUTH CAROLINA
Worksite Postal Code
29201
Job Title
Database Administrator - Project Lead
Job Title Slug
database-administrator-project-lead
Minimum Education
Bachelor's
Major Field of Study
Computer Science or related
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
Y
Accept Alternative Combination Education
Other
Accept Alternative Combination Education Years
5
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
60
Accept Alternative Job Title
IT positions that meet the skills requirements
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
FIVE YEARS OF EXPERIENCE IN DATABASE DEVELOPMENT, DATABASE ADMINISTRATION, ANDOR COMPUTER SYSTEMS ANALYSIS AND DEVELOPMENTbr THREE YEARS OF ADDITIONAL EXPERIENCE WITH THE ABOVE CAN BE SUBSTITUTED FOR EACH YEAR OF EDUCATION REQUIREDbr EXPERIENCE WITH ORACLE RDBMS AND ORACLE DESIGN, DEVELOPMENT, MAINTENANCE, AND REPORTING TOOLS E.G., ORACLE 9I10G ENTERPRISE ED., RECOVERY MANAGER, DIAGNOSTIC PACKAGE, CHANGE MANAGEMENT PACKAGE, TUNING PACKAGE, ORACLE SQL NET, ORACLE DISCOVERER ADMINISTRATIVE AND USERbr EDITION, ORACLE DESIGNER FOR APPLICATION DB DESIGN AND ORACLE PROGRAMMER 2000 FOR APPLICATION DESIGN
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-03-06
SWA Job Order End Date
2019-04-12
Sunday Edition Newspaper
Y
First Newspaper Name
The State
First Advertisement Start Date
2019-06-09
Second Newspaper Ad Name
The State
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-06-16
Employer Website From Date
2019-05-13
Employer Website To Date
2019-06-03
Professional Organization Ad From Date
2020-01-01 07:36:54
Professional Organization Advertisement To Date
2020-01-01 07:36:54
Job Search Website From Date
2019-05-13
Job Search Website To Date
2019-06-03
Employee Referral Program From Date
2019-05-02
Employee Referral Program To Date
2019-06-03
Local Ethnic Paper From Date
2020-01-01 07:36:54
Local Ethnic Paper To Date
2020-01-01 07:36:54
Radio/TV Ad From Date
2020-01-01 07:36:54
Radio/TV Ad To Date
2020-01-01 07:36:54
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
CANADA
Foreign Worker Birth Country
CANADA
Class of Admission
H-1B
Foreign Worker Education
Other
Foreign Worker Information: Major
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
1992
Foreign Worker Institution of Education
JOHN ABBOTT COLLEGE
Foreign Worker Education Institution Address 1
161 QUERBES
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
DORION
Foreign Worker Education Institution State/Province
QUEBEC
Foreign Worker Education Institution Country
CANADA
Foreign Worker Education Institution Postal Code
J7V1J4
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
Y
Preparer Name
Preparer Title
Preparer Email
Employer Information Declaration Name
Geoff Rhodes
Employer Information Declaration Title
General Counsel