Staff Software Engineer, Database

About the Role

We are seeking a Staff Software Engineer, Database to lead the transformation of our database architecture from legacy Microsoft SQL Server (MSSQL) to cloud-native database solutions, including AWS Aurora PostgreSQL. This role requires deep expertise in database architecture, scalability, and design, ensuring that our critical business applications are both high-performing and future-proof.

Key Responsibilities

• Architect & Design: Define and drive the database architecture strategy, ensuring seamless migration from MSSQL to cloud-native databases.

• Cloud-Native Transformation: Lead the transition to AWS Aurora PostgreSQL and explore other modern database technologies that align with business goals.

• Scalability & Performance: Design and implement highly available, scalable, and resilient database solutions for mission-critical applications.

• Database Governance & Security: Establish and enforce best practices around data security, encryption, compliance, backup, and disaster recovery.

• Infrastructure as Code (IaC): Implement database automation and provisioning using Terraform, CloudFormation, or Kubernetes-based database orchestration.

• Observability & Monitoring: Define and implement observability strategies with CloudWatch, Prometheus, or Coralogix.

• Collaboration & Leadership: Work closely with Engineering, DevOps, and Product Teams to align database solutions with application needs and performance expectations.

• Continuous Optimization: Drive cost-efficiency, performance tuning, and cloud resource optimization in the database infrastructure.

• Innovation & Future-State Planning: Research emerging database technologies and propose architectural enhancements for long-term scalability.

Required Skills & Experience

• 8+ years of experience in database engineering, with deep expertise in Microsoft SQL Server (MSSQL), exposure to MySQL and cloud-native databases.

• Hands-on experience with AWS Aurora PostgreSQL, Amazon RDS, or other cloud-based relational databases.

• Proven experience in database transformation projects, including migration from on-prem MSSQL to cloud.

• Strong knowledge of database architecture, replication, clustering, and partitioning strategies.

• Expertise in database schema design, query optimization, indexing, and performance tuning.

• Familiarity with NoSQL databases (e.g., DynamoDB, MongoDB) and hybrid architectures.

• Experience with IaC tools like Terraform, CloudFormation, or Kubernetes-based solutions for managing database infrastructure.

• Deep understanding of CI/CD pipelines and integrating databases into modern DevOps workflows.

• Strong analytical and problem-solving skills to handle large-scale distributed database systems.

Preferred Qualifications

• AWS Certified Database - Specialty or equivalent cloud certifications.

• Experience in designing and implementing event-driven architectures using streaming platforms like Kafka.

• Hands-on experience with multi-region, multi-cloud, and disaster recovery strategies.

• Exposure to serverless databases like AWS Aurora Serverless.

• Experience working in an Agile/Scrum environment.