Database Administrator II — Data Warehouse & ETL Expert

Akaasa Technologies; United States; Hybrid; USD 90,000 - 120,000; Full time

Job summary

Akaasa Technologies in Austin, TX is seeking a Database Administrator 2 for a hybrid role. You will support database administration, data warehousing, ETL, and reporting across enterprise environments. Strong SQL, performance tuning, and data modelling experience are essential.

The position emphasizes security, recovery, data integrity, and collaboration with cross-functional teams. Experience with BI tools like Power BI and Oracle databases is required.

Qualifications

• 5+ years of experience in database management and data warehousing.

Responsibilities

• Support planning, development, implementation, maintenance, and monitoring of integrated database systems.
• Create, load, reorganize, and maintain production databases.
• Monitor database performance, memory utilization, and system efficiency.
• Perform database performance tuning, benchmarking, and threshold testing.
• Analyse database changes and assess their impact on applications and staff.
• Develop and maintain logical and physical data models.
• Design relational database models and physical database structures.
• Support data warehouse and data mart development and maintenance.
• Implement data population and modelling using Star/Snowflake schemas and normalized models.
• Work with GUI-based ETL tools like Informatica or DataStage.
• Support data sourcing, transformation, loading, and SQL development.
• Maintain the data dictionary and data definitions standards.
• Establish and maintain database security, backup, and disaster recovery procedures.
• Create and maintain test database environments and procedures.
• Assist with database software installation and design.
• Support database search strategies and storage requirements.
• Provide tech support to users and respond to data requests.
• Collaborate with tech and non-tech teams to resolve complex issues.
• Support analytical/reporting environments with Business Objects, Cognos, Hyperion, MicroStrategy.
• Ensure DB administration interfaces comply with accessibility standards.

Skills

Analytical skills

Problem-solving

Teamwork

Communication

Oracle Database experience

Tools

Informatica

IBM WebSphere DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Akaasa Technologies in Austin, TX is seeking a Database Administrator 2 for a hybrid role. You will support database administration, data warehousing, ETL, and reporting across enterprise environments. Strong SQL, performance tuning, and data modelling experience are essential.

The position emphasizes security, recovery, data integrity, and collaboration with cross-functional teams. Experience with BI tools like Power BI and Oracle databases is required.