Share this Job

Oracle Database Administrator III

Date: Sep 23, 2022

Location: PHOENIX, AZ, US, 85004-3903

Company: APS

Arizona Public Service generates clean, reliable and affordable energy for 2.7 million Arizonans. Our service territory stretches across the state, from the border town of Douglas to the vistas of the Grand Canyon, from the solar fields of Gila Bend to the ponderosa pines of Payson. As the state’s largest and longest-serving energy provider, our more than 6,000 dedicated employees power our vision of creating a sustainable energy future for Arizona.

 

Since our founding in 1886, APS has demonstrated a strong commitment to our customers in one of the country’s fastest growing states, earning a reputation for customer satisfaction, shareholder value, operational excellence and business integrity.

 

Our present and future success depends on the creative and dedicated people of our company who demonstrate the principles outlined in the APS Promise: Design for Tomorrow, Empower Each Other and Succeed Together.  

Summary

The Database Administrator III for Oracle creates, maintains, and improves databases in a complex, distributed server environment. Ensures database design is effective, secure and reliable in order to meet APS's needs

Minimum Requirements

  • Bachelors' degree in Information Technology or related field
  • PLUS 5 years of prior relevant experience or equivalent combination of education and directly related experience supporting Oracle RDBMS systems and tools
  • Requires strong technical knowledge within a job area or system and basic knowledge across related technical areas


Preferred Special Skills, Knowledge or Qualifications

  • Knowledge of physical data models, technical architecture, system interfaces, etc. for Oracle RDMBS

  • Fluent in performance tuning, backup/recovery procedures, troubleshooting, and high availability implementation

  • Fluent with Linux commands and utilities, RAC implementation, SQL languages, OEM setup/config, Dataguard

  • Ability to develop and write technical documentation; model, design and  deploy relational databases.

  • Proficient in install and supporting relational database management systems (RDMS); demonstrated continuous ability to improve operations and streamline work processes.

Major Accountabilities

1) Reviews, evaluates, designs, implements, and maintains company Oracle relational database management systems
2) Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process
3) Translates user's needs into a sound database design with tables, fields, and relationships documented
4) Installs, monitors, and directs proactive and reactive measures to ensure the availability, integrity, confidentiality and reliability of database systems
5) Assists in developing purge/archive criteria and procedures for historical application data on a relation model database environment
6) Implements and reviews appropriate security guidelines/mechanisms
7) Develops and tests database migration procedures
8) Maintains documentation for system architecture reference purposes
9) Develops database administration tools/utilities/operation procedures
10) May provide guidance and assistance to other employees

Export Compliance / EEO Statement


This position may require access to and/or use of information subject to control under the Department of Energy's Part 810 Regulations (10 CFR Part 810), the Export Administration Regulations (EAR) (15 CFR Parts 730 through 774), or the International Traffic in Arms Regulations (ITAR) (22 CFR Chapter I, Subchapter M Part 120) (collectively, 'U.S. Export Control Laws'). Therefore, some positions may require applicants to be a U.S. person, which is defined as a U.S. Citizen, a U.S. Lawful Permanent Resident (i.e. 'Green Card Holder'), a Political Asylee, or a Refugee under the U.S. Export Control Laws. All applicants will be required to confirm their U.S. person or non-US person status. All information collected in this regard will only be used to ensure compliance with U.S. Export Control Laws, and will be used in full compliance with all applicable laws prohibiting discrimination on the basis of national origin and other factors. For positions at Palo Verde Nuclear Generating Stations (PVNGS) all openings will require applicants to be a U.S. person.

Pinnacle West Capital Corporation and its subsidiaries and affiliates ('Pinnacle West') maintain a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, recruiting, hiring, promoting, compensating, reassigning, demoting, transferring, laying off, recalling, terminating employment, and training for all positions without regard to race, color, religion, disability, age, national origin, gender, gender identity, sexual orientation, marital status, protected veteran status, or any other classification or characteristic protected by law.

For more information on applicable equal employment regulations, please refer to EEO is the Law poster. Federal law requires all employers to verify the identity and employment eligibility of every person hired to work in the United States, refer to E-Verify poster. View the employee rights and responsibilities under the Family and Medical Leave Act (FMLA).

Arizona Public Service is a smoke free workplace.

 

Flex Role:
This position is not required to be performed at a specific APS facility as long as adequate technology and a solid ergonomic set up are present. Pending agreement with leadership, employees hired into this role will be able to choose where they prefer to perform their work. Employees will have two options to choose from: 

  • APS office based: The employee prefers to work most of the time from an APS facility.
  • Home based: The employee prefers to work most of the time from his/her home.

 

*Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need. 


Job Segment: Sustainability, Nuclear, Energy