Intern (Itd)

The Internship Database Administrator or DBA shall provide technical support at a fundamental level given the skillsets and abilities as noted in the candidates resume-profile. This position may perform routine Database administration and assist with writing and/or developing basic SQL code in reference to Microsofts 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 departments business needs and continual meeting of expected performance measures.A minimum of three days on-site at the ADWR officeper weekis 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 States 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.

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.

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.

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

Candidatesmust 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:Drivers License Requirements.

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

Work with a creative collaborative team of people who enjoy sharing their knowledge and experience.

Gain valuable experience working in a State Agency.

By providing the option of a full-time or part-time remote work schedule employees enjoy improved work/life balance report higher job satisfaction and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Positions in this classification participate in the Arizona State Retirement system (ASRS). Please note enrollment eligibility will become effective after 27 weeks of employment. The current contribution rate is 12.00%.

If you have any questions please feel free to contact ADWR Human Resources Office at for assistance. Persons with disabilities may request a reasonable accommodation such as a sign language or an alternative format by contacting ADWR Human Resources. Arizona State Government is an AA/EOE/ADA Reasonable Accommodation Employer.