Jobs
>
Austin

    Database Administrator III - Austin, United States - Texas Department of Aging & Disability Services

    Default job background
    Description

    Job Description:



    Designs, develops, enhances, maintains, and supports the databases underlying IT systems utilized by HHSC program areas. Maintains and monitors integrated database systems. Develops and maintains complex models and logical database designs.

    Provides expertise in and participates in the development and implementation of database architectures to meet application performance and security requirements.

    Works with the application development teams, business stakeholders and other partners to enhance existing systems and implement new solutions. Develops goals and objectives for the use and improvement of efficient and cost-effective database systems.

    This position is classified as a fulltime position (40 hours a week). Work outside of regular hours may be required. Travel to other work locations may be required.

    Performs other duties as assigned
    Essential Job Functions:

    Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

    Work outside of regular hours may be required. Travel to other work locations may be required.

    (30%) Perform and support the design, development, tuning and maintenance of databases including structures, performance, security, and recovery. Provide expertise in and participate in the development and implementation of database architectures to meet application performance and security requirements. Develop and maintain complex models and logical database designs. Coordinate with application development and support teams to ensure their needs are met from a database perspective. Participate in the planning, design, administration, operation, monitoring, maintenance, user security, archiving, and system parameters setting for associated database environments.

    (25%) Implement, administer, manage, and monitor assigned application databases in production and non-production environments. Analyze, design, plan and perform database upgrades and maintenance. Monitor database performance and implement improvements. Ensure that data integrity and data security is maintained. Setup views, roles, stored procedures, and database links to allow use of databases while preserving data integrity and maintaining security within established policies, regulations, and guidelines. Assist in the development and maintenance of the database disaster recovery and backup plan. Establish and implement database security controls and user access levels.

    (25%) Identify and resolve issues related to database systems to ensure that systems are online and without service interruption. Perform analysis, troubleshooting, diagnosis, and problem resolution. Analyze software for defects and performance tuning opportunities. Develop and test database code/scripts to restore defects and improve application reliability and performance. Write and debug complex stored procedures and triggers. Develop, maintain, monitor, and troubleshoot batch processes.

    (15%) Provide technical guidance for database related design, development, integration, conversion, and testing work. Educate development teams on database concepts and techniques. Assist with analysis and design of new development, updates, changes, and fixes. Evaluate and recommend database software packages for potential acquisitions. Perform routine and ad hoc report design and development.

    (5%) Other duties as assigned. May include but are not limited to actively participating and/or serving in a supporting role to meet the agency's obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation.

    Such participation may require an alternate shift pattern assignment and/or location
    Knowledge Skills Abilities:

    Knowledge of the principals, practices and techniques of database design and development, database structures and theories and current database technologies.

    Knowledge of data analysis techniques.
    Knowledge of relational databases (e.g., Oracle, SQL Server)
    Knowledge of the principles, practices, and techniques of software development and the full software development life cycle (SDLC).
    Knowledge of computer operations, systems, and procedures.

    Skill in administering Oracle and/or MS SQL databases.
    Skill in performing Extract, transform, and load (ETL).
    Skill in SQL and scripting.
    Skill in technical analysis and design, including database design and planning.
    Skill in complex problem solving and critical thinking.

    Ability to design and develop database systems based on customer requirements
    Ability to coordinate the development and dissemination of technical content for a variety of users.
    Ability to identify and analyze complex business problems and define user needs.
    Ability to process information logically and perform detailed work accurately.
    Ability to work independently and to meet deadlines.
    Ability to manage and coordinate multiple activities in different projects.


  • AECOM Austin, United States

    Company Description · Work with Us. Change the World. · At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's tr ...


  • AECOM Austin, United States

    **Company Description** Work with Us. Change the World.** · At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world' ...


  • Austin Community College Austin, United States

    Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · Austin Community College is a public two-year institution that serves a multicultural population of approximately 41,000 ...


  • Health & Human Services Comm Austin, United States

    **Essential Job Functions**: · Attends work on a regular and predictable schedule in accordance with agency leave policy.- EJF2. Responsible for keeping program data tracking lists current within program system. Tracking lists include enrollment forms from all incoming volunteers ...


  • TEXAS COMMISSION ON ENVIRONMENTAL QUALITY Austin, United States

    **TCEQ - Administrative Assistant III** **(** **)** · **Organization**: TEXAS COMMISSION ON ENVIRONMENTAL QUALITY · **Primary Location**: Texas-Austin · **Work Locations**: Headquarters (582-HQAUS Park 35 Circle Austin 78753 · **Job**: Office and Administrative Support · **Employ ...


  • ChaseSource Austin, United States

    We are seeking an Administrative Assistant III for a State Agency in Austin, TX. · Part-time hours: 4 hours each day (preferably in the morning), Monday – Friday.Flexible start and end times. · Responsibilities: · Converts paper records into digital images by scanning documents: ...


  • ChaseSource Austin, United States

    Job Description · Job DescriptionWe are seeking an Administrative Assistant III for a State Agency in Austin, TX. · Part-time hours: 4 hours each day (preferably in the morning), Monday – Friday.Flexible start and end times. · Responsibilities: · Converts paper records into digit ...


  • IGT Austin, United States

    Systems Administrator III · Location: · Austin, TX, US, 78754 · Requisition ID: 14957 · IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulated segments, from Lotteries and Gaming Machin ...


  • Austin Community College Austin, United States

    Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · If you are a current Austin Community College employee, please click this link to apply through your Workday account. · ...


  • IGT Austin, United States

    Systems Administrator III · Location: · Austin, TX, US, 78754 · Requisition ID: 14957 · IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulated segments, from Lotteries and Gaming Machin ...


  • Texas Department of Aging & Disability Services Austin, United States

    Job Description: · The Texas Health and Human Services Commission (HHSC) seeks highly qualified candidates to fill the Administrative Assistant II position within the Access and Eligibility (AES), Foster Grandparent Program (FGP). AES is driven by its mission to connect Texans to ...


  • Southwest Key Programs Austin, United States

    Job Summary:: · The Systems Administrator is a key role within the Southwest Key Programs IT team. You will be responsible for providing support to all server and network infrastructure, diagnostic and problem resolution for all infrastructure hardware, software and related peri ...


  • IGT Austin, United States

    IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulated segments, from Lotteries and Gaming Machines to Sports Betting and Digital. Leveraging a wealth of compelling content, substantial ...


  • Southwest Key Programs Austin, United States

    Job Summary: · The Systems Administrator is a key role within the Southwest Key Programs IT team. You will be responsible for providing support to all server and network infrastructure, diagnostic and problem resolution for all infrastructure hardware, software and related periph ...


  • Austin Community College Austin, United States Full time

    · Assistant III, Administrative · Austin Community College · Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · If you are a current Austin Community College employee, ple ...


  • Austin Community College Austin, United States Full time

    · Assistant III, Administrative · Austin Community College · Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · If you are a current Austin Community College employee, ple ...


  • Austin Community College Austin, United States Full time

    · Assistant III, Administrative - Music · Austin Community College · Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · If you are a current Austin Community College emplo ...


  • Austin Community College Austin, United States Full time

    · Assistant III, Administrative · Austin Community College · Job Posting Closing Times: Job postings are removed from advertising at 12:00 A.M. on the closing date e.g., at midnight on the day before the closing date. · If you are a current Austin Community College employee, ple ...


  • Southwest Key Programs Austin, United States

    Job Summary: · The Systems Administrator is a key role within the Southwest Key Programs IT team. You will be responsible for providing support to all server and network infrastructure, diagnostic and problem resolution for all infrastructure hardware, software and related peri ...


  • Cap Metro Austin, United States

    WHO WE'RE LOOKING FOR · The Contracts Administrator II/III reports directly to the Manager, Procurement. · This position is responsible for the purchase of high dollar supplies, equipment, services and construction through formal solicitation methods (IFB, RFP, SOQ) using public ...