All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-21288-59202
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-21288-59202
Case Status
Certified
Received Date
2021-11-29
Decision Date
2022-05-20
Refile
N
Original File Date
2022-01-01 11:31:03
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
MEDICAL MANAGEMENT INTERNATIONAL, INC.
Employer Name Slug
medical-management-international-inc
Employer Address 1
DBA BANFIELD PET HOSPITAL
Employer Address 2
18101 SE 6TH WAY
Employer City
VANCOUVER
Employer City Slug
vancouver
Employer State
WASHINGTON
Employer State Slug
washington
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
98683
Employer Phone
360-784-5000
Employer Number of Employees
19000
Employer Year Commenced Business
1994
NAICS Code
541940
FW Ownership Interest
N
Employer Contact Name
Justine W Pillar
Employer Contact Address 1
18101 SE 6th Way
Employer Contact Address 2
Employer Contact City
Vancouver
Employer Contact State/Province
WASHINGTON
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
98683
Employer Contact Phone
360-784-5092
Employer Contact Email
justine.pillar@banfield.com
Agent Attorney Name
Melina C LaMorticella
Agent Attorney Firm Name
Tonkon Torp LLP
Agent Attorney Phone
5038022122
Agent Attorney Address 1
1600 Pioneer Tower
Agent Attorney Address 2
888 SW Fifth Ave.
Agent Attorney City
PORTLAND
Agent Attorney State/Province
OREGON
Agent Attorney Country
UNITED STATES OF AMERICA
Agent Attorney Postal Code
97204
Agent Attorney Email
melina.lamorticella@tonkon.com
PW Track Number
P10020275854654
PW SOC Code
15-1199
PW SOC Title
Database Architects
PW Skill Level
Level IV
PW Wage
103043.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-04-20
PW Expiration Date
2021-07-19
Wage Offer From
139100.87
Wage Offer To
0.00
Average Salary
139100.87
Wage Unit of Pay
Year
Worksite Address 1
18101 Southeast 6th Way
Worksite Address 2
Worksite City
Vancouver
Worksite City Slug
vancouver
Worksite State
WASHINGTON
Worksite Postal Code
98683
Job Title
Senior Database Administrator - SQL
Job Title Slug
senior-database-administrator-sql
Minimum Education
Bachelor's
Major Field of Study
Computer Science, Computer Information Systems, or closely related field
Required Training
N
Required Experience
N
Required Experience Months
Accept Alternative Field of Study
N
Accept Alternative Major Field of Study
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
SQL Server Administrator, Senior Database Administrator, Computer Systems Analyst or similar positio
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
5 years experiencebr 1. Working with SQL Server performance and troubleshooting, including installation, backup and restoration of databasesbr 2. Implementing Disaster Recovery and High Availability of SQL Server using Failover cluster, Log shipping, Mirroring, Always On and Replicationbr 3. Implementing Data Encryption, Transport Layer Security, Rolebased access management on SQL Server, data encryption and data obfuscationbr 4. Managing database solution in source control and configuring it for CICD in Lab Environmentbr 5. Developing Extract, Transform and Load ETL solutions for data using SSIS and BCP for incremental and one time loadbr 6. Working in team setting using waterfallagile methodology of development, analyzing requirements, and designingbr database solutions using the principal of normalizationdenormalizationbr 7. Working with tables, stored procedures, functions, ClusteredNonClusteredXmlcolumn store indexes, triggers,br xml, json, queue, routes, remote service bindings, message contract, messages, management studio, SQL Profiler,br Extended events, SQL Agent Jobs, Configuration management, Failover Cluster, Always On Availability, DBCC,br Protocols configuration, certificate based authentication, CLR, Isolation levels, Recovery Model, Transactions,br MSDTC, Distributed transactions, data types, temp tables, cursor, Common Table Expression, JOINs.br 3 years experiencebr 1. Working with cloud databases.br br br All experience, skills and requirements may be gained concurrently.br br Applicants will be asked to submit to a background check as a condition of employment.br br H.4B.MAJORS COMPUTER SCIENCE, COMPUTER INFORMATION SYSTEMS, OR CLOSELY RELATED FIELD FOREIGN EQUIVALENT ACCEPTED.br br H.10B.OCCUPATION SQL SERVER ADMINISTRATOR, SENIOR DATABASE ADMINISTRATOR, COMPUTER SYSTEMS ANALYST, OR SIMILAR POSITION.br br THE 60 MONTHS EXPERIENCE LISTED IN H.10A MUST BE PROGRESSIVE AND BE GAINED AFTER BACHELORS DEGREE.br br BUSINESS NECESSITY DOCUMENTATION CAN BE PROVIDED TO ESTABLISH THAT THE JOB DUTIES AND REQUIREMENTS BEAR A REASONABLE RELATIONSHIP TO THE OCCUPATION IN THE CONTEXT OF THE EMPLOYERS BUSINESS AND ARE ESSENTIAL TO PERFORM THE JOB IN A REASONABLE MANNER.
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-07-14
SWA Job Order End Date
2021-08-17
Sunday Edition Newspaper
Y
First Newspaper Name
The Oregonian
First Advertisement Start Date
2021-07-18
Second Newspaper Ad Name
The Oregonian
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-07-25
Employer Website From Date
2022-01-01 11:31:03
Employer Website To Date
2022-01-01 11:31:03
Professional Organization Ad From Date
2022-01-01 11:31:03
Professional Organization Advertisement To Date
2022-01-01 11:31:03
Job Search Website From Date
2021-07-18
Job Search Website To Date
2021-07-20
Employee Referral Program From Date
2022-01-01 11:31:03
Employee Referral Program To Date
2022-01-01 11:31:03
Local Ethnic Paper From Date
2021-07-21
Local Ethnic Paper To Date
2021-07-27
Radio/TV Ad From Date
2022-01-01 11:31:03
Radio/TV Ad To Date
2022-01-01 11:31:03
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
CANADA
Foreign Worker Birth Country
CHINA
Class of Admission
H-1B
Foreign Worker Education
Bachelor's
Foreign Worker Information: Major
CIVIL ENGINEERING AND COMPUTER INFORMATION SYSTEMS
Foreign Worker Years of Education Completed
1999
Foreign Worker Institution of Education
DALIAN UNIVERSITY OF TECHNOLOGY
Foreign Worker Education Institution Address 1
#2 LINGGONGLU ROAD
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
DALIAN
Foreign Worker Education Institution State/Province
LIAONING
Foreign Worker Education Institution Country
CHINA
Foreign Worker Education Institution Postal Code
116024
Foreign Worker Experience with Employer
N
Foreign Worker Employer Pays for Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
Melina C LaMorticella
Preparer Title
Attorney
Preparer Email
melina.lamorticella@tonkon.com
Employer Information Declaration Name
Justine W Pillar
Employer Information Declaration Title
Mobility Immigration Program Manager