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

The IT Database Administrator Sr leads the Information Systems team of Business Technology Unit and will support the department's commitment data informed decision making. The mission of the Information Systems team is to collect, analyze, store, and disseminate actionable information to all stakeholders. In particular this unit is working to grow the departments open data footprint. This position will facilitate data transparency, access and analysis of a wide breadth of both law enforcement and organizational data. This position will support a wide range of business units including but not limited to Human Resources, Emergency Communications, Internal Affairs, Victim Services, Crime Analysis, Executive Staff, and District Representatives. We are looking for a teammate who is not only passionate about data but also putting that data into action.

City of Austin Application:

A complete and detailed 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 and education that is relevant to this position. Starting salary will be based on overall relevant experience and education. Application must include job titles, job duties performed, full or part time status. Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment or computer software used.

A resume and cover letter must be submitted to be considered for this position but will not substitute for a complete employment application. Please verify the employment history dates on your resume exactly match your online application.

CBI :

Must pass a Criminal Justice Information Systems ( CJIS ) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions. Please Click here to find more information.

Secondary Employment:

All Austin Police employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee's duty and responsibility to the Department.

• APD must review all secondary employment.
• Employees are required to submit a Secondary Employment Application for review and approval upon being hired with APD , as well as current APD employees considering Secondary employment.

Benefits:

Working with the Austin Police Department provides a number of health and welfare benefits, such as medical, paid leave time, retirement plan, training opportunities and more. Please click here to find more information.

To learn more about working with the City of Austin, click here to watch a short video!


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.

EEO /AA statement:

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

Preferred Qualifications

• Experience with APIs
• Experience with data design and documentation tools and processes (SparxEA, E/R studio etc,)
• Experiance with M365 (PowerAutomate, PowerApps)

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