IT Database Administrator (For Watershed Employees Only)

Job Description:

IT Database Administrator (For Watershed Employees Only)

Description

Minimum Qualifications

• 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 and Certifications Required:
None.
Notes to Applicants
DEPARTMENT OVERVIEW :
Please learn more about our department and how we serve our community: What does the Watershed Protection Department do?

POSITION OVERVIEW :
The purpose of the position is to maintain and enhance the databases we use to process and store discrete and time-series data for environmental quality. This position requires someone with environmental science understanding, broad technical expertise and a desire to understand and learn skills related to database operations and IT applications. Candidate must be comfortable working creatively through data problems and with teammates to learn new systems with the end goal of supporting our environmental scientists and data modelers.

This position leverages a candidate’s understanding of databases - tables, joins, primary and foreign keys - and a willingness to learn to execute existing workflows and to adapt, develop and implement improved workflows and code to support a variety of database systems.

In this position the selected candidate will work with a diverse team of technical and scientific professionals from a variety of backgrounds and disciplines. The position requires performing in-the-field and desk audits of the tools we provide to monitoring staff in order to ensure that any challenges are appropriately elevated and addressed.

Primary databases are a custom Oracle 19c Oracle Application Express database and Kisters’ Hydstra v14. In addition to these storage systems we utilize temporary systems including MySQL, Postgres and MS SQL Server Express to facilitate the collection of data from remote third-party systems. Duties include:
* programming bug identification and solution implementation
* identifying requirements for new views and/or tools to solve emergent problems and facilitate collaboration
* assist business units in specifying appropriate data structures to store new types of data
* assist in the creation of clearly written documentation that can be used to keep systems functioning properly.

EDUCATION :
Verification of education will be conducted on the top candidate.

ASSESSMENTS :
The candidate selected to interview is subject to pre-employment screening assessments to evaluate skill levels and competencies required for this position.

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.

BENEFITS :
Working with the City of Austin provides a number of health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. Please click here for more information.

ABOUT YOUR EMPLOYMENT APPLICATION (Please read carefully):
When completing the City of Austin Employment Application:

• Include details on the application or prior or current work history with the City of Austin.
• A cover letter is required. It does not substitute for a complete employment application.
• A detailed and complete employment application will help us better evaluate your qualifications and will be used to determine salary if you are selected for this position.
• Include details on the application of any previous employment that you wish to be considered as part of your qualifications and relevant experience. Provide each job title and employment dates for all jobs on the application. Your work history should include duties you performed. “See Resume” is not acceptable and your application will be considered incomplete.
• Work history must include the month and year of employment and whether it was full or part-time work.
• Any relevant work history on the resume must also be reflected in the employment application in order to be considered.

Pay Range
$37.63 - $47.98
Hours
Monday - Friday, with the ability for a 50% telework schedule per week after initial training period. Exceptions may apply subject to the business needs of the department.

May require working outside of normal business hours, including emergency events, evenings, weekends, and holidays as dictated by business needs.
Job Close Date 05/01/2025 Type of Posting Departmental Only Department Watershed Protection Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 505 Barton Springs Road, Austin, Texas 78704 Preferred Qualifications

• This position requires broad experience with Oracle Database (19c), Postgres, MySQL, and Microsoft SQL Server including the development of custom schemae, tables, views, materialized views, triggers, sequences, scheduled batch jobs in each of these different systems and managing the synchronization of dev, test and production instances.
• The ability to understand and extend code written in PL/ SQL , PHP , Powershell, Python, R and Javascript and effectively use related tools including Oracle SQL Developer, R-Studio, pgAdmin, phpMyAdmin.
• The ability to accompany field crews for various data collection excursions and develop/enhance an understanding of the implicit requirements for the data collection and storage tools that we develop and support.
• Ability to travel to more than one work location.

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.

Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures. Loads databases, reorganizes as necessary, and assists in monitoring, troubleshooting, and resolving operational and performance-related database issues. Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures. Configures and implements database network connectivity working with the required technical teams. Ensures data integrity and data security. Maintains data standards, prepares, and develops database documentation, procedures, and definitions for data dictionaries. Creates test database environment for applications section, including the creation of necessary libraries and procedures. Assists with the installation of database software and with analyzing, designing, and implementing databases. Assists with designing and maintaining database structures. Assists in developing and implementing standards.

Responsibilities - Supervisor 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 does not require a Criminal Background Investigation EEO/ADA
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.

Supplemental Questions

Required fields are indicated with an asterisk (*).
* The minimum qualifications for this position includes 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. Do you meet these minimum qualifications?

• Yes
• No

* Are you a current employee for the Watershed Protection Department?

• Yes
• No

* Please describe your experience with database software, such as Oracle Database, Postgres, MySQL, or Microsoft SQL Server.
(Open Ended Question)
* Please describe your experience with writing code in PL/SQL, PHP, Powershell, Python, R, and/or JavaScript and/or with using their related tools, including Oracle SQL, Developer, R Studio, pgAdmin, or phpMyAdmin.
(Open Ended Question)
* Please describe your experience with electronic data collection in the field using iPads or other digital devices.
(Open Ended Question)
* Do you have the ability to travel to multiple sites as part of the regular job duties?
(Open Ended Question)


Optional & Required Documents

Required Documents Optional Documents