Apply on Employer Site

Akkodis · 19 hours ago

Database Architect

Westlake Village, CA

Contract

Onsite

Senior Level

$80/hr - $84/hr

5+ years exp

Akkodis is a company that leverages global resources to provide exceptional staffing solutions. They are seeking a Database Architect to design and implement cloud-native data platforms using AWS services, while also defining modern data architecture blueprints and leading SQL Server to PostgreSQL migration initiatives.

Information Technology & Services

H1B Sponsor Likely

Hiring Manager

Shubhada M.

Responsibilities

Design and implement cloud-native data platforms leveraging AWS services, including data warehouses (Redshift, Snowflake) and lakehouses (Databricks, Delta Lake, Apache Iceberg)

Define modern data architecture blueprints, incorporating multi-model strategies (SQL, NoSQL, streaming, unstructured) to support enterprise-scale analytics and applications

Architect and deliver event streaming solutions using platforms such as Kafka, Kinesis, enabling real-time ingestion, enrichment, and downstream processing

Architect, manage, and optimize SQL Server on AWS (RDS & EC2) with automation around high availability, disaster recovery, backup, and scaling

Lead and execute SQL Server to PostgreSQL migration initiatives, ensuring minimal disruption, optimized performance, and cost-efficiency

Implement advanced performance tuning, indexing, and workload management strategies across relational data platforms

Architect and implement data replication and masking strategies using Delphix, with a strong emphasis on automated provisioning and configuration

Provide replication, masking, and virtualization support for Microsoft SQL Server and PostgreSQL environments, ensuring security, compliance, and efficiency in non-production environments

Implement Infrastructure-as-Code (IaC) practices using Terraform, OpenTofu, or AWS CDK for provisioning and managing data platforms

Establish DataOps practices, including CI/CD for data pipelines, automated schema management, continuous testing, and monitoring

Proactively identify opportunities for automation across database operations, including provisioning, patching, backups, monitoring, and performance tuning — with a strong focus on automating infrastructure deployment using Terraform or OpenTofu and automating performance analysis and optimization across all database types

Build automation frameworks for provisioning, patching, performance optimization, HA/DR, compliance, and security operations

Continuously monitor, analyze, and optimize performance across SQL, NoSQL, data warehouses, lakehouses, and streaming platforms

Implement security best practices, including encryption, masking, key management, RBAC, and compliance with industry regulations

Utilize observability tools (CloudWatch, OTEL, New Relic, or similar) to provide end-to-end monitoring, alerting, and self-healing automation

Partner with engineering, InfoSec, and DevOps teams to design scalable, automated, cloud-native data solutions

Define and publish standards, patterns, and reusable templates for enterprise data platforms

Provide technical guidance and mentorship to other team members, promoting a culture of automation and best practices for managing diverse database environments, including Microsoft SQL Server, PostgreSQL, DynamoDB, and various NoSQL databases, with a strong emphasis on writing and optimizing efficient queries/data access patterns

Qualification

Cloud-native data platformsMicrosoft SQL ServerAWS RedshiftEvent streaming platformsPostgreSQLIaC toolsQuery optimizationData security practicesPythonPowerShellObservability toolsAnalytical skillsCommunication skills

Required

Bachelor's degree in computer science, or a related field

Minimum of 5 years of experience as a Database Architect or in a similar role with 3+ years in cloud-native data platforms

Minimum of 5 years of experience with Microsoft SQL Server, including database design, administration, performance tuning, and high availability solutions, with a strong focus on automation and expert-level query optimization skills

Proven experience with cloud-native data warehouses and lakehouses: AWS Redshift, Snowflake, Databricks, Delta Lake, Apache Iceberg

Strong expertise in event streaming platforms (Kafka, Kinesis, or MSK) for real-time pipelines

Hands-on experience with NoSQL platforms such as DynamoDB, MongoDB, or Cassandra

Deep expertise in SQL Server on AWS, including high availability, automation, migrations, and performance tuning

Experience implementing Delphix-based replication, masking, and provisioning strategies across SQL Server and PostgreSQL

Strong background in Python, PowerShell, AWS CLI, or equivalent programming languages for automation

Proven hands-on experience with IaC tools (Terraform, OpenTofu, AWS CDK) for cloud data infrastructure provisioning

Demonstrated success implementing CI/CD pipelines for database and data workloads using GitLab CI, Jenkins, or AWS CodePipeline

Expert in query optimization, indexing, and schema design across SQL and NoSQL

Solid understanding of cloud data security, governance, and compliance practices

Experience with observability and monitoring frameworks to ensure resilient, self-healing data systems

Strong analytical and problem-solving skills

Excellent written and verbal communication, able to influence senior stakeholders and mentor peers

Ability to thrive in a fast-paced, collaborative, and highly visible environment

Significant experience with PostgreSQL, including database design, administration, performance tuning, high availability, and replication, with a deep understanding of PostgreSQL-specific query optimization techniques

Preferred

Master's degree preferred

Benefits

Medical

Dental

Vision

Term life insurance

Short-term disability insurance

Additional voluntary benefits

Commuter benefits

401K plan

Paid Sick Leave

Holiday pay

Company

Akkodis

Glassdoor3.3

Akkodis provides digital engineering solutions for sustainable and innovative industries.

Zug, Zug, CHE

10001+ employees

https://www.akkodis.com

H1B Sponsorship

Akkodis has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (141)

2024 (121)

2023 (67)