All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21334-79277
Fiscal year: 2023
Fiscal Year
2023
Case Number
A-21334-79277
Case Status
Certified
Received Date
2021-12-19
Decision Date
2022-12-16
Refile
N
Original File Date
2023-01-01 18:00:36
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
TEXAS AM UNIVERSITY
Employer Name Slug
texas-am-university
Employer Address 1
IMMIGRATION SERVICES FOR FACULTY SCHOLARS
Employer Address 2
1158 TAMU
Employer City
COLLEGE STATION
Employer City Slug
college-station
Employer State
TEXAS
Employer State Slug
texas
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
77843
Employer Phone
979-862-1719
Employer Number of Employees
15187
Employer Year Commenced Business
1876
NAICS Code
611310
FW Ownership Interest
N
Employer Contact Name
Erin R Pope
Employer Contact Address 1
Immigration Services for Faculty Scholars
Employer Contact Address 2
1158 TAMU
Employer Contact City
College Station
Employer Contact State/Province
TEXAS
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
77843
Employer Contact Phone
979-862-1719
Employer Contact Email
isfs@tamu.edu
Agent Attorney Name
Cindy Ansbach
Agent Attorney Firm Name
JMA Firm, PLLC
Agent Attorney Phone
9725216650
Agent Attorney Address 1
12655 North Central Expressway
Agent Attorney Address 2
Ste 275
Agent Attorney City
Dallas
Agent Attorney State/Province
TEXAS
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
75243
Agent Attorney Email
cindy@agfirm.net
PW Track Number
P10021176427499
PW SOC Code
15-1141
PW SOC Title
Database Administrators
PW Skill Level
Level IV
PW Wage
99070.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-11-30
PW Expiration Date
2022-06-30
Wage Offer From
99070.00
Wage Offer To
0.00
Average Salary
99070.00
Wage Unit of Pay
Year
Worksite Address 1
400 Harvey Mitchell Parkway S.
Worksite Address 2
Worksite City
College Station
Worksite City Slug
college-station
Worksite State
TEXAS
Worksite Postal Code
77845
Job Title
Database Administrator III
Job Title Slug
database-administrator-iii
Minimum Education
Bachelor's
Major Field of Study
Computer Science
Required Training
N
Required Experience
Y
Required Experience Months
60
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
COMPUTER ENGINEERING, INFORMATION SYSTEMS, OR RELATED FIELD.
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
60
Accept Alternative Job Title
DATABASE ADMINISTRATOR, OR RELATED.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Requires Bachelors degree in Computer Science, Computer Engineering, Information Systems, or related field plus five years of experience in job offered or five years experience in related occupation. Requires five years experience in database architecture and administration; Oracle RAC, Oracle Data Guard, Oracle RMAN Recovery Manager, Oracle Fusion Middleware or Weblogic and Oracle Enterprise Manager OEM, Cloning Techniques, Patching Grid RUPSU, UNIX based OS, Disaster recovery, OJVM database patching, Capacity Planning, Auditing and Security, Performance Tuning, and PLSQL. Also requires three years experience in Ellucian Banner, DevOPS IT Automation tools, and Cloud Migration. Requires ability to multi task and work cooperatively with others. Experience may be gained concurrently. Employer will accept any suitable combination of education, training or experience.br All positions are securitysensitive. Applicants are subject to criminal history investigation, and employment is contingent upon the institutions verification of credentials andor other information required by the institutions procedures, including the completion of the criminal history check.br br BUSINESS NECESSITY The position requires the above listed academic qualifications and work experience in order for the Database Administrator III to be capable of performing the subject job duties detailed above in a normally accepted manner. The nature of the position requires providing advanced capabilities in solving complex businessuniversity problems and creating solutions for the core areas. Understanding the process and problemsolving techniques for processes as well as using the latest information technology are key to the offered position. The subject position is not a runofthe mill or even entry level position. Rather, this position requires multifaceted and complex job duties that involve coordinating projects, taking responsibility for projects, and communicating with senior management and other departments both formally and informally to ensure that their needs and requirements are met. Such position requires the above preparation and related skills which cannot be obtained during a reasonable period of onthejob training.br br NO FAMILIAL RELATIONSHIPS Please note that there are no familial relationships between parties with ownership interests in the sponsoring organization and the foreign worker, and there is no investment in the sponsoring employer by the foreign worker. Accordingly, the foreign worker does not have an ownership interest in the sponsoring organization, and there is no familial relationship between the stockholders, officers, incorporators or board members and the foreign worker. Further, the foreign worker is not one of a small number of employees. As such, the subject position is a bona fide job opportunity available to all U.S. workers.br br NO LAYOFF The employer has NOT had layoff in area of intended employment in the subject or related occupation within the six months immediately preceding the filing of this application.
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
2021-06-29
SWA Job Order End Date
2021-08-06
Sunday Edition Newspaper
Y
First Newspaper Name
The Eagle
First Advertisement Start Date
2021-07-18
Second Newspaper Ad Name
The Eagle
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-07-25
Employer Website From Date
2021-06-25
Employer Website To Date
2021-09-07
Professional Organization Ad From Date
2023-01-01 18:00:36
Professional Organization Advertisement To Date
2023-01-01 18:00:36
Job Search Website From Date
2021-07-18
Job Search Website To Date
2021-07-31
Employee Referral Program From Date
2023-01-01 18:00:36
Employee Referral Program To Date
2023-01-01 18:00:36
Local Ethnic Paper From Date
2023-01-01 18:00:36
Local Ethnic Paper To Date
2023-01-01 18:00:36
Radio/TV Ad From Date
2021-07-17
Radio/TV Ad To Date
2021-07-18
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 ENGINEERING
Foreign Worker Years of Education Completed
2012
Foreign Worker Institution of Education
UNIVERSITY OF NORTH TEXAS
Foreign Worker Education Institution Address 1
1155 UNION CIR
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
DENTON
Foreign Worker Education Institution State/Province
TX
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
76203
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Cindy K Ansbach
Preparer Title
Attorney
Preparer Email
cindy@agfirm.net
Employer Information Declaration Name
Erin Pope
Employer Information Declaration Title
Assistant Director