Cloud Kinetics is looking for a Senior Database Architect tojoin our Proserv PoD (Practice on Demand) team. In this role, you will bedeployed on AWS Professional Services engagements in India, working hands-on todesign, architect, and deliver database solutions for enterprise customers onAWS. You will serve as the leading database expert, translating complex datarequirements into scalable, secure, and high-performance cloud-native databasearchitectures that align with AWS best practices and customer success criteria.As a Senior Database Architect within Cloud Kinetics’ Proserv PoD, you will beembedded in AWS ProServ engagements, leading database strategy and design,executing database migration and modernization workstreams, and implementingdatabase automation frameworks. You will work closely with SolutionsArchitects, Data Engineers, Migration Leads, and customer database teams todrive database transformation outcomes that meet AWS Well-Architected.
KEY RESPONSIBILITIES
- Designand architect enterprise-scale AWS database solutions spanning relational,NoSQL, in-memory, graph, and time-series database engines to meet diverseworkload requirements.
- Developcomprehensive database architecture blueprints, data models, capacityplans, and migration strategies aligned with customer business objectivesand AWS Well-Architected Framework principles.
- Evaluateand recommend the right AWS database service for each workload — AmazonRDS, Aurora (MySQL/PostgreSQL), DynamoDB, ElastiCache (Redis/Memcached),Redshift, Document DB, Keyspaces, Timestream, QLDB, and Amazon Neptune.
- Designfor high availability, multi-AZ/multi-region failover, disaster recovery,and business continuity across all database tiers using AWS-nativereplication and backup capabilities.
- Collaboratewith Solutions Architects to integrate database designs into broader cloudarchitecture blueprints, ensuring end-to-end alignment with security,compliance, and cost optimization requirements.
Database Migration & Modernization
- Leadend-to-end database migration engagements, including assessment, schemaconversion, data migration, validation, and cutover activities using AWSDatabase Migration Service (DMS) and AWS Schema Conversion Tool (SCT).
- Executeheterogeneous database migrations including Oracle to Amazon Aurora/RDSPostgreSQL, SQL Server to RDS/Aurora, MySQL to Aurora, and commercialdatabase to open-source/cloud-native migrations.
- DeliverOracle to Aurora migration projects, including schema conversion, storedprocedure refactoring, PL/SQL to PL/pgSQL translation, and applicationcompatibility validation.
- Performpre-migration assessments, database health checks, schema complexityanalysis, and migration wave planning to minimize risk and customerdowntime during migration windows.
- Conductpost-migration validation including data integrity checks, performancebenchmarking, application compatibility testing, and production readinessassessments.
- Documentmigration runbooks, cutover plans, rollback procedures, and post-migrationconfiguration records for handover to customer database operations teams.
Database Performance & Optimisation
- Performdatabase performance tuning, query optimization, indexing strategy design,and
- executionplan analysis across relational and NoSQL database engines on AWS.
- Designand implement NoSQL data models for DynamoDB, DocumentDB, and Cassandra- compatibleworkloads, applying access pattern analysis, partition key design, andsingle-table design principles.
- Implementcaching strategies using Amazon ElastiCache (Redis/Memcached) to reducedatabase load, improve application response times, and enhance overallsystem throughput.
- Analyseand resolve database bottlenecks, locking contention, connection poolingissues, and storage I/O performance constraints in production AWSenvironments.
- ConductAWS Well-Architected Framework reviews focused on the Database andPerformance Efficiency pillars, providing actionable remediation roadmapsfor customer database environments.
Database Security, Compliance & Automation
- ImplementAWS database security best practices including encryption at rest (KMS),encryption in transit (TLS), IAM database authentication, VPC networkisolation, and AWS Secrets Manager for credential management.
- Designand implement Database DevOps (DB DevOps) pipelines using CI/CD tooling toautomate schema migrations, database deployments, configurationmanagement, and drift detection.
- Developdatabase automation scripts and infrastructure-as-code (IaC) templatesusing Terraform, AWS CloudFormation, and/or AWS CDK to provision andmanage database infrastructure in a repeatable, version-controlled manner.
- Configuredatabase monitoring and observability solutions using Amazon CloudWatch,Amazon RDS Performance Insights, AWS CloudTrail, and third-partymonitoring tools to ensure proactive issue detection and resolution.
- Supportcompliance and governance requirements including data residency, auditlogging, GDPR, PCI-DSS, and HIPAA controls within AWS databaseenvironments.
Delivery Collaboration & Thought Leadership
- Workwithin Agile/Scrum delivery frameworks, participating in sprint planning,daily stand-ups, and retrospectives as part of AWS ProServ engagementteams.
- Collaborateclosely with Solutions Architects, Data Engineers, Project Managers, andcustomer database teams to ensure database delivery aligns with projecttimelines and engagement milestones.
- Producetechnical documentation including database architecture diagrams, dataflow diagrams, design decision records, runbooks, and operational handoverdocuments to support customer knowledge transfer.
- Contributeto the development of reusable database accelerators, migration playbooks,IaC modules, and delivery templates that improve efficiency across CloudKinetics ProServ engagements.
- Mentorjunior database engineers and team members, sharing database expertise,best practices, and AWS database service knowledge across the ProServ PoDteam.
Required Qualifications : Education &Experience
- Bachelor'sdegree in Computer Science, Engineering, Information Technology, or arelated
- technicalfield, or equivalent practical experience.
- 10–14years of overall experience in database architecture, databaseengineering, or data
- platformroles.
- 5–7years minimum of hands-on experience designing and implementing databasesolutions on AWS in production environments.
- Provenexperience leading database migration engagements, including heterogeneousmigrations (Oracle, SQL Server, MySQL) to AWS-managed database services.
- Demonstratedexpertise in both relational and NoSQL database design, data modelling,and query optimisation across multiple database engines.
- Experienceworking in professional services, consulting, or managed services deliveryenvironments preferred.
Technical Skill:
- Deephands-on expertise with AWS relational database services: Amazon RDS(MySQL, PostgreSQL, MariaDB, Oracle, SQL Server), Amazon Aurora(MySQL-compatible and PostgreSQL-compatible editions).
- Strongproficiency with AWS NoSQL and specialty database services: AmazonDynamoDB, Amazon DocumentDB, Amazon ElastiCache (Redis/Memcached), Amazon Keyspaces, Amazon Timestream, and Amazon QLDB.
- Hands-onexperience with Amazon Neptune for graph database workloads, includinggraph data modelling (property graph and RDF), Gremlin and SPARQL querylanguages, and Neptune use cases (knowledge graphs, fraud detection,recommendation engines).
- Proficiencywith AWS database migration tooling: AWS Database Migration Service (DMS)and AWS Schema Conversion Tool (SCT) for heterogeneous and homogeneousmigrations.
- StrongSQL skills including advanced query writing, stored procedure development,indexing strategy, execution plan analysis, and query tuning acrossmultiple relational database engines.
- Experiencewith database infrastructure-as-code tools: Terraform, AWS CloudFormation,and/or AWS CDK for database provisioning and lifecycle management.
- Solidunderstanding of database security principles: encryption at rest/intransit, IAM database authentication, VPC network isolation, SecretsManager, and compliance controls.
- Familiaritywith Database DevOps (DB DevOps) practices including CI/CD pipelines forschema migrations, automated testing, and database deployment automationusing tools such as Flyway, Liquibase, or AWS CodePipeline.
- Experiencewith Amazon Redshift for data warehousing workloads including clusterdesign, distribution/sort key strategy, Redshift Spectrum, and RA3 nodearchitecture.
- Scriptingand automation skills in Python, Bash, and/or SQL for operationalworkflows, data migration scripts, and database automation tasks.
Certifications:
- AWSCertified Database – Specialty (required).
- AWSCertified Solutions Architect – Associate or Professional (required or inprogress).
- AdditionalAWS Specialty certifications (Data Analytics, Security, or MachineLearning) preferred.
Preferred Qualifications: Advanced DatabaseModernization
- Hands-onexperience leading Oracle to Amazon Aurora (PostgreSQL-compatible)migration projects, including PL/SQL refactoring, Oracle-specific featuremitigation, and application layer compatibility validation.
- Experiencewith commercial database license elimination strategies (Oracle/SQL Serverto open-source) as part of cost optimization and cloud modernizationprogrammed.
- Familiaritywith Aurora Serverless v2, RDS Proxy, and Aurora Global Database foradvanced high-availability and scalability architectures.
- AdvancedNoSQL data modelling expertise including DynamoDB single-table designpatterns, access pattern-driven schema design, global secondary index(GSI) strategies, and DynamoDB Streams for event-driven architectures.
- Experiencewith Amazon Neptune for graph workloads, including knowledge graphconstruction, fraud detection graphs, and social network recommendationuse cases.
- Familiaritywith Apache Cassandra workloads and Amazon Key spaces migration patternsfor wide-column NoSQL use cases.
DB DevOps & Delivery Tooling
- Hands-onexperience implementing Database DevOps pipelines using CI/CD tools (AWSCodePipeline, GitLab CI, Jenkins) with schema migration frameworks(Flyway, Liquibase) and automated database testing practices.
- Experiencewith AWS ProServ delivery methodology, engagement tooling, and artefactstandards.
- Familiaritywith ITSM frameworks (ITIL) and change management processes relevant toenterprise database migration and modernization projects.