Austin Aviation - IT Database Administrator Senior

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 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. About Austin-Bergstrom International Airport Owned by the City of Austin and operated by the Department of Aviation, Austin-Bergstrom International Airport is an economic engine, supplying over 74,000 direct and indirect jobs in the Central Texas region. Now, as we build the airports largest improvement program in its history, we are redefining the travel experience in one of the fastest-growing cities in the United States. This is an exciting opportunity to join the team behind Journey With AUS, the airports expansion and development program, where bold ideas, cutting-edge infrastructure, and a shared commitment to excellence are taking flight. Job Description: 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 Bachelors 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 with implementing and supporting Microsoft Hybrid environment, seamless integrating on-premise infrastructure with Azure services. Strong experience with ETL/ELT frameworks (e.g., Apache Airflow, dbt, Azure Data Factory). Hands-on experience with cloud platforms (Azure, AWS, or GCP) Experience working with (SSIS) SQL Server Integrations services, Azure Synapse. Ability to travel. Notes to Candidate: This positions essential duties and functions, may include the following. Other related duties may be assigned. Monitor, analyze, troubleshoot and resolve advanced operational and performance related database issues, coordinate changes, and maintain database structures. Conduct performance tuning, optimization, and capacity planning. Develop and implement robust backup and recovery strategies to safeguard data integrity. Implement and maintain database security measures, including user access controls, encryption, and auditing. Design and implement solutions for high availability and disaster recovery to ensure business continuity. Conduct regular testing of disaster recovery plans to validate effectiveness. Collaborate with technical teams to design, create and implement efficient and scalable database structures including objects, such as tables, indexes, views, triggers, and stored procedures. Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries. Assist in development of data security standards to ensure data integrity data security Develop and maintain scripts and automation tools for routine database tasks. Implement automation for monitoring, alerting, and performance tuning. Plan and execute database software patches and upgrades. Ensure compatibility with existing applications and perform thorough testing. Liaise with vendors and solution architect to understand product road maps, resolve issues, and stay informed. WORK HOURS 40hrs per week; M-F 8:30am 5:30 pm Shift may change according to departmental needs; work hours may include after hours, holidays, and weekend work. SALARY $85,120.00 - $109,400.00 annually TRAVEL This position requires traveling to multiple sites as part of the regular job duties. A driving record verification will be conducted. 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. ASSESSMENT A skills assessment will be required for this position. VETERAN Veteran candidates will be required to provide a copy of their DD214 at the time of interview. ESSENTIAL PERSONNEL This position is categorized as essential personnel. Essential personnel are required to come to work during emergencies or bad weather at the airport if they are scheduled to work and in some cases when they are not scheduled. CRIMINAL HISTORY RECORDS CHECK The top candidate will be subject to a minimum 10 year criminal background check and security threat assessment. GOOD STANDING DEPARTMENT/DIVISION EMPLOYEES Employees, in good standing, who are candidates within the department/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. Department/division employees must remain in good standing through the top candidate selection phase at which time the good standing status will be re-verified. LANGUAGE Must have the ability to read, write, and fluently speak in English. IMPORTANT NOTE TO APPLICANTS Please be aware that the Job Posting Close Date and the final day to apply will be at 11:59 PM the day before the date listed. All application steps, including attachments and submission, must be fully completed before that time. Department may close this job posting at any time after 7 days 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. APPLICATION INFORMATION A detailed and complete employment application is required to help us better evaluate your qualifications and will be used to determine salary if you are selected for this position. Please list your complete employment history, to include all job duties, responsibilities and employment dates on your online application. The application is an official document; incomplete applications will not be considered (i.e., see resume or see LinkedIn profile). Resumes will not be used to qualify for the position and will not be used to recommend salary. Supplemental information or changes to your application will not be accepted after the job posting closes. The responses to the supplemental questions inquiring about experience should be reflected on your application. BENEFITS Working with Aviation provides a number of health and welfare benefits see City of Austin Promotional Benefits Overview and click HERE to learn more. See us in action: Austin-Bergstrom International Airport - AUS - YouTube. 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. 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 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. City of Austin Employment Video