Maintains and documents procedures for ensuring the integrity of the company databases. Designs data models and flow chart diagrams identifying the flow of relevant data with an emphasis on data transformation between respective systems. Controls data access via software configuration and authentication/authorization of user specific security. Identifies database capacity issues, replication, and other distributed data issues. Analyzes database architecture to ensure that company goals are being met with respect of cross system coherency. Familiar with standard concepts, practices, and procedures within a range of database vendors and products.
1. Assumes responsibility for effectively coordinating and performing the analysis, design, and maintenance of database systems at a procedural level. a. Analyzes database requirements and pursues implementation of a relational database design at a physical level. Defines the associated mappings between the internal and conceptual schemas. Analyzes, reviews, and enhances the architecture to increase operating efficiency or adapt to new requirements.
b. Performs a variety of administration tasks including documentation and analysis of database objects. Maintains a high level understanding of various data elements including the sources of relevant data for each of the respective systems.
c. Produces comprehensive diagrams and charts to represent current and proposed systems and their interrelations with one another. Prepares program specifications to communicate system and program designs to others.
d. Maintains data dictionary by revising and providing meta-data information.
e. Identifies database characteristics by monitoring and projecting future database needs such as location, amount of free space, and user access methods.
f. Duties include various ETL (Extract, Transform, Load) operations to keep related systems in sync and loaded with relevant data for end user access.
2. Assumes responsibility for establishing and maintaining good communication and coordination with developers and end users. a. Responds to both developer and user requests and follows through promptly.
b. Resolves problems and concerns. Provides assistance, support, and training to users as required.
c. Ensures that interactions with users are clear, courteous, and understandable.
d. Communicates as much information as possible to developers/users, including reasons for problems, project status, and deadlines.
e. Acts as a consultant and resource to developers, users, management and focus groups.
3. Assumes responsibility for establishing and maintaining effective communication, coordination, and working relations with area staff and management. a. Keeps management informed of significant problems and of progress attained in reaching established objectives. Provides recommendations to establish new and/or more effective database transformation methods.
b. Assists and supports Information Systems personnel as needed. Coordinates, directs, and trains others as needed.
c. Prepares reports of data growth and performance issues, discussing changes and their ramifications. Completes records and other required documents.
d. Attends and participates in meetings and committees as required.
4. Assumes responsibility for related duties as required or assigned. a. Stays informed of changes in database administration and computer technology.
b. Keeps work area clean, secure, and well-maintained.
c. Completes special projects as assigned.
Training/Education/Certification: College education in computer science or related field or an equivalent combination of training and experience in like areas. Required Knowledge: Understanding of Credit Union operations and information needs. Familiarity of data architecture and information systems. Knowledge of business software applications. Experience Required: At least 1 year of related experience, preferably in a financial environment. Experience using Windows, Linux, & Unix operating systems Knowledge and experience using relational databases: Oracle, DB2, MS-SQL Server. Adequate SQL knowledge for basic query analysis. Familiarity of Business Intelligence and analytical type processes. Understanding of relational database architecture. Experience with data extracts and transformations for loading data. Preferred work experience using SQL Server Integration Services. Documentation skills including related database flow charting fundamentals. Skills/Abilities: Strong analytical and problem-solving skills. Well organized. Solid project management abilities Good communication skills. Ability to assist and train others. Work well with and communicate with people. Be self motivated and creative Be flexible, responsive and work effectively under pressure. Understand complex issues and solve problems. Motivate and direct the efforts of others, lead teams and projects. Communicate complex ideas to others clearly. Comprehend complex multi-program, multi-dimension systems.
