What are the responsibilities and job description for the Database Administrator (PostgreSQL AWS RDS and DMS) position at Maania Consultancy Services?
Required Qualifications
- 5 years of experience with PostgreSQL, including advanced query optimization and performance tuning.
- Strong knowledge of indexing strategies, query execution plans, and database internals.
- Experience managing AWS RDS for PostgreSQL in production environments.
- Hands-on experience with AWS DMS for data migration and replication.
- Proficiency in SQL, PL/pgSQL, and scripting (Python, Bash, etc.) for automation.
- Strong experience with database backup, restore, and disaster recovery strategies.
- Ability to troubleshoot and optimize database performance under real-world constraints.
- Active or ability to obtain a TSA Clearance is required
- Experience with AWS data services (Kinesis, EventBridge, Athena, Glue, Firehose).
- Familiarity with NoSQL databases (DynamoDB, Redis, etc.) in AWS environments.
- Understanding of data warehousing concepts and ETL pipelines.
- Experience with Infrastructure-as-Code (Terraform, CloudFormation).
- Exposure to CI/CD pipelines and DevOps best practices for database deployments
