Outdoors, Mountain, Nature, Person, Painting, Valley, Landscape, Scenery, Panoramic, Canyon

INTERN - (ITD)

  • 541334
  • PHOENIX
  • DEPT OF WATER RESOURCES
  • Internship
View favorites

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 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.

Retirement:

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%.

Contact Us:

If you have any questions please feel free to contact ADWR Human Resources Office at (602) 771-8500 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.

ARIZONA MANAGEMENT SYSTEM (AMS)

All Arizona state employees operate within the Arizona Management System (AMS), an intentional, results-driven approach for doing the work of state government whereby every employee reflects on performance, reduces waste, and commits to continuous improvement with sustainable progress.  Through AMS, every state employee seeks to understand customer needs, identify problems, improve processes, and measure results.  
State employees are highly engaged, collaborative and embrace a culture of public service.

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.

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