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