Eleserv Softech

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. (ref:hirist.tech)