Database Administrator

•Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). •Establishes physical database parameters. •Codes database descriptions and specifies identifiers of database to database management system or directs others in coding database descriptions. •Calculates optimum values for database parameters, such as amount of computer memory to be used by the database. •Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. •Tests and corrects errors, and refines changes to database. •Enters codes to create production database. •Selects and enters codes of utility program 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 corrects programs. •Answers user questions. •Determines impact of database changes on other systems and staff cost for making changes. •Modifies database programs to increase processing performance, referred to as performance tuning. •Responsible for backup and recovery of databases and servers. •Performs SQL code reviews prior to implementation into production systems. •Assists in the hardware configuration of current and new systems in regards to processor types, disk configuration, memory, controller and RAID configuration.