Database Administrator

Confidential Jobs; Austin (TX); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Confidential Jobs in Austin, TX seeks an experienced Database Administrator with data warehousing expertise. You will design, implement, and maintain enterprise databases, data warehouses, and data marts.

You will model data using Star and Snowflake schemas, write complex SQL, and tune performance. You will also manage backup/DR, security procedures, and data governance, while supporting ETL processes with Informatica or DataStage and BI tools like Power BI, Business Objects, Cognos, Hyperion,

Qualifications

• 5+ years experience in database administration and data warehousing.
• Experience with enterprise databases (Oracle, SQL Server).
• Proficient with data modeling (star/snowflake).
• Strong SQL skills and performance tuning.

Responsibilities

• Design, develop, implement, maintain, and administer enterprise database systems.
• Develop and maintain data warehouses and data marts.
• Model data using Star/Snowflake/normalized schemas.
• Develop DB objects: tables, views, procedures, queries.
• Perform SQL development, optimization, and tuning.
• Monitor DB performance, resources, and storage.
• Implement backup, recovery, DR, and security procedures.
• Support DB installations, upgrades, migrations, and reorganizations.
• Ensure data integrity and consistent definitions.
• Maintain the data dictionary and collaborate with teams.
• Utilize GUI-based ETL tools and BI platforms.

Skills

Database Admin

Data Warehousing

Data Marts

Star Schema

Snowflake Schema

SQL

Data Modeling

Oracle

SQL Server

BI Tools

Data Dictionary

Performance Tuning

Backup & DR

ETL Tools

Tools

Informatica

IBM WebSphere DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Location: Austin, TX — Hybrid: 3 days onsite (Wed/Thu/Fri), 2 days remote

Key Responsibilities

Design, develop, implement, maintain, and administer enterprise database systems.

Develop and maintain data warehouses and data marts.

Perform logical and physical data modeling, including Star Schema, Snowflake Schema, and normalized data models.

Develop database structures, tables, views, stored procedures, queries, and related database objects.

Perform SQL development, optimization, and performance tuning.

Monitor database performance, memory utilization, storage, and system resources.

Conduct database benchmarking and threshold testing.

Implement database backup, recovery, disaster recovery, and security procedures.

Support database installations, upgrades, migrations, and reorganizations.

Ensure data integrity, minimize redundancy, and maintain consistent data definitions.

Maintain and enhance the data dictionary.

Work with developers, analysts, and business users to determine the impact of database changes.

Use GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar technologies.

Support data extraction, transformation, loading, and data population processes.

Work with analytical and reporting platforms such as Business Objects, Cognos, Hyperion, MicroStrategy, or Power BI.

Translate business requirements into logical and physical database designs.

Provide technical assistance to application development and data/reporting teams.

Support database security standards and disaster recovery procedures.

Create and maintain test database environments.

Troubleshoot database and application-related data issues.

Provide support to technical and non-technical users.

Ensure database administration interfaces and data input/output/reporting solutions meet applicable EIR accessibility standards.

Work effectively with multiple technical and business teams.

Required Skills

5+ years required:

Database Administration / Database Management Systems

Data Warehousing and Data Marts

Data Warehouse implementation

Data population and ETL

Data modeling

Star Schema / Snowflake Schema / Normalized Models

SQL

Enterprise databases such as:

Oracle

SQL Server

Business Objects or similar BI/reporting tools

Data Dictionary

Database access/application delivery tools

Database performance tuning

Benchmarking and threshold testing

Analysis, planning, and management reporting

Database security, backup/recovery and DR

Strong analytical and problem-solving skills