SQL SERVER DATABASE ADMINISTRATOR

Introduction The City of Tucson Information Technology Department (ITD) is seeking a motivated and innovative 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 provides centralized support for all departments within the City organization.
This position requires strong MS SQL Server relational database experience, cloud platform database experience, and PL/SQL scripting.
This position will also actively participate in meetings with users to determine needs, create and configure databases with input from other technical teams, write and edit complex scripts, monitor and tune databases for performance, and ensure data availability.
The successful candidate must be able to communicate courteously and effectively with both technical and non-technical individuals.
General Description 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 Develops, tests, and implements new databases, modified database enhancements, and integrations to meet changing business requirements.
Creates and modifies complex queries (PL/SQL, PowerShell, Python).
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.
Gathers requirements, evaluates and identifies opportunities for new database methodologies and platforms, performs version upgrades, and/or new implementation methods for planned upgrades, migrations, and regular maintenance; leads proof of concept developments.
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 PL/SQL Experience with integration development Working experience with administration and development of MS SQL Server relational databases and cloud platform databases Working experience with database backup and recovery methods and understanding of database performance Outstanding problem solving and troubleshooting skills Experience implementing and maintaining data warehouses 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.
Those who meet the minimum qualifications will have their resume reviewed and graded.
The highest scoring applicants from the resume review will then be invited to participate in an oral board interview.
Virtual Oral Board Interviews will be held the week of January 16, 2023 via the Microsoft TEAMs application.
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: 5% of your rating for education and work experience 15% of your resume review 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 Liliana.
Almeraz@tucsonaz.
gov at least 48 hours prior to the evaluation.
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.
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.