DATABASE DEVELOPER AND ADMINISTRATOR

CORPORATION COMMISSION The Arizona Corporation Commission (ACC) is one of the most unique state agencies in Arizona and one of only 13 public utility commissions in the country where commissioners are elected.
Established by the Arizona Constitution, the ACC is a medium-sized agency with offices in Phoenix and Tucson.
Our mission is diverse—spanning utility rate making; securities registration and enforcement; rail and pipeline safety; and corporate business filings—and we boast an average employment tenure of nearly 10 years.
Learn more by visiting www.
azcc.
gov.
DATABASE DEVELOPER AND ADMINISTRATOR Job Location: Address: 1300 W.
Washington, Phoenix AZ 85007 Remote hybrid and flexible scheduling available Posting Details: Salary: $75,000 - $82,000 Grade: 25 Job Summary: The IT Division provides network, hardware, help desk, project management, and application development services to in support of the mission of the Corporation Commission.
We are responsible for applications used internally and by the public to access information and services.
Job Duties: You will be responsible for building and developing database objects and the database environments.
You will translate systems and program requirements into coded computer instructions, then test and debug that database code.
This involves maintaining and analyzing architecture, scripting database artifacts and effective reporting against data; database migration and maintenance; and documentation.
Knowledge, Skills & Abilities (KSAs): - Strong understanding of Microsoft data ecosystem: T-SQL programming, SQL Server 2014 and greater; SQL SSIS / SSRS; and PowerBI reporting.
- Development skills with MS Visual Studio, SQL Server Management Studio, PowerBI.
- Familiarity with database access methods and LINQ queries in C# under .
NET.
- Ability to develop and test stored procedures, views, functions and scripts, anticipating risks and performance, providing mitigation in the moment.
- Effective working both independently and collectively, remaining open to others’ ideas and adapting to change.
- Ability to translate users’ needs into a sound database design with tables, fields and relationships documented.
- Skills necessary to assist developers in troubleshooting the cause of SQL and/or application failures.
Selective Preference(s): N/A Pre-Employment Requirements: Any offer of employment is contingent upon successful completion of an employment/reference check and confirmation of any degrees/certifications.
A.
R.
S.
Section 40-101 prohibits Commission employees from having certain financial interests in entities that the Commission regulates.
Applicants shall be required to disclose any interests they may have in the regulated entities during the application process, and as a condition of employment, to divest themselves of any prohibited interests.
All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).
Benefits: - Excellent comprehensive benefits, including a top-ranked retirement plan, low-cost health coverage, supplemental policies such as vision and short-term disability, generous paid vacation and sick leave programs, and Paid Parental Leave for those who qualify - Career and personal development support; multiple training and education opportunities and resources; qualifying Public Service Loan Forgiveness employer - Interesting, challenging work in a public sector environment with the chance to make a real difference in our state - We are a recognized Arizona Veteran Supportive Employer 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.
Retirement: This position qualifies for participation in the Arizona State Retirement System (ASRS) defined benefit pension.
Contact Us: If you have any questions, please email HumanResources@azcc.
gov for assistance.