Database Administrator 2 (DBA II) - 26-06523

Seeking an experienced Database Administrator 2 to support enterprise database environments, data warehouses, and decision-support systems. The ideal candidate will have extensive experience in database administration, data modeling, ETL processes, performance tuning, database security, disaster recovery, and enterprise reporting environments., * Install, configure, and maintain enterprise database systems

• Support database software upgrades and migrations
• Design, analyze, modify, and maintain database structures
• Develop database backup, recovery, and disaster recovery procedures
• Implement database security controls and user access management
• Monitor database performance and implement tuning improvements
• Design logical and physical database models
• Build and maintain data dictionaries and metadata repositories
• Support data warehouse and data mart implementations
• Develop standards, policies, and procedures for database environments
• Evaluate and recommend database technologies and software solutions
• Assist users with data access and reporting requirements
• Ensure database environments comply with security and accessibility standards
• Support database benchmarking and threshold testing initiatives

Required Technical Skills

Database Technologies

• Oracle Database
• SQL Server
• Teradata
• Enterprise Database Platforms

Data Warehousing

• Data Warehouse Architecture
• Data Marts
• Data Population Strategies
• ETL Development
• Data Integration

Data Modeling

• Logical Data Modeling
• Physical Data Modeling
• Relational Database Design
• Star Schema Design
• Snowflake Schema Design
• Highly Normalized Data Models

ETL & Data Integration Tools

• Informatica
• IBM WebSphere DataStage
• Comparable Enterprise ETL Tools

Reporting & Analytics

• Business Objects
• Cognos
• Hyperion
• MicroStrategy
• Enterprise Reporting Platforms

Database Administration

• Performance Monitoring
• Performance Tuning
• Backup and Recovery
• Security Administration
• User Access Management
• Data Integrity Management
• Database Documentation

Development & Querying

• SQL
• Database Access Tools
• Data Extraction and Transformation
• Database Testing and Validation

Do you have experience in WebSphere?, * 5+ years of database administration experience

• 5+ years of data warehousing and data mart experience
• 5+ years of ETL implementation experience
• 5+ years of data modeling experience
• 5+ years of analytical/reporting platform experience
• Strong knowledge of database management systems
• Experience building and maintaining data dictionaries
• Experience with business intelligence and decision-support systems
• Strong analytical and problem-solving skills
• Excellent verbal and written communication skills
• Ability to work effectively with technical and non-technical stakeholders, * Oracle Database Administration Experience
• SSRS (SQL Server Reporting Services) Report Development
• M204 Database Experience
• Accessibility (EIR) Compliance Experience
• Government or Public Sector Experience

Soft Skills

• Strong teamwork and collaboration
• Excellent communication skills
• High-level analytical thinking
• Ability to manage multiple priorities simultaneously
• Strong documentation skills
• Ability to work independently with minimal supervision