Database Administrator 2 (DBA II) 26-06523

Database Administrator 2 (DBA II)

Location - Austin TX

Position Overview

Seeking an experienced Database Administrator 2 to support enterprise database environments data warehouses and decision-support systems. The ideal candidate will have extensive experience in database administration data modeling ETL processes performance tuning database security disaster recovery and enterprise reporting environments.

Experience Level: 47 Years

Key Responsibilities

• Install configure and maintain enterprise database systems
• Support database software upgrades and migrations
• Design analyze modify and maintain database structures
• Develop database backup recovery and disaster recovery procedures
• Implement database security controls and user access management
• Monitor database performance and implement tuning improvements
• Design logical and physical database models
• Build and maintain data dictionaries and metadata repositories
• Support data warehouse and data mart implementations
• Develop standards policies and procedures for database environments
• Evaluate and recommend database technologies and software solutions
• Assist users with data access and reporting requirements
• Ensure database environments comply with security and accessibility standards
• Support database benchmarking and threshold testing initiatives

Required Technical Skills

Database Technologies

• Oracle Database
• SQL Server
• Teradata
• Enterprise Database Platforms

Data Warehousing

• Data Warehouse Architecture
• Data Marts
• Data Population Strategies
• ETL Development
• Data Integration

Data Modeling

• Logical Data Modeling
• Physical Data Modeling
• Relational Database Design
• Star Schema Design
• Snowflake Schema Design
• Highly Normalized Data Models

ETL & Data Integration Tools

• Informatica
• IBM WebSphere DataStage
• Comparable Enterprise ETL Tools

Reporting & Analytics

• Business Objects
• Cognos
• Hyperion
• MicroStrategy
• Enterprise Reporting Platforms

Database Administration

• Performance Monitoring
• Performance Tuning
• Backup and Recovery
• Security Administration
• User Access Management
• Data Integrity Management
• Database Documentation

Development & Querying

• SQL
• Database Access Tools
• Data Extraction and Transformation
• Database Testing and Validation

Required Qualifications

• 5 years of database administration experience
• 5 years of data warehousing and data mart experience
• 5 years of ETL implementation experience
• 5 years of data modeling experience
• 5 years of analytical/reporting platform experience
• Strong knowledge of database management systems
• Experience building and maintaining data dictionaries
• Experience with business intelligence and decision-support systems
• Strong analytical and problem-solving skills
• Excellent verbal and written communication skills
• Ability to work effectively with technical and non-technical stakeholders

Preferred Qualifications

• Oracle Database Administration Experience
• SSRS (SQL Server Reporting Services) Report Development
• M204 Database Experience
• Accessibility (EIR) Compliance Experience
• Government or Public Sector Experience

Soft Skills

• Strong teamwork and collaboration
• Excellent communication skills
• High-level analytical thinking
• Ability to manage multiple priorities simultaneously
• Strong documentation skills
• Ability to work independently with minimal supervision

For more details reach at