We are hiring for the role of AWS redshift database administrator.

Title: AWS RedShift Database Administrator

Duration: 6 months

Exp: 5+ years

Details:

Our client is looking to engage a highly skilled Redshift Database Administrator to manage and optimize their data infrastructure. The successful candidate will be responsible for the health, security, and performance of large-scale Redshift environments.

Roles & Responsibilities

Administer and manage large-scale Amazon Redshift clusters (Provisioned & Serverless), including RA3 architecture, WLM configuration, concurrency scaling, and capacity planning.

Drive performance optimization through sort/distribution key strategies, compression tuning (ZSTD/LZO), VACUUM/ANALYZE automation, and query troubleshooting using STL/SVL system tables.

Ensure security, governance, and compliance by implementing IAM RBAC, MFA, encryption (at rest/in transit), VPC security controls, SSO integration, and audit readiness (SOC2).

Own disaster recovery and resilience planning, including automated snapshots, cross-region replication,



RTO/RPO definition, DR drills, and high-availability alignment.

Implement monitoring, logging, and observability frameworks using CloudWatch, S3, SIEM integrations, and proactive alerting standards.

Optimize cost and resource utilization through RA3 migration, managed storage adoption, Reserved Instance planning, tagging governance, and FinOps monitoring.

Collaborate with Data Engineering and cross-functional teams to govern ETL/ELT pipelines (Glue, S3, Lambda, Airflow) and ensure ingestion reliability and schema governance.

Skills Required

Solid expertise in Amazon Redshift administration, including RA3 architecture, WLM configuration, concurrency scaling, Spectrum, and cluster lifecycle management (Provisioned & Serverless).

Advanced performance tuning skills, including sort/distribution key design, compression strategies (ZSTD/LZO), VACUUM/ANALYZE automation, and query diagnostics using STL

📌 AWS RedShift Database Administrator (Uttar Pradesh)
🏢 Sparix Global
📍 Uttar Pradesh