Senior Consultant | Database Administration | PostgreSQL

IMCS Group Inc

Johnston, RI(remote)

JOB DETAILS
SKILLS
Business Support, Call Centers, Capacity Management, Consulting, Customer Support/Service, Data Recovery, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Disaster Recovery, Diversity Recruiting, Documentation, Documentation Plan, Finance, Fortune 500 Customers, Health Information Technology, Incident Management, Knowledge Management, Maintenance Services, On Call, Operational Support, Patient Assessment, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Production Support, Root Cause Analysis, Technical Support
LOCATION
Johnston, RI
POSTED
1 day ago
Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs.  IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical.  We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.

Description: 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: *** 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

Custom Fields:
Name: Intake Call Completed
Value: true

Name: Intake Call Requested
Value: true



EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.

About the Company

I

IMCS Group Inc