Responsibilities:
• Database Management and Administration: Manage and administer the organization's databases to ensure
optimal performance, security, and availability. Perform regular database maintenance tasks such as backups,
restores, and disaster recovery planning.
• Performance Monitoring and Tuning: Monitor database performance and tune queries, indexes, and
database parameters for optimal performance. Generate and collect database statistics over time to analyze
and improve performance.
• Security and Compliance: Implement and maintain database security policies and procedures to ensure data
integrity and protection. Ensure compliance with regulatory requirements related to data management and
security.
• Backup and Recovery: Implement and maintain database backup and recovery strategies to minimize data
loss and downtime.
• Database Design and Optimization: Collaborate with development teams to design and optimize database
schemas, tables, and indexes. Provide guidance on best practices for database design and data modeling.
• Monitoring and Auditing: Monitor database activity and maintain audit logs to track and report on database
usage. Ensure all actions performed by the DBA are logged in the audit trail as per security and compliance
requirements.
Primary Skills:
Database Administration: Proficiency in administering and managing
RDBMS systems.
• Performance Tuning: Experience in monitoring and tuning database
performance using tools and techniques such as query optimization and
index tuning.
• Backup and Recovery: Knowledge of database backup and recovery
strategies to ensure data availability and integrity.
• Security Management: Understanding of database security principles and
experience in implementing security measures and access controls.
• Data Modeling: Ability to design and optimize database schemas and data
models.
• Monitoring Tools: Familiarity with database monitoring tools and utilities for
performance monitoring and management.
• Compliance: Knowledge of regulatory requirements and best practices
related to data management and compliance.
• Technical proficiency in DB2