hero

Careers in San Antonio, TX

Explore career opportunities within the San Antonio region.

IT Infrastructure Administrator II - Database Administrator

City of San Antonio

City of San Antonio

IT, Other Engineering
San Antonio, TX, USA
Posted on Dec 6, 2024

Job Summary

Under general supervision, is responsible for ensuring that the performance and availability of the server and network infrastructure is maintained to the highest standard with maximum levels of productivity and efficiency. Supports multiple complex systems, applications, or databases. Analyzes, implements, monitors, and performs maintenance of physical networks, servers, operating systems, firewalls, internet connectivity, virtualization, business applications, and both information and data security. May exercise technical supervision.

Work Location
100 W Houston (City Tower), San Antonio, Texas 78205

Work Hours
7:45 a.m. - 4:30 p.m., Monday- Friday

Essential Job Functions

  • Performs installation, configuration, maintenance, deployment, and release of databases across a platform, including integration testing of PC/server operating systems, related utilities, and hardware.
  • Programs, installs, troubleshoots, repairs, and maintains all aspects of the database environment, to include providing guidance on security and server updates or patches.
  • Manages current database environment by resolving any database shortages, alerting, and resolving any performance issues and ensuring that data is available to all applications across a platform.
  • Establishes enterprise database standards such as file system layout and database installation and creation, etc.
  • Identifies performance problems and malfunctions, addresses system and equipment problems; performs database backup and disaster recovery procedures and contingency plans and establishes requirements, methods, and procedures.
  • Maintains enterprise database documentation.
  • Participaties in security investigations as needed and and internal audits.
  • Capacity Planning: Monitors utilization for capacity planning. Forecasts utilization patterns and recommends modifications or upgrades.
  • Manages Oracle databases.
  • Adds new host machines to the network and administers network security across a platform.
  • Expands networks by setting up new hardware & software and connecting it to the existing assets across a platform.
  • Provides guidance to all initiatives and platforms.
  • Performs related duties and fulfills responsibilities as required.

Job Requirements

  • Bachelor's degree from an accredited college or university.
  • Four (4) years of information technology experience.
Preferred Qualifications
  • Experience with Oracle databases.
  • Experience establishing enterprise database standards such as file system layout and database installation and creation, etc.
  • Experience maintaining enterprise database documentation.
  • Experience providing and evaluating database access tools and techniques to enable information access by business users.
  • Experience participating in security investigations as needed and internal audits.
  • Experience performing database backup and disaster recovery procedures and contingency plans and establishes requirements, methods, and procedures.
  • Experience in Database Design: Analyzes, tests, and implements physical database design for the storage aspects of the database objects (tables, views, procedures, etc.
  • Experience with Capacity Planning: Monitors utilization for capacity planning. Forecasts utilization patterns and recommends modifications or upgrades.
Applicant Information
  • If selected for this position, official transcripts, diplomas, certifications and licenses must be submitted at the time of processing. Unofficial transcripts and copies of other relevant documents may be attached to the application for consideration in advance.
  • Please be advised that if selected for this position, information regarding employment history as it relates to the qualifications of the position will be needed for employment verification. Applicants claiming military service to meet the experience requirement for this position may attach a DD214 to the application.
  • Unless otherwise stated, applicants are permitted to substitute two years of related full-time experience for one year of higher education or one year of related higher education for two years of experience in order to meet the minimum requirements of the job. One year of full-time experience is defined as 30 or more hours worked per week for 12 months. One year of higher education is defined as 30 credit hours completed at an accredited college or university.
  • Applicants selected for employment with the City of San Antonio in this position must receive satisfactory results from pre-employment drug testing and background checks. If required for the position, a physical, motor vehicle record evaluation, and additional background checks may be conducted.

Knowledge, Skills, and Abilities

  • Knowledge of industry leading practices in Technical Administration of on-premises, virtual, remotely hosted, and cloud solutions.
  • Knowledge of server operating systems.
  • Skill in supporting server virtualization technologies.
  • Skill in performing patch management.
  • Skill in problem solving and troubleshooting.
  • Skill in performing system and software upgrades, patches, etc., by documenting and coordinating changes through a formal change management process.
  • Skill in monitoring vital system statistics and implementing corrective actions.
  • Ability to perform all the essential functions of the position, with or without accommodations.
  • Ability to work primarily in an office environment.