Eleserv Softech - Database Administrator - PostgreSQL

Description

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

(ref : hirist.tech)

Skills Required

Postgresql, Backup Solutions, Troubleshooting, Database Design