Database Administrator 2

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

CANDIDATE SKILLS AND QUALIFICATIONS

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

5

Required

Strong knowledge of database management systems, as well as data warehouse management and decision support tools

5

Required

Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired

5

Required

Experience in business objects and in building the data dictionary

5

Required

Ability to use data base access tools for application delivery

5

Required

Strong familiarity with analysis, planning and management reporting functions

5

Required

Well-developed oral and written communications skills

5

Required

Strong teamwork and interpersonal skills

5

Required

Extremely high level of analytical ability where problems are very unusual and extremely difficult

5

Required

Understanding of benchmarking processes and techniques

5

Required

Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output

5

Required

Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models

5

Required

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

5

Required

Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.

5

Required

Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.

5

Required

Experience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL pe

5

Required

Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.

5

Required

Excellent analytical; problem-solving; team playing; and oral and written communication skills.

5

Required

Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.

5

Preferred

Oracle Database experience

5

Preferred

PowerBI report creation