• Design and planning: Work with development teams on database design, server sizing, capacity planning, and performance testing.
• Design and planning:
• Implementation: Build and configure database servers across all layers, including storage, operating system, and database.
• Implementation:
• Operations: Manage installation, configuration, backup and recovery, replication, and day-to-day monitoring.
• Operations:
• Performance tuning: Find and fix performance bottlenecks to keep systems running well.
• Performance tuning:
• Information lifecycle management: Manage data retention, archiving, and purging in line with company policy.
• Information lifecycle management:
• Security and compliance: Apply and maintain database security controls that meet organizational and industry standards.
• Security and compliance:
• Monitoring and troubleshooting: Track database errors, bugs, and incidents, and resolve them promptly.
• Monitoring and troubleshooting:
• Capacity management: Monitor database usage and growth, and recommend capacity improvements.
• Capacity management:
• Standards and documentation: Develop and maintain DBA standards, procedures, and best practices.
• Standards and documentation: