Eleserv Softech - Database Administrator - PostgreSQL

Location: Bawāna

Description

Key Responsibilities :

Install, configure, and maintain Postgre

SQL 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 Postgre

SQL 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, Dev Ops, 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 Postgre

SQL 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 Postgre

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

(t.tech)