Aws PostgreSQL Database Administrator

Designation - AWS PostgreSQL Database Administrator (DBA)

No of Positions opening for : 1

Experience must be between 3-4 Years

CTC upto - 13,00,000

**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.

**Key Responsibilities**:
1. Database Design and Implementation:
design and implement PostgreSQL database solutions that 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.

**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.
- Excellent problem-solving and communication skills.

Certifications (preferred):

- AWS Certified Database - Specialty
- PostgreSQL Certification

Join our dynamic team and contribute to the success of our organization by ensuring

the reliability and performance of our PostgreSQL databases on the AWS platform.

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

**Benefits**:

- Health insurance

Schedule:

- Day shift

Ability to commute/relocate:

- Tharamani, Chennai, Tamil Nadu: Reliably commute or planning to relocate before starting work (preferred)

Application Question(s):

- Hands-on experience with AWS services, particularly Aurora/RDS, EC2, and

related tools. Mandatory*
- Experience:

- total work: 3 years (required)

License/Certification:

- AWS Certified Database - Specialty (preferred)

Work Location: In person