Database Architect- AWS

*** ONLY ON W2 CONTRACT, NO C2C/1099 ***

Cloud Database Architect

Location: Westlake Village CA

Duration: 5 months contract (potential to go PERM eventually)

Work from Office

Qualifications:

• Bachelor's degree in Computer Science, or a related field. Master's degree preferred.
• 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.