Database Administrator I - III

Are you a problem solver with a knack for handling complex server issues? Do you have the skills to balance priorities and pivot when necessary? If you're looking for a dynamic role that plays a critical part in managing and protecting essential data, TEP has the perfect opportunity for you!

What you will do:

• Plan, install, maintain, modify, and patch or upgrade database software, middleware, and associated toolsets for more than 500 databases.
• Recommend system architectures and participate in data access layer development.
• Participate in the integration, maintenance/conversion, capacity planning, and installation of databases for new applications.
• Develop scripts and programming to support automated database processes.
  
• This role is a hybrid position and requires in-office work every Tuesday and Wednesday at our Tucson, Arizona headquarters and other days as needed for business needs.

What you bring:

• Extensive experience with Oracle Database Appliance, SQL Server, MySQL
• Extensive experience with a major application provider such as PeopleSoft, Oracle EBP, or similar.
• Proficiency with programming in Unix and/or Windows.
• Project management experience.

 

*Full job description*

Position Description

Provide technical expertise in the design, implementation, and maintenance of relational database management systems (RDBMSs) and data integration systems that support corporate business applications at our UNS Energy companies. Responsible for the technical support of multiple database and middleware environments, from various vendors, that run company-wide business applications and which are accessed by multiple departments. Participate in a team environment that provides cost-effective IT data services to the various business units. Work closely with other areas of IT and the Project Management Office to create an efficient, fault tolerant environment for corporate data.

Position-Related Responsibilities

• Maintain development, test, and production RDBMS environments.
• Plan, install, maintain, modify, and patch or upgrade database software, middleware and associated toolsets.
• Maintain knowledge of state-of-the-art technology, equipment, and/or systems.
• Interact with vendor support to address and resolve issues.
• Recommend system architectures, participate in application data access layer development, configure databases, handle backup and recovery activities, monitor and tune systems, and produce reports. 
• Monitor and tune relational databases to optimize their performance, resource usage, and their physical implementations for multi-terabyte Business Intelligence systems including partitioning, bitmap indexing and materialized views; addresses a variety of database integration issues, including migration of data between disparate databases.
• Participate in the integration, maintenance/conversion, capacity planning, and installation of databases for new applications.
• Monitor, tune and maintain application servers and middleware to ensure efficient operation.
• Develop scripts and programming to support automated database support processes.
• Prepare, administer and copy or clone production databases to test systems.
• Collaborate with system administrators to execute failover, fallback, disaster recovery, and other procedures for high availability and system tuning.
• Monitor and maintain, in cooperation with data security administrators, database security and database security software.
• Perform data management tasks as required for extracting, loading, transforming, editing and restoring data.
• Prepare and present audits and reports for management.
• Maintain availability and integrity of databases through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management and data dictionary maintenance.
• Monitor and manage database usage by adding data files, extending tables, managing extents, performing reorganizations, etc.
• Evaluate and recommend testing processes and evaluate new procedures, software, and ha