DATABASE ADMINISTRATOR SENIOR

Arizona Department of Administration•Phoenix, AZ

3d•Remote

About The Position

Would you like to be part of an amazing team that helps Arizonans thrive? At the Department of Economic Security (DES) we strengthen individuals, families and communities for a better quality of life. DES is looking for individuals who are committed to service, community, and teamwork. To learn more about DES please visit des.az.gov [https://des.az.gov/]; or click on the link here [https://www.youtube.com/watch?v=EjLhFs6kqmE] to view ‘Our DES’ video. Come Join the DES Team! The Department of Economic Security is seeking an experienced and highly motivated individual to join our team as a Database Administrator Senior. The Database Administrator Senior maintains the Division’s database systems, including back-up, performance tuning, capacity planning, monitoring critical events, and documentation. This position works with business teams and IT teams to develop an understanding of data and information needs, identify solutions, and improve the quality of service while providing support through the logical and physical design of databases. The Database Administrator Senior provides strategic guidance toward the implementation and utilization of data warehouse and other data sources, maintains the integrity of the Division’s databases, and ensures that data is stored securely and efficiently. This position is conversant with and cognizant of the future direction of systems, how that directly impacts the organization, and how future and current database systems can be developed for the organization’s benefit. This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures. The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, 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

Physical data models.
Technical architecture.
Database querying.
Backup and recovery best practices.
SQL-based query languages.
IT systems and applications.
Leadership, critical thinking.
Customer service, with the ability to collaborate with technical and non-technical stakeholders.
Verbal and written communications to recommend technical processes.
Explaining technical procedures and negotiating the resolution of work issues.
Developing new systems and tools.
Documenting and maintaining up-to-date system procedures.
Identifying and implementing process improvements, managing, planning, and prioritizing work effectively with minimal supervision.
Balance, prioritize, and organize multiple tasks.
Work collaboratively in teams and across organizations.
Synthesize feedback and adjust plans accordingly.
Install and support relational database management systems (RDMS).
Evaluate and test emerging technologies.
Apply creative solutions to business problems to ensure business needs are effectively met.
coordinate and solve moderately complex technical data management issues.
Disaster recovery, performance analysis, and tuning.

Nice To Haves

Bachelor’s degree and five (5) or more years of experience in database administration (or equivalent experience).

Responsibilities

Proactively solves complex problems and translates user needs into sound database design with tables, fields, and relationships documented.
Assists in developing purge/archive criteria and procedures for historical application data on a relational model database environment.
Reviews, evaluates, designs, implements, and maintains organization databases. Implements and reviews appropriate security guidelines and mechanisms.
Develops and tests database migration procedures.
Performs database maintenance functions.
Develops database administration tools, utilities, and operational procedures.
Establishes database procedures and standards.
Assists in database design.
Educates users and maintains database documentation. Assists in interviewing and training new employees and provides guidance when required.
Performance tunes, reviews, and recommends improvements to existing codes.
Reviews and recommends improvements to existing architectures.
Documents data requirements in a logical Entity Relationship Diagram.
Troubleshoots application key selection, creation of appropriate indexes, and query needs.

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
Paid vacation and sick time
Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child.
Deferred compensation plan
Wellness plans
Tuition Reimbursement
Stipend Opportunities
Infant at Work Program
Rideshare and Public Transit Subsidy
Career Advancement & Employee Development Opportunities