Specific Skills:Employer will accept Bachelors degree in Computer Science, Engineering, Business, or related field; and three years of work experience in job offered or three years of work experience in a related occupation. Experience must include one year of experience with each of the followingbr 1. Code review and performance analysis for SQL code;br 2. Tuning SQL queries for better performance using Indexes, hints, SQL profiles, SQL baselines, SQL Plan management, and SQL Tuning advisor;br 3. Monitoring performance of databases;br 4. Working with AWR, ASH, and ADDM reports to identify poor performing SQLs and tune them;br 5. Rewriting complex SQLs and locking the execution plan for poor performing queries;br 6. Working with Golden gate replication between two databases using DDL and DML replication;br 7. Checking user access, roles, auditing for different users and objects;br 8. Supporting database migrations, upgrades, and patching;br 9. Supporting RAC databases and Stand by databases using data guard;br 10. Working with data pump exportimport logical backup, guaranteed restored points using RMAN backup;br 11. Maintaining production database;br 12. Designing new structures procedures views functions for development and data migration; andbr 13. Writing LinuxUnix shell scripting.br Must be available to work on projects at various, unanticipated sites throughout the United States.
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-06-08
Job Oder End Date:2022-07-13
Sunday Edition Newspaper:Y
First Newspaper Name:Chicago Tribune
First Advertisement Start Date:2022-06-26
Second Newspaper Name:Chicago Tribune
Second Advertisement Type:Newspaper
Second Ad Start Date:2022-07-03
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2022-06-06
Employer Website to Date:2022-07-15
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2022-06-06
Job Search Website to Date:2022-06-22
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:2022-06-29
Local Ethnic Newspaper to Date:2022-06-29
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:Y
Country of Citizenship:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRONIC ENGINEERING
Year of Compelted Education:2004
Foreign Worker Istitution of Eduation:UNIVERSITY OF KALYANI
Foreign Worker Education Instution Address Line 1:UNIVERSITY OF KALYANI, BLOCK C, NADIA
Foreign Worker Education Institution Address Line 2:
Foreign Worker Education Institution City:KALYANI
Foreign Worker Educatution Institution State: WEST BENGAL
Foreign Worker Education Institution Country :INDIA
Foreign Worker Education Training Post Code:741235
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :N
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:Hugo P Rojas
Preparer Title:Sr. Associate Immigration Attorney
Preparer Email :hurojas@bal.com
Employer Information Declaration Name:Jared Knotts