Database Architect

Cubic Transportation Systems; Hyderabad; On-site; INR 2,600,000 - 4,200,000; Full time

Job summary

Cubic Transportation Systems in Hyderabad is hiring a Database Architect to design and optimize enterprise-grade databases across Oracle, PostgreSQL and NoSQL with strong AWS cloud experience. You will lead migrations, performance tuning, and cloud-native modernization to support mission-critical transportation solutions.

This role requires expertise in SQL/PLSQL, Liquibase tooling, and scripting in Shell and Python, with a focus on security and compliance.

Qualifications

• 10-12+ years in database design and development with Oracle and PostgreSQL expertise.
• Hands-on with AWS database services (RDS, Aurora, DynamoDB).
• Proficient in SQL, PL/SQL and PostgreSQL language.
• Experience with database migration tools and strategies.
• Familiarity with Liquibase or similar versioning tools.
• Scripting in Shell and Python for automation.
• Understanding PCI DSS, security best practices and compliance.

Responsibilities

• Define and implement database architecture for transactional and analytical systems.
• Lead migrations from Oracle to PostgreSQL or hybrid architectures.
• Optimize legacy systems for cloud-native deployments and performance.
• Design schemas, indexing, and partitioning for scalability.
• Ensure high availability, backup, and disaster recovery in AWS.
• Integrate IaC for database provisioning and CI/CD pipelines.

Skills

Oracle & PostgreSQL

AWS database services

NoSQL databases

SQL/PLSQL

Database migration

Liquibase tooling

Shell & Python

PCI DSS & security

Tools

Terraform

Liquibase

AWS CloudFormation

DynamoDB

RDS/Aurora

MongoDB

Job description

Job Description:

Business Unit

Cubic Transportation Systems

Company Details

When you join Cubic, you become part of a company that creates and delivers technology solutions in transportation to make people’s lives easier by simplifying their daily journeys, and defense capabilities to help promote mission success and safety for those who serve their nation. Led by our talented teams around the world, Cubic is committed to solving global issues through innovation and service to our customers and partners. We have a top-tier portfolio of businesses, including Cubic Transportation Systems (CTS) and Cubic Defense (CD). Explore more on Cubic.com.

Job Details

Job Summary

The Database Architect is responsible for designing, implementing, and optimizing enterprise-grade database solutions across relational and NoSQL platforms. This role requires deep expertise in Oracle, PostgreSQL, and NoSQL databases, with strong experience in AWS cloud services for high availability, scalability, and security. The position involves leading database architecture strategy, migration projects, and performance tuning for mission-critical applications.

Key Responsibilities

• Database Architecture & Design:
  • Define and implement database architecture for transactional and analytical systems using Oracle, PostgreSQL, and NoSQL (e.g., DynamoDB, MongoDB).
  • Design schemas, indexing strategies, and partitioning for optimal performance and scalability.
• Cloud Integration:
  • Architect and deploy database solutions on AWS using services like RDS, Aurora, DynamoDB, and S3.
  • Implement high availability, disaster recovery, and backup strategies in cloud environments.
• Migration & Modernization:
  • Lead migration projects from Oracle to PostgreSQL or hybrid architectures.
  • Optimize legacy systems for cloud-native deployments.
• Performance Tuning & Optimization:
  • Conduct query optimization, indexing, and caching strategies for large-scale databases.
  • Monitor and troubleshoot performance issues in production environments.
• Automation & DevOps Integration:
  • Implement Infrastructure as Code (IaC) for database provisioning using Terraform, Liquibase, or AWS CloudFormation.
  • Integrate database deployments into CI/CD pipelines.
• Security & Compliance:
  • Apply PCI DSS and data security best practices for payment-related systems.
  • Implement encryption, IAM roles, and secure access policies for sensitive data.
• Documentation & Standards:
  • Maintain detailed architecture diagrams, migration plans, and operational procedures.
• Collaboration & Leadership:
  • Work closely with application architects, DevOps teams, and business stakeholders.
  • Mentor junior engineers and provide technical guidance across projects.

Required Skills & Qualifications

• Experience: 10-12+ years in database design and development, with strong Oracle and PostgreSQL expertise.
• Hands-on experience with AWS database services (RDS, Aurora, DynamoDB).
• Proficiency in NoSQL databases (MongoDB, DynamoDB).
• Strong knowledge of SQL, PL/SQL, and PostgreSQL procedural language.
• Experience with database migration tools and strategies.
• Familiarity with Liquibase or similar database versioning tools.
• Scripting skills in Shell and Python for automation.
• Understanding of networking concepts, security best practices, and compliance standards (PCI DSS).

Worker Type

Employee

We are committed to creating an inclusive workplace and welcome applications from people of all backgrounds. We do not discriminate based on any protected characteristic under applicable law.