Responsibilities
- Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
- Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
- Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
- Develops strategies for data acquisitions, archive recovery, and implementation of a database.
- Cleans and maintains the database by removing and deleting old data.
- Evaluate multiple source systems and analyze to generate a unified data flow model for ETL architecture.
- Serves as the liaison between users and the database management team and any software development/integration teams.
- Must be able to understand and communicate the data requirements of any future infrastructure needs, working with the IT architects to develop an approach that fits the current and planned needs of the organization ("enterprise").
Requirements
- Minimum of 7 years of experience playing the role of database architect.
- Must have an end-to-end vision, and to see how a logical design will translate into one or more physical Databases.
- Able to normalize data and create data models for ETL loads.
- Need to be able to address issues of Data Migration (Validation, Clean-up and Mapping).
- Will need to understand the importance of Data Dictionaries.
- Able to determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients, evaluating current systems.
