Database Administrator

The purpose of this classification is responsible for the implementations, maintenance and operational support of the respective partner organizations’ mission-critical GIS database systems (Primary: Oracle, Secondary: Sql Server). Duties include, but are not limited to, conducting performance monitoring, optimizations, and tuning as needed; ensuring database availability, scalability, and overall performance; implementing backup and recovery procedures and disaster recovery strategies; and performing additional duties as assigned by the Geographic Information Officer.

• Ensure effective and efficient database backup and recovery, database creation, database upgrades, and database security.
• Maintain users/rolls/permissions management, performance analysis and tuning, and SQL Log monitoring.
• Troubleshoot databases; create database objects; provide database technical support to developers, system administrators, and end users of various KGIS organizations and their departments.
• Administer the ESRI ArcGIS SDE tier of applications that integrate with the relational database management system.
• Proactively conducts performance monitoring, optimizations and tuning as needed.
• Ensures that the database records are accurate, kept current, and that they conform to standard conventions.
• Provides database related support for application development personnel of City, County, KUB, Knoxville-Knox County Planning and KGIS;
  Architects applications and application changes to support workflows throughout the City, County, KUB, MPC and KGIS, training them on the data quality verification procedures.
• Provides primary support for all desktop applications to personnel within the City, County, KUB, Knoxville-Knox County Planning and KGIS; acts as backup to System Administrator when needed.
  Recommends and develops GIS data warehouse infrastructure architecture (based upon industry Best Practices and specific needs of business workflows of the supported organizations).
• Builds and follows software currency strategies (upgrades and patch management);
• Leads or participates in problem resolution and recovery processes during an outage situation.
• Responsible for significant amounts of translation of data from the various KGIS partnerships, which include adjacent Counties and Utilities, along with private data providers, and ensures its proper incorporation into the KGIS databases.
• Oversees data security and access restrictions as part of KGIS’s gatekeeper role to the various agencies and organizations.

• Education:
  
  Bachelor's Degree
• Certifications (Required By Hire):
  None
• Certifications (Required After Hire): GISP Certification within 12 months
• Experience:
  
  Six (6) years
• Preferences:
  None
• Other Requirements:
  Oracle DB Admin Certification preferred

Any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities may be considered for employment into the position.

• Background check will be conducted prior to hire.

• Geographic Information Systems
• Oracle SQL
• Arc Map
• ESRI ArcGIS Enterprise
• Other various software platforms

• Excellent verbal and written communication skills
• Excellent organization and time management skills
• Proficient in use of Microsoft Office suite of products
• Proficient in use of PCs, tablets, smartphones and other electronic devices
• Excellent problem-solving skills

• Ability to work in a position of high complexity
• Ability to work cooperatively as a member of a team
• Ability to focus and demonstrate great attention to detail
• Additional
  
  Job Functions:
  
  Respond to and report immediately if called upon by local, regional or central office supervisors, as part of a coordinated emergency response by the Knox County Mayor’s Office
• Ensure regular, punctual attendance during scheduled work hours.
• Perform other duties as required.
• None

Work is primarily done in an office setting. Occasional periods of light, physical activity.

Knox County Government is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, Knox County Government may provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.