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.
