DEPARTMENT OF ECONOMIC SECURITY

Your Partner For A Stronger Arizona.

DES works with families, community organizations, advocates and state and federal partners to realize our collective vision: A thriving Arizona.

DES serves more than 3 million Arizonans. Our Mission is to strengthen individuals, families, and communities for a better quality of life.

APPLICATIONS DEVELOPER SENIOR/LEAD (SQL SERVER DATABASE ADMINISTRATOR)

Job Location:

Division of Technology Services (DTS)
1400 West Washington Street, Phoenix, Arizona 85007

Posting Details:

Salary:  $95,000.00 Annually

Grade: 27

Closing Date: May 8, 2025

Job Summary:

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; or click on the link here to view ‘Our DES’ video. Come Join the DES Team!

DES is seeking an experienced and highly motivated individual to join our team as a Applications Developer Senior/Lead (SQL Server Database Administrator). This position is responsible for the overall management and maintenance of information databases used to operate IT applications and systems. The DBA partners with application teams and infrastructure operations to ensure that database performance is not hindered and performance standards adhere to service level agreements set with the enterprise. DBA will manage and maintain SQL Ml/ SQL Server/Postgre SQL databases, ensuring their performance, availability, security, and integrity through tasks like monitoring, backups, performance tuning, and troubleshooting.

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

Job Duties:

Essential Duties and Responsibilities include but are not limited to:

• Partners with development teams to design data management and governance protocols, manages the information lifecycle, and design infrastructure and data integration controls. Proactively solves problems. Installs, monitors. and directs proactive and reactive measures to ensure the availability, integrity, confidentiality and reliability of database systems.
• Meets performance standards in accordance to service level agreements set by the company. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Implement and review appropriate security guidelines/mechanisms.
• Analyzes and reports the performance of database operations against the key database performance metrics. Develops and test database migration procedures and performs database migrations.
• Designs, configures, implements, and administers all databases for the respective parties involved. Develops database administration tools/utilities/operation procedures.
• Builds and manages the database disaster recovery and backup plan. Performs database maintenance functions. Move, rebuild, or change database objects as required in production.

Knowledge, Skills & Abilities (KSAs):

Knowledge of:
• Conceptual, Logical and Physical data models, technical architecture, system interfaces, etc.
• In-depth knowledge of SQL with an emphasis on the Azure Platform - SQL Ml
• PostgreSQL I Vector Databases
• High availability and disaster recovery solutions
• Azure DevOps Cl/CD

Skills In:
• Strong experience using AZURE SQL Ml.
• Performance Tuning and Optimization and strong verbal and written communication skills.
• Experience with database security best practices and backup/recovery procedures
• Migrating on-prem databases to the cloud platform
• Proficient with relational databases ( SQL Server)

Ability to:
• Document database configurations, procedures, standards and ensure adherence to database policies and procedures.
•