Database Administrator

HMG America - Austin, TX

Full-time - Mid Level

Austin, TX

Professional, Scientific, and Technical Services

About the position

The Database Administrator will be responsible for the planning, development, maintenance, and monitoring of integrated database systems, specifically focusing on the Financial Data Warehouse. This role involves optimizing database performance, implementing modifications, and ensuring data integrity while working with Oracle databases. The candidate will also be tasked with creating and testing new database structures and providing technical assistance to users.

Responsibilities

• Create production databases by entering codes and selecting utility programs to monitor performance.
• Direct programmers and analysts to implement changes to the database management system.
• Review and correct database programs and answer user questions regarding database functionality.
• Modify database programs to enhance processing performance through performance tuning.
• Evaluate user requests for new data elements and incorporate them into the existing data environment.
• Coordinate data usage to ensure integrity and control redundancy, including loading and reorganizing databases as needed.
• Perform logical and physical data modeling, designing relational database models, and creating physical data models from logical data models.
• Implement security recovery procedures and determine database search strategies and storage requirements.
• Maintain a data dictionary ensuring uniformity of definitions and set standards for its use.
• Monitor database performance and recommend efficiency improvements.
• Create test database environments for application sections, including necessary libraries and procedures.
• Execute procedures to save, retrieve, and recover databases from failures.
• Assist with database software installation and analyze, design, and implement databases.
• Benchmark and threshold test databases, establishing and controlling necessary security measures.

Requirements

• 4-7 years of experience in database administration or a related field.
• Experience in Oracle database design, analysis, and performance tuning (6 years required).
• Knowledge of database structures and theories, and current database technologies.
• Experience designing enterprise applications and/or services (6 years required).
• Experience creating technical and functional design documentation (6 years required).
• Experience within the software development lifecycle using Agile methodology (6 years required).
• Experience with multi-tier system/application development (6 years required).
• Familiarity with EIR Accessibility standards and assistive technologies.

Nice-to-haves

• Jira experience (1 year preferred).
• Oracle Certification (1 year preferred).
• Experience with data warehouse applications and/or database reporting features (1 year preferred).

Benefits

• Competitive salary
• Health insurance
• Flexible work hours
• Professional development opportunities