What are the responsibilities and job description for the Database Administrator position at Arizona Department of Revenue?
Position Summary:
The Database Administrator is responsible for administering, testing, and implementing computer database system(s) as assigned, and coordinating changes to the database system(s) as needed. This position will identify, investigate, and resolve any database performance issues and will also implement security measures to ensure the safeguard of the database system(s).
Supervision:
This position does not have direct reports.
System Support & Administration
- Analyzes, troubleshoots, and resolves database or production issues
- Tests databases and makes necessary modifications to meet functionality requirements
- Plans, coordinates, and implements security measures
- Engages with database stakeholders to understand functional requirements
- Reviews and recommends improvements to existing architectures.
Programming
- Create deliverables according to the Software Development Life Cycle to include writing and coding database scripts and stored procedures.
Documentation
- Develops standards and guidelines for database use and protection
- Identifies and documents functional and technical database specifications.
Agency/Department Compliance & Continuous Improvement
- Remains current on all laws, regulations, policies, and best practices related to taxation through regular engagement in activities such as: self-directed research, conferring with other practitioners and technical experts; subscriptions to regulatory/legal/industry newsletters and briefs; membership industry associations and attendance at meetings/events; and or participation in training and others continuing education opportunities.
- Actively contributes to team and individual effectiveness through the following: -
- Attends staff meetings and huddles of work unit or district; and may cascade and track information as indicated
- Completes all required training in a timely manner.
- Participates in assigned work teams as appropriate.
- May complete periodic metrics, projects, huddle boards and reports as requested.
- Prepares for and actively participates in 1:1 coaching with supervisor
- Maximizes work processes and deliverables through lean principles within the Arizona Management System (AMS); and provides recommendations for process improvement and engages in continuous improvement efforts as assigned.
Miscellaneous
- Assist in training of new employees and/or junior staff
- Other duties as assigned
Education & Experience
- Any combination that meets the knowledge, skills and abilities (KSA); typical ways KSAs are obtained may include but are not limited to: a relevant degree from an accredited college or university such as Associate’s Degree (e.g., A.A.), training, coursework, and work experience relevant to the assignment.
- Minimum of three (3) years database administration experience
- Previous experience in public cloud hosted database design, provisioning and administration. This may include Amazon RDS, Azure SQL Database or Google Cloud SQL
Selective Preference(s):
- Experience in T-SQL, PowerShell, NoSQL, PL/SQL
- Report building experience, Data Warehouse, Data Lake, ODS, OLAP
- Experience in both Hybrid Cloud and Public Cloud architectures
- Oracle DB experience, 19c-21c
- Experience and/or knowledge of continuous improvement or LEAN concepts and principles
- Certifications: AWS Certified Database - Specialty, Azure Database Administrator Associate or Google Cloud Professional Cloud Database Engineer