Oracle Database Administrator ( Only Locals to Texas)

Location & Duration

Austin, TX (Hybrid) – Long Term

Responsibilities

• Enter codes to create production database.
• Select and enter codes of utility programs to monitor database performance, such as distribution of records and amount of available memory.
• Direct programmers and analysts to make changes to the database management system.
• Review and correct programs.
• Answer user questions.
• Confer with coworkers to determine impact of database changes on other systems and staff cost.
• Modify database programs to increase processing performance (performance tuning).
• Provide assistance in planning, development, maintenance, and monitoring of integrated database systems, ensuring conceptual and design phases align with structural parameters.
• Evaluate users' requests for new data elements and systems, incorporate them into the existing shared data environment, and provide technical assistance.
• Coordinate the use of data to ensure data integrity, control redundancy, load databases, and reorganize as needed.
• Perform data modeling and prototyping, including logical and physical data modeling, design relational database models, and create physical data models from logical models.
• Perform security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain the data dictionary, ensuring uniformity of definitions and setting standards for its use.
• Monitor database performance and recommend efficiency improvements.
• Create test database environments for applications, including necessary libraries and procedures.
• Execute procedures to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Assist with determining, implementing, and enhancing standards on database security and monitoring agency disaster recovery procedures and systems.
• Assist with the installation of database software and with analyzing, designing, and implementing databases.
• Assist in benchmarking and threshold testing of databases and in establishing and controlling necessary database security.
• Assist in the selection of database management software.
• Ensure user interfaces for database administration and data input/output are compliant with EIR Accessibility standards.
• Provide support to users in obtaining data/information when EIR Accessibility issues arise.

Required Qualifications

• 5+ years of experience with Database Management Systems (DBMS), data warehousing, and decision support tools.
• 5+ years of experience in the development, implementation, and maintenance of data warehouses and data marts.
• 5+ years of experience with Business Objects and building/maintaining data dictionaries.
• 5+ years of experience using database access tools for application delivery.
• 5+ years of experience with analysis, planning, and management reporting functions.
• 5+ years of experience with data warehousing, data population, and data modeling techniques, including star schema, snowflake schema, and normalized data models.
• 5+ years of experience with GUI‑based ETL tools, such as Informatica, IBM WebSphere DataStage, or similar technologies.
• 5+ years of implementation experience with enterprise‑class databases (e.g., Teradata, Oracle, SQL Server, or similar).
• 5+ years of implementation experience with analytical and reporting tools, including Business Objects, Cognos, Hyperion, MicroStrategy, or similar platforms.
• 5+ years of experience across the end‑to‑end data warehouse implementation lifecycle, covering business requirements, logical modeling, physical database design, data sourcing, transformation, loading, SQL, and end‑user tools.
• 5+ years of experience with benchmarking processes and techniques.
• 5+ years of experience demonstrating exceptional analytical, problem‑solving, communication, teamwork, and interpersonal skills.
• 5+ years of experience working effectively with technical and non‑technical groups while managing multiple responsibilities.

Preferred Qualifications

• 5+ years of experience with Oracle Database.
• 5+ years of experience creating Power BI reports.

Knowledge & Skills

• Understanding of computer programming and systems design principles, operations, procedures, project control, cost estimating, programming languages, data‑processing flowcharting, database structures and theories, and current database technologies.
• Working knowledge of EIR Accessibility standards and assistive technologies.
• Ability to ensure user interfaces for database administration and data input/output are compliant with accessibility standards.