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).
This position may be available for remote work within Arizona.
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.
- 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: -
- Completes all required training in a timely manner.
- Participates in assigned work teams as appropriate.
- 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.
- Assist in training of new employees and/or junior staff
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
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
The final candidate will be required to abide by the the following pre-employment checks:
- Employment Verification and Reference Checks
- State and Federal Criminal Background Check, including fingerprinting
- Arizona Tax Filing Records Check
- If applicable, ASEDRA Authorized Driver Identification Check
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.
The State of Arizona provides a world class comprehensive benefits package including:
- Affordable medical, dental, life, and short-term disability insurance plans
- Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
- 10 paid holidays per year
- Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
- Sick time accrued at 3.70 hours bi-weekly
- Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
- Deferred compensation plan
- Wellness plans
- Tuition Reimbursement
- Stipend Opportunities
- Infant at Work Program
- Rideshare and Public Transit Subsidy
- Career Advancement & Employee Development Opportunities
- Flexible schedules to create a work/life balance
Learn more about the Paid Parental Leave program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page
State employees are required to participate in the Arizona State Retirement System (ASRS).
Top ranked Arizona State Retirement System (ASRS) provides 100% employer matched contributions (enrollment eligibility will be effective after 27 weeks of State employment). ASRS provides a lifelong benefit based on years of service earned, or worked, and your ending salary.
Learn more about ASRS at: https://www.azasrs.gov/content/new-and-prospective-members.
If you have any questions, need assistance, or would like to request a reasonable accommodation, please contact the ADOR Talent Team at oagre.ctr@azdor.gov
The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.