Manage the firms™ database team with responsibility for planning and managing data collection, data cleaning, and statistical analysis. Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system. Designs logical and physical databases and reviews description of changes to database design to understand how changes to be made affect physical database parameters. Codes database descriptions and specifies identifiers of database to database management system and directs others in coding database descriptions. Calculates optimum values for database parameters such as amount of computer memory to be used by database, following manuals and using calculator. Specifies user access level for each segment of one or more data items such as Insert, replace, retrieve or delete data. Specifies which users can access databases and what data can be accessed by user. Tests and corrects errors, and refines changes to database. Enter codes to create production database. Selects and enter codes of utility programs to monitor database performance such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to database management system. Reviews and correct programs. Answers user questions. Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database. Modifies database programs to increase processing performance, referred to as performance tuning. |
