We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements.

Responsibilities

• Manage, configure, and maintain PostgreSQL databases, ensuring high availability and reliability.
• Implement Primary-Slave replication architecture and ensure smooth data synchronization.
• Work with AWS RDS for PostgreSQL database hosting.
• Automate database backups and manage release versions for database changes.
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery.
• Regularly monitor database health and performance metrics.
• Analyze and optimize slow queries to enhance application performance.
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory.
• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views.
• Implement indexing strategies to improve query performance.
• Work closely with application developers and business analysts to understand new product requirements.
• Provide recommendations on database design and architecture for scalable solutions.
• Implement best practices for database security, access control, and data integrity.
• Ensure compliance with data governance and security policies.
• Automate database maintenance tasks such as backups, indexing, and archiving.
• Establish monitoring and alerting systems to proactively address database issues.
  
  

Requirements

• 3 to 6 years of experience as a Database Administrator (DBA).
• Strong knowledge of PostgreSQL and RDBMS principles.
• Experience in writing stored procedures, SQL functions, and SQL Views.
• Hands-on experience in query optimization and performance tuning.
• Understanding of Primary-Slave architecture and replication setup.
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc. )
• Experience in automating database backups and version control for DB changes.
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR).
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP).
• Strong problem-solving and analytical skills.
• Experience in high-availability solutions and disaster recovery strategies.
• Exposure to NoSQL databases is a plus.
• Experience with database migrations and upgrades.
  
  

This job was posted by Kalpna Panwar from Suzuki Digital.