AWS Database Consultant

Join our AWS team as an AWS Database Engineer at the Consultant level, focusing on designing, migrating, and optimizing database solutions in AWS cloud environments. This role requires deep technical expertise to support complex AWS projects, ensuring data integrity, performance, and scalability. You will architect and implement solutions using services like Amazon RDS, Aurora, DynamoDB, Redshift, and DocumentDB, lead migrations, optimize performance, and manage infrastructure aspects including security and disaster recovery.

Must Have

• Architect and implement AWS database solutions (RDS, Aurora, DynamoDB, Redshift, DocumentDB).
• Lead database migrations to AWS using Terraform, DMS, and Schema Conversion Tool.
• Optimize database performance (indexing, query tuning, partitioning, ElastiCache).
• Manage infrastructure aspects of databases (storage, backups, replication, disaster recovery).
• Develop automation scripts and pipelines (Terraform, Lambda, CloudFormation).
• Perform security assessments, implement access controls, and monitor database health.
• Minimum 8 years of experience in database engineering, with at least 5 years in AWS environments.
• Expert-level proficiency in AWS migrations.
• Strong hands-on experience with Terraform for managing database infrastructure as code.
• Comprehensive infrastructure knowledge (storage types, IOPS provisioning, EC2, Lambda).
• Expertise in network configurations for databases.
• Proficiency in SQL/NoSQL databases (MySQL, PostgreSQL, MongoDB) and tools.
• AWS Certified Data Engineer – Associate (Mandatory).
• AWS Certified Solutions Architect – Associate (Mandatory).

Good to Have

• Knowledge of AWS Connect for database-driven applications (integrating with Lex for chatbots or Kinesis for streaming data).
• Experience with data migration tools like AWS SCT and third-party ETL software.
• AWS Certified Database – Specialty (Important).
• Terraform Associate certification (Important).

Why SoftwareOne?

SoftwareOne and Crayon have come together to form a global, AI-powered software and cloud solutions provider with a bold vision for the future. With a footprint in over 70 countries and a diverse team of 13,000+ professionals, we offer unparalleled opportunities for talent to grow, make an impact, and shape the future of technology. At the heart of our business is our people. We empower our teams to work across borders, innovate fearlessly, and continuously develop their skills through world-class learning and development programs. Whether you're passionate about cloud, software, data, AI, or building meaningful client relationships, you’ll find a place to thrive here. Join us and be part of a purpose-driven culture where your ideas matter, your growth is supported, and your career can go global.

The role

Join our AWS team as an AWS Database Engineer at the Consultant level, where you will focus on designing, migrating, and optimizing database solutions in AWS cloud environments. This role requires deep technical expertise to support complex AWS projects, ensuring data integrity, performance, and scalability.

Key Responsibilities

• Architect and implement AWS database solutions using services like Amazon RDS, Aurora, DynamoDB, Redshift, and DocumentDB, tailored for high-performance and resilient applications.
• Lead database migrations to AWS using Terraform for IaC, DMS (Database Migration Service), and Schema Conversion Tool, minimizing data loss and downtime in complex scenarios.
• Optimize database performance through indexing, query tuning, partitioning, and integration with caching services like ElastiCache.
• Configure AWS Connect integrations with databases for real-time data handling in contact centers, such as storing call logs in S3 or querying customer data from RDS.
• Manage infrastructure aspects of databases, including storage (EBS, S3), backups, replication (cross-region/global), and disaster recovery using services like AWS Backup.
• Collaborate with network and application teams to ensure secure data access, implementing VPC endpoints, IAM roles, and encryption (KMS) for compliance.
• Develop automation scripts and pipelines for database provisioning, scaling, and monitoring using Terraform, Lambda, and CloudFormation.
• Perform security assessments, implement access controls, and monitor database health with CloudWatch, Performance Insights, and AWS Trusted Advisor.
• Troubleshoot complex issues in hybrid environments, including on-premises to AWS migrations and multi-database integrations.
• Contribute to best practices for data modeling, ETL processes, and big data handling with services like Glue and Athena.

What we need to see from you

• Bachelor's or Master's degree with experience in the relevant field
• Minimum 8 years of experience in database engineering, with at least 5 years in AWS environments.
• Expert-level proficiency in AWS migrations, including homogeneous/heterogeneous database transfers and post-migration optimizations.
• Strong hands-on experience with Terraform for managing database infrastructure as code, including drift detection and version control.
• Knowledge of AWS Connect for database-driven applications, such as integrating with Lex for chatbots or Kinesis for streaming data.
• Comprehensive infrastructure knowledge, including storage types, IOPS provisioning, and integration with compute services like EC2 and Lambda.
• Expertise in network configurations for databases, such as private subnets, NAT gateways, and peering for secure connectivity.
• Demonstrated ability to manage complex AWS projects, including data warehousing, real-time analytics, and serverless data solutions.
• Proficiency in SQL/NoSQL databases (e.g., MySQL, PostgreSQL, MongoDB) and tools like pgAdmin or DynamoDB streams.
• Excellent analytical skills and experience with data migration tools like AWS SCT and third-party ETL software.
• Certifications:
• AWS Certified Data Engineer – Associate (Mandatory)
• AWS Certified Solutions Architect – Associate (Mandatory)
• AWS Certified Database – Specialty *(Important)
• Terraform Associate certification (Important)

Job Function

Software & Cloud