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 ResponsibilitiesDatabase AdministrationCreate and maintain production databases; monitor performance metrics such as record distribution and memory utilizationPerform performance tuning to optimize database processingReview and correct programs; direct programmers/analysts on required database changesExecute backup, recovery, and disaster recovery proceduresImplement and enhance database security standards; perform security recovery proceduresDetermine database search strategies and storage requirementsAssist with database software installation, design, and implementationData Warehousing & ETLDesign and implement data warehouses and data martsPerform data modeling and prototyping, including logical and physical data modelsBuild and maintain relational database models using Star Schema, Snowflake Schema, and normalized data structuresDevelop and manage ETL processes using tools such as Informatica or IBM WebSphere DataStageSupport the full data warehouse lifecycle: requirements gathering, logical/physical design, data sourcing, transformation, loading, and SQL performance tuningReporting & Business IntelligenceSupport 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 environmentMaintain the data dictionary and enforce standards for its useCollaboration & SupportConfer with coworkers to assess the impact of database changes on other systems and estimate associated costsAnswer user questions and provide technical assistanceCreate test database environments, including supporting libraries and proceduresAssist with benchmarking and threshold testing of databasesAccessibility ComplianceEnsure database administration interfaces and reporting outputs comply with EIR (Electronic and Information Resources) accessibility standardsSupport users in resolving accessibility-related issues when accessing data or reportsCANDIDATE SKILLS AND QUALIFICATIONSMinimum 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.YearsRequired/PreferredExperience5RequiredStrong knowledge of database management systems, as well as data warehouse management and decision support tools5RequiredExtensive experience in the development, implementation and maintenance of data warehouses and data marts is desired5RequiredExperience in business objects and in building the data dictionary5RequiredAbility to use data base access tools for application delivery5RequiredStrong familiarity with analysis, planning and management reporting functions5RequiredWell-developed oral and written communications skills5RequiredStrong teamwork and interpersonal skills5RequiredExtremely high level of analytical ability where problems are very unusual and extremely difficult5RequiredUnderstanding of benchmarking processes and techniques5RequiredVery high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output5RequiredData Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models5RequiredGUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.5RequiredImplementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.5RequiredImplementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.5RequiredExperience 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 pe5RequiredImplementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.5RequiredExcellent analytical; problem-solving; team playing; and oral and written communication skills.5RequiredProven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.5PreferredOracle Database experience5PreferredPowerBI report creation

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