Job Description

:
This role is for one of the Weekday's clients
Min Experience: 8 years
Location: Gurgaon
JobType: full-time
We are seeking an experienced AWS Database Expert with a strong focus on PostgreSQL to manage, optimize, and secure databases in a high-availability cloud environment. This role will play a key part in supporting scalable applications, especially within fintech and other data-intensive domains. You will be responsible for performance tuning, automation, disaster recovery, and compliance within a mission-critical AWS setup.
Requirements:
Key Responsibilities:

• Design, deploy, and maintain PostgreSQL databases on AWS with a focus on high availability, scalability, and performance.
• Implement robust backup, disaster recovery, and failover strategies to ensure data protection and availability.
• Continuously monitor and fine-tune database performance using tools such as Amazon CloudWatch.
• Conduct regular security reviews, patch updates, and implement best practices to ensure compliance with industry standards.
• Work closely with development teams to optimize database schemas, indexing, and SQL queries.
• Manage and maintain AWS RDS and Aurora PostgreSQL instances, including provisioning, patching, and upgrades.
• Automate administrative tasks using scripting languages like Python, Bash, or equivalent.
• Provide technical expertise and guidance to teams on database optimization, query tuning, and cloud-native data management.
• Stay up-to-date with evolving database technologies and AWS services to continuously enhance system performance and reliability.

Required Skills & Qualifications:

• Deep hands-on experience in managing and tuning PostgreSQL databases, especially within AWS environments.
• Expertise in AWS services including RDS, Aurora, EC2, S3, IAM, CloudWatch, and AWS CLI.
• Strong understanding of database security, disaster recovery planning, and data integrity practices.
• Proficiency in scripting and automation tools (Python, Bash, or similar).
• Familiarity with networking fundamentals such as DHCP, DNS, and load balancing.
• Ability to create detailed documentation for systems architecture, standard procedures, and configurations.
• Demonstrated experience working collaboratively with cross-functional teams in agile and DevOps environments.

Educational Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent professional experience).
• A minimum of 10 years of experience in database administration with a specialization in PostgreSQL and AWS-based infrastructures.

Technical Skills:
Core Database: PostgreSQL
AWS Services: RDS, Aurora, EC2, S3, IAM, CloudWatch, AWS CLI
Performance & Reliability: Indexing, Query Optimization, Partitioning, Disaster Recovery, Performance Tuning
Scripting & Automation: Python, Bash
Security & Compliance: Backup, Patching, Access Control