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.