• Installation of database software in the servers • Identification of database configuration parameters • Creation of database templates for UAT, Development and Testing environments • Setting up of security profiles, roles, etc • Implementation of latest available and recommended patches based on the analysis of Application Database Setup
• Creation of schemas • Configuration of table space/data files • Addition of users and setting their access privileges • Distribution of the files across the file-systems for the better I/O • Monitoring the application and providing optimal values for memory to achieve the maximum availability of the application
• Providing growth trend analysis of the database on a periodic basis • Identification and establishment of thresholds • Plan for additional forecasted capacity
• Access control • Auditing • Authentication • Encryption that includes both data and backup’s • Creation and publishing of appropriate security standards for the database environment • Vulnerability assessment attempts to find vulnerability holes that could be used to break into the database • Continuous monitoring for compliance with database security • Monitoring of database users’ activities depending on the security strategy • Regular review of permissions granted to individual users and automated processes
• Resolve memory allocation issues • Effective utilization of the available resources • Perform Instance Tuning • Check and configure the change log and audit log • Perform database parameter performance tuning tasks • Perform tuning tasks to prepare for the loading of a large number of users • Analysis SQL’s needs to be tuned. • Analysis locks, latches, and Wait events • Analysis of dead locks
Designs backup and recovery planning strategies in order to recover from any malfunction/data loss in live databases in the shortest possible time interval.
Database Installation:
ReplyDelete• Installation of database software in the servers
• Identification of database configuration parameters
• Creation of database templates for UAT, Development and Testing environments
• Setting up of security profiles, roles, etc
• Implementation of latest available and recommended patches based on the analysis of Application Database Setup
Database configuration activities:
ReplyDelete• Creation of schemas
• Configuration of table space/data files
• Addition of users and setting their access privileges
• Distribution of the files across the file-systems for the better I/O
• Monitoring the application and providing optimal values for memory to achieve the maximum availability of the application
Storage Management & Capacity Planning
ReplyDelete• Providing growth trend analysis of the database on a periodic basis
• Identification and establishment of thresholds
• Plan for additional forecasted capacity
Patches & Upgrades
ReplyDelete• Maintain current knowledge of available patches related to the database
• Identify appropriate patches
Security Management
ReplyDelete• Access control
• Auditing
• Authentication
• Encryption that includes both data and backup’s
• Creation and publishing of appropriate security standards for the database environment
• Vulnerability assessment attempts to find vulnerability holes that could be used to break into the database
• Continuous monitoring for compliance with database security
• Monitoring of database users’ activities depending on the security strategy
• Regular review of permissions granted to individual users and automated processes
Database Tuning
ReplyDelete• Resolve memory allocation issues
• Effective utilization of the available resources
• Perform Instance Tuning
• Check and configure the change log and audit log
• Perform database parameter performance tuning tasks
• Perform tuning tasks to prepare for the loading of a large number of users
• Analysis SQL’s needs to be tuned.
• Analysis locks, latches, and Wait events
• Analysis of dead locks
Backup and Recovery Planning
ReplyDeleteDesigns backup and recovery planning strategies in order to recover from any malfunction/data loss in live databases in the shortest possible time interval.