Database Administrator 4

Role: Database Administrator 4

Location: 30 West Spring Street, Columbus, OH 43215

Short Description: 2 days a week onsite. Either Tuesday/Wednesday or Wednesday/Thursday. Please submit top 2 candidates.

Complete Description: Data Modeler should have a sound knowledge of data warehousing with good communication skills. Data Modeler is expected to design models that integrate data from various sources, reduce data redundancy, streamline data movements, and improve enterprise information management.

1. Analyzing and translating business needs into relational data models.
2. Evaluating existing data systems.
3. Working with the business team to create conceptual data models and data flows.
4. Implementing data strategies and developing physical data models.
5. Updating and optimizing local and metadata models.
6. Defining and developing data modeling practices, standards, and guidelines.
7. Creating and managing conceptual, logical, and physical data models and metadata.
8. Working with business/data analysts to define data requirements and design data models.
9. Collaborating with the development team to ensure the database design meets application requirements.
10. Conducting data analysis and quality assurance to ensure data integrity and consistency.
11. Implementing database schema changes and modifications.
12. Documenting data models, metadata, data flows, and data dictionaries.
13. Providing technical support and guidance to users.

1. Bachelor's degree in computer science, information technology, or a similar field.
2. 3 years of hands-on experience with physical and relational data modeling.
3. Knowledge of metadata management and related tools.
4. Excellent communication and presentation skills.
5. Experience with data modeling tools like ERwin, ER/Studio or PowerDesigner.
6. Experience with SQL.
7. Experience with relational databases such as Oracle, SQL Server, or MySQL.
8. Knowledge of data warehousing and business intelligence concepts.
9. Excellent problem-solving skills and attention to detail.
10. Ability to work independently and in a team environment.