CGI TECHNOLOGIES AND SOLUTIONS INC.
Database Administrator
A-22207-94677
H-1B
2023
Certified
Salary
$120,100
Visa Type
H-1B
Job Title
Database Administrator
Employee's Citizenship
INDIA
Graduate School
TEXAS AM UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22207-94677
Case Status
Certified
Received Date
2022-08-13
Decision Date
2023-05-19
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
CGI TECHNOLOGIES AND SOLUTIONS INC.
Employer Address_Line 1
11325 RANDOM HILLS ROAD
Employer Address_Line 2
-
Employer City
FAIRFAX
State
-
Employer State/ Province
VIRGINIA
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
22030
Employer Phone No.
703-267-8000
Employer Phone Extent No.
-
Total Number of Employees
72500
Employer Year of Commenced
1976
NAICS Code
541512
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Josephine Fix
Employer Contact Address Line1
11325 RANDOM HILLS ROAD
Employer Contact Address Line2
-
Employer Contact City
FAIRFAX
Employer Contact State/ Provice
VIRGINIA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
22030
Employer Contact Phone
732-428-2390
Employer Contact Email
Immigration.US@cgi.com
Attorney
11 fields
Agent/ Attorney Name
Michael F Smith
Agent/ Attorney Firm Name
Fragomen, Del Rey, Bernsen Loewy, LLP
Agent/ Attorney Phone
2022235515
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
1101 15th Street, NW
Agent/ Attorney Address Line 2
Suite 700
Agent/ Attorney City
Washington
Agent/ Attorney State/ Province
DISTRICT OF COLUMBIA
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
20005
Agent/ Attorney Email
RecruitTeamPham@Fragomen.com
Position Info
89 fields
Prevailing Wage Track Number
P10021216502710
Prevailing Wage SOC Code
15-1141
Prevailing Wage SOC Title
Database Administrators
Prevailing Wage Skill Level
N/A
Prevailing Wage
120100
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
Other
Prevailing Wage Other Source
HRA of the NCA 2020 9/1/2020
Prevailing Wage Determination Date
2022-03-18
Prevailing Wage Expiration Date
2022-06-30
Wage Offer From
132000
Wage Offer To
-
Wage Offer Unit of Pay
Year
Workstie Address Line 1
11325 Random Hills Road
Worksite Address Line 2
Fulltime Telework Permitted
Worksite City
Fairfax
Worksite State
VIRGINIA
Worksite Postal Code
22030
Job Title
Database Administrator
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Computer Science, Engineering, Information Systems, IT or a related field
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
N
Required Alternate Level of Education
-
Other Alternate Level of Education
-
Acceptable Years of Experience
-
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
84
Accept Alternate Job Title
See H.14
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
Bachelors degree in Computer Science, Engineering, Information Systems, IT or a related field and 7 years of database administration experience with MSSQL Server 20122014 or newer. Prior experience must include 7 years implementing High Availability and Disaster recovery; 7 years of experience with database migrations inplace or SidebySide; 7 years of experience with SSIS; 7 years of experience in SQL Performance Tuning and Troubleshooting; 5 years working with Metastorm v7 or higher application databases on MS SQL; 5 years of experience in Microsoft AZURE; 5 years working with Shell Scripts; 5 years writing Dynamic Management Views and Functions; 5 years working with SSRS and Business Intelligence; 5 years of experience in natural disaster recovery grant distribution or public assistance domain; 5 years working with SQL Client Configuration utility, Replication Tools, HeidiSQL, DBArtisan, SQL Safe, Idera Defrag Manager, Red Gate SQL Compare, Data Compare, Spotlight for SQL Server, NetBackup appliance, CommVault, and DataVault; 5 years of experience with Network and Windows OS; 3 years working on Master Data Services and Data Quality Services; 3 years working with Oracle 12c or higher; and 3 years of experience providing 24x7 operational support for SQL Server critical applications. SQL Server Database Administration Certification required. Fulltime telework permitted.br br All offers of employment are contingent upon the successful completion of a background check, which may also include a drug screen depending on work assignment.br br F.6A Full Survey Name Human Resource Association of the National Capital Area 2020 912020br br J.12. Praveen Kumar Koyalkar attained a Master of Science degree in Computer Science from Texas AM University in 2008. Praveen Kumar Koyalkar also earned a Bachelor of Technology degree in Computer Science Engineering from Jawaharlal Nehru Technological University in India in 2006.
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-05-16
Job Oder End Date
2022-06-20
Sunday Edition Newspaper
Y
First Newspaper Name
The Washington Post
First Advertisement Start Date
2022-06-19
Second Newspaper Name
The Washington Post
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-06-26
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
-
Employer Website to Date
-
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-06-22
Job Search Website to Date
2022-06-28
Private Employment Firm from Date
-
Pricate Employment Firm to Date
-
Employee Referral Program from Date
2022-05-27
Employee Referral Program to Date
2022-06-14
Campus Placement from Date
-
Campus Placement to Date
-
Local Ethnic Newspaper from Date
2022-06-22
Local Ethnic Newspaper to Date
2022-06-22
Radio/TV Ad from Date
-
Radio/TV Ad to Date
-
Employer Received the Payment
N
Payment Details
-
Bargaining Representative Notified
N/A
Posted Notice at Worksite
Y
Layoff in Past Six Months
Y
US Worker Considered
N/A
Country of Citizenship
INDIA
Foreign Worker Birth Country
INDIA
Class of Admission
H-1B
Employee Info
24 fields
Foreign Worker Education
Master's
Foreign Worker Education Other
-
Foreign Worker Major
COMPUTER SCIENCE
Year of Compelted Education
2008
Foreign Worker Istitution of Eduation
TEXAS AM UNIVERSITY
Foreign Worker Education Instution Address Line 1
2200 CAMPBELL STREET
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
COMMERCE
Foreign Worker Educatution Institution State
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code
75428
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N/A
Foreign Worker Alternate Education and Experience
N/A
Foreign Worker Alternate Occupation Experience
Y
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pay for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Michael F Smith
Preparer Title
Of Counsel
Preparer Email
RecruitTeamPham@fragomen.com
Employer Information Declaration Name
Josephine Fix
Employer Declaration Title
Manager, U.S. Immigration Member Services