FMR LLC
Principal Database Administrator
A-22229-07107
H-1B
2023
Certified
Salary
$110,770
Visa Type
H-1B
Job Title
Principal Database Administrator
Employee's Citizenship
INDIA
Graduate School
SRI KRISHNADEVARAYA UNIVERSITY
Case info
9 fields
Data Publish Year
2023
Case Number
A-22229-07107
Case Status
Certified
Received Date
2022-09-20
Decision Date
2023-07-05
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
FMR LLC
Employer Address_Line 1
245 SUMMER STREET
Employer Address_Line 2
-
Employer City
BOSTON
State
-
Employer State/ Province
MASSACHUSETTS
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
2210
Employer Phone No.
617-563-6780
Employer Phone Extent No.
-
Total Number of Employees
52000
Employer Year of Commenced
1946
NAICS Code
52399
Foreign Worker Ownership & Interest
N
HR Info
9 fields
Employer Contact Name
Christina Jackson
Employer Contact Address Line1
100 New Millennium Way
Employer Contact Address Line2
-
Employer Contact City
Durham
Employer Contact State/ Provice
NORTH CAROLINA
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Post Code
27709
Employer Contact Phone
(800) 835-5099
Employer Contact Email
christina.jackson@fmr.com
Attorney
11 fields
Agent/ Attorney Name
Russell B Swapp
Agent/ Attorney Firm Name
Seyfarth Shaw LLP
Agent/ Attorney Phone
(617) 946-4905
Agent/ Attorney Phone Ext.
-
Agent/ Attorney Address Line 1
2 Seaport Lane Seaport East
Agent/ Attorney Address Line 2
Suite 1200
Agent/ Attorney City
Boston
Agent/ Attorney State/ Province
MASSACHUSETTS
Agent/ Attorney Country
UNITED STATES OF AMERICA
Agent/ Attorney Postal Code
2210
Agent/ Attorney Email
dlsmith@seyfarth.com
Position Info
89 fields
Prevailing Wage Track Number
P10021281633479
Prevailing Wage SOC Code
15-1141
Prevailing Wage SOC Title
Database Administrators
Prevailing Wage Skill Level
N/A
Prevailing Wage
110770
Prevailing Wage Unit of Pay
Year
Prevailing Wage Source
Other
Prevailing Wage Other Source
Willis Towers Watson: General [CONT'D IN H.14]
Prevailing Wage Determination Date
2022-04-13
Prevailing Wage Expiration Date
2022-07-12
Wage Offer From
110770
Wage Offer To
142000
Wage Offer Unit of Pay
Year
Workstie Address Line 1
12 Destiny Way
Worksite Address Line 2
-
Worksite City
Westlake
Worksite State
TEXAS
Worksite Postal Code
76262
Job Title
Principal Database Administrator
Minimum Education
Bachelor's
Other Degree/ Diploma
-
Major Field of Study
Computer Science, Engineering, Information Technology
Required Training
N
Required Training Month
-
Required Field of Training
-
Required Experience
N
Required Expreience Months
-
Accept Alternate Field of Study
Y
Accept Alternate Major
Information Systems, Mathematics, Accounting, or a closely related field
Alternate Combination of Education/ Experience
Y
Required Alternate Level of Education
Master's
Other Alternate Level of Education
-
Acceptable Years of Experience
3
Accept Foreign Educationa
Y
Acceptable Alternate Occupation
Y
Acceptable Alternate Occupation Month
60
Accept Alternate Job Title
Job offered or supporting Oracle EBS databases in a financial services environment.
Normal Requirements of Job Opportunity
N
Required Foreign Language
N
Specific Skills
CONTD FROM F.6A Industry Middle Management, Professional, and Support Compensation Survey 9132021br br Education and Experiencebr br Bachelors degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Accounting, or a closely related field and five 5 years of experience in the job offered or five 5 years of experience supporting Oracle EBS databases in a financial services environment.br br Or, alternatively, Masters degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Accounting, or a closely related field and three 3 years of experience in the job offered or three 3 years of experience supporting Oracle EBS databases in a financial services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE performing Oracle RAC database administration capacity planning, indexing, partitioning, archiving, and compression, and designing and implementing enhanced database monitoring and alerting solutions using Linux Shell scripting, Oracle PLSQL programs, and Oracle Enterprise manager scheduler;br br DE developing, installing, and managing Oracle replication technologies Oracle GoldenGate and Oracle Data Guard; performing infrastructure development on Amazon Web Services AWS; migrating databases from onpremise to AWS Cloud using DMS; and configuring, enabling, and administering NiFi data ingestion services, Service Oriented Architecture SOA, Web Center Interaction WCI, and Hyperion Financial Management HFM;br br DE performing SQL performance tuning and optimization PTO, using Oracle Enterprise Manager Grid control OEM 12c and Linux shell scripting; writing database monitoring jobs in PLSQL; supporting Collibra tool for governance; and implementing Guardium and CyberArk for critical onpremise and AWS databases for privileges access management and auditing;br br DE performing Oracle EBusiness suite application administration, using Oracle Applications DBA Oracle AD Utilities, ADOP, Patchwizad tools, and Shell scripting; performing database administration upgrading, cloning, and configuring Single Sign On SSO, performing Oracle EBusiness database upgrades to 11g, 12c, and 19c, and converting databases to multitenant using Oracle Applications DBA Oracle AD Utilities, ADOP, and Patchwizad tools; installing, configuring, upgrading, and managing an EBS suite of applications, and integrating the suite with Enterprise Command Centers ECC, More4Apps, Virtual Trader, Ping, and Noetix analytics tools and applications.
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-27
Job Oder End Date
2022-07-01
Sunday Edition Newspaper
Y
First Newspaper Name
The Dallas Morning News
First Advertisement Start Date
2022-06-12
Second Newspaper Name
The Dallas Morning News
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-06-19
Job Fair From Date
-
Job Fair to Date
-
On Campus Recruiting from Date
-
On Campus Recruiting to Date
-
Employer Website from Date
2022-05-27
Employer Website to Date
2022-07-02
Pro. Org. Ad from Date
-
Pro.Org. Ad to Date
-
Job Search Website from Date
2022-05-27
Job Search Website to Date
2022-06-13
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
-
Local Ethnic Newspaper to Date
-
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
24 fields
Foreign Worker Education
Bachelor's
Foreign Worker Education Other
-
Foreign Worker Major
ACCOUNTING
Year of Compelted Education
1990
Foreign Worker Istitution of Eduation
SRI KRISHNADEVARAYA UNIVERSITY
Foreign Worker Education Instution Address Line 1
JJ6X747
Foreign Worker Education Institution Address Line 2
-
Foreign Worker Education Institution City
ANANTAPURAM
Foreign Worker Educatution Institution State
ANDHRA PRADESH
Foreign Worker Education Institution Country
INDIA
Foreign Worker Education Training Post Code
515003
Foreign Worker Training Completion
N/A
Foreign Worker Required Experience
N/A
Foreign Worker Alternate Education and Experience
N
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
Russell B Swapp
Preparer Title
Attorney
Preparer Email
dlsmith@seyfarth.com
Employer Information Declaration Name
Christina Jackson
Employer Declaration Title
Senior Immigration Specialist