Description

Job Responsibilities:

We are seeking an experienced Database Administrator with strong expertise in data warehousing, ETL development, and business intelligence reporting to support the planning, development, maintenance, and performance tuning of integrated database systems. This role blends traditional DBA responsibilities with data warehouse architecture and reporting tool implementation, and requires close collaboration with programmers, analysts, and end users to ensure database systems remain secure, performant, and aligned with business needs.

Key Responsibilities

Database Administration

• Create and maintain production databases; monitor performance metrics such as record distribution and memory utilization
• Perform performance tuning to optimize database processing
• Review and correct programs; direct programmers/analysts on required database changes
• Execute backup, recovery, and disaster recovery procedures
• Implement and enhance database security standards; perform security recovery procedures
• Determine database search strategies and storage requirements
• Assist with database software installation, design, and implementation

Data Warehousing & ETL

• Design and implement data warehouses and data marts
• Perform data modeling and prototyping, including logical and physical data models
• Build and maintain relational database models using Star Schema, Snowflake Schema, and normalized data structures
• Develop and manage ETL processes using tools such as Informatica or IBM WebSphere DataStage
• Support the full data warehouse lifecycle: requirements gathering, logical/physical design, data sourcing, transformation, loading, and SQL performance tuning

Reporting & Business Intelligence

• Support analytical and reporting tool implementations (Business Objects, Cognos, Hyperion, MicroStrategy, Power BI)
• Evaluate user requests for new data elements and incorporate them into the shared data environment
• Maintain the data dictionary and enforce standards for its use

Collaboration & Support

• Confer with coworkers to assess the impact of database changes on other systems and estimate associated costs
• Answer user questions and provide technical assistance
• Create test database environments, including supporting libraries and procedures
• Assist with benchmarking and threshold testing of databases

Accessibility Compliance

• Ensure database administration interfaces and reporting outputs comply with EIR (Electronic and Information Resources) accessibility standards
• Support users in resolving accessibility-related issues when accessing data or reports

Key Skills

Education

Any Graduate