Senior Database Administrator (AWS RDS PostgreSQL | MongoDB Atlas)

About Paydoh Paydoh is a next-generation fintech platform enabling digital banking and payment solutions for financial institutions. Our platform is built using modern cloud-native technologies on AWS with a strong focus on scalability, security, high availability, and operational excellence. As part of our technology modernization strategy, we are standardizing our production database platform by migrating workloads from MongoDB Atlas to Amazon RDS for PostgreSQL. This initiative will improve system reliability, reduce operational complexity, enhance data integrity, and optimize infrastructure costs. We are looking for a highly skilled Senior Database Administrator (DBA) to take ownership of our production database environment and lead this strategic transformation.

Position Summary The Senior Database Administrator will be responsible for managing, securing, monitoring, and optimizing Paydoh's production databases. The role includes administration of Amazon RDS for PostgreSQL and MongoDB Atlas, ensuring high availability, performance, disaster recovery readiness, and database security. The successful candidate will also lead the migration from MongoDB Atlas to Amazon RDS for PostgreSQL by designing migration strategies, validating data integrity, optimizing database performance, and ensuring minimal downtime during production cutover.

Key Responsibilities Production Database Administration Own and manage all production databases. Administer Amazon RDS for PostgreSQL instances and MongoDB Atlas clusters. Ensure high availability, performance, scalability, and reliability of production databases. Perform database provisioning, configuration, upgrades, maintenance, and patch planning. Monitor database health, storage utilization, replication, and resource consumption. Support engineering teams during production deployments involving database changes. Troubleshoot and resolve database incidents within defined SLAs. Participate in on-call support for critical production database issues.

Amazon RDS PostgreSQL Administration Administer Amazon RDS for PostgreSQL production environments. Configure and manage Multi-AZ deployments. Manage Read Replicas where applicable. Configure parameter groups and option groups. Monitor Performance Insights and Enhanced Monitoring metrics. Optimize SQL queries, indexes, and execution plans. Perform database maintenance including VACUUM, ANALYZE, and statistics management. Manage snapshots, automated backups, and point-in-time recovery. Monitor database growth and perform capacity planning. Ensure high database availability and performance.

MongoDB Atlas Administration Administer MongoDB Atlas clusters and projects. Monitor Atlas performance and cluster health. Manage cluster sizing and cost optimization. Configure backup and restore policies. Utilize Atlas Performance Advisor and Query Profiler to identify optimization opportunities. Manage users, roles, API keys, IP Access Lists, and network security configurations. Ensure MongoDB Atlas environments remain secure and compliant until migration is completed.

Database Security & Access Management Manage database users, roles, permissions, and administrative credentials. Integrate database credentials with AWS Secrets Manager. Implement Role-Based Access Control (RBAC). Enforce least-privilege access principles. Perform periodic database security reviews and access audits. Support internal security, compliance, and audit requirements.

Backup, Recovery & Disaster Recovery Design and maintain automated backup strategies. Validate backup integrity through periodic restore testing. Define and maintain Disaster Recovery procedures. Ensure Recovery Point Objective (RPO) and Recovery Time Objective (RTO) targets are met. Participate in business continuity planning and disaster recovery drills.

Performance Monitoring & Optimization Continuously monitor database performance and availability. Identify and resolve performance bottlenecks. Analyze slow queries and optimize execution plans. Improve indexing strategies and database design. Monitor locking, deadlocks, and transaction performance. Recommend improvements to enhance scalability and efficiency.

MongoDB Atlas to Amazon RDS PostgreSQL Migration Lead the end-to-end migration initiative, including: Assessment of existing MongoDB Atlas schemas and collections. Data modeling and relational schema design. Data transformation and migration planning. Migration automation and execution. Data reconciliation and validation. Performance benchmarking. Production cutover planning. Rollback strategy development. Post-migration optimization. Documentation of migration architecture and operational procedures.

Engineering Collaboration Work closely with Backend, DevOps, QA, Product, and Infrastructure teams. Support application releases involving database changes. Review database design and schema modifications. Assist developers with SQL optimization and best practices. Participate in Root Cause Analysis (RCA) for production incidents. Recommend database architecture improvements to support future business growth.

Documentation Maintain comprehensive documentation for: Database Architecture Backup & Recovery Procedures Disaster Recovery Runbooks Migration Plans Security Standards Operational SOPs Database Monitoring Procedures Capacity Planning Reports

Required Technical Skills (Mandatory) 2+ years of Database Administration experience. Strong hands-on experience with Amazon RDS for PostgreSQL. Experience administering MongoDB Atlas production environments. Advanced SQL programming and query optimization. PostgreSQL performance tuning and indexing. Experience with RDS Multi-AZ, snapshots, backups, and point-in-time recovery. Experience using Amazon RDS Performance Insights and Enhanced Monitoring. Backup, restore, and disaster recovery planning. Linux administration and shell scripting. Database security and access management. AWS Secrets Manager. Git version control. Strong analytical and troubleshooting skills.

Preferred AWS Certified Database – Specialty or AWS Solutions Architect certification. Experience with database migration projects. Terraform or Infrastructure as Code. Docker and Kubernetes. Jenkins or GitHub Actions. Amazon CloudWatch, Grafana, and Prometheus. Experience supporting high-transaction fintech or banking applications.

Qualifications Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline. Relevant AWS and PostgreSQL certifications are an advantage.

Desired Competencies Strong ownership and accountability. Excellent problem-solving and analytical skills. Ability to work in a fast-paced production environment. Effective communication and documentation skills. Strong collaboration across engineering and operations teams. Commitment to operational excellence and continuous improvement.

Success Metrics 99.99% production database availability. Zero critical database security incidents. Successful migration from MongoDB Atlas to Amazon RDS for PostgreSQL. Improved database performance and application response times. Reduction in database infrastructure and maintenance costs. Reliable backup and disaster recovery processes with validated recovery procedures. Complete and up-to-date operational documentation. High engineering satisfaction through timely production support and database optimization.

Technology Stack Cloud Platform: AWS Relational Database: Amazon RDS for PostgreSQL NoSQL Database: MongoDB Atlas Programming Language: Go (Golang) Architecture: Microservices Container Platform: Docker, Amazon ECS Infrastructure as Code: Terraform Monitoring: Amazon CloudWatch, Grafana, Prometheus CI/CD: Jenkins, GitHub Actions Secrets Management: AWS Secrets Manager Version Control: Git

Location: Mumbai (India) Experience: 2–5 Years

Employment Type: Full-Time Department: Engineering

CTC- Upto 5.5 LPA Interested candidates can share their updated CVs at

seema@paydoh.in .