Accept Alternate Job Title:offered or related position
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Must know through academic training or work experience Spotlight SolarWinds tool, ACTIVEPASSIVE Clustering, Mirroring, SQL developer TOAD for Oracle; installing and maintaining MS SQL Server 2017201620142012 on Windows 20162012 servers; SQL 2017, 2016, 2014, 2012 ActivePassive cluster environments for the production servers; SQL server 20052008 R2 refresh projects which are migrated to SQL server 2012 and SQL 2014 servers; deployment of SSIS packages and SSRS reports through SQL server data tools in SQL 2016, 2017 2019 environments; quarterly SQL server patching for 201720161412 versions; troubleshooting methods and resolving database performance and deadlocking issues; Oracle 19c DB and ASM administration; creating scripts and scheduling backups in cron for RMAN database backups and recoveries; using Oracle Data pump ExportsImports utility for moving data among the servers; creating and maintaining DB on OCI platform; and writingediting UNIX Shell Scripts.
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:2021-03-25
Job Oder End Date:2021-04-26
Sunday Edition Newspaper:Y
First Newspaper Name:Pittsburgh PostGazette
First Advertisement Start Date:2021-03-28
Second Newspaper Name:Pittsburgh PostGazette
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-04-04
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2020-11-27
Employer Website to Date:2021-05-13
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-03-23
Job Search Website to Date:2021-04-06
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:2021-03-31
Local Ethnic Newspaper to Date:2021-03-31
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:N
US Worker Considered:
Country of Citizenship:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRICAL ENGINEERING
Year of Compelted Education:2012
Foreign Worker Istitution of Eduation:NORTHWESTERN POLYTECHNIC UNIVERSITY
Foreign Worker Education Instution Address Line 1:47671 WESTINGHOUSE DR
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:FREMONT
Foreign Worker Educatution Institution State:CA
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:94539
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :Y
Foreign Worker Alternate Education and Experience :N/A
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:Ellen Freeman
Preparer Title:Managing Partner
Preparer Email :efreeman@freemanimmigration.com
Employer Information Declaration Name:Julie Spiker
