AHCCCS

Address:  801 E. Jefferson Street, Phoenix, AZ 85034

Must reside in the state of Arizona.

Salary: $106,000

Grade: 27

Closing Date: Open Until Filled

This position is eligible for full-time remote work (including virtual office arrangement in Arizona).

Join the State of Arizona!

At the State of Arizona, we prioritize a fantastic work/life balance for our employees. Enjoy engaging work, flexible remote options, comprehensive health and wellness benefits, and ample opportunities for career growth.

We are seeking a candidate with proven experience in administering, monitoring, and maintaining Azure SQL databases and data warehouses. This includes expertise in database provisioning, configuration, backup, recovery, and performance tuning. A strong proficiency in Azure database services, particularly Azure Synapse (Azure SQL Data Warehouse), is essential.

If this sounds like you, we invite you to join our team! Come work with us!

What You'll Do:

As the Database Administrator is responsible for database design, ensuring reliability, upholding security standards, deployment and optimizing performance of AHCCCS databases. You will work on both standard maintenance support issues and day-to-day operational activities including break/fix, capacity management, backup and recovery, database replication setup/management and ongoing database change reviews. Works closely with our Infrastructure, Development, Data Analytics and Quality Assurance teams, identifying issues while also suggesting and implementing corrective actions.

Major duties and responsibilities include but are not limited to:
• Manage and administer AHCCCS databases, including monitoring, performance tuning, and troubleshooting to ensure optimal performance and availability.
• Configure and maintain data warehouse security policies and access controls to ensure data integrity and compliance with regulatory requirements. Responsible for tasks such as development of best practices and repeatable procedures for deploying database structures.
• Monitor and manage data warehouse backups, restores, and data retention policies.
• Performs Database Systems production on-call support.
• Provide technical support and guidance to data analysts on data warehouse-related issues and occasionally help with Informatica -ETL migration and development
• Develop and maintain disaster recovery and high availability strategies for the data warehouse environment.

Knowledge:
• Database Management Systems (DBMS): Comprehensive understanding of various database management systems, particularly Azure SQL Database, Azure SQL Data Warehouse, or similar cloud-based platforms
• Data Warehousing Concepts: Strong grasp of data warehousing principles, methodologies, and best practices
• Azure Services: Proficiency in Azure services relevant to database administration, such as Azure Synapse Analytics. Creation and use of Synapse Pipelines
• SQL and Query Optimization: In-depth knowledge of SQL querying and optimization techniques to enhance database performance, troubleshoot issues, and optimize data retrieval processes in a data warehouse environment

Skills:
• Database Administration: Proven experience in administering, monitoring, and maintaining Azure SQL databases and data warehouses, including database provisioning, configuration, backup, recovery, and performance tuning
• Troubleshooting and Debugging: Strong troubleshooting skills to identify and resolve database-related issues, optimize query performance, troubleshoot data integration problems, and ensure the smooth functioning of data warehouse operations
• Scripting and Automation: write scripts (e.g., PowerShell, T-SQL) and leverage automation tools to automate routine database administration tasks, streamline processes, and improve operational efficiency
• Collaboration and Communication: Excellent communication and collaboration skills to effectively interact with cross-functional teams, stakeholders

Abilities:
• Analytical Thinking: Ability to analyze complex data sets, identify trends, patterns, and anomalies, and derive actionable insights to support decision-making processes and improve data warehouse performance
• Attention to Detail: Meticulous attention to detail to ensure data accuracy, consistency, and integrity within the data warehouse environment
• Problem-Solving Orientation: Strong problem-solving orientation with the ability to approach challenges with a systematic mindset, troubleshoot issues efficiently, and
implement effective solutions to address database-related issues and optimize performance

Minimum:
• Bachelor’s degree plus 5 or more years of experience in database administration (or equivalent experience). Equivalent experience to include: 2 years Application Programming, 2 years Application Analysis and Design, 5 Data Base Administration or Data Base Administration Training - vendor specific with a focus on data warehouse technologies. Strong proficiency in Azure database services, particularly Azure Synapse (Azure SQL Data Warehouse).

Preferred:
• Experience with Azure Data Factory,Databricks, and other Azure data integration and analytics services is a plus.

• Successfully complete the Electronic Employment Eligibility Verification Program (E-Verify), applicable to all newly hired State employees.
• Successfully pass fingerprint background check, prior employment verifications and reference checks; employment is contingent upon completion of the above-mentioned process and the agency’s ability to reasonably accommodate any restrictions.
• Travel may be required for State business. Employees who drive on state business must complete any required driver training (see Arizona Administrative Code R2-10-207.12.) AND have an acceptable driving record for the last 39 months including no DUI, suspension or revocations and less than 8 points on your license. If an Out of State Driver License was held within the last 39 months, a copy of your MVR (Motor Vehicle Record) is required prior to driving for State Business. Employees may be required to use their own transportation as well as maintaining valid motor vehicle insurance and current Arizona vehicle registration; however, mileage will be reimbursed.

- If selected for an interview, you will be required to complete an exercise so that we may assess proficiency in Azure database services, particularly Azure Synapse (Azure SQL Data Warehouse).

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

Among the many benefits of a career with the State of Arizona, there are:
• 10 paid holidays per year
• Paid Vacation and Sick time off (13 and 12 days per year respectively) - start earning it your 1st day (prorated for part-time employees)
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
• Other Leaves - Bereavement, civic duty, and military.
• A top-ranked retirement program with lifetime pension benefits
• A robust and affordable insurance plan, including medical, dental, life, and disability insurance
• Participation eligibility in the Public Service Loan Forgiveness Program (must meet qualifications)
• RideShare and Public Transit Subsidy
• A variety of learning and career development 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

Lifetime Pension Benefit Program
• Administered through the Arizona State Retirement System (ASRS)
• Defined benefit plan that provides for life-long income upon retirement.
• Required participation for Long-Term Disability (LTD) and ASRS Retirement plan.
• Pre-taxed payroll contributions begin after a 27-week waiting period (prior contributions may waive the waiting period).

Deferred Retirement Compensation Program
• Voluntary participation.
• Program administered through Nationwide.
• Tax-deferred retirement investments through payroll deductions.

Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by emailing careers@azahcccs.gov.
Requests should be made as early as possible to allow time to arrange the accommodation. The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.