Aws PostgreSQL Database Administrator

POSITION: AWS PostgreSQL Database Administrator (DBA) [5-6 Years] (Ref: APDBAMF1)

This is an urgent requirement for an US organization to be based in Chennai. You will be on a payroll of their Indian associate and

report directly to US management.

Experience : 5-6 Years

Salary : Much higher than current CTC

Time frame : Will be finalized ASAP

Position Overview:
As an AWS PostgreSQL Database Administrator (DBA), you will play a critical role in managing and maintaining the performance,

integrity, and security of PostgreSQL databases hosted on the Amazon Web Services (AWS) platform. Your responsibilities will

include database design, implementation, monitoring, optimization, and troubleshooting to ensure the availability and reliability of

database systems.

Qualifications:

- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Proven experience as a PostgreSQL Database Administrator, preferably in an AWS environment.
- Strong understanding of database design principles, performance optimization, and security best practices.
- Hands-on experience with AWS services, particularly Aurora/RDS, EC2, and related tools.
- Proficiency in scripting languages such as Python, Bash, or PowerShell.
- Knowledge of database migration strategies and tools.
- Certification - AWS Certified Database
- Specialty, PostgreSQL.

Key Responsibilities:
1. Database Design and Implementation:
meet business requirements.

**Ensure optimal database schema design, indexing, and partitioning for performance and scalability.**

2. Database Administration:

- Install, configure, and upgrade PostgreSQL database software.
- Create and manage database instances on AWS RDS/Aurora or EC2 instances.
- Perform regular database maintenance tasks, including backups, restores, and disaster recovery procedures.

3. Performance Monitoring and Optimization:
**Monitor database performance and proactively address issues to ensure optimal performance.**

**Identify and implement performance tuning strategies, including query optimization and indexing.**

4. Security and Compliance:

- Implement and enforce security best practices to safeguard sensitive data.
- Ensure compliance with data protection regulations and industry standards.

5. High Availability and Disaster Recovery:

- Configure and manage high availability solutions such as streaming replication and logical replication.
- Develop and maintain disaster recovery plans to minimize downtime in the event of a failure.

6. Automation and Scripting:

- Implement automation scripts for routine database tasks using tools like AWS CLI, Python, or other relevant technologies.
- Work on infrastructure as code (IaC) to automate the deployment and maintenance of database environments.

7. Collaboration and Documentation:

- Collaborate with cross-functional teams to troubleshoot and resolve database-related issues.
- Maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

8. Capacity Planning:

- Monitor database growth trends and plan for scaling resources as needed.
- Recommend and implement capacity planning strategies to ensure sufficient resources for future demands.

Other Requirement & Knowledge:

- Strong critical / analytical thinking and problem-solving skills.
- Ability to multi-task and thrive in fast paced, rapidly changing and complex environment.
- Good written and verbal communication skills.

If you are interested, please send your updated resume with current and expected CTC or call us.

Regards,

Divya T

HR Manager

Mayon Soft Private Limited

+91 7904663792
/ +91 7338992461

jobs mayonsoft
com

**Job Types**: Full-time, Permanent

**Salary**: ₹1,000,000.00 - ₹1,200,000.00 per year

Schedule:

- Fixed shift
- US shift

Work Location: Remote

**Speak with the employer**

+91 7904663792