Senior Database Architect

Cloud Kinetics; United States; Remote; USD 120.000 - 190.000; Vollzeit

Zusammenfassung

Cloud Kinetics is seeking an experienced database architect to design enterprise AWS database architectures across relational, NoSQL, in-memory, graph and time-series workloads.

You will lead migrations using AWS DMS/SCT, develop blueprints and capacity plans, and ensure security, performance and cost optimization while mentoring junior engineers in a fast-paced, Agile environment.

Qualifikationen

• Deep hands-on knowledge of Amazon RDS and Aurora for PostgreSQL/MySQL.
• Strong knowledge of AWS NoSQL and specialized database services including DynamoDB, DocumentDB, ElastiCache, Keyspaces, Timestream, Redshift and Neptune.
• Proficiency with AWS DMS and SCT for migrations.
• Advanced SQL, stored procedures, indexing, execution plans and performance tuning across relational database engines.
• Experience with Terraform, AWS CloudFormation and/or AWS CDK; scripting in Python, Bash and/or SQL.
• Working knowledge of database security, IAM, encryption, networking, Secrets Manager, compliance and Database DevOps practices.
• Familiarity with CI/CD and schema migration tools such as AWS CodePipeline, GitLab CI, Jenkins, Flyway and Liquibase.

Aufgaben

• Design enterprise AWS database architectures across relational, NoSQL, in-memory, graph and time-series workloads.
• Develop architecture blueprints, data models, capacity plans, HA/DR strategies and migration approaches aligned to business objectives.
• Lead end-to-end database migrations covering assessment, schema conversion, data migration, validation, cutover and handover using AWS DMS and SCT.
• Deliver heterogeneous migrations such as Oracle, SQL Server and MySQL to AWS-managed and cloud-native database services, including Oracle-to-Aurora PostgreSQL modernization.
• Perform health checks, schema complexity analysis, migration-wave planning, data integrity validation, performance benchmarking and application compatibility testing.
• Create migration runbooks, cutover/rollback plans and production-readiness documentation.
• Collaborate with Solutions Architects, Data Engineers, Project Managers and customer teams within Agile/ProServ engagements.
• Produce architecture diagrams, data flows, design decisions, runbooks and operational handover documentation.
• Develop reusable migration playbooks, IaC modules and delivery accelerators; mentor junior database engineers.

Kenntnisse

RDS/Aurora PostgreSQL

Oracle/SQL Server

DynamoDB

DocumentDB

ElastiCache

Keyspaces

Timestream

Redshift

Neptune

SQL Performance Tuning

Terraform

CloudFormation

AWS CDK

Python Bash SQL scripting

IAM & Security

CI/CD

CodePipeline

GitLab CI

Jenkins

Liquibase/Flyway

Tools

Terraform

CloudFormation

AWS CDK

GitLab CI

Jenkins

Liquibase

Flyway

Jobbeschreibung

Key Responsibilities:

Database Architecture & Design:

• Design enterprise AWS database architectures across relational, NoSQL, in-memory, graph and time-series workloads.
• Develop architecture blueprints, data models, capacity plans, HA/DR strategies and migration approaches aligned to business objectives.
• Select and optimise appropriate AWS database services including RDS, Aurora, DynamoDB, ElastiCache, Redshift, Document DB, Keyspaces, Timestream and Neptune.
• Ensure designs address security, compliance, resilience, performance and cost optimization.

Database Migration & Modernization:

• Lead end-to-end database migrations covering assessment, schema conversion, data migration, validation, cutover and handover using AWS DMS and SCT.
• Deliver heterogeneous migrations such as Oracle, SQL Server and MySQL to AWS-managed and cloud-native database services, including Oracle-to-Aurora PostgreSQL modernization.
• Perform health checks, schema complexity analysis, migration-wave planning, data integrity validation, performance benchmarking and application compatibility testing.
• Create migration runbooks, cutover/rollback plans and production-readiness documentation.

Performance, Security & Automation:

• Perform query tuning, indexing, execution-plan analysis, NoSQL data modelling and resolution of database, connection, locking and storage I/O bottlenecks.
• Implement AWS database security including KMS encryption, TLS, IAM authentication, VPC isolation, Secrets Manager and audit/compliance controls.
• Build database automation and DevOps capabilities using CI/CD, Terraform, CloudFormation and/or CDK for repeatable database provisioning and deployments.
• Implement monitoring and observability using CloudWatch, Performance Insights, CloudTrail and appropriate third-party tools.

Delivery & Collaboration:

• Collaborate with Solutions Architects, Data Engineers, Project Managers and customer teams within Agile/ProServ engagements.
• Produce architecture diagrams, data flows, design decisions, runbooks and operational handover documentation.
• Develop reusable migration playbooks, IaC modules and delivery accelerators; mentor junior database engineers.

Required Qualifications:Education & Experience:Technical Skills:

• Deep hands-on knowledge of Amazon RDS and Aurora for PostgreSQL/MySQL, plus experience with Oracle, SQL Server, MySQL and MariaDB workloads.
• Strong knowledge of AWS NoSQL and specialized database services including DynamoDB, Document DB, ElastiCache, Keyspaces, Timestream, Redshift and Neptune.
• Proficiency with AWS DMS and SCT for homogeneous and heterogeneous migrations.
• Advanced SQL, stored procedures, indexing, execution plans and performance tuning across relational database engines.
• Experience with Terraform, AWS CloudFormation and/or AWS CDK; scripting skills in Python, Bash and/or SQL.
• Working knowledge of database security, IAM, encryption, networking, Secrets Manager, compliance and Database DevOps practices.
• Familiarity with CI/CD and schema migration tools such as AWS CodePipeline, GitLab CI, Jenkins, Flyway and Liquibase.

Certifications:

• AWS Certified Solutions Architect Associate or Professional (required or in progress).
• Additional AWS Specialty certifications in Data Analytics, Security or Machine Learning preferred.

Preferred Qualifications:

• Hands-on Oracle-to-Aurora PostgreSQL/postgreSQL modernization, including PL/SQL refactoring, Oracle feature mitigation and application compatibility validation.
• Experience with commercial database license-elimination and cloud-modernization programmes.
• Familiarity with Aurora Serverless v2, RDS Proxy and Aurora Global Database for advanced HA/scalability.
• Advanced DynamoDB modelling, GSI strategies and event-driven patterns; familiarity with Neptune, Cassandra/Amazon Keyspaces and graph/wide-column workloads.
• Experience implementing Database DevOps pipelines, automated database testing and AWS ProServ delivery standards; ITIL/change-management familiarity preferred.