Austintexas

IT Database Administrator Sr

Austin Energy Headquarters · Senior

Sponsorship not specified$85k-$109kDetected 27 days ago

PowerShellSQLLinuxData EngineeringStatisticsAuditingPublic HealthLeadershipCollaboration

About the role

Duties, Functions and Responsibilities: Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following.
Supervisor and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others.
Other: The ability to travel to more than one work location.

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.
Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures.
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.
include database installation and configuration, patching and upgrades, backup and recovery, performance tuning, troubleshooting, monitoring, capacity planning, support of business-critical applications.
The City of Austin employment application is an official document; incomplete applications will not be considered.

Additional work hours may be required to support the 24-hour Utility operations, which may include evenings, weekends, holidays, inclement weather, and emergency closures.
All application steps, including attachments and submission, must be fully completed before that time.
Designs, configures, and implements database network connectivity working with required technical teams.

Experience administering Oracle Enterprise database in Linux and/or IBM AIX environments, including installation, configuration, patching, upgrades and lifecycle management.
Experience with Oracle high-availability technologies, including Real Application Clusters (RAC), Automatic Storage Management (ASM) and Oracle Data Guard.
Experience designing, implementing, and supporting Oracle backup, recovery, business continuity, and disaster recovery solutions utilizing RMAN and related technologies.
Experience with Oracle Multitenant Architecture, including Container Databases (CDB) and Pluggable Databases (PDB).
Experience monitoring, troubleshooting, and tuning Oracle database environments, including SQL performance tuning, execution plan analysis, and capacity planning.
Experience designing, implementing and supporting Oracle Goldengate replication and change data capture.
Experience installing, configuring, and utilizing Oracle Enterprise Manager (OEM) and other enterprise monitoring tools.
Experience administering mission-critical, highly available (24x7) database environments supporting enterprise systems and applications.

Knowledge of industry and department best practices, requirements and policies and procedures.
Knowledge of advanced database structures and theories.
Knowledge of current database technologies.
Knowledge of Oracle and SQL Server database tools, environments and query languages (SQL, TSQL).
Knowledge of statistical analysis processes.
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.

$85,120.00 - $109,400.00 annually, depending on qualifications and experience.
Starting salary will be based on overall relevant experience from your application.
This position is classified as EXEMPT (Salaried). Exempt employees are not eligible for overtime compensation.

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.
Essential Employees provide services that impact the public health, safety, utility services, and welfare of members of the Austin community and other employees and ensure the continuity of essential operations.
Focus on Wellness: Stay healthy through wellness programs, on-site fitness centers, and mental health support.

At the City of Austin, we are more than just an employer-we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities.
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.
Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications.

This listing is sourced directly from Austintexas's careers page and normalized into a canonical job model.