AWS Redshift Administrator

Location: Cincinnati, OH (Onsite – 5 Days/Week)
Duration: 12 Months
Client: TCS
Experience: 6–8+ Years

Max Rate: $52/hr CTC or $48/hr W2

Note: Due to ITAR and federal compliance requirements, candidates must qualify as a U.S. Person and be authorized to work in the United States without current or future sponsorship.

Job Description

We are seeking an experienced AWS Redshift Administrator to support enterprise data warehouse environments. The ideal candidate will have strong experience administering Amazon Redshift, managing database security, optimizing performance, and supporting production environments.

Required Skills

• 6+ years of Database Administration (DBA) experience.
• Hands-on experience with AWS Redshift Administration.
• Experience provisioning, configuring, and maintaining Redshift clusters or Redshift Serverless workgroups.
• Strong knowledge of database security, including users, roles, permissions, and schema-level access.
• Experience monitoring database health, workload performance, storage utilization, and operational alerts.
• Expertise in SQL performance tuning, query optimization, workload management (WLM), and resource optimization.
• Experience with backup, snapshot, restore, disaster recovery, patching, and release management.
• Strong troubleshooting skills with production support, incident management, and root cause analysis (RCA).
• Experience supporting database deployments, schema changes, and production releases.
• Ability to create and maintain database documentation, runbooks, standards, and governance processes.
• Experience supporting audit and compliance activities.

Preferred Qualifications

• Experience with SQL Server, Oracle, or PostgreSQL Database Administration.
• Knowledge of AWS services such as CloudWatch and IAM.
• Experience working in Data Warehouse or Business Intelligence (BI) environments.
• Strong communication and collaboration skills.

Responsibilities

• Administer and maintain AWS Redshift environments across development, test, and production.
• Manage database security, user access, and permissions.
• Monitor system performance and optimize database workloads.
• Perform database backups, snapshots, restores, and recovery operations.
• Support production incidents and resolve database-related issues.
• Implement database changes, patches, and releases.
• Develop and maintain operational documentation and best practices.
• Collaborate with application, infrastructure, and business teams to ensure database reliability and performance.