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 four (4) 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
POSITION OVERVIEW : This position’s 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
ASSESSMENT : A skills assessment will be 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.
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.
VETERAN : Veteran candidates will be required to provide a copy of their DD214 at the time of interview.
GOOD STANDING - DEPARTMENT / DIVISION POSTINGS :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 employee must remain in Good Standing through the Top Candidate Selection phase at which time the Good Standing status will be re-verified.
ESSENTIAL PERSONNEL : This position is categorized as an 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 BACKGROUND CHECK : Top candidate will be subject to a minimum 10 year criminal background check and security threat assessment.
LANGUAGE :Must have the ability to read, write, and fluently speak in English.
WORK HOURS : Shift may change according to departmental needs. Work hours may include after hours, holidays, and weekend work
DEPARTMENT MAY CLOSE THE JOB POSTING AT ANY TIME AFTER 7 DAYS Pay Range
$38.97 - $50.67
Hours
Monday - Friday; 8:30 a.m. - 5:30 p.m.
3 Days on-site with 2 remote days (Telework)
Hours may change depending on departmental needs.
Work hours may include after-hours, holidays, and weekend work
Job Close Date 05/23/2024 Type of Posting External Department Aviation Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location Austin Bergstrom International Airport Preferred Qualifications
Preferred Experience: - Experience with implementing and supporting Microsoft Hybrid environment, seamless integrating on-premise infrastructure with Azure services.
- Strong background in Windows Server Administration, covering both on-premises and cloud-based instances
- SQL Server, PowerShell Scripting, and Virtual Machine expertise.
- Experience working with ( SSIS ) SQL Server Integrations services
- 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.
1. Design, analyze, troubleshoot and resolve advanced operational and performance related database issues, coordinate changes, and maintain database structures, and assist in developing policies and procedures designed to ensure the integrity of the database environment
2. Design, coordinate, implement, and determine procedures necessary to save and recover production databases, and to recover databases from hardware and software failure
3. Perform database performance monitoring and auditing, implement efficiency improvements, and modify existing databases and database management systems
4. Design, configure and implement database network connectivity working with required technical teams.
5. Monitor capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation
6. Create databases and database objects, such as tables, indexes, views, triggers, and stored procedures
7. Track database assets and critical information about those assets
8. Assist in development of data security standards to ensure data integrity data security
9. Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries
10. Create test database environment for applications section, including the creation of necessary libraries and procedures
11. Install new software releases and/or upgrades including researching, testing and implementing new technology
Responsibilities- Supervision 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
• 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
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 (*).
* This position requires a 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 Licenses or Certifications: None. Do you meet these minimum qualifications?
* Please describe your experience with implementing and supporting Microsoft Hybrid environment, seamless integrating on-premise infrastructure with Azure services.
(Open Ended Question)
* Please describe your experience with Windows Server Administration, covering both on-premise and cloud-based instances.
(Open Ended Question)
* Please describe your SQL Server, PowerShell Scripting, and Virtual Machine experience.
(Open Ended Question)
* Do you have experience working with (SSIS) SQL Server Integrations services?
* Do you have the ability to travel to multiple sites as part of the regular job duties?
(Open Ended Question)
* The Transportation Security Administration (TSA-division of the USA Dept. of Homeland Security) requires all employees of the Austin-Bergstrom International Airport to pass a minimum 10-year criminal background investigation and security threat assessment. By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful Criminal Background Check to be hired.
- I acknowledge and understand this position requires a 10-year Criminal Background Investigation and security threat assessment
* Were you referred to this opportunity by a current Aviation employee? If yes, please provide the employee’s full name.
(Open Ended Question)
Optional & Required Documents
Required Documents Optional Documents
