Job Title

Locations: Noida/Gurgaon/Indore/Bangalore/Pune/Hyderabad Overall Experience: 5-9 yearsShould have minimum of 3-7 years of Experience with AWS Redshift or another analytic column-store. Should have set up Redshift clusters from scratch and involved in planning the cluster, deployment and administration. 2+ years of experience with SQL analysis, troubleshooting activities, including data warehousing, analytical applications support. Experience in working on AWS technologies, AWS services, AWS CLI & S3 storage understanding. Strong knowledge on multiple cloud technologies including VPC, EC2, S3, Amazon API Gateway, DynamoDB, SimpleDB, AWS Route 53 2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices is an added advantage. Ability to read, understand and communicate complex technical information or queries. Ability to express ideas in an organized, articulate and concise manner Any certification regarding Redshift Administration services will be an added advantage. Should have a good understanding of services business for fortune 1000 from the operations point of view Should have good understanding of ITIL processes, operations support and ticketing toolsRoles & ResponsibilitiesRedshift Cluster Planning Principal points to consider in choosing the cluster. Analyze the sizing of the cluster and an estimated need of storage. Given a scenario and workload pattern, analyze the Redshift workloads i.e., Data integration, Workflow orchestration and Analysis. Cluster sizing & Benchmarking: given a scenario and frequency of execution, identify the specifics for the workload, including CPU, memory, storage, disk I/OCluster Administration Deploy and administer AWS Redshift, columnar data lake, and SQL query engines. Modifications to any existing databases with appropriate impact analysis. Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure. Provide consistent database maintenance, optimization and best practices inputs to existing Redshift and SQL databases, data lake, SQL engines, and applications. Development and testing support – Helping programmers and engineers to efficiently utilize the database. Integrity – Verifying or helping to verify data integrity Availability – Ensuring maximum uptime Performance – Ensuring maximum performance. Establish and maintain sound backup and Disaster Recovery (DR) policies with RPO/RTO objectives and procedures.Cluster Maintenance Regular maintenance and data cleanups. Troubleshooting error User on-boarding Should be able to scan logs, errors, exception and get to the root cause of the issueCluster monitoring Redshift admins must monitor the database performance and evaluate complex information coming from a variety of sources. Suggest and implement service improvements for enhancing monitoring and alerting Configure automated alerts and notifications. Strong CloudWatch monitoring experienceCluster security Implement and maintain database security (create and maintain users and roles, assign privileges). Security – Defining and/or implementing access controls to the data Apply authorized checks & validation procedures.Manage customer calls and analyze issues reported by customer Should be capable of working independently & responsible for L1/L2/L3 Support Should work with complete ownership and handle all issues without missing SLA’s Work closely with engineering team and support team for productionizing new use cases, users Should be able to debug the issues and report appropriately in the ticketing system Handover the shift and circulate a daily report to stakeholders Contribute to improve the efficiency of the assignment by quality improvements & innovative suggestions Should be customer oriented and willing to work in 24/7 shifts Contribute in developing a knowledge base on collaboration with other team members Maintain customer loyalty through Integrity and accountability Aligning with the systems engineering team to propose and deploy new hardware and software environments required for Hadoop and to expand existing environments. Working with data delivery teams to setup new users. Diligently teaming with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability. Point of Contact for Vendor escalation Working with application teams for system upgrades and patches. Maintain and publish a platform roadmap forecasting all upgrades, patches, capacity changes, and new services. Cluster and application problem resolution for restoring service Drive operational enhancements back to the product organization Create runbooks & troubleshooting guides & knowledge base Notify applications teams to compress or purge files while necessary