IT Database Administrator Senior

Job Description:

IT Database Administrator Senior

Description

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin, we are more than just an employer-we are a vibrant community dedicated to shaping one of the nation's 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 Senior

Purpose:

This position designs, administers, maintains, secures, and improves performance of complex 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.

• Designs, analyzes, troubleshoots, and resolves advanced operational and performance-related database issues; coordinates changes; maintains database structures; and assists in developing policies and procedures designed to ensure the integrity of the database environment.
  
• Designs, coordinates, implements, and determines procedures necessary to save and recover production databases and databases from hardware and software failure.
  
• Performs database performance monitoring and auditing, implements efficiency improvements, and modifies existing databases and database management systems.
  
• Designs, configures, and implements database network connectivity working with required technical teams.
  
• Monitors capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation.
  
• Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures.
  
• Tracks database assets and critical information about those assets.
  
• Assists in development of data security standards to ensure data integrity data security.
  
• Maintains data standards and 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.
  
• Installs new software releases and/or upgrades including researching, testing, and implementing new technology.
  

Responsibilities - Supervisor and/or Leadership Exercised:

May provide leadership, work assignments, evaluation, training, and guidance to others.

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 advanced principles, practices and techniques of secure computer programming, system design, computer operations, systems and procedures.
  
• Knowledge of advanced database structures and theories.
  
• Knowledge of current database technologies.
  
• Knowledge of Oracle and SQLServer database tools, environments and query languages (SQL, TSQL).
  
• Knowledge of statistical analysis processes.
  
• Skill in developing reports and cross references from the data dictionary.
  
• Skill in performing data modeling and prototyping to implement efficiency improvements.
  
• Skill database debugging, testing and troubleshooting techniques.
  
• Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts
  
• 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.
  
• 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 bachelor’s degree from an accredited college or university with major course work in a field related to the job, plus four (4) years of experience in a related field. Experience may substitute for education for up to four (4) years.

Preferred Qualifications:

• Experience using Microsoft SQL Server and Oracle RDMS with fluency in Transact-SQL.
  
• Experience building and optimizing data pipelines using Informatica IDMC (Intelligent Data Management Cloud).
  
• Experience developing, updating, and maintaining dimensional warehouse data models supporting Power BI reporting environments.
  
• Demonstrated ability to work with and support cross functional teams to understand their data and reporting needs and deliver on requirements in an agile manner.
  
• Effectively manage multiple responsibilities, prioritize assignments, and switch quickly between assignments as required.
  
• Ability to travel to more than one work location.
  

Notes to Candidate:

Position Overview:

The IT Database Administrator Senior (Data Warehouse and ETL Developer) role is part of the Austin Capital Delivery Services (ACDS) Technology Division and will develop, construct, test and maintain scalable and durable departmental data solutions including ACDS data mart, capital project data pipelines and reporting/processing systems.

Salary: $85,120 - $109,400

Location: 505 Barton Springs Rd. Austin, TX, One TX Center

Working Hours: Monday - Friday 8:00 AM - 5:00 Telework: Up to 60% teleworking available

Click here to visit our Facebook page to learn more about Capital Delivery Services Department. ( https://www.facebook.com/atxcapitaldelivery/ )

Who Are We:

Capital Delivery Services (CDS ) builds public projects to support the community. We do this by directly managing the City of Austin’s Capital Program with over 600 active projects, representing an investment of over $10 Billion. At CDS, we aim to create an environment that values diversity and adaptability and encourages staff at all levels to think creatively, experiment with new ideas, and contribute to a culture of continuous improvement.

Click here to visit our Facebook page to learn more about the Capital Delivery Services Department. ( https://www.facebook.com/atxcapitaldelivery/ )

Why Join Us?

Meaningful Work
Contribute to projects that improve the lives of the people in our community. Your work directly enables our department to deliver tangible construction projects throughout the city that will resonate for generations to come. Seeing results through a constructed project provides a sense of accomplishment and pride in your work.

Innovation and Collaboration
Collaborate with diverse and talented teams, leveraging technology, continuous improvement, and best practices to drive progress and embrace our One City - One Team - One Approach model of delivering capital projects.

Professional Growth and Development
Achieve your professional goals. CDS offers opportunities to advance in multiple career paths, including engineering, architecture, construction management, project planning and management, finance, business administration, process improvement, and data analytics. Education assistance is available through our tuition reimbursement program, and financial support for continuing education, licenses, and certifications is also available.

Work-Life Balance
Enjoy a balanced lifestyle in a city renowned for its quality of life, outdoor activities, and cultural experiences. Our employees also enjoy the ability to work up to 60% remotely, depending upon position and business needs.

Health and Wellness

The City of Austin is committed to providing cost-effective, sustainable benefits that assist employees in being physically and mentally healthy. For employees that are covered this includes low cost medical, dental, vision, paid leave time, a highly competitive retirement plan, training opportunities and more. Click here to review the City of Austin's Employee Benefits Guide. ( https://www.austintexas.gov/department/active-employee-benefits )

Note: New employees’ health benefits start on the 1st of the month following the effective start date.

To learn more about working with the City of Austin, click here to watch a short video! ( https://www.youtube.com/watch?v=lmXyHwXyMbg )

Application Details:

A detailed, complete City of Austin employment application is required to help us better evaluate your qualifications. For each position, please describe your specific experience as it relates to the minimum and preferred qualifications. Please be thorough in completing the employment application and list all experience that is relevant to this position.

• This position may allow for a resume or cover letter to be included but relevant entries on your employment application will primarily be considered for interview qualification and compensation purposes.
  
• If you are selected as the top candidate for a position, we may be contacting your current and former employer, as well as the references listed in your application. Please be sure you have listed at least 3 previous supervisors in the application with correct contact information.
  

Note:

• 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.
  
• We also recommend that you save or print a copy of the job posting for your records. Once a posting has closed, it will no longer be viewable in the system.
  

Additional Details:

• 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.
  
• The Capital Delivery Services Department 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.
  

Travel:

The Capital Delivery Services Department is comprised of multiple facilities located throughout Austin. If you are selected for this position, and meet the Driver Safety Standards in the City of Austin Driver Record Evaluation 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.

( https://www.austintexas.gov/sites/default/files/files/Employment/new_hire_driver_safety_standards.pdf )

Hybrid Work Environment:

The City of Austin Telework Program is designed to empower employees and leaders to establish hybrid work arrangements that promote high levels of performance and engagement. The City of Austin has an established work arrangement under which an employee is scheduled to work at least 2 days per week at their designated worksite. Some positions may require additional time at their designated worksite.

90 Day Provision for Additional Vacancy:

If the same or an additional vacancy occurs within the Capital Delivery Services Department in the same job title within 90 days after the start date of the top candidate, the additional position may be offered to another top candidate from the same candidate pool. This may include filling other vacancies with the same job title in other division/work locations within the City of Austin, Capital Delivery Services Department. Decisions on assigned selection may be made at the time of hire based on the business needs of the department.

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 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.

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.

Closing Date/Time: 2026-02-16