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

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