Database Expert

Analyze, design, and maintain both relational (PostgreSQL, MySQL on AWS RDS, Aurora) and NoSQL (MongoDB on Atlas) databases across cloud platforms (AWS, OCI).

Provision, configure, and manage databases using Database-as-a-Service (DBaaS) tools like AWS RDS, Aurora, MongoDB Atlas, and OCI Autonomous DB.

Monitor performance and availability of managed databases using native monitoring tools (e.g., CloudWatch, Performance Insights, Atlas Metrics).

Define and manage parameter groups, read replicas, and scaling configurations in DBaaS environments.

Implement automated backup strategies, snapshot policies, and cross-region replication for high availability and disaster recovery.

Ensure data encryption at rest and in transit, using cloud-native KMS tools or customer-managed keys.

Control and audit database access using IAM roles, VPC security, network whitelisting, and fine-grained user roles.

Optimize cost and performance using DBaaS features such as auto-scaling, query tuning, indexing, and storage tiering.

Implement and monitor alerts, health checks, and slow query logs using AWS CloudWatch, MongoDB Atlas alerts, and third-party observability tools.

Enforce data security, retention, and compliance policies aligned with regulations (e.g., PCI DSS, GDPR, SOC 2) using managed features and audits.

Collaborate with DevOps and Data Engineering teams to support CI/CD pipelines and infrastructure-as-code for database changes (e.g., using Terraform, CloudFormation).

Manage schema migrations and versioning using tools like Liquibase, Flyway, or Alembic in cloud environments.

Create, maintain, and document standard operating procedures for database provisioning, incident response, and change management.

Perform capacity planning and cost forecasting using metrics and usage trends across cloud platforms.

Participate in incident management, root cause analysis, and escalation processes for critical database issues.

Assist with data integrations between databases and analytics platforms (e.g., DMS, Glue, Kafka Connect).

• Carry out other duties as assigned, based on the evolving cloud strategy and business needs.