IT Database Administrator

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin we are more than just an employerwe are a vibrant community dedicated to shaping one of the nations most dynamic and innovative cities. As we strive to fulfill our commitment as public servants it is important that we ground our efforts in a set of guiding principles Empathy Ethics Excellence Engagement and Equity anchors in delivering services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career contributing to the community and being part of a forward-thinking organization that values every employee.

What Makes the City of Austin Special

• Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation.

• Value and Innovation : Work in an environment where employees are valued and innovation thrives.

• Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave work-life balance programs and extensive benefits.

• Retirement Security: Plan for the future with the City of Austin Employees Retirement System.

• Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure.

• Focus on Wellness: Stay healthy through wellness programs on-site fitness centers and mental health support.

• Career Growth: Advance your skills and expertise with professional development and leadership opportunities.

• Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration.

By joining us you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

Job Description:

IT Database Administrator

Purpose:

This position designs administers maintains secures and improves performance of databases.

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.

Minimum Qualifications:

• Graduation with a Bachelors 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

Preferred Qualifications:

• Experience with Oracle Databases
• Experience with Snowflake
• Experience writing Oracle SQL PL/SQL and Unix scripting.
• Experience with Data Warehousing
• Experience in Data Integration and ETL
• Ability to travel to more than one work location

Notes to Candidate:

Position Overview:

This position will be within the Citys Financial Services IT group which is responsible for the management and support of the Citys 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.

Pay Range:

$80490.00 - $107310.00

Hours:

Monday Friday; 8:00 a.m. to 5:00 p.m.

This position is primarily remote; however you must come into the office anytime it is required.

Location:

124 W 8th St. Austin Texas 78701

Application Details:

• A detailed complete COA employment application is required. It helps us to better evaluate your qualifications and will be used to determine your salary if you are selected for this position.

• Please be sure to detail on the application all previous employment that you wish to be considered as part of your qualifications.

• For each position please describe your specific experience as it relates to the minimum and preferred qualifications.

• A résumé is also required but will not substitute for a complete COA employment are not accepted in place of a completed online application. It is the responsibility of the applicant to provide the detailed and relevant work experience which would qualify them for the position.

• When completing the City of Austin employment application the work experience listed must include a month year and a verifiable Supervisor or Human Resources phone number.

• Incomplete applications will not be considered.

• Each individual who submits an Application as provided in the Municipal Civil Service Rules and meets the Minimum Qualifications for a Competitive Position shall be considered a Candidate for that Position. Employees in Good Standing who are candidates within the Department or division that the Position resides in and who meet the Minimum and Preferred Qualifications (if any) of the Position will be included in the initial interview.

• Use of AI is strictly prohibited to respond to the application and during the interview process.

• Please be aware that the Job Posting Close Date reflects the final day to apply but the posting will close at 11:59 PM the day before the date listed. All application steps including attachments and submission must be fully completed before that time.

Additional Details:

• Austin Financial Services may close this job posting at any time after it has been advertised for seven (7) days please apply as soon as possible if interested.

• This position may require a skills assessment.

• If you are identified as a top candidate verification of your education which may include High School graduation or GED equivalent undergraduate and/or graduate degrees will be required.

• This position will require a pre-employment Criminal Background Investigation (CBI).

• If you are selected as the top candidate for a position we may contact your current and former employer as well as the references.

• If you are identified as a top military candidate or a veteran you must provide a copy of your DD-214.

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.

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.

EEO Statement for City of Austin:

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 addition the City will not discriminate in employment decisions on the basis of an individuals 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.

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 or Texas Relay by dialing 7-1-1.