Software Architect For DB

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.

• 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.

• 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).