IT Database Administrator Sr

About This Position Job Description: IT Database Administrator Senior Purpose: This position designs, administers, maintains, secures, and improves 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. 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. Designs, configures, and implements database network connectivity working with required technical teams. Monitors capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation. Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures. Tracks database assets and critical information about those assets. Assists in development of data security standards to ensure data integrity data security. 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. Installs 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 SQL Server 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. Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts 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. 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. Preferred Qualifications: 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 developing administrative automation scripts using shell, PowerShell or similar technologies. Experience administering mission-critical, highly available (24x7) database environments supporting enterprise systems and applications. Experience administering Microsoft SQL Server database supporting commercial off-the-shelf (COTS) applications. Other: The ability to travel to more than one work location. Notes to Candidate: The IT Database Administrator Senior is responsible for the administration, maintenance, security, performance, availability, and recoverability of enterprise database systems. This position serves as both an infrastructure and application database administrator, providing technical leadership for Oracle database environments, including Oracle RAC, ASM, and related database technologies. Responsibilities include database installation and configuration, patching and upgrades, backup and recovery, performance tuning, troubleshooting, monitoring, capacity planning, support of business-critical applications. This position works closely with application teams, systems administrators, vendors, and business stakeholders to ensure reliable, secure and highly available database services supporting the organization. Work Location/Schedule: Austin, Texas 78723 - Hybrid; Monday - Friday, 8:00 a.m. - 5:00 p.m. - 40 Hour Work Week. Additional work hours may be required to support the 24-hour Utility operations, which may include evenings, weekends, holidays, inclement weather, and emergency closures. Salary: $85,120.00 - $109,400.00 annually, depending on qualifications and experience. Employment Application: The City of Austin employment application is an official document; incomplete applications will not be considered. Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications. The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held. Starting salary will be based on overall relevant experience from your application. Rsums will not be accepted and statements such as "see rsum" will not be accepted. You may use "N/A" for fields that are not applicable. Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed. Important Note to Applicants: Please be aware that the Job Posting Close Date reflects the final day to apply , but the posting will close at 11:59 PM the day before the date listed . All application steps, including attachments and submission, must be fully completed before that time. We also recommend that you save or print a copy of the job posting for your records. Once a posting has closed, it will no longer be viewable in the system. Assessments: Your skill level in some of the competency areas for this job may be assessed through skills testing. If you are selected as a top candidate: Verification of your education (which may include high school graduation or GED, undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution. If you are identified as a top candidate and are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date. This position requires a criminal background investigation. Fair Labor Standards Act: This position is classified as EXEMPT (Salaried). Exempt employees are not eligible for overtime compensation. Critical: This position has been designated as an Essential Employee position. 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. In the event of a designated emergency, these positions will be called back or retained to assist with operations and recovery. Essential employee schedules will be modified based on extraordinary situations or emergency conditions and may be assigned to report to a designated work site. The designated work site will be a location of City-owned or City-leased office space to which an employee would traditionally be assigned and report for work, if not teleworking. 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. JOIN THE CITY OF AUSTIN TEAM 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. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles - Empathy, Ethics, Excellence, Engagement, and Equity - that anchor our delivery of services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward-thinking organization that values every employee. What Makes the City of Austin Special? Make a Difference : Join a team driving meaningful change in one of the fastest-growing cities in the nation. Value and Innovation : Work in an environment where employees are valued, and innovation thrives. Competitive Benefits : 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. Sustainable Transportation Options : Commute easily with access to public transit and bike-friendly infrastructure. Focus on Wellness : Stay healthy through wellness programs, on-site fitness centers, and mental health support. Career Growth : Advance your skills and expertise with professional development and leadership opportunities. Modern Workspaces : Work in innovative and sustainable environments that foster collaboration and inspiration. 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. JOIN THE CITY OF AUSTIN TEAM 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. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles - Empathy, Ethics, Excellence, Engagement, and Equity - that anchor our delivery of services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward-thinking organization that values every employee. What Makes the City of Austin Special? Make a Difference : Join a team driving meaningful change in one of the fastest-growing cities in the nation. Value and Innovation : Work in an environment where employees are valued, and innovation thrives. Competitive Benefits : 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. Sustainable Transportation Options : Commute easy with access to public transit and bike-friendly infrastructure. Focus on Wellness : Stay healthy through wellness programs, on-site fitness centers, and mental health support. Career Growth : Advance your skills and expertise with professional development and leadership opportunities. Modern Workspaces : Work in innovative and sustainable environments that foster collaboration and inspiration. 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. EEO Statement for City of Austin: 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. 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 or Texas Relay by dialing 7-1-1. For applications and inquiries, contact:View email address on click.appcast.io #J-18808-Ljbffr