Database Administrator

Arizona Department of Administration•Phoenix, AZ

3d•Hybrid

About The Position

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.

Requirements

Working Knowledge of computer database management systems, applications, and programming languages
Knowledge of the Software Development Life-Cycle
Knowledge of IT release and configuration management
Knowledge of the fundamentals of object-oriented programming principles
Deep understanding of monitoring, database diagnostic and analytics tools.
Strong verbal, written, and listening communication skills
Effective interpersonal skills and demeanor
Effective organization and time management skills with the ability to manage multiple priorities simultaneously and work in high-pressure situations
Proficient in the use of a PC in a Windows environment; in the use of the Internet; in the use of MS Office Applications such as Outlook, Word and Excel, PowerPoint; and in the use of Google Suite applications such as Gmail, Sheets, Docs, and Drive.
Advanced proficiency with T-SQL and PowerShell, database design, database implementation, database administration, troubleshooting databases and database servers.
Proficient in Windows based systems: MS SQL Server 13.0-16.0 (2016, 2017, 2019, 2022), Azure DevOps, Index management, SSMS, SSRS, SSIS, SSAS, and system backups.
Ability to clear a comprehensive background and clearance process that includes an Arizona tax compliance verification, and a criminal background check through the FBI via level one fingerprint clearance through the Arizona Department of Public Safety
Ability to work with a high degree of autonomy and also participate collaboratively as part of a team
Ability to work in a confidential manner, ensuring information is shared with internal and external individuals in an appropriate manner
Ability to understand and solve problems by applying intermediate analytical skills to include collecting all the relevant information and data needed to address the problem
Willingness and ability to embody ADOR’s core values of Do the Right Thing, Commit to Excellence, and Care About One Another
This position functions in a standard office environment with the physical demand of prolonged sitting and/or standing, manual dexterity, and seeing
Additional mental demands include continuous analysis
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

Nice To Haves

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

Responsibilities

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
Create deliverables according to the Software Development Life Cycle to include writing and coding database scripts and stored procedures
Develops standards and guidelines for database use and protection
Identifies and documents functional and technical database specifications
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

Benefits

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