Arizona Department of Child Safety
A New Beginning for Arizona's Children
SQL DATABASE ADMINISTRATOR
Information Technology (IT) Operations
Department of Child Safety
3003 N Central Ave. Phoenix AZ 85012
DCS Mission Statement
Successfully engage children and families to ensure safety, strengthen families, and achieve permanency.
If you consider yourself to be a highly organized and motivated individual who possesses technical development skills and is passionate about SQL reporting and data analysis, this is the job for you!
The SQL Database Administrator will be responsible for the DCS data warehouse, SQL process and application database needs. This position will manage the architecture, development, maintenance, and day-to-day operations of the data warehouse, including appropriate policy, retention, SQL, and documentation. This position will design, develop, and implement SQL codes and support production SQL bug fixes. This position also requires experience with EDW, DW, and OLAP. Additionally, this position will design and create data models and data warehousing and related BI functions as well as design, build, and deploy successful SSIS packages.
Solves problems, installs, monitors, and directs proactive and reactive measures
Coordinates resolution of trouble calls with help desk, monitors and manages user accounts, and maintains database instances
Translates user's needs into a sound database design with tables and fields
Assists in developing purging and archiving criteria and procedures
Reviews, evaluates, designs, implements and maintains company database(s)
Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process
Implements and reviews appropriate security guidelines
Develops, tests, and performs database migration procedures
All other duties as assigned
KNOWLEDGE, SKILLS AND ABILITIES (KSAs):
Physical data models, technical architecture, system interfaces, etc.
Normalized and dimensional modeling techniques
Various industry standards for data capture, transmission, consumption, and reporting
Verbal and written communication
Strong customer service
Establishing and maintaining interpersonal relationships
Balance, prioritize, and organize multiple tasks
Work collaboratively in teams and across organizations
Synthesize feedback and adjust plans accordingly
Build strong relationships inside and outside the organization
The ability to secure and maintain an Arizona Fingerprint Clearance Card; and the ability to secure and maintain clearance from the CPS Central Registry.
Employment is contingent on the selected applicant passing a background investigation.
In-state travel is sometimes required. Requires possession of and ability to retain a current, valid state-issued driver's license appropriate to the assignment. Employees who drive on state business are subject to driver's license record checks, must maintain acceptable driving records and must complete any required driver training (see Arizona Administrative Code R2-10-207.12.).
We offer a comprehensive benefits package that includes:
Vacation with 10 paid holidays per year
Health and dental insurance
Life insurance and long-term disability insurance
Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance
Positions in this classification participate in the Arizona State Retirement System (ASRS).
Enrollment eligibility will become effective after 27 weeks of employment.
Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting 602-255-2903. Requests should be made as early as possible to allow time to arrange the accommodation. Arizona State Government is an AA/EOE/ADA Reasonable Accommodation Employer.
State Of Arizona