IT Database Administrator

Full-time 8 months ago
Employment Information
Position Information

Posting Title
IT Database Administrator

Job Requisition Number
COA091422

Position Number
108309

Job Type
Full-Time

Division Name
FSD-FSIT-Financial Systms & IT

Minimum Qualifications
Education and/or Equivalent Experience:
  • Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job, plus two (2) years of experience in a related field.
  • Experience may substitute for education for up to four (4) years.


Licenses or Certifications:
  • None.

Notes to Applicants


THE DEPARTMENT MAY CLOSE THIS JOB POSTING AT ANY TIME AFTER 7 DAYS.

The Financial Services Department serves as a trusted steward of public resources with integrity and accountability to ensure a fiscally sound city.

Position Overview

This position will be within the City’s Financial Services IT group, which is responsible for the management and support of the City’s financial, payroll, and timekeeping systems, databases, internal and external web applications, desktop, and network support. This position will require the applicant to work cohesively in a teleworking team environment. Supporting custom applications and interfaces. Also, supporting the central payroll, timekeeping, and financial and accounting applications. This position is eligible for teleworking with approval.

Ninety (90) day provision for additional vacancy

When the same or an additional vacancy occurs within a department in the same job title within 90 days after the start date of the top candidate, the hiring department may offer the additional position to another candidate from the same candidate pool.

Application Instructions and Top Candidate Requirements
  • A detailed and complete Employment Application is required.
  • Resume and Cover Letter are required and will not be accepted in lieu of a complete online Employment Application.
  • Employment history dates on resume should match online Employment Application.
  • Employment history dates must include month and year. Please include contact information from previous employers.
  • Candidates will be subject to a skills assessment.
  • The candidate selected for this position may be required to provide proof of education.
  • This position will require a pre-employment Criminal Background Investigation.
Travel

If you are selected for this position and meet the Driver Safety Standards in the City of Austin Driver Safety Program, you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations.

Working with the City of Austin provides a number of health and wellness benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, training opportunities and more. Please click HERE for more information.

Pay Range
$37.14 – $47.35

Hours
Monday – Friday: 7:45 a.m. to 4:45 p.m.

Telework opportunities may be available after an initial training period. Work schedules are implemented to meet the requirements of the department and are subject to change based on business needs.

Job Close Date
04/19/2024

Type of Posting
External

Department
Financial Services

Regular/Temporary
Regular

Grant Funded or Pooled Position
Not Applicable

Category
Technical

Location
Municipal Building, 124 W. 8th St.

Preferred Qualifications
Preferred Experience:
  • Experience with Oracle Databases
  • Experience writing Oracle SQL, PL/SQL, and Unix scripting.
  • Experience with Data Warehousing
  • Experience in Data Integration and ETL

Duties, Functions and Responsibilities
Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.
  • Create databases and database objects, such as tables, indexes, views, triggers, and stored procedures
  • Load databases, reorganize as necessary, and assist in monitoring, troubleshooting and resolving operational and performance related database issues
  • Execute the procedures necessary to save, retrieve, and recover databases from hardware and software failures
  • Configure and implement database network connectivity working with the required technical teams
  • Ensure data integrity, and data security
  • Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries
  • Create test database environment for applications section, including the creation of necessary libraries and procedures
  • Assist with the installation of database software and with analyzing, designing, and implementing databases
  • Assist with designing and maintaining database structures
  • Assist in developing and implementing standards.

Responsibilities- Supervision and/or Leadership Exercised:
  • None.

Knowledge, Skills and Abilities
Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.
  • Knowledge of industry and department best practices, requirements and policies and procedures.
  • Knowledge of the principles, practices and techniques of computer programming, system design, computer operations, systems and procedures.
  • Knowledge of database structures and theories.
  • Knowledge of current database technologies.
  • Knowledge of Oracle and SQLServer database tools, environments and query languages (SQL, TSQL).
  • Skill in developing reports and cross references from the data dictionary.
  • Skill in data modeling.
  • Skill database debugging, testing and troubleshooting techniques.
  • Ability to write Extraction, Transform and Load (ETL) or SSIS tasks for the Extraction, Transformation or Loading (ETL) process.
  • Ability to gather, assemble, correlate, and analyze facts.
  • Ability to perform a root cause analysis.
  • Ability to assess future information needs so that the databases can evolve in an appropriate manner.
  • Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs.
  • Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals.
  • Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability.
  • Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding.
  • Ability to define, analyze, and find solutions for difficult or complex problems.
  • Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts.
  • Ability to view the big picture.
  • Ability to quickly become familiar with emerging technologies.
  • Ability to identify trends as well as isolated events.

Criminal Background Investigation
This position has been approved for a Criminal Background Investigation.

EEO/ADA
The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.

The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS, AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

Information For City Employees: If you are an employee within
the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview.

New Things Will Always
Update Regularly