Fiscal Year

2022

Case Number

A-21012-41178

Case Status

Certified-Expired

Received Date

2021-02-18

Decision Date

2022-01-04

Refile

N

Original File Date

2022-01-01 10:42:00

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CITY OF SAN ANTONIO DBA CITY PUBLIC SERVICE BOARD

Employer Name Slug

city-of-san-antonio-dba-city-public-service-board

Employer Address 1

500 MCCULLOUGH AVENUE

Employer Address 2

Employer City

SAN ANTONIO

Employer City Slug

san-antonio

Employer State

TEXAS

Employer State Slug

texas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

78215

Employer Phone

210-353-2780

Employer Number of Employees

3100

Employer Year Commenced Business

1942

NAICS Code

926130

FW Ownership Interest

N

Employer Contact Name

Kipling D Giles

Employer Contact Address 1

500 McCullough Avenue

Employer Contact Address 2

Employer Contact City

San Antonio

Employer Contact State/Province

TEXAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

78215

Employer Contact Phone

210-353-3169

Employer Contact Email

KDGiles@CPSEnergy.com

Agent Attorney Name

Victoria M Garcia

Agent Attorney Firm Name

Bracewell LLP

Agent Attorney Phone

2102993546

Agent Attorney Address 1

300 Convent Street, Suite 2700

Agent Attorney Address 2

Agent Attorney City

San Antonio

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

78205

Agent Attorney Email

victoria.garcia@bracewell.com

PW Track Number

P10020240791378

PW SOC Code

15-1141

PW SOC Title

Database Administrators

PW Skill Level

Level IV

PW Wage

113901.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-02-02

PW Expiration Date

2021-06-30

Wage Offer From

113901.00

Wage Offer To

0.00

Average Salary

113901.00

Wage Unit of Pay

Year

Worksite Address 1

500 McCullough Avenue

Worksite Address 2

145 Navarro Street

Worksite City

San Antonio

Worksite City Slug

san-antonio

Worksite State

TEXAS

Worksite Postal Code

78215

Job Title

Administrator Database Oracle 3

Job Title Slug

administrator-database-oracle-3

Minimum Education

Bachelor's

Major Field of Study

Info Sys, Engineering, Computer Science or a related field

Required Training

N

Required Experience

Y

Required Experience Months

72

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

A related field

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

72

Accept Alternative Job Title

Database Admin General, Oracle Database Admin, Asst. Manager ITSMG, Oracle APPS DBA

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

The minimum requirements for the position of Administrator Database Oracle 3 are a Bachelors degree or higher, or foreign degree equivalent, in Information Systems, Engineering, Computer Science or related field and a minimum of six 6 years of experience in a Production Oracle ecosystem or higher education equivalent.br A minimum of four 4 years of experience with the followingbr o Hands on experience with Oracle database administration in UNIX and virtual environments.br o Skilled in performing detailed performance analysis and resource utilization of systems.br o Proficiency with Oracle backups, restores and recovery models.br o Hands on experience with High Availability HA and Disaster Recovery DR options for Oracle RACData Guard.br o Knowhow in migrating code and database changes through the various stages of the development life cycle.br o Skilled in troubleshooting and performance tuning skills with Oracle databases.br o Experience in project management concepts, tools MS Project and techniques.br o Hands on experience as technology subject matter expert for at least three versions of relational database management systems such as Oracle 9i, 10g, 11g, 12c, 18c and 19c.br o Installation, configuration and administration of Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.br o OEM Oracle Enterprise Manager troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.br o Skilled in using Recovery Manager RMAN and ASM Automatic Storage Management for backups and storage management.br Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.br Valid Class C Texas Drivers License.br Makes independent recommendations.br Proficient in Microsoft Office Package, including word processing, spreadsheets, presentation software, electronic mail and scheduling.br br Preferred Qualifications But Not Requiredbr br Masters degree in Information Systems or related field.br Oracle certifications are a plus. Examples include Oracle Autonomous database, Oracle Cloud Infrastructure, Oracle Certified Associate, Oracle Certified Professional.br Experience in administering, patching, upgrading Oracle databases based on SAP ERP applications.br Performed database tasks using BR Tools SAP related Oracle databases.br Experience with Hyperconverged infrastructure.br Utility Industry experience.br NERC North American Electric Reliability Corporation background and experience.

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

2020-08-24

SWA Job Order End Date

2020-09-23

Sunday Edition Newspaper

Y

First Newspaper Name

San Antonio Express News

First Advertisement Start Date

2020-08-30

Second Newspaper Ad Name

San Antonio Express News

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-09-06

Employer Website From Date

2020-09-08

Employer Website To Date

2020-10-09

Professional Organization Ad From Date

2022-01-01 10:42:00

Professional Organization Advertisement To Date

2022-01-01 10:42:00

Job Search Website From Date

2020-08-30

Job Search Website To Date

2020-09-29

Employee Referral Program From Date

2022-01-01 10:42:00

Employee Referral Program To Date

2022-01-01 10:42:00

Local Ethnic Paper From Date

2020-09-02

Local Ethnic Paper To Date

2020-09-02

Radio/TV Ad From Date

2020-08-31

Radio/TV Ad To Date

2020-08-31

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDIA

Foreign Worker Birth Country

INDIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2016

Foreign Worker Institution of Education

CALIFORNIA STATE UNIVERSITY FULLERTON

Foreign Worker Education Institution Address 1

800 N STATE COLLEGE BLVD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FULLERTON

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

92831

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Victoria M Garcia

Preparer Title

Attorney

Preparer Email

victoria.garcia@bracewell.com

Employer Information Declaration Name

Kipling D Giles

Employer Information Declaration Title

Director, Senior Counsel