SENIOR DATABASE ADMINISTRATOR
Job no: 530109
Position type: Full-time
Location: REMOTE OPTIONS, PHOENIX
Division/Equivalent: STATE OF AZ
School/Unit: DEPT OF LIQUOR LICENSES AND CONTROL
Department/Office: LL100-LL-ADMINISTRATION
Categories: Information Technology/Services
ARIZONA DEPTARTMENT OF LIQUOR LICENSES AND CONTROLThe mission of the Department of Liquor Licenses and Control (DLLC) is to protect public safety and support economic growth through the responsible sale and consumption of liquor, and to efficiently license qualified applicants. |
SENIOR DATABASE ADMINISTRATOR
Job Location: |
800 West Washington Street
Phoenix, AZ 85007
Posting Details: |
Salary: $80,000 - $90,000 (DOE)
Grade: 27
This position will remain open until filled
Job Summary: |
Under the general supervision of the Chief Technology Officer, the Database Administrator is responsible for the design, implementation, maintenance, and optimization of all database systems and related technologies, ensuring the availability, integrity, and security of mission-critical databases. This role involves developing and implementing policies and procedures for database use and access, and applying strong communication, analytical, and problem-solving skills to ensure optimal database performance.
The ideal candidate will apply proven skills in designing and implementing new database systems, installing and configuring database software, optimizing performance, ensuring data security, managing backups and recovery, troubleshooting user issues, and collaborating with other IT staff.
The Database Administrator will also stay current with emerging database technologies and best practices to maintain robust and efficient data management capabilities for the organization.
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.
Job Duties: |
• Assist in developing purge/archive criteria and procedures for historical application data on a relation model database environment
• Proactively solves complex problems, and Troubleshoots application key selection, creation of appropriate indexes, and query needs
• Establishes database procedures and standards; assists in database design; and maintains database documentation
• Translates user’s needs into a sound database design with tables, fields, and relationships documented
• Performance tunes, reviews, and recommends improvements to existing architectures and code(s)
• Reviews, evaluates, designs, implements, and maintains organizational database(s)
• Implement and review appropriate security guidelines/mechanisms
Knowledge, Skills & Abilities (KSAs): |
Knowledge:
• Various Industry standards for data capture, transmission, consumption, and reporting
• Physical data models, technical architecture, system interfaces, etc
• Normalized and dimensional modeling techniques
Skills:
• Develop and write technical documentation and demonstrated experience with scripting languages, particularly Python and/or PHP, to automate tasks and enhance database operations
• Proficient analytical skills to evaluate information gathered from multiple sources, consolidate details, and extract into functional
requirements
• Install and support relational database management systems (RDMS)
• Excellent interpersonal, written, and oral communication skills
• Design relational databases
Ability:
• Build strong relationships with internal and external stakeholders
• Work collaboratively in teams and across organizations
• Synthesize feedback and adjust plans accordingly
• Balance, prioritize, and organize multiple tasks
Selective Preference(s): |
• Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database - Specialty, or similar certifications demonstrating expertise in database administration and architecture
• Additionally, holding certifications like the Zend Certified PHP Engineer or the Python Institute's Certified Associate in Python Programming would be highly advantageous
Pre-Employment Requirements: |
• Bachelor’s degree plus 5 or more years of experience in database administration (or equivalent experience)
• Requires a criminal background (fingerprint) check in accordance with A.A.C. R2-5A-303
Benefits: |
The State of Arizona offers a comprehensive benefits package to include:
• Sick leave
• Retirement plan
• Health and dental insurance
• Vacation with 10 paid holidays per year
• Life insurance and long-term disability insurance
• Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance
• 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: |
• Position will be pension eligible for either PSPRS or ASRS depending on standing as governed by Arizona law and the state's pension board
Contact Us: |
• If you have any questions please feel free to contact Brian Westerberg at brian.westerberg@azdoa.gov for assistance
Advertised: US Mountain Standard Time
Application close:
Apply now