Database Administrator (PostgreSQL)

Job Title: Database Administrator (PostgreSQL)
Experience: 3 to 6 years
Location: Gurgaon (Hybrid)
Employment Type: Full-time

Job Description:

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.

Key Responsibilities:

1. Database Administration & Management

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

2. Performance Monitoring & Optimization

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

3. SQL Development & Optimization

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views.
• Implement indexing strategies to improve query performance.

4. Collaboration & Requirement Analysis

• Work closely with application developers and business analysts to understand new product requirements.
• Provide recommendations on database design and architecture for scalable solutions.

5. Database Security & Compliance

• Implement best practices for database security, access control, and data integrity.
• Ensure compliance with data governance and security policies.

6. Automation & Maintenance

• Automate database maintenance tasks such as backups, indexing, and archiving.
• Establish monitoring and alerting systems to proactively address database issues.

Technical Expertise Required:

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

Preferred Qualifications:

• Experience in high-availability solutions and disaster recovery strategies.
• Exposure to NoSQL databases is a plus.
• Experience with database migrations and upgrades.