INTERN ITD

Position: INTERN - (ITD)
DEPT OF WATER RESOURCES

ADWR's mission is to safeguard the health, safety and economic welfare of the public by protecting, conserving and enhancing Arizona's water supplies in a bold, thoughtful and innovative manner. Do you want to join our team? ADWR is currently recruiting for an Intern position in the Information Technology Department.

Intern - (Database Administrator)

Information Technology Department

WWW.AZWATER.GOV

Job Location:

Address:
Hybrid - 1110 W. Washington St., Suite #310

Phoenix, AZ 85007

Posting Details:

Salary: $16.50 - $17.60

Grade: 04

Closing Date:
Open Until Filled

Job Summary:

The Internship 'Database Administrator or "DBA," shall provide technical support at a fundamental level, given the skillset's and abilities as noted in the candidate's resume-profile. This position may perform routine Database administration and assist with writing and/or developing basic SQL code in reference to Microsoft's SQL Server platform.

Schedule:

Hours may vary from 20 hours per week up to 40 hours per week.

This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures. A minimum of three days on-site at the ADWR office per week is required.

The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.

Job Duties:

The essential functions include, but are not limited to, the following:

* Gain knowledge in Database administration, up to and including SQL coding.

* Assist the Senior Database Administrator on certain day-to-day tasks, which may

include onboarding and offboarding of ADWR employees in an Oracle database

environment, along with creating and updating user profiles.

* Gain knowledge and understanding with MS SQL Server basic administration

tasks, such as creating and managing user accounts, granting permissions and

roles, backup and recovery strategies, and other essential functions of database

management.

* Assist Application Development on an as-needed basis for SQL code tuning,

best method of execution, and error resolution.

* Gain knowledge in PYTHON scripting and leverage as needed.

* Other duties as assigned.

Knowledge, Skills & Abilities (KSAs):

The ideal candidate should have:

Knowledge of:

* Basic knowledge of database structures and familiarity with relational data

storage and retrieval.

* Proficiency with common office software (Microsoft Word, Excel).

Skills in:

* Clear written and verbal communication

* Moderate level of organizational skills with attention to detail.

* Managing detailed data entry with a high level of accuracy and attention to detail

* Using spreadsheets and databases to enter, track, manage, and retrieve information

* Working cooperatively in a team environment

Ability to:

* Follow instructions and complete tasks accurately and efficiently

* Ability to communicate at a professional level, either in person and/or in writing.

* Ability to prioritize tasks and meet deadlines.

* Ability to work independently and as part of a team.

Selective Preference(s):

Applicants should demonstrate an interest in water resources, environmental policy, or public service and possess strong organizational and communication skills to support program activities.

Pre-Employment Requirements:

Candidates must be enrolled in a degree program related to Information Technology, Computer Science, Computer Information Systems (CIS), Data Science, Cybersecurity or a similar field.

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply:
Driver's License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits:

Work with a creative, collaborative team of…