Redshift Administration

Although Redshift requires far less maintenance and administrative overhead than traditional data warehouse platforms, and automates vacuum, analyze, table sort and table optimization by default, there are still administration requirements to ensure stability, security and cost control in your Redshift environment. Our expert Redshift DBA services can provide best-practice implementation and ongoing management of your Redshift environment. These Redshift DBA services include:

• Definition and configuration of the Redshift security model: IAM identity, role-based access control, row-level and column-level security, dynamic data masking, and Lake Formation permissions for shared and external data
• Provisioned cluster and Serverless workgroup configuration: node types, base and max RPU, usage limits and query limits
• Monitoring and tuning Redshift's automatic maintenance (auto vacuum, auto analyze, automatic table sort and Automatic Table Optimization), with manual intervention only where the automation is not keeping up
• Auto WLM configuration with query priorities and query monitoring rules
• Snapshot and disaster recovery: automated and manual snapshots, cross-region copy, restore testing and recovery point objectives
• Cross-account and cross-region data sharing governance: which namespaces publish, who consumes, and how usage is charged back
• Patch-cycle and maintenance-window management, and review of release notes for changes that affect your workloads
• Complex Redshift configuration settings and parameter groups

...See More Redshift Services