GIS DATABASE ADMINISTRATOR

The City of Tucson Information Technology Department (ITD) is seeking a motivated and innovative GIS Database Administrator to join our team. The ITD Database Administrator team develops, administers, and maintains enterprise level databases to ensure security, accuracy, and efficiency.

Understands and adheres to sound relational design practices using defined City standards; reviews logical and physical database designs for proposed changes to existing databases or new project implementations.

Ensures that the City's data and databases are available, usable, and reliable through monitoring, following best security practices, and data integrity facilities.

Establishes and enforces policies and procedures related to database authentication, data access control authorization, and auditing of security practices.

Implements database software by installing and testing several database software products and upgraded databases; plans, implements, and maintains database backup and recovery strategies to protect the City's data and databases.

Provides daily operations support to existing applications systems databases; provides technical project team support for application systems modifications and/or development; develops and maintains appropriate documentation.

Proactively establishes optimum values for existing and newly installed systems to optimize performance; ensures that best practices are followed so that good performance will result.

Troubleshoots and corrects problems.

Evaluates new database methodologies, version upgrades, and/or new implementation methods for planned upgrades, migrations, and regular maintenance; advises management of opportunities, changes, or alternative action to meet user needs.

Administers and controls data resources by working with outside agencies to make on-line information sharing possible; monitors and maintains security of databases and project schedules for assignments; provides instructions, prototypes of programs, training and technical assistance on timely accomplishment of tasks; documents procedures with complete instructions for back-up personnel; and coordinates schedules with other departments' schedules for assistance.

This is a lead position affording guidance to other positions performing the same tasks. This lead position also reviews workloads, assigns work and coaches employees with specialized instructions and practices for job accomplishments. Lead personnel may contribute to other employees' performance evaluations, assist with the hiring process by interviewing and making recommendations and providing input to supervisory staff.

Minimum Education Level & Type: Bachelor's Degree

Minimum Experience Qualifications: At least 3 years in database development and administration

• Bachelor or Master's degree in Information Technology, Management Information Systems, Computer Science or related degree program
• Strong ability to write scripts using structured query language and Python
• Working experience with development of spatial databases
• Working experience with administration and development of ESRI ArcSDE geodatabases and ESRI ArcPy module
• Outstanding problem solving and troubleshooting skills 

As part of the online application process all applicants are required to submit a Resume. Please ensure your application contains the required materials prior to submission. Applications submitted without a resume will be considered incomplete.

Applicants who meet the minimum qualifications will be evaluated on the education and work experience in their employment profile and the responses to their supplemental questions. The highest scoring applicants will then be invited to participate in an oral board interview.   

• Oral Board Interviews will be held November 2, 2022.

Upon completion of all examination processes, the highest scoring applicants will be placed on the Civil Service Employment List.  An applicant's ranking on the Civil Service list will be based on their final score which will be calculated as:      

• 20% of your rating for education and work experience
• 80% of your oral board

This recruitment will establish a civil service list that will be utilized to fill vacancies occurring within the next 6 months.

Veterans, Native American, or Disability preference points will be added to the final score for those that are placed on the Civil Service Employment List.  If you qualify for preference points as outlined in the Employment Profile, you must provide a copy to the HR facilitator prior to your Oral Board interview.  The DD 214 must be a copy that indicates characterization of service.  

If you are in need of Americans with Disabilities Act-related accommodation during the testing process, please email Erin.Gallego@tucsonaz.gov  at least 48 hours prior to the evaluation.

Communications throughout this process will be sent via email exclusively so please ensure your browser accepts emails from jobs@tucsonaz.gov and check your email account regularly.  Failure to respond or follow instructions will result in disqualification.  All email inquiries should be directed to Erin Gallego at Erin.Gallego@tucsonaz.gov 

This position includes support of Public Safety related systems therefore, the successful candidate will be required to pass an extensive criminal background check conducted by the Tucson Police Department..

None

To ensure accurate payroll information for tax purposes, the successful candidate will need to provide their original Social Security Card or original letter from the Social Security Administration with their social security number prior to beginning work with the City of Tucson.

The City of Tucson hires lawful workers only - US citizens or nationals and non-citizens with valid work authorization - without discrimination. Federal immigration laws require all employers to verify both the identity and employment eligibility of all persons hired to work in the United States. In its efforts to meet the law's requirements, the City of Tucson participates in the E-Verify program established by the Department of Homeland Security (DHS) and the Social Security Administration (SSA) to aid employers in verifying the eligibility of workers.

Retired City of Tucson employees receiving benefits from the Tucson Supplemental Retirement System who are considering reemployment with the City should be aware that pursuant to Section 22-37(g) of the Tucson City Code, retirement benefits shall be suspended during the period of reemployment with the City of Tucson unless you have been separated at least twelve consecutive months before returning to work AND you return to a non-permanent employment classification. Creditable service does not accrue during any reemployment period.