Database Architect

Description :

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 :

- Implement encryption, IAM roles, and secure access policies for sensitive data.

Documentation & Standards :

Collaboration & Leadership :

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