Database Administrator

Pune - India

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Description:

1. DDL & Schema Management

Change Execution: Deploy DDL changes (e.g. CREATE ALTER DROP) across Dev QA and Production environments.
Impact Review: Check migration scripts for expensive operations that might lock large tables or cause downtime.
Version Control: Utilize schema migration tools (like Liquibase or Flyway) to track database versions.

2. Monitoring & Health Checks

Dashboarding: Use Amazon CloudWatch to monitor metrics like CPU Utilization Free Storage Space and Database Connections.
Performance Insights: Use RDS Performance Insights to identify the top SQL queries causing load on the system.
Log Analysis: Regularly review error logs and slow query logs to proactively catch issues before they become outages.

3. Data Protection & Security

Backup & Recovery: Manage automated snapshots and perform manual snapshots before major updates. Practice Point-in-Time Recovery (PITR).
Access Control: Manage database-level users and integrate with AWS IAM for secure authentication.
Encryption: Ensure Encryption at Rest (using KMS) and Encryption in Transit (SSL/TLS) are enforced.

4. Performance Tuning (Junior Level)

Indexing: Identify missing indexes based on query execution plans.
Instance Scaling: Assist in right-sizing instances (e.g. moving from a to an m

during growth phases).

Storage Management: Monitor disk usage and manage storage autoscaling or Provisioned IOPS (gp3 vs. io1).

Job Description: 1. DDL & Schema Management Change Execution: Deploy DDL changes (e.g. CREATE ALTER DROP) across Dev QA and Production environments. Impact Review: Check migration scripts for expensive operations that might lock large tables or cause downtime. Version Control: Utilize sc...