GIS DATABASE ADMINISTRATOR

Recruitment #2207-0764-001

Introduction



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.

The ITD is looking for a dynamic team player with strong geospatial database and SQL skills.  This position primarily supports Windows based MS SQL Server relational databases that are spatially enabled using ESRI’s framework. This position meets with users to determine needs, configures databases with input from other technical teams, monitors, and tunes databases for performance, and ensures data availability. A person in this position must be able to communicate courteously and effectively with both technical and non-technical individuals. 

**The Information Technology Department is a 24/7 operation. The incumbent will be required to serve in an on-call status to respond to requests and emergencies occurring after normal business hours. **

Essential Functions

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 Qualifications

Minimum Education Level & Type: Bachelor's Degree

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

Preferred Qualifications

  • 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 

Selection Plan

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 August 16, 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.

The City of Tucson values the safety of our employees, our residents, our community, and our visitors.  In support of these values, if you are selected for this job, you must be fully vaccinated against COVID-19, except when vaccination is not medically advised or violates your sincerely held religious beliefs. If you are invited to join our team, you must submit proof that you are fully vaccinated against COVID-19 to your initial HR representative, or you must request an exemption from your representative. New employees must either provide proof of vaccination or be granted a medical or religious exemption before working with the City of Tucson.

Conclusion

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

Pre-employment Medical Testing Requirements

None

Bulletin Footer

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.