Senior Database Reliability Engineer
ActiveCampaign
🚀 We help small teams power big businesses with the must-have platform for intelligent marketing automation. Customers from over 170 countries depend on our mix of pre-built automations and integrations (including Facebook, Google, WordPress, Salesforce, Shopify, and Square) to power personalized marketing, transactional emails, and one-to-one CRM interactions throughout the customer lifecycle.
Tech stack
AWS
PostgreSQL
Snowflake
SQL
NoSQL
Job description
ActiveCampaign is seeking a Senior Database Engineer to lead the design, implementation, and optimization of our database systems. In this role, you will play a key role in architecting scalable and high-performance database solutions to support our growing data infrastructure needs. You will collaborate with cross-functional teams to ensure our database systems meet business requirements and performance goals.
What your day could consist of:
- Lead the design, implementation, and optimization of database systems to support data warehousing and analytics requirements.
- Work closely with software engineers, data scientists, and analysts to understand data needs and design efficient database schemas and structures.
- Optimize database performance through query tuning, indexing strategies, and partitioning techniques.
- Establish and enforce best practices for database design, data modeling, and data governance.
- Monitor database health and performance metrics, and implement proactive measures to ensure system reliability and availability.
- Evaluate and recommend new technologies and tools to improve database scalability, performance, and efficiency.
- Mentor junior team members and provide technical guidance and expertise.
- Collaborate with cross-functional teams to troubleshoot and resolve database-related issues and challenges.
- Stay abreast of industry trends and advancements in database technologies, and drive innovation and continuous improvement.
What is needed:
- 5 years of experience designing, implementing, and optimizing NoSQL database systems, such as DynamoDB, Cassandra, Vertica, Amazon Redshift, Google BigQuery, or Snowflake.
- Strong proficiency in SQL query optimization, database tuning, and performance monitoring.
- Hands-on experience with ETL processes, data modeling, and data pipeline orchestration.
- Experience deploying and managing services hosted on Kubernetes.
- Solid understanding of distributed systems, data replication, and high availability architectures.
- Proficiency in programming languages such as Python, Java, or Scala.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a fast-paced, Agile environment.
- Experience leading database architecture and design projects is a plus.