Database Administrator

DEPT OF REVENUE

Funding Arizona’s future through excellence in innovation, exceptional customer service and public servant-led continuous improvement.

All Arizona State employees operate within the Arizona Management System (AMS), an intentional, results-driven approach for doing the work of state government. Our goal is for every ADOR team member to reflect on individual and team performance, reduce waste, and commit to continuous improvement with sustainable progress. Through AMS, every ADOR team member seeks to understand customer needs, identify problems, improve processes, and measure results.

Database Administrator

Job Location:

Address: 1600 W Monroe St, Phoenix, AZ 85007

Posting Details:

Salary: $75,000

Grade: 25

Closing Date: Until Filled

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

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.

Job Duties:

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

Knowledge, Skills & Abilities (KSAs):

Requirements

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

Licenses & Certifications

None

Knowledge/Understanding

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.

Skills

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

Abilities

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; organizing, classifying and synthesizing the data into fundamental issues; from the information, identifying the most probable causes of the problem; reducing the information down into manageable components; identifying the logical outcomes from the analyses of the data collected; and, identifying the options and solutions for addressing the problems analyzed.

Willingness and ability to embody ADOR’s core values of Do the Right Thing, Commit to Excellence, and Care About One Another

Additional Job Demands

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

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

Pre-Employment Requirements:

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.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits:

The State of Arizona provides a world class comprehensive benefits package including:

-Paid time off for holidays, sick days, annual leave, military leave, bereavement leave, and civic duty leave

-Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).

-A robust and affordable insurance plan that includes medical, dental, vision, life insurance, short-term, and long-term disability options.

-Higher education discounts for State employees and tuition reimbursement up to $5,250 per fiscal year, available to seek further career advancement or certification in Continuing Professional Education.

-Work-life balance and additional options for life betterment such as the Infant at Work Program, State Wellness Program, Public Transit Discounts, Alternate Work Schedules, and Telework opportunities.

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.

Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement:

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:

Contact Us:

If you have any questions, need assistance, or would like to request a reasonable accommodation, please contact the ADOR Talent Team at .

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