Database Cloud Engineer /Cloud Database Engineer/ Database Engineer

Role: Database Cloud Engineer /Database Lead Data Engineer/Database AWS Engineer/ Cloud Database Engineer

Tools: Redshift, Aurora and DynamoDB

Location: San Francisco, CA — Local candidates only

Interview Mode: In-person interview is mandatory

Duration: 18 Months

Note: Candidate must be eligible for full-time hire,

Engagement:No C2C

Details:

·       We are seeking an experienced Database Lead Data Engineer to join our team and drive the development of modern data platforms and AI-augmented solutions.

·       This role is critical to supporting ongoing operations of Large Data Warehouse, architecting the Large Data Hub, and preparing for the enterprise data mesh modernization program.

Responsibilities:

Data Engineering & Pipeline Development:

•           Develop and maintain end-to-end ETL/ELT pipelines for data ingestion from multiple sources (databases, APIs, streaming), transformation, quality validation, data modeling, and consumption layer optimization using AWS services (Glue, EMR, Lambda, Kinesis, Step Functions)

•           Implement data governance policies, metadata management, data lineage tracking, fine-grained access controls, and automated data quality frameworks with validation rules, anomaly detection, and monitoring/alerting mechanisms

Data Mesh Architecture

•           Design and implement Data Mesh architecture on AWS with federated governance, defining domain boundaries, data product specifications, and self-serve infrastructure patterns across Databricks, Starburst, Collibra, and Immuta platforms

•           Develop reusable frameworks, accelerators, and self-serve tools enabling domain teams to independently publish, discover, and consume data products while ensuring performance optimization and cost efficiency

DevSecOps & Infrastructure

•           Integrate DevSecOps practices including CI/CD pipelines, infrastructure as code (Terraform/CloudFormation), automated security scanning, compliance validation, and disaster recovery strategies

AI-Augmented Development

•           Design and build agentic AI solutions, RAG pipelines, and intelligent automation using LLMs, orchestration frameworks, and AI-powered development tools (Copilot, Claude Code) to enhance platform capabilities and accelerate SDLC

Technical Leadership & Collaboration

•           Provide L3 technical support and mentor engineering teams on data mesh principles and modern data technologies

•           Collaborate with stakeholders to translate business requirements into technical solutions

•           Lead architecture design reviews and create comprehensive technical documentation

Required Qualifications

Data Mesh Architecture & AWS (5+ years required):

•           Deep experience designing distributed data architectures on AWS (S3, Glue, Lake Formation, EMR, Redshift)

•           Hands-on implementation of data mesh principles including domain-oriented data ownership, data as a product, and federated computational governance

Modern Data Platform Technologies:

•           Proficiency: Databricks (Unity Catalog, Delta Lake), Starburst/Trino (federated query), Collibra (data governance), or Immuta (dynamic data access control)

•           Ability to architect multi-technology solutions

DevSecOps & Infrastructure as Code:

•           Strong experience with CI/CD pipelines (GitLab/GitHub Actions, Jenkins)

•           Containerization expertise (Docker/ECS)

•           Infrastructure automation (Terraform, CloudFormation)

•           Security compliance frameworks for AWS GovCloud environments

AI-Augmented Development & Engineering:

•           Demonstrated use of generative AI tools for accelerating SDLC activities including code generation, testing, and documentation

•           Experience designing or implementing agentic AI solutions using Amazon Bedrock or similar frameworks

Leadership & Soft Skills

•           Proven ability to translate business requirements into technical solutions

•           Experience leading technical design sessions and mentoring engineering teams

•           Strong communication skills to convey complex architectural concepts to both technical and non-technical stakeholders

•           Experience working across hybrid cloud/on-premises environments

Software Galaxy Systems, LLC (SGS) is an award-winning Contingent Workforce Services firm providing a broad range of integrated suite of services through a global delivery platform. SGS brings innovative talent management strategies to empower its clients to stay focused on growth of their core competencies. SGS has developed a comprehensive process-oriented methodology to manage high-volume contingent labor, payroll services and SOW’s for today’s competitive landscape.

SGS is proud of the partnerships it has built with its clients, MSP’s, and employees which has allowed it to deliver unparalleled service to its wide-ranging customer base. SGS is a certified minority owned enterprise that provides innovative yet practical solutions, from concept through execution. We combine technology with strategy and aim to deliver results today that endure tomorrow. SGS’ client centric approach delivers unparalleled value with vastly responsive, streamlined and highly process oriented workforce solutions.

SGS has been awarded and acknowledged by leading MSP’s (i.e., KellyOCG, TAPFIN, Guidant Global, etc.) for its exemplary performance in the contingent workforce space.