*Position: DB2 DBA* Location: Rancho Cordova, CA * TASKS/RESPONSIBILITIES* Responsible for the logical and physical integrity of the application database environment and the logical and physical database design. Monitors and tunes database performance during testing and production operations; coordinates and implements database sizing/resizing, restructures and index rebuilds; assists with capacity planning for future database growth; documents benchmarks and procedures needed to optimize performance; ensure that all performance guidelines are followed. Reviews and analyzes change requests to determine the scope of work and estimate the level of effort for database changes.
*Writes technical specifications.* Develops and modifies database definitions including entities, attributes, relationships, and referential integrity triggers. Maintains detailed database design documentation. . Develops, maintains and supports procedures, standards and interfaces for centralized database management. Installs, patches, upgrades, maintains, and supports DB2 in all environments. Implements database access procedures including the administration of User IDs. . Implements Database Change Requests (DBCRs), i.e., data repairs. Assists application development and maintenance staff with database questions and issues. Plans and implements strategies and procedures for physical disaster/recovery and contingency planning. Establishes mechanisms for replicating production databases in development environments. Provides problem resolution support, specific to database issues; identifies and resolves database problems, coordinating with application users to determine symptoms and ensure accurate problem definition. Assists in development and improvement of database administration-related plans, processes, procedures, standards and priorities. Maintains detailed knowledge of all database administration processes, procedures, and quality standards *Thanks* *ATTY* || Best way to reach me via reply of this email || -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.
