What are the responsibilities and job description for the IT Database Administrator Senior position at City of Austin?
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 will be responsible for installing, configuring, managing and maintaining Microsoft SQL Databases hosted in a VM / Windows environment and Microsoft Azure environment. The position will communicate directly with customers to understand, document and fulfill their database requirements. In addition to the technical skills required for the job, the position will coordinate and participate in meetings, effectively communicate technical concepts to both technical and non-technical audiences, guide vendors and offer advice and recommendations on proposed solutions. This position will assist with the implementation and management of the Enterprise Data Services Microsoft Azure Cloud Tenancy and will provide ongoing maintenance and support to ensure that MS SQL systems are kept up to date with the latest software versions and patches.
About the Department :
The City of Austin Communication and Technology Management ( CTM ) Department provides and empowers the City's business partners and Austin's residents, visitors and businesses with sustained, reliable, and efficient technology services, infrastructure, and telecommunications. By leveraging state-of-the-art tools, innovative methods, and strategic partnerships, we are at the center of shaping the City of Austin's IT strategy.
Application Instructions : In completing your job application, be sure to provide a COMPLETE employment history including past job titles, employment dates and a detailed summary of your job duties, functions, responsibilities, and skills / abilities. A detailed and complete job application is required to help us determine base pay in the event you are selected for this position.
NOTE : A cover letter and / or resume will NOT be accepted. Once a position is closed, no additional applications or application changes will be accepted.
All interviews are being conducted virtually via Microsoft Teams.
Skills Assessment(s) may be required as part of the recruitment process.
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.
Critical : This position has been designated as a Critical Employee position. Critical employee is necessary and vital and supports activities that impact City or department operations. This work can be done while at a designated worksite or while working at al alternate work location. Critical employees may be reassigned to another area to provide essential services to support any extraordinary situations or emergency conditions.
Fair Labor Standards Act :
This position is classified FLSA Exempt. Exempt employees are salaried and are not eligible for overtime compensation.
Post Interview Verification : If you are selected as the top candidate for a position, we will be contacting your current and former employers, as well as the references listed in your application. Please do your best to ensure that the contact information on the application is accurate. Top candidates will also be required to provide proof of education from an accredited organization, copies of any professional licenses or certificates listed on the minimum or preferred qualifications and a copy of your DD-214 if claiming veteran's preference.
Working with the City of Austin provides a number of benefits, including medical, paid leave time, a great retirement plan, training opportunities and more! Click here for more information.
Preferred Qualifications
Preferred Experience :
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.
Criminal Background Investigation This position does not require 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.
