city seal

City of Austin - JOB DESCRIPTION

city seal

IT Database Administrator Senior
FLSA: Standard/Exempt EEO Category: (20) Professionals
Class Code: 12225 Salary Grade: LJ5
Approved: April 14, 2014 Last Revised: June 06, 2019

Purpose:
 
Design, administer, maintain, secure, and improve 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.
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
 
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
 
Licenses and Certifications Required:
 

None.

This description is intended to indicate the kinds of tasks and levels of work difficulty required of the position given this title and shall not be construed as declaring what the specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of management to assign, direct and control the work of employees under supervision. The listing of duties and responsibilities shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty.