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:
The Senior Software Engineer – Database is responsible for designing, developing, and maintaining robust database solutions across relational and NoSQL platforms. This role requires hands-on experience with Oracle, PostgreSQL, and NoSQL databases, along with strong knowledge of AWS cloud services for secure and scalable deployments.
Key Responsibilities
- Database Development & Maintenance:
- Design, develop, and optimize database schemas, queries, and stored procedures for Oracle and PostgreSQL.
- Implement NoSQL solutions (e.g., DynamoDB, MongoDB) for high-performance applications.
- Cloud Integration:
- Deploy and manage databases on AWS using services like RDS, Aurora, and DynamoDB.
- Ensure high availability, backup, and disaster recovery strategies in cloud environments.
- Migration & Modernization:
- Assist in migrating legacy Oracle databases to PostgreSQL or hybrid architectures.
- Performance Tuning:
- Optimize queries, indexing, and caching strategies for large-scale databases.
- Automation & DevOps:
- Use tools like Liquibase for database versioning and integrate with CI/CD pipelines.
- Write scripts in Shell or Python for automation and operational tasks.
- Security & Compliance:
- Apply best practices for securing sensitive data, including encryption and IAM roles.
- Collaboration:
- Work closely with application developers and cloud engineers to ensure seamless integration.
Required Skills & Qualifications
- Experience: 6+ years in database development and administration.
- Strong expertise in Oracle and PostgreSQL.
- Hands-on experience with AWS database services (RDS, Aurora, DynamoDB).
- Familiarity with NoSQL databases (MongoDB, DynamoDB).
- Proficiency in SQL, PL/SQL, and PostgreSQL procedural language.
- Experience with Liquibase or similar tools for database version control.
- Scripting skills in Shell and Python.
- Knowledge of Agile/Scrum methodologies.
Preferred Qualifications
- AWS certification (Database Specialty or Solutions Architect).
- Experience with data migration projects and ETL pipelines.
- Familiarity with containerized database deployments (Docker, Kubernetes).
Worker Type:
Employee