- Design and implement multi-terabyte Data Warehouse and Data Lake infrastructure in support of large scale Data Analytics and Data Science applications.
- Optimize and tune Redshift cluster, queries and workflows to support multiple analytics and visualization platforms.
- Design and implement workflows for Analytics and Data Science use cases, including Python ETL, AWS Lambda, AWS Step Functions, and Database Python UDFs.
- Implement Redshift Workload Management (WML) to prioritize workloads and manage concurrency issues.
- Architect and implement working solutions that leverage Redshift Spectrum, Redshift Serveless
- Establish controls needed to comply with company cybersecurity and data loss prevention policies, standards, and industry best practices.
- Provide timely support in response to performance issues.
- Design and implement monitoring and alerting system for AWS Redshift cluster performance and uptime.
- Design and implement Redshift Disaster Recovery Plan.
- Excellent in optimizing and testing Python ETL code that includes AWS Boto3 SDK
- Expert AWS Redshift performance and tuning including the following:
- 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 in performance and scalability of large data sets
- Postgres, AWS RDS, AWS Aurora, MySQL, SQL Server, Oracle, AWS DynamoDB, AWS Glue Metastor, MongoDB, Redis, AWS ElastiCache or AWS OpenSearch
- 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
- Bachelor's degree in technology, engineering, or related field
- 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
- Experienced in use of Redshift Spectrum and Redshift Serverless Architecture
- Strong communications skills, both written and verbal
- Strong analytical and trouble-shooting skills
- Medical insurance covered up to 100%
- Dental & vision insurance
- 401(k) matching
- Stock options
- Complimentary gym access
- Autonomy and upward mobility
- Diverse, equitable, and inclusive culture, where your voice matters.
-
Database Engineer
2 weeks ago
AXS Los Angeles, United StatesThe Company · AXS connects fans with the artists and teams they love. Each year we sell millions of tickets to thousands of incredible events - from concerts and festivals to sports and theater - at some of the most iconic venues in the world. Since our founding in 2011, we've c ...
-
Database Engineer
2 weeks ago
JBA International Los Angeles, United StatesJob Summary: · The Database Engineer, Senior will · work closely with the engineering team members to design, develop and enhance Microsoft SQL Server and PostgreSQL database solutions. · Duties & Responsibilities: · Strong SQL, experience writing, tuning queries based on app ...
-
Database Engineer
2 weeks ago
AXS Los Angeles, United StatesThe Company · Apply (by clicking the relevant button) after checking through all the related job information below. · AXS connects fans with the artists and teams they love. Each year we sell millions of tickets to thousands of incredible events - from concerts and festivals to ...
-
Database Engineer
3 weeks ago
TEKsystems Anaheim, United States Contract to RegularDescription: · ESSENTIAL POSITION FUNCTIONS: · Analyzes and defines the properties required by a database management system (DBMS) that will meet the current and future needs of the company. · Analyzes the organizational structure of the company and defines the logical database s ...
-
Administrative Assistant, Business
3 weeks ago
Sony Pictures Entertainment, Inc. Culver City, United StatesWe are looking for an Administrative Assistant to support the SVP of Business and Legal Affairs for our Game Shows division, headquartered in Culver City, CA. This role may also provide occasional departmental administrative support, as needed. The assistant will be a key member ...
-
Digital Program Manager
2 weeks ago
Amazon Services LLC Culver City, United StatesMaster's degree or 5+ years of equivalent professional experience · - Strong attention to detail, end-to-end ownership, and driving results · - Clear verbal/written communication, including an ability to effectively communicate with diverse audiences, and both business and techni ...
-
Principal Database Engineer
3 weeks ago
Northrop Grumman Azusa, United StatesAt Northrop Grumman, our employees have incredible opportunities to work on revolutionary systems that impact people's lives around the world today, and for generations to come. Our pioneering and inventive spirit has enabled us to be at the forefront of many technological advanc ...
-
Database Reliability Engineer
4 days ago
Blue Pisces Consulting Inc. Simi Valley, United StatesWe're looking for passionate engineers who love Linux & contributing to open source projects, intimately familiar with cloud infrastructure, and are more comfortable in the shell as they are in an IDE. Lean, agile, self-sufficient teams is how we operate. We value a cloud first a ...
-
Database Reliability Engineer
2 weeks ago
Blue Pisces Consulting Inc. Simi Valley, United StatesWe're looking for passionate engineers who love Linux & contributing to open source projects, intimately familiar with cloud infrastructure, and are more comfortable in the shell as they are in an IDE. Lean, agile, self-sufficient teams is how we operate. We value a cloud first a ...
-
Post Production Manager
2 days ago
Sony Pictures Entertainment, Inc. Culver City, United States**Responsibilities**: · Create, Maintain, and/or Distribute the following: · - Contact Lists: Sony Inter-department quick reference, Post Production Executive (all studios) · - Motion Picture Production Database: Post Production Database · - Post Production Schedules · - Producti ...
-
Central Operations Manager, Prime Video
1 week ago
Amazon Services LLC Culver City, United StatesPrevious supervisory experience, including hiring, developing, and leading teams with 3+ direct reports · - Proven ability to lead cross-functional teams to deliver products and projects on tight deadlines · - Experience coordinating complex program development cycles · - Interme ...
-
Sony Pictures Entertainment, Inc. Culver City, United StatesSony Pictures Television Studios (SPTS) is one of the industry's leading content providers, producing programming worldwide across genres and platforms. As the largest independent TV studio in the industry, SPTS produces 50+ shows each year including THE BOYS, COBRA KAI, THE GOOD ...
-
Principal Product Manager
3 days ago
Crunchyroll, LLC Culver City, United States**About Crunchyroll**: · WE HELP EVERYONE BELONG. IT'S OUR PURPOSE. · Founded by fans, Crunchyroll delivers the art and culture of anime to a passionate community. We super-serve over 100 million anime and manga fans across 200+ countries and territories, and help them connect wi ...
-
Cloud Database Infrastructure Engineer
1 week ago
Danta Technologies Burbank, United StatesHi · Looking for Senior Database Infrastructure Engineer (Remote Work), If your interested. Please share your updated profile to · Position: Cloud Database Infrastructure Engineer · Duration: Long Term · Remote Work · Mandatory skill · Postgres · skills · (Postgres/On pr ...
-
Research Associate I
1 week ago
CEDARS-SINAI Beverly Hills, United States**Principal Investigator, Lali Medina-Kauwe, PhD, is looking for a Research Associate to join the team** · When the work you do every single day has a crucial impact on the lives of others, every effort, every detail, and every second matters. This shared culture of happiness, pa ...
-
Research Associate I Per Diem
1 week ago
CEDARS-SINAI Beverly Hills, United States**Principal Investigator, Lali Medina-Kauwe, PhD, is looking for a Research Associate to join the team** · When the work you do every single day has a crucial impact on the lives of others, every effort, every detail, and every second matters. This shared culture of happiness, pa ...
-
Research Bioinformatician I
1 week ago
CEDARS-SINAI Beverly Hills, United StatesThe Kao Autoimmunity Institute is committed to translational and clinical research that will advance the treatment of rheumatology diseases. The Kao Autoimmunity Institute is dedicated to the comprehensive care of patients with rheumatic diseases, along with a distinct focus on c ...
-
Research Bioinformatician I
1 week ago
Springer Nature Beverly Hills, United States**Research Bioinformatician I - Kao Autoimmunity Institute (Per Diem)**: · - Employer- Cedars-Sinai- Location- Beverly Hills, California- Salary- Competitive- Closing date- 23 Jun 2024- Discipline · Health Science · Job Type · Researcher · Employment - Hours · Full time · Duratio ...
-
Research Associate I Per Diem
1 week ago
Springer Nature Beverly Hills, United States**Research Associate I Per Diem - Medina-Kauwe Lab - Biomedical Sciences**: · - Employer- Cedars-Sinai- Location- Beverly Hills, California- Salary- Competitive- Closing date- 24 Jun 2024- Discipline · Health Science · Job Type · Researcher · Employment - Hours · Full time · Dura ...
-
Research Associate I
1 week ago
Springer Nature Beverly Hills, United States**Research Associate I - Medina-Kauwe Lab - Biomedical Sciences**: · - Employer- Cedars-Sinai- Location- Beverly Hills, California- Salary- Competitive- Closing date- 24 Jun 2024- Discipline · Health Science · Job Type · Researcher · Employment - Hours · Full time · Duration · Pe ...
Principal AWS Database Engineer - Culver City, United States - Spotter
Description
Overview:
Spotter, named one of TIME100's Most Influential Companies this year, empowers top YouTube creators to accelerate their business and unleash their full creative potential by giving them access to the capital, knowledge, and community they need to succeed at scale. As the top provider of creator-friendly growth capital, Spotter tailors our investments to meet the unique needs of each creator we partner with, giving them the freedom to create without compromise.
Creators are free to reinvest their funds however they choose, from hiring a team, to building their own production studios, and everything in between, all while maintaining total control over their catalogs, their channels, and their future earnings. In addition to funding, Spotter provides creators with in-depth data insights into the performance of their existing content, enabling them to leverage the full value of their library, as well as the value of future uploads and how they can improve performance in the future.
Featured in Forbes, Fast Company, Variety, Axios, and more, Spotter has already deployed over $850 million to YouTube creators to reinvest in themselves and accelerate their growth. Spotter has licensed content that consists of over 725,000 videos, which generate 88 billion monthly watch-time minutes. With our curated premium video catalog, we deliver a unique scaled media solution to Advertisers and Ad Agencies that is transparent, efficient, and 100% brand safe.
What You'll Do/Responsibilities:
We're looking for a talented and intensely curious Senior AWS Database Engineer who is nimble and focused with a startup mentality. In this newly created role you will be the liaison between data engineers, data scientists and analytics engineers. You will work to create cutting-edge architecture that provides the increased performance, scalability and concurrency for Data Science and Analytics workflows.
Who You Are/Required Qualifications:
Valued Skills:
Why Spotter:
In compliance with local law, we are disclosing the compensation, or a range thereof, for roles that will be performed in Culver City. Actual salaries will vary and may be above or below the range based on various factors including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The overall market range for roles in this area of Spotter are typically: $100-$500K salary per year. The range listed is just one component of Spotter's total compensation package for employees. Other rewards may include annual discretionary bonus and equity.
COVID-19 Vaccination Policy
Spotter requires proof of being fully vaccinated for COVID-19 as a condition of commencing employment.
Spotter is an equal opportunity employer. Spotter does not discriminate in employment on the basis of race, religion, creed, color, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic characteristics or information, marital status, sex (including pregnancy, childbirth, breastfeeding, and related medical conditions), gender, gender identity, gender expression, age, sexual orientation, military status, veteran status, use of or request for family or medical leave, political affiliation, or any other status protected under applicable federal, state or local laws.
Equal access to programs, services and employment is available to all persons. Those applicants requiring reasonable accommodations as part of the application and/or interview process should notify a representative of the Human Resources Department.