Database Administrator | Mainframe DBA

Share your Profile:

narsimha.Reddy@Itechsolutions.com

(703) 286 -7774 - Ext 449

Title: Database Administrator | Mainframe DBA

Location: Hartford, CT, United States

Duration: 12+ Months

Description

· 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