Database Administrator

Position Summary

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

Required Qualifications (5+ Years Experience)

• Strong knowledge of database management systems, data warehouse management, and decision support tools
• Extensive experience developing, implementing, and maintaining data warehouses and data marts
• Experience with Business Objects and building data dictionaries
• Proficiency with database access tools for application delivery
• Strong background in analysis, planning, and management reporting
• Data warehouse population and modeling techniques (Star Schema, Snowflake Schema, highly normalized models)
• Hands-on experience with GUI-based ETL tools (Informatica, IBM WebSphere DataStage, or similar)
• Implementation experience with enterprise-class databases (Teradata, Oracle, SQL Server, or similar)
• Implementation experience with analytical/reporting tools (Business Objects, Cognos, Hyperion, MicroStrategy, or similar)
• Full data warehouse implementation lifecycle experience, including SQL performance tuning
• Excellent analytical, problem-solving, and teamwork skills
• Excellent oral and written communication skills
• Proven ability to work with both technical and non-technical stakeholders while managing multiple responsibilities
• High level of interpersonal skills to collaborate effectively and motivate team output
• Advanced analytical ability to solve unusual and highly complex problems
• Solid understanding of benchmarking processes and techniques

Preferred Qualifications

• Oracle Database experience
• Power BI report creation experience