Eleserv Softech

Job Description : PostgreSQL Database Administrator (DBA) for Cloud-based CRM Applications.

We are seeking an experienced PostgreSQL DBA to lead database administration and data migration activities, specifically for cloud-deployed CRM applications.

Key Responsibilities :
• Database Administration : Manage and maintain PostgreSQL databases across cloud instances, ensuring high availability, performance, and security. Perform routine database administration tasks such as monitoring, tuning, and backups. Implement and maintain database clustering, replication, and partitioning strategies to support scalability and performance.
• Data Migration : Lead the data migration process from on-premise CRM applications to cloud-based PostgreSQL instances. Develop and execute data migration plans, including data mapping, data transformation, and validation strategies. Ensure data integrity and minimal downtime during migration activities.
• Performance Tuning and Optimization : Monitor database performance and optimize queries, indexing, and schema design to improve performance. Proactively identify performance bottlenecks and resolve them to ensure smooth database operations. Implement database monitoring tools and alerts to quickly detect and address issues.
• Cloud Instance Management : Work with cloud platforms (such as GCP, AWS, or Azure) to manage PostgreSQL instances in cloud environments. Ensure the cloud database environment adheres to security and compliance standards. Implement best practices for cloud-based database backup, disaster recovery, and high availability.
• Security & Compliance : Implement database security measures, including access controls, encryption, and auditing. Ensure compliance with industry standards and organizational policies related to data security and privacy.
• Collaboration & Documentation : Collaborate with application teams, DevOps, and cloud engineers to ensure seamless integration between databases and applications. Document all database configurations, procedures, and migration plans. Provide technical support and guidance to internal teams regarding database best practices.

Requirements :
• Technical Skills : 3-5 years of experience working as a PostgreSQL DBA, with strong experience managing databases in cloud environments. Experience with cloud platforms such as Google Cloud Platform (GCP), AWS, or Azure for managing PostgreSQL databases. Proficiency in data migration from on-premise databases to cloud instances. Strong knowledge of database performance tuning, query optimization, and indexing strategies. Experience with high availability and disaster recovery configurations, such as replication and clustering. Familiarity with security best practices for databases, including encryption, role-based access control (RBAC), and auditing.
• Soft Skills : Strong problem-solving and analytical skills to diagnose and resolve database-related issues. Excellent communication skills for collaborating with cross-functional teams. Ability to work independently and manage multiple tasks in a fast-paced environment.
• Certifications (Preferred but not mandatory) : Certified PostgreSQL DBA or similar certifications. Cloud certifications related to database management, such as AWS Certified Database Specialty or Google Cloud Professional Database Engineer, are a plus.
• Education : Bachelors degree in Computer Science, Information Technology, or a related field. Relevant certifications in database management or cloud platforms are a plus.