INTERN - (ITD)

DEPT OF WATER RESOURCES

Intern - (Database Administrator) Information Technology Department Job Location: 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. 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 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: 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: 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: 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 View phone number on click.appcast.io 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. #J-18808-Ljbffr Arizona State Government