Maintain data dictionary, ensuring uniformity of definitions and establishing data dictionary usage standards
Monitor database performance and recommend efficiency improvements
Create test database environments for applications, including necessary libraries and procedures
Execute procedures to save, retrieve, and recover databases from hardware and software failures
Assist with determining, implementing, and enhancing database security standards
Monitor agency disaster recovery procedures and systems
Assist with database software installation and analysis
Participate in benchmarking and threshold testing of databases
Assist in selecting database management software
Ensure user interfaces for database administration and data input/output are compliant with accessibility standards
Provide support to users in resolving accessibility issues
Qualifications
Required
5+ years of experience with strong knowledge of database management systems, data warehouse management, and decision support tools
5+ years of extensive experience in the development, implementation, and maintenance of data warehouses and data marts
5+ years of experience with Business Objects and building data dictionaries
5+ years of ability to use database access tools for application delivery
5+ years of strong familiarity with analysis, planning, and management reporting functions
Well-developed oral and written communication skills
Strong teamwork and interpersonal skills
Extremely high level of analytical ability to address unusual and difficult problems
Understanding of benchmarking processes and techniques
Very high level of interpersonal skills to work effectively with others and motivate team members
Knowledge of data warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
Experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools
5+ years of implementation experience with enterprise-class databases such as Teradata, Oracle, SQL Server, or similar technologies
5+ years of implementation experience with analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools
Experience with the complete data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and transformation, data loading, SQL, and end-user tools
Excellent analytical, problem-solving, team-playing, and oral and written communication skills
Proven ability to work successfully with both technical and non
