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.
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.
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.
AWS certification (Database Specialty or Solutions Architect).
Experience with data migration projects and ETL pipelines.
Familiarity with containerized database deployments (Docker, Kubernetes).