CAPGEMINI AMERICA, INC.

Senior Consultant (Database Services 040)

A-22306-50591 H-1B 2023 Withdrawn

Salary

$76,045

Visa Type

H-1B

Job Title

Senior Consultant (Database Services 040)

Employee's Citizenship

INDIA

Graduate School

UNIVERSITY OF KALYANI

Case info Company Info HR Info Attorney Position Info Employee Info

Case info

9 fields

Data Publish Year 2023

Case Number A-22306-50591

Case Status Withdrawn

Received Date 2022-11-30

Decision Date 2023-03-02

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 CAPGEMINI AMERICA, INC.

Employer Address_Line 1 333 W. WACKER DRIVE

Employer Address_Line 2 SUITE 300

Employer City CHICAGO

State -

Employer State/ Province ILLINOIS

Employer Country UNITED STATES OF AMERICA

Employer Postal Code 60606

Employer Phone No. 312-395-5000

Employer Phone Extent No. -

Total Number of Employees 19000

Employer Year of Commenced 1984

NAICS Code 541512

Foreign Worker Ownership & Interest N

HR Info

9 fields

Employer Contact Name Jean Taylor

Employer Contact Address Line1 333 W. Wacker Drive

Employer Contact Address Line2 Suite 300

Employer Contact City Chicago

Employer Contact State/ Provice ILLINOIS

Employer Contact Country UNITED STATES OF AMERICA

Employer Contact Post Code 60606

Employer Contact Phone 312-395-5000

Employer Contact Email iasimmigration.nar@capgemini.com

Attorney

11 fields

Agent/ Attorney Name Hugo P Rojas

Agent/ Attorney Firm Name Berry Appleman Leiden LLP

Agent/ Attorney Phone 4699407765

Agent/ Attorney Phone Ext. -

Agent/ Attorney Address Line 1 1 S Wacker Drive

Agent/ Attorney Address Line 2 Suite 550

Agent/ Attorney City Chicago

Agent/ Attorney State/ Province ILLINOIS

Agent/ Attorney Country UNITED STATES OF AMERICA

Agent/ Attorney Postal Code 60606

Agent/ Attorney Email hurojas@bal.com

Position Info

89 fields

Prevailing Wage Track Number P10021173419237

Prevailing Wage SOC Code 15-1199

Prevailing Wage SOC Title Database Architects

Prevailing Wage Skill Level Level II

Prevailing Wage 76045

Prevailing Wage Unit of Pay Year

Prevailing Wage Source OES

Prevailing Wage Other Source -

Prevailing Wage Determination Date 2022-02-24

Prevailing Wage Expiration Date 2022-06-30

Wage Offer From 76045

Wage Offer To 98700

Wage Offer Unit of Pay Year

Workstie Address Line 1 333 West Wacker Drive, Suite 300

Worksite Address Line 2 and various, unanticipated locations throughout the U.S.

Worksite City Chicago

Worksite State ILLINOIS

Worksite Postal Code 60606

Job Title Senior Consultant (Database Services 040)

Minimum Education Bachelor's

Other Degree/ Diploma -

Major Field of Study See H.14

Required Training N

Required Training Month -

Required Field of Training -

Required Experience Y

Required Expreience Months 36

Accept Alternate Field of Study Y

Accept Alternate Major See H.14

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 36

Accept Alternate Job Title See H.14

Normal Requirements of Job Opportunity N

Required Foreign Language N

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

24 fields

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

Employer Declaration Title Immigration Manager