DATABASE ADMINISTRATOR

Recruitment #1812-0764-001

Introduction

The City of Tucson Information Technology (IT) Department provides centralized support for all departments within the City organization which serve the Tucson community. The diversity of business functions and supporting technologies makes for a dynamic work environment that is both challenging and rewarding. Public Safety which includes Tucson Fire and Tucson Police, City Services such as Planning and Development Services, Environmental and General Services, and Water, and Organizational Support Services such as Business Services and Human Resources are examples of the business needs support that IT offers.

The IT Department is looking for a self-driven, solution and detail orientated team player with great technical and communication skills, willing to make a difference. This position requires strong administrative skills in the Oracle (11g and higher), and SQL Server (2012 and higher) environments. Candidates should have strong skills in structured query language (DDL and DML), experience with database backup and recovery methods, and an understanding of database performance.  The successful candidate will need to communicate clearly with both technical and non-technical people, bridging the gap between business rule analysis and database development and implementation.

This position administers application system databases used to support the business services delivery of the City of Tucson. Responsibilities include: Implements and maintains database backup and recovery strategies, develops, documents, and automates processes to promote information sharing between systems and conducts performance tuning to ensure that databases are performing at optimal levels. This position will also actively participate in mentoring and knowledge transfer of new technologies and processes with DBA team members.

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

General Description

The Database Administrator develops, administers, and maintains department databases to ensure security, accuracy, and efficiency. Provides support for databases running on several platforms to enable user access to data. Meets with users to determine needs, configures databases with input from systems administrators, monitors and tunes databases for performance, and ensures data availability. Trains, guides, and mentors others in the execution of assigned tasks. Interacts with individuals at all levels within and outside of the organization to resolve technical and non-technical issues.

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.

Follows best practices to optimize system performance.

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's degree in Information Technology, Management Information Systems, or Computer Science

Master's degree in Information Technology, Management Information Systems, or Computer Science

Advance level skills in Oracle 11g and higher and SQL Server 2012 and higher 

Selection Plan

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 January 30, 2019.

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:      

  • 10% of your rating for education and work experience
  • 90% 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 upload, email or hand deliver your documentation as part of the application process, for email please send to Shelly.Urias@tucswonaz.gov  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 SS_HR_Satellite@tucsonaz.gov at least 48 hours prior to the evaluation.

Conclusion

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.

Fingerprinting and reference checks may also be conducted prior to an offer of employment. Employment offers are contingent upon successfully passing any of the above requirements. A valid Arizona Driver's license is also a requirement while holding this position.

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.