Senior Consultant | Database Administration | PostgreSQL

POC: Bharath Subramanya ATTENTION ALL SUPPLIERS READ BEFORE SUBMITTING: • UPDATED CONTACT NUMBER and EMAIL ID is a MANDATORY REQUEST from our client for all the submissions • Limited to 2 submission per supplier. Please submit your best. • We prioritize endorsing those with complete and accurate information • Avoid submitting duplicate profiles. We will Reject/Disqualify immediately. • Make sure that candidate's interview schedules are updated. Please inform the candidate to keep their lines open. MANDATORY: Please include in the resume the candidate’s complete & updated contact information (Phone number, Email address and Skype ID) as well as a set of 5 interview timeslots over a 72-hour period after submitting the profile when the hiring managers could potentially reach to them. PROFILES WITHOUT THE REQUIRED DETAILS and TIME SLOTS will be REJECTED. Job title: Senior Consultant | Redshift | Amazon Redshift Production Support Engineer Work Location: Johnston, RI 02919 Vendor Rate: 60 USD/HR Minimum years of experience: 8-10 Would you require the candidates to meet you for in person interview? Is Skype/WebEx interview,OK? Yes Is this onsite/remote position: Onsite If onsite, will you be considering relocation candidates: No Does this position require Visa independent candidates only? Yes Job Description: Amazon Redshift Production Support Engineer responsible for the day-to-day administration, monitoring, performance tuning, incident management, and operational support of enterprise-scale Redshift data warehouse environments. The role involves ensuring platform stability, availability, security, and optimal performance while supporting business-critical analytics workloads. Key Responsibilities 1. Production Support & Operations Provide 24x7 support for Amazon Redshift clusters. Monitor cluster health, availability, and performance. Handle incidents, service requests, and problem management activities. Participate in on-call rotations and production support coverage. Perform issue triage and root cause analysis (RCA). Coordinate with application, ETL, cloud, and infrastructure teams during incidents. Maintain SLA compliance for incident resolution and service requests. 2. Redshift Administration Provision and configure Redshift clusters. Manage cluster upgrades and maintenance activities. Perform node replacement and cluster resizing activities. Configure workload management (WLM) queues. Manage snapshots and backup strategies. Restore clusters during failures or DR testing. Implement parameter group and cluster configuration changes. 3. Having exp in Performance Tuning Backup, Recovery & Disaster Recovery Data Load and ETL Support Capacity Planning Documentation & Knowledge Management Please provide the TOP skills, and the years of experience that you’ll consider: 8-10 yrs 1. Amazon Redshift Production Support 2. Performance Tuning , Backup, Recovery & Disaster Recovery 3. Data Load and ETL Support , Capacity Planning , Documentation & Knowledge Management Project Code: Child code for DB support team within RU