Senior Cloud Database Engineer (AWS Redshift)
Spotter
·
Posted:
May 19, 2023
·
Remote
About the position
Spotter is a leading provider of growth capital for YouTube creators, offering them the resources and support they need to thrive. With a focus on empowering creators to unleash their creative potential, Spotter provides tailored investments that allow creators to reinvest in their businesses while maintaining control over their content. In addition to funding, Spotter offers data insights to help creators optimize their performance and maximize the value of their content. With a track record of success and recognition in the industry, Spotter is dedicated to helping creators accelerate their growth and achieve their goals.
Responsibilities
- Design and implement multi-terabyte Data Warehouse and Data Lake infrastructure
- Optimize and tune Redshift cluster and queries
- Implement Redshift Workload Management (WML)
- Establish controls for cybersecurity and data loss prevention
- Provide timely support for performance issues
- Design and implement Monitoring and Alerting system for AWS Redshift cluster
- Design and implement Redshift Disaster Recovery Plan
- Expert Database Administration skills using AWS Redshift
- SQL performance tuning and optimization
- Concurrency scaling and monitoring
- Data distribution monitoring and optimization
- Stored Procedures, Materialized view, User Defined Functions - Optimization & Tuning
- Workload Manager, queue Management
- Disaster recovery design/implementation - snapshots & recovery points
- Large scale Data Warehouse & Data Lake workloads optimization
- Parameter Group management
- Data Governance & Security - Data Encryption, Redshift User Roles & Groups, Role Based Data Access Controls (row level data security), IAM integration, AWS Security Groups, AWS Cloud Watch event monitoring
- Expert DBA skills using RDBMS and/or NoSQL platforms
- Working knowledge of DevOps best practices
- Advanced knowledge and experience in the development of Linux Shell scripting
- Advanced knowledge and experience in the Design and implementation of Data Warehouse, Data Lake
- Advanced knowledge and experience in maintenance of Metadata repositories
- Experienced in Metadata classification, lineage, and discovery
- Experienced in use of AWS IAM, AWS Security Groups, AWS Web Application Firewall
- Bachelor's degree in technology, engineering (valued skill)
Requirements
- Expert Database Administration skills using AWS Redshift
- SQL Performance tuning and optimization
- Concurrency scaling and monitoring
- Data distribution monitoring and optimization
- Stored Procedures, Materialized view, User Defined Functions - Optimization & Tuning
- Workload Manager, queue Management
- Disaster recovery design/implementation - snapshots & recovery points
- Large scale Data Warehouse & Data Lake workloads optimization based on Spark, Lambda Functions, S3, Glue
- Parameter Group management
- Data Governance & Security - Data Encryption, Redshift User Roles & Groups, Role Based Data Access Controls (row level data security), IAM integration, AWS Security Groups, AWS Cloud Watch event monitoring
- Expert DBA skills using RDBMS and/or NoSQL platforms such as Postgres, AWS RDS, AWS Aurora, MySQL, SQL Server, Oracle, AWS DynamoDB, AWS Glue Metastor, MongoDB, Redis, AWS ElastiCache or AWS OpenSearch
- Working knowledge of DevOps best practices: Advanced knowledge and experience in the development of Linux Shell scripting in combination with AWS SAM / AWS-CLI, AWS CloudFormation and/or Terraform templates for Deployment automation
- Advanced knowledge and experience in the Design and implementation of Data Warehouse, Data Lake - with Data Mesh as a plus
- Advanced knowledge and experience in maintenance of Metadata repositories such as AWS Glue Catalog, Glue crawler for data stored in: S3, AWS Redshift, AWS RDS for access thru Redshift Spectrum
- Experienced in Metadata classification, lineage, and discovery based on AWS technologies or equivalent open source frameworks
- Experienced in use of AWS IAM, AWS Security Groups, AWS Web Application Firewall
- Bachelor's degree in technology, engineering (not complete due to HTML tags)
Benefits
- Medical insurance covered up to 100%
- Dental & vision insurance
- 401(k) matching
- Stock options
- Autonomy and upward mobility
- Diverse, equitable, and inclusive culture, where your voice matters.