Redshift Administrator

Description

1. Experience in database administration and implementation of DB related scripts/jobs.
2. Experience with SQL analysis, troubleshooting activities, including Redshift data warehouse & Aurora PostgreSQL RDS, analytical applications support.
3. Experience in working on AWS technologies, AWS services, AWS CLI & S3 storage understanding.
4. Strong knowledge on multiple cloud technologies including VPC, IAM, Security Group, EC2, S3, Amazon API Gateway, DynamoDB, Athena, AWS Route 53, Glue.
5. Good understanding of Redshift architecture, hands on experience in setting up Redshift cluster from the scratch and snapshot creation.
6. Hands on experience in cluster security like, data proration, identify and access management (IAM) & infrastructure security.
7. Hands on experience in loading data, running complex queries, performance tuning.
8. Hands on experience in configuring monitoring of AWS Redshift clusters, automated reporting of alerts, auditing & logging.
9. Conducting daily maintenance and support for both production and development databases using CloudWatch and CloudTrail.
10. Experience in CloudFormation
11. Experience of working in Linux/Unix environments.
12. Good understanding of snapshot creation and Disaster recovery.
13. General operational expertise such as good troubleshooting skills, understanding of system’s capacity, bottlenecks, basics of memory, CPU, OS, storage, and networks.
14. Expertise in debugging and analytical skills with solid grasp of system development methodologies, techniques, and tool.
15. Partnering with Data Integration Engineers to migrate data from a variety of source platforms - including SQL Server, DB2. The target for these platforms is AWS Redshift, using AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
16. Proven experience in crafting and implementation of security and auditing standards for large databases. And running DR Environments (Standby, ADG).
17. Solid understanding of Database, Performance tuning in AWS
18. Experience in Oracle/Teradata is a plus.
19. Familiarity with Big Data (Hadoop) systems is an added advantage.