All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-19214-39047
Fiscal year: 2020
Fiscal Year
2020
Case Number
A-19214-39047
Case Status
Certified-Expired
Received Date
2019-10-10
Decision Date
2020-03-09
Refile
N
Original File Date
2020-01-01 07:46:21
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
UBS BUSINESS SOLUTIONS US LLC
Employer Name Slug
ubs-business-solutions-us-llc
Employer Address 1
2711 CENTERVILLE ROAD
Employer Address 2
SUITE 400
Employer City
WILMINGTON
Employer City Slug
wilmington
Employer State
DELAWARE
Employer State Slug
delaware
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
19808
Employer Phone
615-332-6481
Employer Number of Employees
60000
Employer Year Commenced Business
2006
NAICS Code
523110
FW Ownership Interest
N
Employer Contact Name
Sasha Gilmore
Employer Contact Address 1
315 Deaderick Street
Employer Contact Address 2
Employer Contact City
Nashville
Employer Contact State/Province
TENNESSEE
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
37238
Employer Contact Phone
615-393-7459
Employer Contact Email
sasha.gilmore@ubs.com
Agent Attorney Name
James Ziegenfuss
Agent Attorney Firm Name
FRAGOMEN, DEL REY, BERNSEN LOEWY LLP
Agent Attorney Phone
2126888555
Agent Attorney Address 1
1400 Broadway
Agent Attorney Address 2
10th Floor
Agent Attorney City
New York
Agent Attorney State/Province
NEW YORK
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
10018
Agent Attorney Email
JZiegenfuss@fragomen.com
PW Track Number
P10018285526095
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level III
PW Wage
90210.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2019-02-21
PW Expiration Date
2019-06-30
Wage Offer From
91000.00
Wage Offer To
100000.00
Average Salary
95500.00
Wage Unit of Pay
Year
Worksite Address 1
315 Deaderick Street
Worksite Address 2
Worksite City
Nashville
Worksite City Slug
nashville
Worksite State
TENNESSEE
Worksite Postal Code
37238
Job Title
Associate Director, Senior MS SQL Server Database Administrator
Job Title Slug
associate-director-senior-ms-sql-server-database-administrator
Minimum Education
Master's
Major Field of Study
Computer Science, Computer Engineering, Computer Information Systems or related
Required Training
N
Required Experience
Y
Required Experience Months
36
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
Accept Alternative Combination
N
Accept Alternative Combination Education
Accept Alternative Combination Education Years
Accept Foreign Education
Y
Accept Alternative Occupation
Y
Accept Alternative Occupation Months
36
Accept Alternative Job Title
Senior Associate IT Operations, Technical Lead IT IS, Engineer Database Administration or rel
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Three 3 years of experience in the job offered or related position resolving daily service desk incidents and tickets including issues related to blocking, CPU, memory, backup, job failures and performance; supporting online transaction processing and warehouse databases using different SQL Server versions and High Availability options including Log shipping, Clustering, Replication and Database Mirroring; tuning database stacks to meet service and operational level agreements using SQL Server; installing SQL Servers on clustering environments; applying service packs and hotfixes; automating tasks using Powershell scripting; performing DBA activities including database lifecycle management, creation, upgrade, migration, refresh, backup recovery, space user management, database corruption; and utilizing ITIL concept, process and used ITIL oriented operational tools; managing and reporting on capacity planning for all SQL Servers; ensuring optimal resilience of deployed systems to meet disaster recovery and compliance requirements.
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-05-07
SWA Job Order End Date
2019-06-07
Sunday Edition Newspaper
Y
First Newspaper Name
Nashville Banner Tennesean
First Advertisement Start Date
2019-05-19
Second Newspaper Ad Name
Nashville Banner Tennesean
Second Advertisement Type
Newspaper
Second Ad Start Date
2019-05-26
Employer Website From Date
2019-05-14
Employer Website To Date
2019-05-28
Professional Organization Ad From Date
2020-01-01 07:46:21
Professional Organization Advertisement To Date
2020-01-01 07:46:21
Job Search Website From Date
2019-05-19
Job Search Website To Date
2019-06-17
Employee Referral Program From Date
2019-05-14
Employee Referral Program To Date
2019-05-28
Local Ethnic Paper From Date
2020-01-01 07:46:21
Local Ethnic Paper To Date
2020-01-01 07:46:21
Radio/TV Ad From Date
2020-01-01 07:46:21
Radio/TV Ad To Date
2020-01-01 07:46:21
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 INFORMATION SYSTEMS
Foreign Worker Years of Education Completed
2007
Foreign Worker Institution of Education
UNIVERSITY OF PUNE
Foreign Worker Education Institution Address 1
GANESHKHIND RD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
PUNE
Foreign Worker Education Institution State/Province
MAHARASHTRA
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
411007
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
James Ziegenfuss
Preparer Title
Associate
Preparer Email
JZiegenfuss@fragomen.com
Employer Information Declaration Name
Adrian Fuller
Employer Information Declaration Title
Director