BLACKSMITH APPLICATIONS
Database Developer
A-22207-95027
H-1B
2023
Certified
Salary
$132,850
Visa Type
H-1B
Job Title
Database Developer
Employee's Citizenship
CHINA
Graduate School
THE HARRISBURG UNIVERSITY OF SCIENCE AND TECHNOLOGY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22207-95027
Case Status
Certified
Received Date
2022-07-29
Decision Date
2023-05-17
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
BLACKSMITH APPLICATIONS
Employer Address_Line 1
1 UNION ST
Employer Address_Line 2
-
Employer City
LAWRENCE
State
-
Employer State/ Province
MASSACHUSETTS
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
1840
Employer Phone No.
6035600543
Employer Phone Extent No.
-
Total Number of Employees
68
Employer Year of Commenced
2000
NAICS Code
541511
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Robin Doyle
Employer Contact Address Line1
1 Union St
Employer Contact Address Line2
-
Employer Contact City
Lawrence
Employer Contact State/ Provice
MASSACHUSETTS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
1840
Employer Contact Phone
6035600543
Employer Contact Email
robin.doyle@blacksmithapplications.com
Attorney
11 fields
Agent/ Attorney Name
Magaly R Cheng
Agent/ Attorney Firm Name
Clark Lau LLC
Agent/ Attorney Phone
6172994200
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
155 Federal Street
Agent/ Attorney Address Line 2
Suite 400
Agent/ Attorney City
Boston
Agent/ Attorney State/ Province
MASSACHUSETTS
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
2110
Agent/ Attorney Email
mcheng@clarklau.com
Position Info
89 fields
Prevailing Wage Track Number
P10021200469825
Prevailing Wage SOC Code
15-1141
Prevailing Wage SOC Title
Database Administrators
Prevailing Wage Skill Level
Level IV
Prevailing Wage
132850
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
OES
Prevailing Wage Other Source
-
Prevailing Wage Determination Date
2021-12-22
Prevailing Wage Expiration Date
2022-06-30
Wage Offer From
132850
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
1 Union Street
Worksite Address Line 2
Suite 500
Worksite City
Lawrence
Worksite State
MASSACHUSETTS
Worksite Postal Code
1804
Job Title
Database Developer
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Database Developer
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
N
Required Expreience Months
-
Accept Alternate Field of Study
N
Accept Alternate Major
-
Alternate Combination of Education/ Experience
Y
Required Alternate Level of Education
Master's
Other Alternate Level of Education
-
Acceptable Years of Experience
2
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
60
Accept Alternate Job Title
See H14
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Bachelors degree in computer science, computer information sciences, or a closely related field and at least five 5 years of progressively more responsible work experience with Database Modeling, Database Architecture and system design using RDBMS concepts and constructs.br br In the alternative, the Employer will accept a Masters degree in computer science, computer information sciences, or a closely related field and at least two 2 years of work experience with Database Modeling, Database Architecture and system design using RDBMS concepts and constructs.br br Additionally, the employer requires the followingbr br 1. Demonstrated knowledge of data modeling, creating and maintaining complex logical and physical data models gained through two 2 years of work experience;br 2. Demonstrated ability developing, monitoring, extracting, and transforming data using SSIS, Import Export Wizard, and Bulk Insert gained through two 2 years of work experience; andbr 3. Demonstrated ability working with Data transformation to distinguish property of fields like mapped, unmapped, forwarded, and deleted gained through two 2 years of work experience.br br All years of experience may be gained concurrently.
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-02-10
Job Oder End Date
2022-03-21
Sunday Edition Newspaper
Y
First Newspaper Name
The Boston Globe
First Advertisement Start Date
2022-02-27
Second Newspaper Name
The Boston Globe
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-03-06
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
2022-03-01
Employer Website to Date
2022-03-25
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-03-10
Job Search Website to Date
2022-03-25
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
-
Employee Referral Program to Date
-
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
-
Local Ethnic Newspaper to Date
-
Radio/TV Ad from Date
2022-02-10
Radio/TV Ad to Date
2022-02-10
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
CHINA
Foreign Worker Birth Country
CHINA
Class of Admission
H-1B
Employee Info
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
COMPUTER INFORMATION SCIENCES
Year of Compelted Education
2020
Foreign Worker Istitution of Eduation
THE HARRISBURG UNIVERSITY OF SCIENCE AND TECHNOLOGY
Foreign Worker Education Instution Address Line 1
326 MARKET ST
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
HARRISBURG
Foreign Worker Educatution Institution State
PA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
17101
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N/A
Foreign Worker Alternate Education and Experience
Y
Foreign Worker Alternate Occupation Experience
N
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pay for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Magaly R Cheng
Preparer Title
Attorney
Preparer Email
mcheng@clarklau.com
Employer Information Declaration Name
Robin Doyle
Employer Declaration Title
Senior Director, Human Resources