Database Administrator I, II, III, Senior

About Us

UNS Energy Corporation , headquartered in Tucson, Arizona, is a subsidiary of Fortis Inc. , the largest investor-owned electric and gas distribution utility in Canada. Our public utility subsidiaries, Tucson Electric Power Company, UNS Electric, Inc. and UNS Gas, Inc., power our economy by providing electric and gas service to nearly 700,000 customers in Arizona.

We embrace a spirit of giving, dedicated to improving quality of life in the communities we have served for generations, and in TEP’s case, since the 1890s. We’re building a cleaner, greener grid, with more wind and solar power than ever before, while maintaining safe, reliable, and affordable service.

Your Employer of Choice

Our culture is rooted in shared core values that define how we work and who we are. Our team of innovative professionals bring their authentic selves to work each day to power our vision and make a difference.

We Create Opportunities For Employees To Thrive Through:

- Continual growth: In an industry changing faster than ever before, our commitment to professional growth and leadership development means we never stop challenging ourselves to explore new possibilities.

- Active Engagement: We support a collaborative environment, with peer-to-peer learning and employee-driven groups that foster an inclusive culture.

- Total compensation: UNS Energy Corporation also offers a competitive compensation and benefits package that includes a 401k plan with a generous company match and additional non-discretionary employer contribution for eligible employees, affordable individual and family health insurance plans, tuition assistance, life insurance, long-term disability insurance and much more.

Hear from some of our employees, here and here .

Job Description - Database Administrator I, II, III, Senior Role Overview: Oracle Database Appliance Specialist

- Install, configure, and maintain Oracle Database Appliance (ODA) systems, including hardware setup, Oracle Linux, and integrated components such as Oracle ILOM and Grid Infrastructure.

- Perform patching and upgrades for ODA bundles (BIOS, firmware, drivers, Oracle Appliance Manager, and RDBMS homes) to ensure system stability and compliance.

- Demonstrate proficiency in Linux system administration and networking fundamentals, including TCP/IP, VLANs, DNS, firewall rule configuration, and adherence to enterprise security standards for secure ODA environments.

- Show strong troubleshooting skills for complex hardware, software, and network issues, with the ability to coordinate with Oracle Support and apply best practices for high availability and security.

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 UniSource. 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, hardware 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 hardware.

- Perform database backups, monitor and manage database backup processes, logs, and journals; install, maintain, and upgrade database software; restore and/or recover data as required.

- Provide advice to applications programmers in the effective use of database access languages; advise on troubleshooting, exception processing needs, and other data management issues.

- Create and tune SQL code, PL/SQL, stored procedures and triggers.

- Assist developers with writing and tuning SQL queries.

- Create, procure and maintain various database related documents such as manuals and programmers handbooks.

- Create and maintain Unix shell scripts; particularly Korn shell scripts.

- Operate on a scheduled 24-hour on-call basis.

- Perform other job-related duties as assigned by management.

- Conform to corporate procedures and Information Services guidelines.

- Administratively report to a Group or Team Lead.

- This position may provide services to affiliates of the Company subject to the UNS Energy Code of Conduct and the related Policies and Procedures.

Knowledge, Skills & Abilities

(Equivalent combination of education and experience will be considered.)

Level I Minimum Qualifications

- High school diploma or GED.

- Working toward a Bachelor’s degree in Management Information Systems, Computer Science or related disciplines.

- Demonstrated ability to work both independently and as part of a team.

- Excellent communication skills, both verbal and written.

- Proficient in programming and SQL skills.

- UNIX and/or Windows Operating System experience required.

- Demonstrated project management experience is desirable.

- A minimum of 3 years of IT experience in the application development or system support field.

- 0 to 2 years of professional experience with Oracle and/or Microsoft SQL Server RDBMSs preferred.

Level II

Minimum Qualifications

- All the knowledge, skills and abilities of a Database Administrator I.

- Bachelor’s degree in Management Information Systems, Computer Science or related disciplines is required.

- Demonstrated ability to work with a scheduler such as UC4 and/or cron.

- Demonstrated project management experience is preferred.

- A minimum of 5 years of IT experience in the application development or system support field.

- A minimum of 4 years of professional experience with Oracle and/or Microsoft SQL Server RDBMSs is required.

- A minimum of 2 years of application database experience with a major (PeopleSoft, Oracle EBS, Storms, etc.) application provider is preferred.

Level III

Minimum Qualifications

- All the knowledge, skills and abilities of a Database Administrator II.

- Proficiency with Oracle and/or SQL Server Tools, Utilities, and Application Servers is preferred.

- Proficient in supporting Oracle Middleware is preferred

- Proficient in Data Modeling and Design is preferred.

- A minimum of 7 years of IT experience in the application development or system support field.

- A minimum of 6 years of professional experience with Oracle and/or Microsoft SQL Server RDBMSs is required.

- A minimum of 4 years of application database experience with a major application provider (PeopleSoft, Oracle EBS, etc.) is preferred.

Senior

Minimum Qualifications

- All the knowledge, skills and abilities of a Database Administrator III plus leadership abilities.

- Demonstrated leadership abilities.

- Demonstrated project management experience is required.

- Proficient in Oracle and/or SQL Server Tools and Utilities is required.

- Proficiency in supporting Oracle Middleware is required.

- Proficiency in Data Modeling and Design is required

- Strong interpersonal skills required to lead IS staff members and maintain effective relations with clients

- A minimum of 10 years of IT experience in the application development or system support field.

- A minimum of 9 years of professional experience with Oracle and/or Microsoft SQL Server RDBMSs is required.

- A minimum of 6 years of application database experience with a major application provider (PeopleSoft, Oracle EBS, etc.) is required.

Pay Rate:

Salary determined based on candidates experience and qualifications.

All job offers are contingent on successful completion of a pre-employment drug screen and background check.

California Job Applicants - click here to see our Job Applicant Privacy Notice.