Database Administrator Senior
Database Administrator Senior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 80000 - 106000
1 Vacancy
Job Description
AHCCCS
Arizona Health Care Cost Containment System
Accountability Community Innovation Leadership Passion Quality Respect Courage Teamwork
The Arizona Health Care Cost Containment System (AHCCCS) Arizonas Medicaid agency is driven by its mission to deliver comprehensive costeffective health care to Arizonans in need. AHCCCS is a nationally acclaimed model among Medicaid programs and a recipient of multiple awards for excellence in workplace effectiveness and flexibility.
AHCCCS employees are passionate about their work committed to high performance and dedicated to serving the citizens of Arizona. Among government agencies AHCCCS is recognized for high employee engagement and satisfaction supportive leadership and flexible work environments including remote work opportunities. With career paths for seasoned professionals in a variety of fields entrylevel positions and internship opportunities AHCCCS offers meaningful career opportunities in a competitive industry.
Come join our dynamic and dedicated team.
Database Administrator Senior
Information Services Division (ISD)
Address: 801 E. Jefferson Street Phoenix AZ 85034
Must reside in the state of Arizona.
Salary: $
Grade: 27
Closing Date: Open Until Filled
This position is eligible for fulltime 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 Youll 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 daytoday 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 oncall support.
Provide technical support and guidance to data analysts on data warehouserelated 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 cloudbased 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: Indepth 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 databaserelated 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 TSQL) 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 crossfunctional teams stakeholders
Abilities:
Analytical Thinking: Ability to analyze complex data sets identify trends patterns and anomalies and derive actionable insights to support decisionmaking 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
ProblemSolving Orientation: Strong problemsolving orientation with the ability to approach challenges with a systematic mindset troubleshoot issues efficiently and
implement effective solutions to address databaserelated issues and optimize performance
Minimum:
Bachelors 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 FactoryDatabricks and other Azure data integration and analytics services is a plus.
Successfully pass fingerprint background check prior employment verifications and reference checks; employment is contingent upon completion of the abovementioned process and the agencys 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 R210207.12.)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:Drivers License Requirements.
All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (EVerify).
If selected for an interview you will be required to complete an exercise so that we may assessproficiency in Azure database services particularly Azure Synapse (Azure SQL Data Warehouse).
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 parttime employees)
Paid Parental LeaveUp to 12 weeks per year paid leave for newborn or newlyplaced foster/adopted child.Learn more about the Paid Parental Leave pilot programhere.
Other Leaves Bereavement civic duty and military.
A topranked 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 fulltime or parttime 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.
For a complete list of benefits provided by The State of Arizona please visit ourbenefits page.
Lifetime Pension Benefit Program
Administered through the Arizona State Retirement System (ASRS)
Defined benefit plan that provides for lifelong income upon retirement.
Required participation for LongTerm Disability (LTD) and ASRS Retirement plan.
Pretaxed payroll contributions begin after a 27week waiting period (prior contributions may waive the waiting period).
Deferred Retirement Compensation Program
Voluntary participation.
Program administered through Nationwide.
Taxdeferred 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
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.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
