All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-20168-66199
Fiscal year: 2021
Fiscal Year
2021
Case Number
A-20168-66199
Case Status
Certified-Expired
Received Date
2020-08-04
Decision Date
2021-03-15
Refile
N
Original File Date
2021-01-01 09:06:21
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
TRUIST BANK
Employer Name Slug
truist-bank
Employer Address 1
214 NORTH TRYON STREET
Employer Address 2
Employer City
CHARLOTTE
Employer City Slug
charlotte
Employer State
NORTH CAROLINA
Employer State Slug
north-carolina
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
28202
Employer Phone
615-391-8416
Employer Number of Employees
58000
Employer Year Commenced Business
1872
NAICS Code
522110
FW Ownership Interest
N
Employer Contact Name
Cheryl B Williams
Employer Contact Address 1
Truist Bank Nashville Operations Center
Employer Contact Address 2
41 Rachel Drive
Employer Contact City
Nashville
Employer Contact State/Province
TENNESSEE
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
37214
Employer Contact Phone
615-391-8416
Employer Contact Email
PRImmigration@BBandT.com
Agent Attorney Name
Penni P Bradshaw
Agent Attorney Firm Name
Constangy, Brooks, Smith Prophete, LLP
Agent Attorney Phone
336-721-6842
Agent Attorney Address 1
100 N. Cherry St.
Agent Attorney Address 2
Suite 300
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
P10020110498733
PW SOC Code
15-1141
PW SOC Title
IT Database Administrator III
PW Skill Level
Level III
PW Wage
88629.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2020-08-04
PW Expiration Date
2021-06-30
Wage Offer From
96000.00
Wage Offer To
112000.00
Average Salary
104000.00
Wage Unit of Pay
Year
Worksite Address 1
2101 South Tarboro Street
Worksite Address 2
Worksite City
Wilson
Worksite City Slug
wilson
Worksite State
NORTH CAROLINA
Worksite Postal Code
27893
Job Title
IT Database Administrator III
Job Title Slug
it-database-administrator-iii
Minimum Education
Master's
Major Field of Study
Computer Science
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
Information Systems, Engineering and Information Technology or related field
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
36
Accept Alternative Job Title
experience as a Database Administrator or related IT occupation
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Experience is required and must include Performing database administration duties including database installationconfiguration, database monitoring and troubleshooting, performance tuning, security setup, high availability, backup and recovery, and migrations and upgrades; Application or system programming experience including algorithms, logical operations, API understanding, SQL, programming principles, data structures and error handling; Writing host system scripting languages such as Job Control Language JCL, UNIX shell scripting, or NT batch; In physical database design and the development of database applications, including the ability to read logical models and create the physical database structure; Development and maintenance of medium sized databases; Data access methods, data extraction, migration, and loading processes; and Database loading techniques and tools.br br The employer will accept any suitable combination of experience of education, training, or experience.
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
2020-04-19
SWA Job Order End Date
2020-05-20
Sunday Edition Newspaper
Y
First Newspaper Name
The News and Observer
First Advertisement Start Date
2020-04-26
Second Newspaper Ad Name
The News and Observer
Second Advertisement Type
Newspaper
Second Ad Start Date
2020-05-03
Employer Website From Date
2020-04-21
Employer Website To Date
2020-05-06
Professional Organization Ad From Date
2021-01-01 09:06:21
Professional Organization Advertisement To Date
2021-01-01 09:06:21
Job Search Website From Date
2020-04-19
Job Search Website To Date
2020-05-04
Employee Referral Program From Date
2021-01-01 09:06:21
Employee Referral Program To Date
2021-01-01 09:06:21
Local Ethnic Paper From Date
2020-04-28
Local Ethnic Paper To Date
2020-04-28
Radio/TV Ad From Date
2021-01-01 09:06:21
Radio/TV Ad To Date
2021-01-01 09:06: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
Bachelor's
Foreign Worker Information: Major
COMPUTER SCIENCE TECHNOLOGY
Foreign Worker Years of Education Completed
2006
Foreign Worker Institution of Education
ANDHRA UNIVERSITY SIR C.R.REDDY COLLEGE OF ENGINEERING
Foreign Worker Education Institution Address 1
VATLURU, WEST GODAVARI DIST.
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
ELURU
Foreign Worker Education Institution State/Province
ANDHRA PRADESH
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Institution Postal Code
534007
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
Attorney
Preparer Email
pbradshaw@constangy.com
Employer Information Declaration Name
Cheryl Williams
Employer Information Declaration Title
Asst General Counsel, Legal Regulatory Affairs