Specialist - Cloud & Infra Management

Job Description

Role AWS Redshift Database administratorExperience Overall 4 to 5 years 4 years relevantLocation Bangalore IndiaRedshift Platform Engineer with expertise in administering large scale Amazon Redshift clusters including RA3 architecture workload management WLM concurrency scaling and automated maintenance operations Proficient in query performance optimization using sortdistribution key strategies compression encoding VACUUMANALYZE automation and SVLSTL diagnostic tables Strong hands on experience integrating Redshift with S3 Glue Lambda and IAM implementing secure VPC based deployments snapshot management and cost optimized storage frameworks Skilled in developing platform automation using Python and AWS Lambda to ensure high availability scalable processing and operational reliabilityStrong verbal and written communication skills with ability to articulate results and issues to internal and client teams Proven ability to work creatively and analytically in a problemsolving environmentPrimary Responsibilities IncludePlatform Architecture Infrastructure ManagementDesign provision and manage Amazon Redshift clusters Provisioned and ServerlessDefine DevQAProd environment strategy and governanceCapacity planning and workload segmentationEvaluate and implement new AWS Redshift featuresPerformance Workload OptimizationOptimize query performance and database designConfigure and manage Workload Management WLMOversee distributionsort key strategiesManage concurrency scaling and cluster tuningConduct performance benchmarking and proactive improvementsIdentity Security GovernanceImplement IAM rolebased access control RBACIntegrate Redshift with AWS Identity Center Enterprise SSO eg Entra IDManage MFA enforcement and service account governanceImplement encryption at rest in transitControl network access via VPC security configurationsOversee PAM integration and password rotation policiesParticipate in vulnerability remediation and compliance initiativesDisaster Recovery ResilienceDefine and manage crossregion snapshot strategyEstablish RTORPO objectivesConduct DR testing and validationEnsure backup governance and high availability alignmentLogging Monitoring ObservabilityDesign logging architecture CloudWatchS3 integrationEnsure SIEM integration eg SentinelSplunkQRadarDefine monitoring and ing standardsOwn L3L4 escalation and incident triage governanceCost Governance FinOpsMonitor and optimize cluster utilizationManage Reserved Instance planning and renewalsDetect cost anomalies using AWS Cost Explorer ApptioDrive tagging governance and cost attributionOptimize storage lifecycle S3 tieringData Integration Pipeline OversightGovern ETLELT ingestion patternsCollaborate with data engineering teams using Glue S3 LambdaEnsure ingestion reliability and schema governanceStrategic Planning Stakeholder CollaborationPartner with Data Engineering BI Security SOC and Finance teamsEngage AWS TAMsupport for escalations and feature requestsMaintain platform roadmap and technical debt registerRepresent platform during audits and security reviewsTechnical EssentialsRedshift RA3 Spectrum WLM SortDist Keys Compression ZSTD STLSVL TablesAWS S3 Glue Athena Lambda CloudWatch SNS SQS IAM VPC KMSETL Tools IICS Glue ETL Qlik Replicate AirflowLanguages SQL Python Shell ScriptTools Git Jira Jenkins Terraform optionalBusiness Soft SkillsProven ability and initiative to learn and research new concepts ideas and technologies quicklyAbility to communicate effectively both verbal and written excellent presentation skillsAbility to effectively move forward on tasks even with ambiguous or changing requirementsAbility to work in a teamoriented collaborative environment in a global contextWillingness and ability to train and teach othersAbility to facilitate meetings and follow up with resulting action itemsAbility to selfmanage prioritize and execute tasks in a highpressure environmentStrong systemsprocess orientation with demonstrated analytical thinking organization skills and problemsolving skillsThe desire for growth and innovation to bring rapid solutions to business challengesopportunitiesStrong consultancy orientation and experience with the ability to form collaborative productive working relationships across diverse teams and cultures is a mustThe ability to work in a centralizeddecentralized operating model with varying implementation partners and implementation owners

Keyskills :
AWSDATABASESERVICES