Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:TRANSCORE, LP
Employer Address_Line 1:150 4TH AVENUE NORTH
Employer Address_Line 2:SUITE 1200
Employer City :NASHVILLE
State:
Employer State/ Province:TENNESSEE
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:37219
Employer Phone No.:615-988-9974
Employer Phone Extent No.:
Total Number of Employees:1147
Employer Year of Commenced :
NAICS Code:541330
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:James W Ott
Employer Contact Address Line1:150 4th Avenue North, Suite 1200
Employer Contact Address Line2:
Employer Contact City:Nashville
Employer Contact State/ Provice:TENNESSEE
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:37219
Employer Contact Phone:615-988-9974
Employer Contact Email:james.ott@transcore.com
Attorney
Agent/ Attorney Name:Michelle A White
Agent/ Attorney Firm Name:Littler Mendelson, P.C.
Agent/ Attorney Phone:3054007549
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:Wells Fargo Center, 333 SE 2nd Avenue
Agent/ Attorney Address Line 2:Suite 2700
Agent/ Attorney City:Miami
Agent/ Attorney State/ Province:FLORIDA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:33131
Agent/ Attorney Email:MAWhite@littler.com
Position Info
Prevailing Wage Track Number:P10020351963350
Prevailing Wage SOC Code :15-1141
Prevailing Wage SOC Title :SQL Server Database AdministratorDeveloper
Prevailing Wage Skill Level:Level III
Prevailing Wage:87402
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-04-28
Prevailing Wage Expiration Date :2021-07-27
Wage Offer From:87402
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:4415 Lewis Road
Worksite Address Line 2:
Worksite City :Harrisburg
Worksite State:PENNSYLVANIA
Worksite Postal Code:17111
Job Title:SQL Server Database Administrator/Developer
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:Mechanical Engineering
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :Y
Required Expreience Months :48
Accept Alternate Field of Study:Y
Accept Alternate Major:Computer Science, Computer Engineering or related
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:48
Accept Alternate Job Title:Database Administrator, SQL Server DBA, or related
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:EDUCATION EXPERIENCE BACHELORS DEGREE OR HIGHER IN MECHANICAL ENGINEERING,COMPUTER SCIENCE, COMPUTER ENGINEERING, INDUSTRIAL ENGINEERING, INFORMATION TECHNOLOGY OR A RELATED FIELD AND 4 YEARS OF EXPERIENCE AS A SQL SERVER DATABASE ADMINISTRATORDEVELOPER OR RELATED POSITION.br br SPECIFIC SKILLS OR OTHER REQUIREMENTSbr 4 YEARS OF PROFESSIONAL EXPERIENCE WITH MICROSOFT SQL SERVER TO OPTIMIZE AND TROUBLESHOOT DATABASE SECURITY ISSUES, PERFORMANCE ISSUES, CONNECTIVITY ISSUES, INTEGRITY ISSUES, BLOCKING AND DEADLOCKING ISSUES, CPU, MEMORY, IO AND DISK SPACE ISSUES USING SSMS, DBCC UTILITIES, DMVS AND DMFS, SQL PROFILER, EXECUTION PLANS, EXTENDED EVENTS, PERFMON AND DATACOLLECTOR TOOLS.br 4 YEARS OF PROFESSIONAL EXPERIENCE WITH DESIGNINGBUILDING DATABASE MODEL USING ERWIN, AND MAINTAINING LARGE DATABASES, EXPERIENCE WORKING WITH COMPLEX SYSTEMS, AND EXPERIENCE QUERYING AND ASSEMBLING VERY LARGE DATA SETS.br 4 YEARS OF PROFESSIONAL EXPERIENCE WITH TSQL PROGRAMMING SQL DEVELOPMENT WITH CREATING AND MAINTAINING COMPLEX SQL QUERIES, STORED PROCEDURES, FUNCTIONS, BCP UTILITY, DATA CLEANSING, SSRS, SSIS AND ETL PROCESS.br 4 YEARS OF PROFESSIONAL EXPERIENCE WITH ADMINISTRATION OF TEAM FOUNDATION SERVER,br VMWAREVSPHERE ENVIRONMENTS, MICROSOFT VISUAL STUDIO AND MAINTENANCE OF TDE ON DIFFERENT DATABASE SYSTEMS.br 4 YEARS OF PROFESSIONAL EXPERIENCE IN IMPLEMENTATION AND WORKING WITH HIGH AVAILABILITYbr TECHNIQUES AND DATA AVAILABILITY TECHNIQUES LIKE ALWAYSON, CLUSTERING, MIRRORING, ONLINE RESTORE AND PARTITIONING.br 4 YEARS OF PROFESSIONAL EXPERIENCE AND ABILITY TO DEVELOP SOFTWARE USING .NET FRAMEWORK C#, ASP.NET, VB.NET.br 4 YEARS OF EXPERIENCE WITH OPTIMIZATION CONCEPTS POTENTIALLY USING MATHEMATICAL MODELING.
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-06-18
Job Oder End Date:2021-07-21
Sunday Edition Newspaper:Y
First Newspaper Name:The Patriot News
First Advertisement Start Date:2021-06-20
Second Newspaper Name:The Patriot News
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-06-27
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-10-12
Employer Website to Date:2021-12-06
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-07-01
Job Search Website to Date:2021-07-16
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-06-25
Local Ethnic Newspaper to Date:2021-06-25
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:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:MECHANICAL ENGINEERING
Year of Compelted Education:2015
Foreign Worker Istitution of Eduation:OSMANIA UNIVERSITY
Foreign Worker Education Instution Address Line 1:OSMANIA UNIVERSITY MAIN RD, AMBERPET
Foreign Worker Education Institution Address Line 2:
