Key Responsibilities :

- Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.

- Perform regular database backups, restorations, patching, and version upgrades.

- Ensure database availability, reliability, and scalability.

- Monitor database performance, identify bottlenecks, and implement tuning strategies.

- Optimize queries, indexing, memory configuration, and storage utilization.

- Conduct capacity planning to ensure efficient resource allocation.

- Design and implement database schemas, tables, views, indexes, and constraints.

- Support development teams with data modeling, normalization, and SQL best practices.

- Ensure database architecture meets business requirements for scalability and efficiency.

- Diagnose and resolve database-related issues, including performance problems, replication failures, and data inconsistencies.

- Perform root cause analysis and implement preventive actions.

- Implement and manage PostgreSQL replication solutions (Streaming Replication, Logical Replication, etc.).

- Ensure high availability (HA), failover readiness, and disaster recovery strategies.

- Work on backup solutions and maintain DR procedures.

- Enforce database security policies, user access management, and role-based permissions.

- Implement encryption, auditing, and compliance controls as required.

- Regularly review logs, monitor suspicious activity, and maintain security hygiene.

- Work closely with application, DevOps, and infrastructure teams to support seamless deployments and database interactions.

- Prepare and maintain documentation for database configurations, processes, and troubleshooting guides.

- Communicate technical concepts clearly to internal teams.

Qualifications :

- Strong experience 3+ Years in PostgreSQL Database Administration, including maintenance, backups, and upgrades.

- Proficiency in Database Design to support business applications with scalability and efficiency.

- Ability to perform Troubleshooting and technical issue resolution with databases.

- Knowledge of Replication techniques for data synchronization and high availability.

- Familiarity with PostgreSQL systems and related tools is highly desirable.

- Good analytical and problem-solving skills.

- Effective communication and collaboration abilities within a team environment.

- Preferred qualifications include a degree in Computer Science, Information Technology, or a related field, and any relevant database management certifications.