Sr Database Administrator-Amazon RDS, Amazon Aurora

Database Administrator (DBA)

production support

Amazon RDS, Amazon Aurora, Cassandra, and Document-based databases

Technical Skills

• Proven experiene in Amazon RDS, Amazon Aurora, Cassandra, and Document-based databases Administrator or similar role in production support environments.
• 10+ years of experience in database administration and production support roles.
• Hands-on experience managing and supporting Apache Cassandra in a production environment.
• Strong knowledge of Cassandra internals, architecture, data modeling, replication, and consistency levels.
• Proficiency in troubleshooting cluster issues, performance tuning, and capacity planning.
• Strong hands-on experience with:
• Amazon RDS (PostgreSQL, MySQL, or SQL Server).
• Apache Cassandra (including setup, scaling, repairs, and performance tuning).
• Document Databases (e.g., MongoDB, Amazon DocumentDB, Couchbase).
• Experience with cloud infrastructure (preferably AWS ), including EC2, S3, IAM, and VPC.
• Proficiency in Linux/Unix environments and shell scripting.
• Strong SQL and NoSQL data modeling and query optimization skills.
• Familiarity with backup/recovery tools, high availability, and disaster recovery strategies.
• Strong troubleshooting and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work in a 24/7 support rotation and handle urgent production issues.
  

Responsibilities

• Production Support & Monitoring
• Provide 24x7 production support for RDS (PostgreSQL/MySQL/SQL Server), Cassandra, and Document databases.
• Monitor database health, availability, and performance using AWS CloudWatch, Prometheus, Grafana, or similar tools.
• Triage and resolve database-related incidents and s in a timely manner.
• Perform root cause analysis and implement preventive measures for recurring issues.
• Database Maintenance & Administration
• Manage database configurations, backup, restore, and disaster recovery for all supported platforms.
• Perform software upgrades, security patches, and maintenance tasks with minimal downtime.
  

o

.

• Performance Tuning & Optimization
• Tune queries, indexes, and configurations for optimal performance across RDS, Cassandra, and Document stores.
• Analyze workloads and suggest improvements to data access patterns and schema design.
• Security & Compliance
• Support audits, compliance checks, and data protection policies across environments.
• Implement and enforce database security best practices (encryption, IAM policies, VPCs, RBAC, etc.).
• Automation & CI/CD Integration
• Automate operational tasks and deployments using scripts (Bash, Python) and IaC tools like Terraform or CloudFormation.
• Collaborate with DevOps teams to integrate database changes into CI/CD pipelines.
• Collaboration & Documentation
• Work closely with development, SRE, and infrastructure teams to support application rollouts and releases.
• Maintain detailed runbooks, SOPs, and incident post-mortem documentation.
  

Qualification

• Experience with AWS-native database services : Amazon DocumentDB, Keyspaces (for Cassandra), or DynamoDB.
• Familiarity with container orchestration (e.g., Kubernetes) and cloud-native application patterns.
• Hands-on experience with automation tools like Ansible, Terraform, or Jenkins.
• Certifications such as AWS Certified Database – Specialty, or AWS Solutions Architect Associate.
• Exposure to monitoring/logging tools like CloudWatch, DataDog, ELK stack, or Prometheus/Grafana.
  

Skills