Database Administrator | Level IV (Only on W2)

Title: Database Administrator | Level IV

Location: 3 days a week in office at Hartford, CT 06183

Duration: 12 months

Note: Only on W2

Mainframe database skills required, including IMS and Db2 for z/OS. Administers organization's database, using database management system to organize and store data. Determines user requirements, sets up computer databases, and tests and coordinates changes. Activities involve interaction with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases. Ensures performance of database. Typically requires a bachelor's degree in field of specialty. Excludes paraprofessional positions.: Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system. Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database; i.e., 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 database, following manuals. Specifies user access - 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. 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 data base management system. Reviews and corrects programs. Answers user questions. Confers with co-workers 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. Workers typically specialize in one or more types of database management systems. May train users.