Database Administrator

This is a 6-month contract position for a Database Administrator based in Austin, Texas. You will be responsible for designing, implementing, maintaining, and monitoring integrated database systems, ensuring data integrity, and optimizing database performance across enterprise-class environments.

Responsibilities

• Enter codes to create and manage production databases
• Select and enter utility program codes to monitor database performance, including distribution of records and available memory
• Direct programmers and analysts to make changes to database management systems
• Review and correct database programs
• Answer user questions and provide technical assistance
• Confer with coworkers to determine the impact of database changes on other systems and associated costs
• Modify database programs to increase processing performance through performance tuning
• Provide assistance in the planning, development, maintenance, and monitoring of integrated database systems
• Evaluate user requests for new data elements and systems, incorporating them into the shared data environment
• Coordinate data usage to ensure data integrity and control redundancy; load and reorganize databases as needed
• Perform data modeling and prototyping, including logical and physical data modeling
• Design relational database models and create physical data models from logical models
• Perform security and recovery procedures
• Determine and implement database search strategies and storage requirements
• 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