Database Administrator III

TX-HHSC-DSHS-DFPS • Austin, TX

1d

About The Position

The Database Administrator III 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 full-time 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.

Requirements

• 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.
• Bachelor’s degree or higher in a technology related field is preferred.
• Three years of database administration experience in Oracle database.
• Experience in Application lifecycle support, automation & scripting.

Nice To Haves

• Oracle/SQL Certification is preferred but not required

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.

Benefits

• comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level