AWS Redshift Admin

Skills

Description

Experience in database administration and implementation of DB related scripts/jobs.
Experience with SQL analysis, troubleshooting activities and analytical applications support.
Experience in working on AWS technologies, AWS services, AWS CLI & S3 storage understanding.
Good understanding of Redshift architecture, hands on experience in setting up Redshift cluster from the scratch and snapshot creation.
Hands on experience in loading data, running complex queries, performance tuning.
Hands on experience in configuring monitoring of AWS Redshift clusters, automated reporting of alerts, auditing & logging.
Conducting daily maintenance and support for both production and development databases using CloudWatch and CloudTrail.
Good understanding of snapshot creation and Disaster recovery.
General operational expertise such as good troubleshooting skills, understanding of systems capacity, bottlenecks, basics of memory, CPU, OS, storage, and networks.
Expertise in debugging and analytical skills with solid grasp of system development methodologies, techniques, and tool.
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)
Proven experience in crafting and implementation of security and auditing standards for large databases. And running DR Environments (Standby, ADG).
Solid understanding of Database, Performance tuning in AWS
Experience in Client or SQL Server Administration a plus.
Strong verbal & written communication and excellent analytical & problem-solving skills are mandatory.